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 $
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