How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1)

demn

How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1)

To Bottom

Modified:02-Apr-2013

Type:HOWTO













In this Document

Goal
Fix
References

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 todeinstallOCM

来自 <https://support.oracle.com/epmos/faces/SearchDocDisplay?_adf.ctrl-state=9kfufexgp_4&_afrLoop=27396137888787>