How to Rollback / Revert the autoconfig changes in EBS

When ever we run autoconfig, the autoconfig log files are stored under the following locations.

On Database Tier:
$ORACLE_HOME/appsutil/log/$CONTEXT_NAME/<MMDDhhmm>

On Middle Tier:
$APPL_TOP/admin/$CONTEXT_NAME/log/<MMDDhhmm>


At the same time, all the backup configuration files from each autoconfig session are saved under following directories:

On Database Tier:
$ORACLE_HOME/appsutil/out/$CONTEXT_NAME/<MMDDhhmm>

On Middle Tier:
$APPL_TOP/admin/$CONTEXT_NAME/out/<MMDDhhmm>

There is also a script called restore.sh / restore.cmd under these locations along with backup configuration files.

We can run restore.sh (unix) or restore.cmd (windows) to revert back the autoconfig changes.

perl adcfgclone.pl appsTier fails with coredump error on AIX

Issue:

On AIX server, perl adcfgclon.pl appsTier is failing with below errors.

$ perl adcfgclone.pl appsTier
Enter the APPS password [APPS]:


First Creating a new context file for the cloned system.
The program is going to ask you for information about the new system:

sh: 758236 Illegal instruction(coredump)
ERROR: context creation not completed successfully.
Please check /tmp/adcfgclone_1515866.err file for errors


$ cat  /tmp/adcfgclone_1515866.err
        stackpointer=2ff207f0
JVMXM004: JVM is performing abort shutdown sequence
JVMDG217: Dump Handler is Processing a Signal - Please Wait.
JVMDG303: JVM Requesting Java core file
JVMDG304: Java core file written to /u01/app/comn/clone/bin/javacore1413304.1369742403.txt
JVMDG215: Dump Handler has Processed Exception Signal 4.


Cause:

The cause of the issue is because the symbolic links were missing from either $IAS_ORACLE_HOME/appsoui/jre/1.3.1 or $COMMON_TOP directory.


Fix:

1. Go to /<COMMON_TOP>/clone/jre. 
2. mv lib lib.old 
3. mv bin bin.old 
4. ln -s jre/bin bin 
5. ln -s jre/lib lib 
6. Repeat the steps in $IAS_ORACLE_HOME/appsoui/jre/1.3.1 
7. Run the perl adcfgclone.pl AppsTier again.

Autoconfig failed during bisdblrp.sql

Autoconfig failed during bisdblrp.sql

Issue: Found Ora-600 error in alert log while dropping a database link.

Error Message :
ORA-00600: internal error code, arguments: [16500], [kqdDBLinkUpdate], [3], [2], [EDW_APPS_TO_WH.WORLD], [], [], [], [], [], [], []

Current SQL from trace file:
drop database link EDW_APPS_TO_WH.WORLD;

Reason:
There are 2 database links in the database with same name.

SQL> select * from dba_db_links where db_link='EDW_APPS_TO_WH.WORLD';

APPS       EDW_APPS_TO_WH.WORLD    APPS    TEST   24-JUL-12
APPS       EDW_APPS_TO_WH.WORLD    APPS    TEST   25-JUL-12


Solution:
Drop the database links from SYS.LINK$ table using below command:

SQL> delete from sys.link$
 2  where NAME='EDW_APPS_TO_WH.WORLD';