Rapid Install for E-Business Suite Release 12.2 Troubleshoot Oracle Doc

This doc id from oracle will help in troubleshooting the installation done using Rapid Wizard.

• Troubleshooting Rapid Install for E-Business Suite Release 12.2 (Doc ID 1378579.1)

R12.2 Autoconfig failing with ORA-06512

Error while running R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 81

In the proces of upgrading from R12.1.3 to R12.2.4. there is an error running autoconfig at database end

$ afdbprf.sh started

The environment settings are as follows …

ORACLE_HOME : /u01/oracle/product/11.2.0

ORACLE_SID : appsdb

PATH : /u01/oracle/product/11.2.0/perl/bin:/u01/oracle/product/11.2.0/perl/bin:/u01/oracle/product/11.2.0/bin:/usr/bin:/usr/sbin:/u01/oracle/product/11.2.0/appsutil/jre/bin:/bin:/usr/bin/X11:/usr/local/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracrp1/bin:.

Library Path : /u01/oracle/product/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/u01/oracle/product/11.2.0/lib:/usr/dt/lib:/u01/oracle/product/11.2.0/ctx/lib

Executable : /u01/oracle/product/11.2.0/bin/sqlplus

SQL*Plus: Release 11.2.0.4.0 Production on Mon May 4 23:09:23 2015

Copyright (c) 1982, 2013, Oracle. All rights reserved.

Enter value for 1: Enter value for 2: Enter value for 3: Connected.
begin
*
ERROR at line 1:
ORA-00955: name is already used by an existing object
ORA-06512: at “APPS.ADX_PRF_PKG”, line 83
ORA-01403: no data found
ORA-06512: at line 7

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ERRORCODE = 1 ERRORCODE_END
.end std out.

.end err out.


Solution:

1. Run adadmin–>Recreate Grants and Synonyms
2. Compile Apps Schema

This workaround will resolve the issue with autoconfig on the database side.

Change Oracle Apps 12.1.3 database APPS password

Steps:

Source the environment first as shown below:

1. Log into the Operating system level by way of the applmgr user.

2. Run the environment script APPSORA.env:

a. cd $APPL_TOP
b. Run APPSORA.env.
c. The above should also run <sid>_<node>.env, but can verify by running it.
d. cd admin.
e. Run adovars.env

FNDCPASS Utility:

FNDCPASS <APPS username>/<APPS password> 0 Y \ <SYSTEM username>/<SYSTEM password> <token> <username> <new_password>

Example:

1) To change the APPS and APPLSYS schema password:

FNDCPASS apps/apps 0 Y system/manager SYSTEM APPLSYS WELCOME

2) To change an Oracle Applications schema password (other than APPS/APPLSYS):

FNDCPASS apps/apps 0 Y system/manager ORACLE GL GL1

3) To change all ORACLE schema passwords:

FNDCPASS apps/apps 0 Y system/manager ALLORACLE WELCOME

4) To change an Oracle Applications user's password:

FNDCPASS apps/apps 0 Y system/manager USER VISION WELCOME