Tuesday, July 26, 2011

Reinstalling OCM thows ORA-20007: ORA-31003: Parent /sys/acls/ already contains child entry

On the process of reinstalling OCM; ORACLE_OCM user was dropped. After running setupCCR the setup of installCCRSQL.sh was failing with below:

[oracle@test ccr]$ $ORACLE_HOME/ccr/admin/scripts/installCCRSQL.sh collectconfig
An error had occured.
For details, check the log file at /u01/app/oracle/product/11.2.0/db_1/ccr/hosts/test/log/collectconfigkandevdb.log

ERROR at line 1:
ORA-20007: ORA-31003: Parent /sys/acls/ already contains child entry
oracle-sysman-ocm-Resolve-Access.xml
ORA-06512: at line 163
The problem is, though ORACLE_OCM is removed but the dependencies are not removed.

Following is the Workaround:
begin
DBMS_NETWORK_ACL_ADMIN.DROP_ACL('oracle-sysman-ocm-Resolve-Access.xml');
commit;
end;


And then run installCCRSQL.sh and should be good

No comments: