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>

目录
相关文章
|
SQL Oracle 关系型数据库
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database
WARNING: Too Many Parse Errors With error=911 When Running a JDBC Application Connected to an Oracle 19c database (
384 2
|
SQL Oracle 关系型数据库
Connect to Autonomous Database Using Oracle Database Tools
Connect to Autonomous Database Using Oracle Database Tools
117 1
|
Oracle 关系型数据库 Linux
Oracle Linux: How To Disable NUMA At OS Level (Doc ID 2193586.1)
Oracle Linux: How To Disable NUMA At OS Level (Doc ID 2193586.1)
151 1
|
Oracle 关系型数据库 Linux
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
Requirements for Installing Oracle Database/Client 19c on OL8 or RHEL8 64-bit (x86-64) (Doc ID 2668780.1)
135 0
|
人工智能 Oracle 关系型数据库
一篇文章弄懂Oracle和PostgreSQL的Database Link
一篇文章弄懂Oracle和PostgreSQL的Database Link
|
SQL Oracle 关系型数据库
实时计算 Flink版产品使用合集之如何获取 Oracle 自增 ID
实时计算Flink版作为一种强大的流处理和批处理统一的计算框架,广泛应用于各种需要实时数据处理和分析的场景。实时计算Flink版通常结合SQL接口、DataStream API、以及与上下游数据源和存储系统的丰富连接器,提供了一套全面的解决方案,以应对各种实时计算需求。其低延迟、高吞吐、容错性强的特点,使其成为众多企业和组织实时数据处理首选的技术平台。以下是实时计算Flink版的一些典型使用合集。
|
5天前
|
存储 Oracle 关系型数据库
服务器数据恢复—光纤存储上oracle数据库数据恢复案例
一台光纤服务器存储上有16块FC硬盘,上层部署了Oracle数据库。服务器存储前面板2个硬盘指示灯显示异常,存储映射到linux操作系统上的卷挂载不上,业务中断。 通过storage manager查看存储状态,发现逻辑卷状态失败。再查看物理磁盘状态,发现其中一块盘报告“警告”,硬盘指示灯显示异常的2块盘报告“失败”。 将当前存储的完整日志状态备份下来,解析备份出来的存储日志并获得了关于逻辑卷结构的部分信息。
|
1月前
|
存储 Oracle 关系型数据库
oracle数据恢复—oracle数据库执行错误truncate命令的数据恢复案例
oracle数据库误执行truncate命令导致数据丢失是一种常见情况。通常情况下,oracle数据库误操作删除数据只需要通过备份恢复数据即可。也会碰到一些特殊情况,例如数据库备份无法使用或者还原报错等。下面和大家分享一例oracle数据库误执行truncate命令导致数据丢失的数据库数据恢复过程。
|
3月前
|
Oracle 安全 关系型数据库
【Oracle】使用Navicat Premium连接Oracle数据库两种方法
以上就是两种使用Navicat Premium连接Oracle数据库的方法介绍,希望对你有所帮助!
695 28
|
3月前
|
SQL Oracle 关系型数据库
【赵渝强老师】Oracle的闪回数据库
Oracle闪回数据库功能类似于“倒带按钮”,可快速将数据库恢复至 earlier 状态,无需还原备份。本文介绍了闪回数据库的使用方法及实战案例:包括设置归档模式、开启闪回功能、记录SCN号、执行误操作后的恢复步骤等。通过具体 SQL 操作演示了如何利用闪回数据库恢复被误删的用户数据。注意,使用此功能前需确保数据库为归档模式。
125 9

热门文章

最新文章

推荐镜像

更多