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

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 to deinstallOCM

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