R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 83   1 comment

Hi,

In the proces of upgrading from R12.1.3 to R12.2.4. I encountered an issue with autoconfig on database side

Below is the excert from error log

afdbprf.sh started at Mon May 4 23:09:23 PDT 2015

The environment settings are as follows …

ORACLE_HOME : /dev/oracle/product/11.2.0
ORACLE_SID : dev
PATH : /dev/oracle/product/11.2.0/perl/bin:/dev/oracle/product/11.2.0/perl/bin:/dev/oracle/product/11.2.0/bin:/usr/bin:/usr/sbin:/dev/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 : /dev/oracle/product/11.2.0/lib:/usr/X11R6/lib:/usr/openwin/lib:/dev/oracle/product/11.2.0/lib:/usr/dt/lib:/dev/oracle/product/11.2.0/ctx/lib

Executable : /dev/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 has resolved the issue with autoconfig on the database side.

Thanks

Advertisements

Posted May 5, 2015 by balaoracledba.com in OracleAppsR12, R12.2

One response to “R12.2 Autoconfig failing with ORA-06512: at “APPS.ADX_PRF_PKG”, line 83

Subscribe to comments with RSS.

  1. Nice Blog..Good amount of information

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: