_MGMTDB Management database (CHM repository) resource

Starting 12c, the management repository single instance database is created if the option is selected during GI installation.  It’s managed by GI and is a single instance that will fail over to the other node in case of the hosting node goes down.  The purpose of the management database is the central repository to store cluster health monitor (CHM/ora.crf).  Its data files are on the same shared storage as OCR and Voting file.  If the option is not configured during the installation or upgrade, all features of Cluster Health Monitor will be disabled.

To display the management repository configuration

srvctl config mgmtdb (-verbose /  – all)

Database unique name: _mgmtdb

Database name:

Oracle home: /u01/oracle/product/12.1.0.1/grid

Oracle user: oracle

Spfile: +GI/_mgmtdb/spfile-MGMTDB.ora

Password file:

Domain:

Start options: open

Stop options: immediate

Database role: PRIMARY

Management policy: AUTOMATIC

Database instance: -MGMTDB

Type: Management

To display the configuration for management listener resource:

srvctl config mgmtlsnr

Name: MGMTLSNR

Owner: oracle

Home: <CRS home>

End points: TCP:1531

Some useful commands to check out the management repository database

oclumon manage -get MASTER

srvctl status mgmtdb

srvctl config mgmtdb

srvctl enable  mgmtdb

srvctl disable mgmtdb

srvctl disable mgmtlsnr

srvctl disable mgmtdb -node glsnd015 (To disable the management repository database from running on node glsnd015)

srvctl enable mgmtdb -node glscind01

srvctl relocate mgmtdb -n glscind01 (relocate from node glscind02 to glsind01)

select file_name from dba_data_files union select member file_name from v$logfile

oclumon manage -get reppath

oclumon manage -repos changerepossize 4000