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

Friday, July 22, 2011

OCM Configuration fails "The ORACLE_HOME does not contain Java"

While trying to install Oracle's Configuration Manager application following error issued:
[oracle@LAB bin]$ ./setupCCR -s
The ORACLE_HOME does not contain java.
The ORACLE_HOME does not contain a valid JDK/JRE.
Redefine JAVA_HOME to refer to a JDK/JRE 1.2.2 or greater.

Somehow it was failing to recognize java home.

Workaround:
export JAVA_HOME=/u01/app/oracle/product/11.2.0/db_1/jdk

And then run the setup again.

./setupCCR -s    

References:  Note: 854831.1 - Installation Fails with “The JAVA_HOME_CCR environment variable does not contain java and/or jar