Essential Maintance Of MGMTDB

Today I want to talk about the most basic maintenance we can do of the MGMTDB (MGMTDB is new database instance which is used for storing Cluster Health Monitor (CHM) data). Let’s see the minimum commands that we must keep in mind to work with this database;

To check database;

srvctl status mgmtdb

To start database;

srvctl start mgmtdb [-startoption start_options] [-node node_name]

To set up database;

srvctl config mgmtdb

Like an Oracle database, it has its own listener, and you can perform the same operations, for example (from the owner of the GRID);

lsnrctl status MGMTLSNR

To connect to the database with sqlplus we must first point to the ORACLE_SID (from the owner of the GRID);

export ORACLE_SID=-MGMTDB
sqlplus “/ as sysdba”

HTH – Antonio NAVARRO

 

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s