[root@racn1 ~]# $ORACLE_HOME/bin/crsctl stop cluster -all
[root@racn1 ~]# systemctl stop oracle-ohasd
[root@racn2 ~]# systemctl stop oracle-ohasd
[grid@rac1 ~]$ srvctl status nodeapps
VIP 192.168.1.31 is enabled
VIP 192.168.1.31 is running on node: rac1
VIP 192.168.1.32 is enabled
VIP 192.168.1.32 is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
[grid@rac1 ~]$ srvctl status scan_listener
SCAN Listener LISTENER_SCAN1 is enabled
SCAN listener LISTENER_SCAN1 is running on node rac2
SCAN Listener LISTENER_SCAN2 is enabled
SCAN listener LISTENER_SCAN2 is running on node rac1
SCAN Listener LISTENER_SCAN3 is enabled
SCAN listener LISTENER_SCAN3 is running on node rac1
[grid@rac1 ~]$ crsctl check cluster -all
**************************************************************
rac1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
rac2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
**************************************************************
[grid@rac1 ~]$ crsctl check ctss
CRS-4700: The Cluster Time Synchronization Service is in Observer mode.
[grid@rac1 ~]$ srvctl config all
Oracle Clusterware configuration details
========================================
Oracle Clusterware basic information
------------------------------------
Operating system Linux
Name rac-cluster
Class STANDALONE
Cluster nodes rac1, rac2
Version 19.0.0.0.0
Groups SYSOPER:oinstall SYSASM:dba SYSRAC:dba SYSDBA:oinstall
OCR locations +DATA
Voting disk locations DATA
Voting disk file paths /dev/oracleasm/disks/VOL1
Cluster network configuration details
-------------------------------------
Interface name Type Subnet Classification
enp0s3 IPV4 192.168.1.0/24 PUBLIC
enp0s8 IPV4 192.168.10.0/24 PRIVATE, ASM
SCAN configuration details
--------------------------
SCAN "rac-scan" details
+++++++++++++++++++++++
Name rac-scan
IPv4 subnet 192.168.1.0/24
DHCP server type static
End points TCP:1521
SCAN listeners
--------------
Name VIP address
LISTENER_SCAN1 192.168.1.41
LISTENER_SCAN2 192.168.1.42
LISTENER_SCAN3 192.168.1.43
ASM configuration details
-------------------------
Mode remote
Password file +DATA
SPFILE +DATA
ASM disk group details
++++++++++++++++++++++
Name Redundancy
DATA EXTERN
Database configuration details
==============================
Database "ora.orcl.db" details
------------------------------
Name ora.orcl.db
Type RAC
Version 19.0.0.0.0
Role PRIMARY
Management AUTOMATIC
policy
SPFILE +DATA
Password file +DATA
Groups OSDBA:oinstall OSOPER:oper OSBACKUP:backupdba OSDG:dgdba
OSKM:kmdba OSRAC:racdba
Oracle home /u01/app/oracle/product/19.3
[grid@rac1 ~]$ srvctl status database -d orcl -verbose
Instance orcl1 is running on node rac1. Instance status: Open.
Instance orcl2 is not running on node rac2
[grid@rac1 ~]$ crsctl status resource -t
--------------------------------------------------------------------------------
Name Target State Server State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.LISTENER.lsnr
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.chad
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.net1.network
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
ora.ons
ONLINE ONLINE rac1 STABLE
ONLINE ONLINE rac2 STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.ASMNET1LSNR_ASM.lsnr(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 ONLINE OFFLINE STABLE
ora.DATA.dg(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE rac2 STABLE
ora.LISTENER_SCAN2.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.LISTENER_SCAN3.lsnr
1 ONLINE ONLINE rac1 STABLE
ora.asm(ora.asmgroup)
1 ONLINE ONLINE rac1 Started,STABLE
2 ONLINE ONLINE rac2 Started,STABLE
3 OFFLINE OFFLINE STABLE
ora.asmnet1.asmnetwork(ora.asmgroup)
1 ONLINE ONLINE rac1 STABLE
2 ONLINE ONLINE rac2 STABLE
3 OFFLINE OFFLINE STABLE
ora.cvu
1 ONLINE ONLINE rac1 STABLE
ora.orcl.db
1 ONLINE ONLINE rac1 Open,HOME=/u01/app/ o
racle/product/19.3, S
TABLE
2 OFFLINE OFFLINE Instance Shutdown,S T
ABLE
ora.qosmserver
1 ONLINE ONLINE rac2 STABLE
ora.rac1.vip
1 ONLINE ONLINE rac1 STABLE
ora.rac2.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan1.vip
1 ONLINE ONLINE rac2 STABLE
ora.scan2.vip
1 ONLINE ONLINE rac1 STABLE
ora.scan3.vip
1 ONLINE ONLINE rac1 STABLE
--------------------------------------------------------------------------------
srvctl stop listener -n rac1
[grid@rac1 ~]$ srvctl status nodeapps
VIP 192.168.1.31 is enabled
VIP 192.168.1.31 is running on node: rac1
VIP 192.168.1.32 is enabled
VIP 192.168.1.32 is running on node: rac2
Network is enabled
Network is running on node: rac1
Network is running on node: rac2
ONS is enabled
ONS daemon is running on node: rac1
ONS daemon is running on node: rac2
nslookup imdb-scan.imdbworld.com
nslookup imdb02-vip.imdbworld.com
OCR Commands :
OCR manual backup
./ocrconfig -manualbackup
./ocrconfig -showbackup
./oifcfg getif
./crsctl query css votedisk
./crsctl enable has
./crsctl disable has
./crsctl stop has
./srvctl modify service -db orcl -service gracserv -failovertype SELECT
./srvctl modify service -db orcl -service gracserv -failovermethod BASIC
./srvctl modify service -db orcl -service gracserv -notification TRUE
./srvctl modify service -db orcl -service gracserv -failoverdelay 5
./srvctl modify service -db orcl -service gracserv -failoverretry 60
./srvctl modify service -db orcl -service gracserv -clbgoal SHORT
Use below commands to modify preferred and available instances
./srvctl modify service -db orcl -service gracserv -modifyconfig -preferred orcl 2 -available orcl 1
./srvctl modify service -db orcl -service gracserv -modifyconfig -preferred orcl 2,orcl 1
Start created service
./srvctl start service -db orcl -service gracserv
Relocate to next instance
./srvctl relocate service -db orcl -service gracserv -oldinst orcl 1 -newinst orcl 2
Show configuration for the service
./srvctl config service -db orcl -service gracserv
dev5088:+ASM2:/e2open/home/grid: 348>srvctl config all
Oracle Clusterware configuration details
========================================
Oracle Clusterware basic information
------------------------------------
Operating system Linux
Name gopirac
Class STANDALONE
Cluster nodes dev5088
Version 19.0.0.0.0
Groups SYSOPER: SYSASM:asmadmin SYSRAC:asmadmin SYSDBA:asmdba
OCR locations +DATA01
Voting disk locations DATA01
Voting disk file paths /dev/sde1
Cluster network configuration details
-------------------------------------
Interface name Type Subnet Classification
eth0 IPV4 10.120.96.0/19 PUBLIC
eth1 IPV4 192.168.0.0/24 PRIVATE, ASM
SCAN configuration details
--------------------------
SCAN "gopirac-scan" details
+++++++++++++++++++++++++++
Name gopirac-scan
IPv4 subnet 10.120.96.0/19
DHCP server type static
End points TCP:1521
SCAN listeners
--------------
Name VIP address
LISTENER_SCAN1 10.120.115.205
LISTENER_SCAN2 10.120.115.204
LISTENER_SCAN3 10.120.115.203
ASM configuration details
-------------------------
Mode remote
Password file +DATA01
SPFILE +DATA01
ASM disk group details
++++++++++++++++++++++
Name Redundancy
ARCH01 EXTERN
DATA01 EXTERN
DATA02 EXTERN
REDO01 EXTERN
Database configuration details
==============================
Database "ora.gopirac.db" details
---------------------------------
Name ora.gopirac.db
Type RAC
Version 19.0.0.0.0
Role PRIMARY
Management AUTOMATIC
policy
SPFILE +DATA01
Password file +DATA01
Groups OSDBA:dba OSOPER:oinstall OSBACKUP:dba OSDG:dba OSKM:dba
OSRAC:dba
Oracle home /oragopirac01/app/oracle/product/19.3.0
ip route
ip rule
1p addr
srvctl add service -d gopirac -s TEST -r "gopirac1,gopirac2"
srvctl relocate service -d gopirac -s gservice -oldinst gopirac2 -newinst gopirac1 -force -drain_timeout 30 -stopoptions IMMEDIATE
[root@rac1 ~]# /u01/app/grid/19.3/bin/crsctl stop cluster -all
CRS-2673: Attempting to stop 'ora.crsd' on 'rac1'
CRS-2673: Attempting to stop 'ora.crsd' on 'rac2'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac1'
CRS-2673: Attempting to stop 'ora.chad' on 'rac1'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN1.lsnr' on 'rac1'
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac1'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac1'
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on server 'rac2'
CRS-2673: Attempting to stop 'ora.cvu' on 'rac2'
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN3.lsnr' on 'rac2'
CRS-2677: Stop of 'ora.LISTENER_SCAN1.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.LISTENER_SCAN2.lsnr' on 'rac2'
CRS-2673: Attempting to stop 'ora.scan1.vip' on 'rac1'
CRS-2673: Attempting to stop 'ora.rac2.vip' on 'rac2'
CRS-2673: Attempting to stop 'ora.qosmserver' on 'rac2'
CRS-2673: Attempting to stop 'ora.chad' on 'rac2'
CRS-2677: Stop of 'ora.scan1.vip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN3.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan3.vip' on 'rac2'
CRS-2677: Stop of 'ora.rac2.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.LISTENER_SCAN2.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.scan2.vip' on 'rac2'
CRS-2677: Stop of 'ora.scan3.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.DATA.dg' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2677: Stop of 'ora.scan2.vip' on 'rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1'
CRS-2677: Stop of 'ora.cvu' on 'rac2' succeeded
CRS-2677: Stop of 'ora.qosmserver' on 'rac2' succeeded
CRS-2677: Stop of 'ora.chad' on 'rac2' succeeded
CRS-2677: Stop of 'ora.chad' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac1'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac1' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac1' succeeded.
CRS-33673: Attempting to stop resource group 'ora.asmgroup' on server 'rac2'
CRS-2673: Attempting to stop 'ora.DATA.dg' on 'rac2'
CRS-2677: Stop of 'ora.DATA.dg' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac2'
CRS-2677: Stop of 'ora.ASMNET1LSNR_ASM.lsnr' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.asmnet1.asmnetwork' on 'rac2'
CRS-2677: Stop of 'ora.asmnet1.asmnetwork' on 'rac2' succeeded
CRS-33677: Stop of resource group 'ora.asmgroup' on server 'rac2' succeeded.
CRS-2673: Attempting to stop 'ora.ons' on 'rac2'
CRS-2677: Stop of 'ora.ons' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac2'
CRS-2677: Stop of 'ora.net1.network' on 'rac2' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac2' has completed
CRS-2673: Attempting to stop 'ora.net1.network' on 'rac1'
CRS-2677: Stop of 'ora.net1.network' on 'rac1' succeeded
CRS-2792: Shutdown of Cluster Ready Services-managed resources on 'rac1' has completed
CRS-2677: Stop of 'ora.crsd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'rac2'
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac2'
CRS-2677: Stop of 'ora.crsd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.storage' on 'rac1'
CRS-2677: Stop of 'ora.storage' on 'rac2' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.evmd' on 'rac2'
CRS-2677: Stop of 'ora.storage' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.asm' on 'rac1'
CRS-2673: Attempting to stop 'ora.asm' on 'rac2'
CRS-2677: Stop of 'ora.evmd' on 'rac2' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.ctssd' on 'rac1'
CRS-2673: Attempting to stop 'ora.evmd' on 'rac1'
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac1'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac1' succeeded
CRS-2677: Stop of 'ora.ctssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.evmd' on 'rac1' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac1'
CRS-2677: Stop of 'ora.cssd' on 'rac1' succeeded
CRS-2677: Stop of 'ora.asm' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cluster_interconnect.haip' on 'rac2'
CRS-2677: Stop of 'ora.cluster_interconnect.haip' on 'rac2' succeeded
CRS-2673: Attempting to stop 'ora.cssd' on 'rac2'
CRS-2677: Stop of 'ora.cssd' on 'rac2' succeeded
No comments:
Post a Comment