ORACLE_MGMTDB
The ORACLE_MGMTDB application monitors the management instance availability, which includes the tablespaces and alert log.
ORACLE_MGMTDB is a new database instance that stores Cluster Health Monitor (CHM) data. It is intended to help in troubleshooting clusterware issues. This database instance runs in a single instance mode, and is managed by the clusterware.
The Oracle Management Instance is created automatically if the Oracle 12c instance is part of a Real Application Cluster (RAC) setup.
Application class attributes
Item | Description |
---|---|
Active | Yes |
Created by | Discovery |
Parent class |
|
Child class |
By default only the status will be active.
To monitor the alerts log and tablespaces, the user needs to configure (i.e.,using KM command or CMA) the instance home, username, and password.
To monitor tablespaces, the Oracle database monitoring user must be able to connect using SQL*PLUS into the management instance, and must have the privilege to query and view the following tables:
- dba_free_space
- dba_data_files
- v$diag_info
Attributes (parameters)
The following attributes are available for this monitor type:
- Management Instance Alerts (ManagementAlerts)
- Management Instance Configuration Status (MGMTDBConfigurationStatus)
- Management Instance Status (InstanceStatus)
Note
- Users must use the KM command or CMA configuration to monitor the alerts log and the tablespaces.
- Windows users must add the pconfig entry "/OracleConfig.GridHome" with the full path to the GRID HOME.
Comments
Log in or register to comment.