How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1)-阿里云开发者社区

开发者社区> 数据库> 正文

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

简介:  How To Manually Remove ORACLE_OCM From Database (Doc ID 859113.1) To Bottom   Modified:02...


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

To Bottom

To Bottom

 

Modified:02-Apr-2013

Type:HOWTO

Rate this document

 

Email link to this document

 

Open document in new window

 

Printable Page

 

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>

版权声明:本文内容由阿里云实名注册用户自发贡献,版权归原作者所有,阿里云开发者社区不拥有其著作权,亦不承担相应法律责任。具体规则请查看《阿里云开发者社区用户服务协议》和《阿里云开发者社区知识产权保护指引》。如果您发现本社区中有涉嫌抄袭的内容,填写侵权投诉表单进行举报,一经查实,本社区将立刻删除涉嫌侵权内容。

分享:
数据库
使用钉钉扫一扫加入圈子
+ 订阅

分享数据库前沿,解构实战干货,推动数据库技术变革

其他文章