Home » RDBMS Server » Server Administration » Safely remove OCM (ORACLE_OCM) after applying patch set 3 (Oracle 10gR2, Windows (32 bit) 2003 Server)
Safely remove OCM (ORACLE_OCM) after applying patch set 3 [message #351863] Fri, 03 October 2008 08:51
Messages: 84
Registered: January 2006
Location: Zug, Switzerland

I installed Oracle 10g without creating a database (just ORACLE_HOME), then installed patch set 2 -> into that same ORACLE_HOME and did NOT enable OCM during the patch set installation. Then started DBCA and created a custom database (pretty much minimal).
Now there is the ORACLE_OCM account and scheduler jobs setup to gather information. Apparently it's trying to write files via the ORACLE_OCM_CONFIG_DIR directory that points to ORACLE_HOME\ccr\state which by the way does NOT exist (only ORACLE_HOME\ccr). As all exceptions are caught and swallowed by the OCM packages/jobs setup the scheduler jobs report successful runs.

Unfortunately, Metalink notes and the OCM install & admin guide suggest to run %OCM_INSTALL_ROOT\ccr\admin\scripts\dropocm.sql to remove OCM. But there is no such ..\admin directory and searching the whole ORACLE_HOME for a file dropocm.sql returns no results.

The big question is, how do I safely get rid of all OCM components?

Thanks in advance!


[Updated on: Fri, 03 October 2008 08:54]

Report message to a moderator

Previous Topic: Password file recreation
Next Topic: TNS 11254 error
Goto Forum:

Current Time: Fri Jul 21 01:53:17 CDT 2017

Total time taken to generate the page: 0.10779 seconds