********************
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
