|
How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1) |
|
|
|
Modified:02-Apr-2013
Type:HOWTO
|
|
In this Document
APPLIES TO:
OracleConfiguration Manager - Version 10.2.3 to 10.3.1
Informationin this document applies to any platform.
***Checkedfor relevance on 16-FEB-2012***
GOAL
Whenupgrading a 9i or 10g database to 10.2.0.4, user ORACLE_OCM is created.
This isbecause as of Oracle Database release 10.2.0.4, the database is automaticallyinstrumented for OCM collections, out-of-the-box.
In"Oracle Configuration Manager Installation and Administration Guide"it is stated:
"Ifyou upgrade from a 9.x database version to a 10.x version after the OracleConfiguration Manager installation, you must run the installCCRSQL.sh scriptagain to instrument the upgraded version."
If OCMconfiguration was skipped at the 10.2.0.4 database install/upgrade time, theOCM Collector installation and configuration is not properly completed.
Therefore,although directory $ORACLE_HOME/crr exists, $ORACLE_HOME/crr/admin directorywill be missing.
You areaware that in order to successfully install and configure OCM, simply need tofollow:
"Oracle Configuration Manager Quick Start Guide"
available at http://www.oracle.com/technology/documentation/ocm.html
but forthe time being you decide to delete the ORACLE_OCM user from the database.
Found note761313.1, just that the subdirectory
'admin' anddropocm.sql script are not available.
How tocontinue?
FIX
NB: It isstrongly recommended to have Oracle Configuration Manager configured for yourdatabase.
Run thefollowing commands only for a 10.2.0.4 database which doesn't have the$ORACLE_HOME/ccr/admin/scripts/dropocm.sql script.
For allother cases, in order to deinstall the OCM Collector, must follow the"Uninstalling Oracle Configuration Manager" section in OCMdocumentation.
In orderto manually remove the ORACLE_OCM user and associated objects from database,run:
SQL>drop user ORACLE_OCM cascade;
SQL>drop directory ORACLE_OCM_CONFIG_DIR;
Then canalso remove the $ORACLE_HOME/ccr directory.
REFERENCES
NOTE:761313.1 - How to
deinstallOCM