Posts by jayan sellappan

Apply Phase Options ABANDON and RESTART

Options ABANDON and RESTART adop phase=apply patches=12121212 abandon=yes Used to specify whether to restart the previous run of adop. May be useful if the previous action had an error. Note:If…

Read More

Adcfgclone failing with Error: AFTER PASTEBINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2

Adcfgclone failing with Error: AFTER PASTE BINARY COMMENV.SH FILE IS POPULATED WITH INCORRECT JAVA_HOME PATH in EBS 12.2 Oracle Support notes: ===================== 12.2 E-Business Suite Applications Manager Rapidclone Fails With…

Read More

Steps to Implement Transparent Data Encryption(TDE) using fast offline conversion for Oracle Databases

Prerequisite: Make sure you have applied the patch 23315889(fast offline conversion patch) if you are on Oracle 11g Database or latest CPU patches are applied which already include all the…

Read More

DBCA Configure Database option is greyed out in Oracle

Database Configuration Assistant was not showing the database and Configure Database Options and it was greyed out(disabled). We tried setting up ORACLE_SID and ORACLE_HOME and ran dbca but it was…

Read More

Gather Schema Statistics – Program error with Locks and Duplicate columns

Oracle E-Business Suite Release 12 uses cost–based optimization in order to choose the most efficient execution plan for SQL statements.Gather Schema Statistics is the favourite one among Apps DBA’s and…

Read More

How to open Concurrent Out file in excel format

An *.out file is a compiled executable file created by various source code compilers in Unix-like operating systems, such as Linux and AIX. *.out files are most commonly seen as…

Read More

No Write Permission on ACFS Mount Point

I managed to create the ACFS Mount Point after resolving the issue “ACFS-9459: ASVM/ACFS is not supported on this os version”. But, after creating the ACFS Mount Point, I’m unable…

Read More

GETTING APPLICATION USER PASSWORD IN R12 

Step 1 :   CREATE OR REPLACE PACKAGE get_pwd AS    FUNCTION decrypt (KEY IN VARCHAR2, VALUE IN VARCHAR2)       RETURN VARCHAR2; END get_pwd; / Step 2 :…

Read More

RC-00110: FATAL: ERROR OCCURRED WHILE RELINKING OF APPLYDBTECHSTACK

RC-00110: Fatal: Error occurred while relinking of ApplyDBTechStack Problem: I faced the following error while cloning one of our recently upgraded EBS version from 11.5.10 to 12.1.3 RC-00110: Fatal: Error…

Read More

How To Troubleshoot OID DIP Sync Mapping Problems

Consider the following scenarios: Scenario 1: DIP Import Sync from Active Directory (AD) to OID works for most entries, but fails when a new organizationalunit (ou) entry is added in…

Read More