Relocate MGMTDB Database To Another Node

Hello, today I would like to show how to move the MGMTDB database within the nodes of a cluster. This database (optional until version 12.1 if I remember correctly) is used mainly to store the telemetry that Oracle collects on the operation of the cluster on which it is executed.

In my case, I’m going to move it because I need to launch the cluster monitor (oclumon) from node 1. The main benefit of running the oclumon and that the database MGMTDB are in the same node is to reduce network traffic in the Interconnect (or private network).

 
First, check where the database is running;

griduser@node-1 $ srvctl status mgmtdb
Database is enabled
Instance -MGMTDB is running on node node-2

Now execute the relocate to node one;

griduser@node-1 $ srvctl relocate mgmtdb -node node-1
griduser@node-1 $

Check again;

griduser@node-1 $ srvctl status mgmtdb
Database is enabled
Instance -MGMTDB is running on node node-1
griduser@node-1 $

You can also check the presence of the pmon with the world famous command “ps -ef | grep pmon” as shown below;

griduser@node-1 $ ps -ef | grep pmon
    grid 10311     1   0   Nov 14 ?           6:12 asm_pmon_+ASM1
    grid  7723     1   0   Nov 14 ?           5:52 apx_pmon_+APX1
  oracle 10582     1   0   Nov 14 ?           9:59 ora_pmon_CLOUD1
    grid 29146     1   0 15:40:09 ?           0:00 mdb_pmon_-MGMTDB

 

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