On the process of reinstalling OCM; ORACLE_OCM user was dropped. After running setupCCR the setup of installCCRSQL.sh was failing with below:
And then run installCCRSQL.sh and should be good
[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
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;
DBMS_NETWORK_ACL_ADMIN.DROP_ACL('oracle-sysman-ocm-Resolve-Access.xml');
commit;
end;
And then run installCCRSQL.sh and should be good