Add RAC Database to Clusterware
#Add RAC Database to Clusterware
srvctl add database -d CDB -n CDB -o '/u01/app/oracle/product/19.0.0.0/dbhome_1' -p '+DATA/CDB/PARAMETERFILE/spfile.437.1148238013' -t IMMEDIATE -a 'DATA,RECO'
#Add RAC Database Instances
srvctl add instance -d CDB -i CDB1 -n node1
srvctl add instance -d CDB -i CDB2 -n node2
#Check the RAC Database configuration
srvctl config database -d CDB
#Check and start the RAC Database
srvctl start database -d CDB
srvctl status database -d CDB
#Stop the RAC Database and remove from the cluster if needed
srvctl stop database -d CDB
srvctl remove database -d CDB
#disable auto start-up for the RAC database
srvctl disable database -d CDB
srvctl enable database -d CDB
logs:
=====
[root@node1 ~]# ps -ef|grep smon
root 20464 1 1 Nov12 ? 08:16:44 /u01/app/19.0.0.0/grid/bin/osysmond.bin
oracle 20796 1 0 Nov12 ? 00:00:47 asm_smon_+ASM1
oracle 23058 1 0 Nov12 ? 00:01:20 ora_smon_RAC12C1
root 31533 29768 0 01:39 pts/0 00:00:00 grep --color=auto smon
[root@node1 ~]# . oraenv
ORACLE_SID = [root] ? +ASM1
The Oracle base has been set to /u01/app/oracle
[root@node1 ~]#
[root@node1 ~]# env |grep ORA
ORACLE_SID=+ASM1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/19.0.0.0/grid
[root@node1 ~]#
[root@node1 ~]# olsnodes
node1
node2
[root@node1 ~]#
[root@node1 ~]# crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_PRIMDB.lsnr
ONLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_RAC12C.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.chad
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.helper
OFFLINE OFFLINE node1 IDLE,STABLE
OFFLINE OFFLINE node2 IDLE,STABLE
ora.net1.network
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ons
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node2 169.254.9.52 10.38.9
.112,STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 Started,STABLE
3 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE node2 STABLE
ora.dhbstg.db
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.gridtgt.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.mgmtdb
1 ONLINE ONLINE node2 Open,STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 ONLINE ONLINE node2 STABLE
ora.qosmserver
1 ONLINE ONLINE node2 STABLE
ora.rac12c.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE node1 STABLE
ora.scan2.vip
1 ONLINE ONLINE node2 STABLE
ora.scan3.vip
1 ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
[root@node1 ~]#
[oracle@node1 ~]$ . oraenv
ORACLE_SID = [oracle] ? CDB1
The Oracle base has been set to /u01/app/oracle
[oracle@node1 ~]$
[oracle@node1 ~]$ env |grep ORA
ORACLE_SID=CDB1
ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=/u01/app/oracle/product/19.0.0.0/dbhome_1
[oracle@node1 ~]$ srvctl status database -d CDB
PRCD-1120 : The resource for database CDB could not be found.
PRCR-1001 : Resource ora.cdb.db does not exist
[oracle@node1 ~]$
[oracle@node1 ~]$ srvctl add database -d CDB -n CDB -o '/u01/app/oracle/product/19.0.0.0/dbhome_1' -p '+DATA/CDB/PARAMETERFILE/spfile.437.1148238013' -t IMMEDIATE -a 'DATA,RECO'
[oracle@node1 ~]$
[oracle@node1 ~]$ srvctl config database -d CDB
Database unique name: CDB
Database name: CDB
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/CDB/PARAMETERFILE/spfile.437.1148238013
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances:
Configured nodes:
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@node1 ~]$ srvctl add instance -d CDB -i CDB1 -n node1
[oracle@node1 ~]$ srvctl add instance -d CDB -i CDB2 -n node2
[oracle@node1 ~]$ srvctl config database -d CDB
Database unique name: CDB
Database name: CDB
Oracle home: /u01/app/oracle/product/19.0.0.0/dbhome_1
Oracle user: oracle
Spfile: +DATA/CDB/PARAMETERFILE/spfile.437.1148238013
Password file:
Domain:
Start options: open
Stop options: immediate
Database role: PRIMARY
Management policy: AUTOMATIC
Server pools:
Disk Groups: DATA,RECO
Mount point paths:
Services:
Type: RAC
Start concurrency:
Stop concurrency:
OSDBA group: oinstall
OSOPER group: oinstall
Database instances: CDB1,CDB2
Configured nodes: node1,node2
CSS critical: no
CPU count: 0
Memory target: 0
Maximum memory: 0
Default network number for database services:
Database is administrator managed
[oracle@node1 ~]$ srvctl status database -d CDB
Instance CDB1 is not running on node node1
Instance CDB2 is not running on node node2
[oracle@node1 ~]$ srvctl start database -d CDB
[oracle@node1 ~]$ srvctl status database -d CDB
Instance CDB1 is running on node node1
Instance CDB2 is running on node node2
Verify the database status at Cluster level using crsctl
[oracle@node2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_PRIMDB.lsnr
ONLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_RAC12C.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.chad
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.helper
OFFLINE OFFLINE node1 IDLE,STABLE
OFFLINE OFFLINE node2 IDLE,STABLE
ora.net1.network
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ons
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node2 169.254.9.52 10.38.9
.112,STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 Started,STABLE
3 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.cdb.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/o
racle/product/19.0.0
.0/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/o
racle/product/19.0.0
.0/dbhome_1,STABLE
ora.cvu
1 ONLINE ONLINE node2 STABLE
ora.dhbstg.db
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.gridtgt.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.mgmtdb
1 ONLINE ONLINE node2 Open,STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 ONLINE ONLINE node2 STABLE
ora.qosmserver
1 ONLINE ONLINE node2 STABLE
ora.rac12c.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE node1 STABLE
ora.scan2.vip
1 ONLINE ONLINE node2 STABLE
ora.scan3.vip
1 ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
[oracle@node2 ~]$
[oracle@node1 ~]$ srvctl remove database -d CDB
PRKO-3141 : Database CDB could not be removed because it was running
[oracle@node1 ~]$ srvctl stop database -d CDB
[oracle@node1 ~]$ srvctl remove database -d CDB
Remove the database CDB? (y/[n]) y
[oracle@node1 ~]$
[oracle@node2 ~]$ crsctl stat res -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_PRIMDB.lsnr
ONLINE OFFLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.LISTENER_RAC12C.lsnr
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.chad
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.helper
OFFLINE OFFLINE node1 IDLE,STABLE
OFFLINE OFFLINE node2 IDLE,STABLE
ora.net1.network
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
ora.ons
ONLINE ONLINE node1 STABLE
ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE node1 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE node2 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE node2 STABLE
ora.MGMTLSNR
1 ONLINE ONLINE node2 169.254.9.52 10.38.9
.112,STABLE
ora.RECO.dg(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 OFFLINE OFFLINE STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 Started,STABLE
3 ONLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE node2 STABLE
2 ONLINE ONLINE node1 STABLE
3 ONLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE node2 STABLE
ora.dhbstg.db
1 ONLINE OFFLINE STABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.gridtgt.db
1 OFFLINE OFFLINE Instance Shutdown,ST
ABLE
2 ONLINE OFFLINE Instance Shutdown,ST
ABLE
ora.mgmtdb
1 ONLINE ONLINE node2 Open,STABLE
ora.node1.vip
1 ONLINE ONLINE node1 STABLE
ora.node2.vip
1 ONLINE ONLINE node2 STABLE
ora.qosmserver
1 ONLINE ONLINE node2 STABLE
ora.rac12c.db
1 ONLINE ONLINE node1 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
2 ONLINE ONLINE node2 Open,HOME=/u01/app/o
racle/product/12.2.0
.1/dbhome_1,STABLE
ora.rhpserver
1 OFFLINE OFFLINE STABLE
ora.scan1.vip
1 ONLINE ONLINE node1 STABLE
ora.scan2.vip
1 ONLINE ONLINE node2 STABLE
ora.scan3.vip
1 ONLINE ONLINE node2 STABLE
--------------------------------------------------------------------------------
[oracle@node2 ~]$
No comments:
Post a Comment