Sunday, March 4, 2012

Issue on DB Autoconfig : Error details >> txkcreateACL.sh: exiting with status 1 >> ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

********************

Instance Details:

********************

Apps : 12.1.2

DB : 11.1.0.7

Activity : CPU Patching Jan'12 & Autoconfig.

Issue: DB Autoconfig failed with below error ...

Error details extracted from Log file :

[AutoConfig Error Report]

The following report lists errors AutoConfig encountered during each

phase of its execution. Errors are grouped by directory and phase.

The report format is:

[APPLY PHASE]

AutoConfig could not successfully execute the following scripts:

Directory: /kirang/oracle/product/111/appsutil/install/KIRANG_ramubro

txkcreateACL.sh INSTE8_APPLY 1

AutoConfig is exiting with status 1

Exact Error details during execution of script "txkcreateACL.sh"

SQL*Plus: Release 11.1.0.7.0 - Production on Sun Mar 4 01:24:33 2012

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

Connected.

Checking for existence of the ACL ....

No ACL exists for this, creating a new one ....

DECLARE

*

ERROR at line 1:

ORA-31003: Parent /sys/acls/ already contains child entry OracleEBS.xml

ORA-06512: at "SYS.DBMS_NETWORK_ACL_ADMIN", line 226

ORA-06512: at line 36

ORA-01403: no data found

Disconnected from Oracle Database 11g Enterprise Edition Release 11.1.0.7.0 - 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

txkcreateACL.sh: exiting with status 1

Upon search found related Note : 1328458.1

Solution : Followed steps as per the note and executed Autoconfig on DB Node.

1. Execute the below PL/SQL block to drop the existing OracleEBS ACL :

sqlplus "/as sysdba"

BEGIN

DBMS_NETWORK_ACL_ADMIN.drop_acl (acl => 'OracleEBS.xml');

commit;

end;

2. Run autoconfig on DB Node again..

cd $ORACLE_HOME/appsutil/kirang

adautocfg.sh

Thanks

Kiran Ginni

2 comments:

  1. this didn't work. ACL could not be dropped. unable to execute the script. please help

    ReplyDelete