关闭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

相关文章
|
Shell PHP Windows
php交互式命令行工具window操作系统安装readline扩展函数实现interactive mode enabled到Interactive Shell
php交互式命令行工具window操作系统安装readline扩展函数实现interactive mode enabled到Interactive Shell
92 0
|
前端开发
Bootstrap系列 -- 20. 禁用状态
  Bootstrap框架的表单控件的禁用状态和普通的表单禁用状态实现方法是一样的,在相应的表单控件上添加属性“disabled”   在使用了“form-control”的表单控件中,样式设置了禁用表单背景色为灰色,而且手型变成了不准输入的形状。
908 0