First, create a disk group GIMR for storing new GIMR data. At the moment, it is stored in disk group OCR_VOTE. Please refer to section “Create New Disks and Create New Diskgroup FRA” for creating a disk group.
1. Stop and disable ora.crf resource on every node
[root@racnode1 bin]# pwd /u01/app/12.1.0/grid/bin [root@racnode1 bin]# ./crsctl stop res ora.crf -init CRS-2673: Attempting to stop 'ora.crf' on 'racnode1' CRS-2677: Stop of 'ora.crf' on 'racnode1' succeeded [root@racnode1 bin]# ./crsctl modify res ora.crf -attr ENABLED=0 -init [root@racnode2 bin]#
Do not stop ora.mgmtlsnr or ora.mgmtdb resource, otherwise Step 2 will fail with the following:
Oracle Grid Management database is running on node “racnode1”. Run dbca on node “racnode1” to delete the database.
2. Use DBCA to delete the management database
As user grid, find on which node the mgmtdb is running on :
[grid@racnode1 ~]$ srvctl status mgmtdb Database is enabled Instance -MGMTDB is running on node racnode1 [grid@racnode1 ~]$ /u01/app/12.1.0/grid/bin/dbca -silent -deleteDatabase -sourceDB -MGMTDB Connecting to database 4% complete 9% complete 14% complete 19% complete 23% complete 28% complete 47% complete Updating network configuration files 48% complete 52% complete Deleting instance and datafiles 76% complete 100% complete Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb.log" for further details. [grid@racnode1 ~]$ cat "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb.log" The Database Configuration Assistant will delete the Oracle instance and datafiles for your database. All information in the database will be destroyed. Do you want to proceed? Connecting to database DBCA_PROGRESS : 4% DBCA_PROGRESS : 9% DBCA_PROGRESS : 14% DBCA_PROGRESS : 19% DBCA_PROGRESS : 23% DBCA_PROGRESS : 28% DBCA_PROGRESS : 47% Updating network configuration files DBCA_PROGRESS : 48% DBCA_PROGRESS : 52% Deleting instance and datafiles DBCA_PROGRESS : 76% DBCA_PROGRESS : 100% Database deletion completed. [grid@racnode1 ~]$
3. Recreate the 12.1.0.2 MGMTDB
a. As Grid User on any node execute the following DBCA command with the desired <DG Name>:
[grid@racnode1 ~]$ /u01/app/12.1.0/grid/bin/dbca -silent -createDatabase -sid -MGMTDB -createAsContainerDatabase true -templateName MGMTSeed_Database.dbc -gdbName _mgmtdb -storageType ASM -diskGroupName +GIMR -datafileJarLocation /u01/app/12.1.0/grid/assistants/dbca/templates -characterset AL32UTF8 -autoGeneratePasswords -skipUserTemplateCheck Registering database with Oracle Grid Infrastructure 5% complete Copying database files 7% complete 9% complete 16% complete 23% complete 30% complete 37% complete 41% complete Creating and starting Oracle instance 43% complete 48% complete 49% complete 50% complete 55% complete 60% complete 61% complete 64% complete Completing Database Creation 68% complete 79% complete 89% complete 100% complete Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/_mgmtdb0.log" for further details. [grid@racnode1 ~]$
b. Create a PDB within the MGMTDB by using DBCA.
As Grid User on any node execute the following DBCA command:
NOTE: The CLUSTER_NAME needs to have any hyphens (“-“) replaced with underscores (“_”)
[grid@racnode1 ~]$ /u01/app/12.1.0/grid/bin/dbca -silent -createPluggableDatabase -sourceDB -MGMTDB -pdbName RACNODE_CLUSTER -createPDBFrom RMANBACKUP -PDBBackUpfile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.dfb -PDBMetadataFile /u01/app/12.1.0/grid/assistants/dbca/templates/mgmtseed_pdb.xml -createAsClone true Creating Pluggable Database 4% complete 12% complete 21% complete 38% complete 55% complete 85% complete Completing Pluggable Database Creation 100% complete Look at the log file "/u01/app/grid/cfgtoollogs/dbca/_mgmtdb/RACNODE_CLUSTER/_mgmtdb.log" for further details. [grid@racnode1 ~]$
4. Secure that the Management Database credential
[grid@racnode1 ~]$ srvctl status MGMTDB Database is enabled Instance -MGMTDB is running on node racnode1 [grid@racnode1 ~]$ [grid@racnode1 ~]$ /u01/app/12.1.0/grid/bin/mgmtca <--no output [grid@racnode1 ~]$
5. Enable and start ora.crf resource on every node
[root@racnode1 ~]# /u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=1 -init [root@racnode1 ~]# /u01/app/12.1.0/grid/bin/crsctl start res ora.crf -init CRS-2672: Attempting to start 'ora.crf' on 'racnode1' CRS-2676: Start of 'ora.crf' on 'racnode1' succeeded [root@racnode1 ~]# [root@racnode2 bin]# /u01/app/12.1.0/grid/bin/crsctl modify res ora.crf -attr ENABLED=1 -init [root@racnode2 bin]# /u01/app/12.1.0/grid/bin/crsctl start res ora.crf -init CRS-2672: Attempting to start 'ora.crf' on 'racnode2' CRS-2676: Start of 'ora.crf' on 'racnode2' succeeded [root@racnode1 bin]# ./crsctl stat res -t -init -------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------- ora.asm 1 ONLINE ONLINE racnode1 Started,STABLE ora.cluster_interconnect.haip 1 ONLINE ONLINE racnode1 STABLE ora.crf 1 ONLINE ONLINE racnode1 STABLE ora.crsd 1 ONLINE ONLINE racnode1 STABLE ora.cssd 1 ONLINE ONLINE racnode1 STABLE ora.cssdmonitor 1 ONLINE ONLINE racnode1 STABLE ora.ctssd 1 ONLINE ONLINE racnode1 ACTIVE:0,STABLE ora.diskmon 1 OFFLINE OFFLINE STABLE ora.evmd 1 ONLINE ONLINE racnode1 STABLE ora.gipcd 1 ONLINE ONLINE racnode1 STABLE ora.gpnpd 1 ONLINE ONLINE racnode1 STABLE ora.mdnsd 1 ONLINE ONLINE racnode1 STABLE ora.storage 1 ONLINE ONLINE racnode1 STABLE --------------------------------------------------------------------------------
6. Check management database and management listener
[grid@racnode1 ~]$ srvctl status MGMTDB Database is enabled Instance -MGMTDB is running on node racnode1 [grid@racnode1 ~]$ ps -eaf | grep tns root 15 2 0 20:05 ? 00:00:00 [netns] grid 1168 892 0 22:37 pts/0 00:00:00 grep --color=auto tns grid 3974 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr MGMTLSNR -no_crs_notify -inherit grid 4064 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER -no_crs_notify -inherit grid 4092 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER_SCAN2 -no_crs_notify -inherit grid 4103 1 0 20:06 ? 00:00:00 /u01/app/12.1.0/grid/bin/tnslsnr LISTENER_SCAN3 -no_crs_notify -inherit [grid@racnode1 ~]$ lsnrctl status MGMTLSNR LSNRCTL for Linux: Version 12.1.0.2.0 - Production on 14-MAR-2016 22:38:03 Copyright (c) 1991, 2014, Oracle. All rights reserved. Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=MGMTLSNR))) STATUS of the LISTENER ------------------------ Alias MGMTLSNR Version TNSLSNR for Linux: Version 12.1.0.2.0 - Production Start Date 14-MAR-2016 20:06:33 Uptime 0 days 2 hr. 31 min. 29 sec Trace Level off Security ON: Local OS Authentication SNMP OFF Listener Parameter File /u01/app/12.1.0/grid/network/admin/listener.ora Listener Log File /u01/app/grid/diag/tnslsnr/racnode1/mgmtlsnr/alert/log.xml Listening Endpoints Summary... (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=MGMTLSNR))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=172.16.100.61)(PORT=1521))) (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=169.254.146.121)(PORT=1521))) Services Summary... Service "-MGMTDBXDB" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "_mgmtdb" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... Service "racnode_cluster" has 1 instance(s). Instance "-MGMTDB", status READY, has 1 handler(s) for this service... The command completed successfully
Make DBA Life Easy 