Oracle DBA Tips and Techniques

By Arjun Raja

WARNING MESSAGE IN ORACLE CONFIG MANAGER STATUS.

Posted by Arjun Raja on January 18, 2011

When checking the status of the Oracle Congfig Manager , you may get the following warning message at the end – if so the sql collection packages need to be reloaded.

EX- While checking the status below rcatd database had a warning message attached to it …..

[PROD] rcatd:/u01/oracle/product/10.2.0.4/rmand/ccr/bin > ./emCCR status
Oracle Configuration Manager – Release: 10.3.3.1.1 – Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.
——————————————————————
Start Date 14-Nov-2010 11:05:07
Last Collection Time 18-Jan-2011 11:03:00
Next Collection Time 19-Jan-2011 11:03:00
Collection Frequency Daily at 11:03
Collection Status idle
Log Directory /u01/oracle/product/10.2.0.4/rmand/ccr/hosts/xxxxxx/log
Registered At 29-Mar-2010 11:03:09
Automatic Update On
Collector Mode Connected
HTTP Proxy xxxxxx\svc-proxy-oracle-cm@bc-uat-proxy.xxxxxx.local:xxxxxx

WARN: Oracle Configuration Manager database objects are not in sync with
the installed configuration collection scripts.
Refer to the Installation and Configuration documentation on reloading the
SQL collection packages.
SID Script
—- —–
rcatd collectconfig

[PROD] rcatd:/u01/oracle/product/10.2.0.4/rmand/ccr/bin >

Run following script to reload sql collection packages in the database rcatd.

cd $ORACLE_HOME/ccr/admin/scripts >

[PROD] rcatd:/u01/oracle/product/10.2.0.4/rmand/ccr/admin/scripts > ./installCCRSQL.sh collectconfig -s rcatd -r sys
Provide password for the SYSDBA user “sys”: enter sys password.
Successfully installed collectconfig in the database with SID=rcatd.
[PROD] rcatd:/u01/oracle/product/10.2.0.4/rmand/ccr/admin/scripts >

cd $ORACLE_HOME/ccr/bin > ./emCCR status –

[PROD] rcatd:/u01/oracle/product/10.2.0.4/rmand/ccr/bin > ./emCCR status
Oracle Configuration Manager – Release: 10.3.3.1.1 – Production
Copyright (c) 2005, 2010, Oracle and/or its affiliates. All rights reserved.
——————————————————————
Start Date 14-Nov-2010 11:05:07
Last Collection Time 18-Jan-2011 11:03:00
Next Collection Time 19-Jan-2011 11:03:00
Collection Frequency Daily at 11:03
Collection Status idle
Log Directory /u01/oracle/product/10.2.0.4/rmand/ccr/hosts/xxxxxx/log
Registered At 29-Mar-2010 11:03:09
Automatic Update On
Collector Mode Connected
HTTP Proxy xxxxxx\svc-proxy-oracle-cm@bc-uat-proxy.xxxxxx.local:xxxxxx

Fixed !

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

 
%d bloggers like this: