关闭mgmtdb 库并disable

简介: 关闭mgmtdb 库并disable

ALERT: Disable pstack Called From Diagsnap After Applying PSU/RU released between October 2017 and July 2018 to Grid Infrastructure (GI) Home on 12.1.0.2 and 12.2. (Doc ID 2422509.1)
在12c中,diagsnap调用的OS命令(其中有ssh)可能会消耗大量的CPU(Bug 27182006),但这个问题在19c中已经得到了修复。

这个SR的问题是,可能是一次性问题。

12c以及以上版本的diagsnap是什么? [2469643.1]

如果问题复现的话,请使用下面的workaround回避此问题

oclumon manage -disable diagsnap --禁用diagsnap
oclumon manage -enable diagsnap --启用diagsnap

重启ora.crf资源
crsctl stop res ora.crf -init
crsctl start res ora.crf -init

The diagsnap logs are located in the $ORACLE_BASE/diagsnap directory for 12.1 and 12.2.0.1

How To Enable Diagsnap
$ oclumon manage -enable diagsnap

How To Disable Diagsnap
$ oclumon manage -disable diagsnap

How To Check Whether the Diagsnap is Disabled or Enabled?
$GRID_HOME/crf/admin/crf$(hostname -s).ora

https://orcl.tistory.com/entry/Disable-Diagsnap-in-Oracle-12c

因此关闭MGMTDB库,需要先将chm和cha服务关闭。
【下一步建议】
关闭MGMTDB库,可按以下步骤:
1) 关闭ORA.CHA 服务(ora.cha和mgmtdb 有依赖关系)
[root]#crsctl status res ora.chad -p | grep "DEPEND"
START_DEPENDENCIES=hard(global:ora.mgmtdb) pullup(global:ora.mgmtdb) <<<ora.cha 与mgmtdb依赖
START_DEPENDENCIES_RTE_INTERNAL=
STOP_DEPENDENCIES=hard(global:intermediate:ora.mgmtdb) <<<ora.cha 与mgmtdb依赖
STOP_DEPENDENCIES_RTE_INTERNAL=
2) 关闭ora.crf 服务(所有节点)
–- stop and disable ora.crf resource.

/bin/crsctl stop res ora.crf -init

/bin/crsctl modify res ora.crf -attr ENABLED=0 –init

crsctl stat res ora.crf -init
crsctl status res ora.crf –init -f
3) 查看并关闭ora.cha 服务
[root]# srvctl status cha
Oracle Cluster Health Analysis Service is enabled
Oracle Cluster Health Analysis Service is running on nodes: rac1
[root]# srvctl stop cha
[root]#srvctl status cha
Oracle Cluster Health Analysis Service is enabled
Oracle Cluster Health Analysis Service is not running.
4) 关闭mgmtdb 库并disable
[root]# srvctl stop mgmtdb
[root]# srvctl disable mgmtdb
[root]# srvctl status mgmtdb
Database is disabled
Database is not running.
5) 关闭mgmtlsnr 服务并disable
[root]# srvctl disable listener -l mgmtlsnr
[root]# srvctl status listener -l mgmtlsnr
Listener MGMTLSNR is disabled
Listener MGMTLSNR is not running

相关文章
|
关系型数据库 MySQL 数据库
一文剖析MySQL主从复制异常错误代码13114
一文剖析MySQL主从复制异常错误代码13114
1814 0
|
关系型数据库 MySQL
ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
ERROR 1449 (HY000): The user specified as a definer (‘mysql.infoschema‘@‘localhost‘) does not exist
860 0
|
Oracle 关系型数据库 Linux
Linux 关闭透明大页(transparent_hugepage)和 NUMA
有些情况下需要关闭Linux 服务器的 透明大页和 NUMA,比如安装 Oracle 数据库!
Linux 关闭透明大页(transparent_hugepage)和 NUMA
|
存储 关系型数据库 MySQL
|
SQL Oracle 关系型数据库
Oracle rman备份保留策略,归档删除策略及delete命令的使用
oracle rman备份保留策略、归档策略的使用及对delete命令的影响
2805 0
|
Oracle 关系型数据库
impdp导入卡住,等待事件wait for unread message on broadcast channel
impdp导入卡住,等待事件wait for unread message on broadcast channel
3537 0
|
Oracle Unix 关系型数据库
[INS-06006] Passwordless SSH connectivity not set up between the following node(s)
[INS-06006] Passwordless SSH connectivity not set up between the following node(s)
2279 0
|
SQL 存储 Oracle
Oracle数据库-设置10053事件的三种办法
Oracle数据库-设置10053事件的三种办法
544 0
|
网络协议 Oracle 关系型数据库
Oracle rac 修改SCAN IP
Oracle rac 修改SCAN IP
1190 0