- Shutdown Oracle Home process accessing database.
- Shutdown RAC Database Instances on all nodes.
- Shutdown All ASM instances from all nodes.
- Shutdown Node applications running on nodes.
- Shut down the Oracle Cluster ware or CRS.
- Shutdown Oracle Home process accessing database:
[[email protected] bin]$ srvctl stop listener -n node1
[[email protected] bin]$ srvctl status listener -n node1
Listener LISTENER is enabled on node(s): node1
Listener LISTENER is not running on node(s): node1
- Shutdown RAC Database Instances on all nodes:
[[email protected] ~]$ srvctl status database -d RACDB
Instance RACDB1 is running on node node1
Instance RACDB2 is running on node node2
[[email protected] ~]$ srvctl stop database -d RACDB
[[email protected] ~]$ srvctl status database -d RACDB
Instance RACDB1 is not running on node node1
Instance RACDB2 is not running on node node2
***We just need to execute one command from any one of the server having database and it will stop all database instances on all servers.
- Shutdown All ASM instances from all nodes:
[[email protected] oracle]# srvctl stop asm -n node1 -f
[[email protected] oracle]# srvctl stop asm -n node2 -f
[[email protected] oracle]# srvctl status asm -n node1
ASM is not running on node1
[[email protected] oracle]# srvctl status asm -n node2
ASM is not running on node2
***Sometimes, Database administrator face some issues in stopping ASM instance, In that case use “-f” option to forcefully shutdown ASM instances.
- Shutdown Node applications running on nodes:
[[email protected] oracle]# srvctl stop nodeapps -n node1 -f
[[email protected] oracle]# srvctl status nodeapps -n node1
VIP node1-vip is enabled
VIP node1-vip is running on node: node1
Network is enabled
Network is running on node: node1
GSD is disabled
GSD is not running on node: node1
ONS is enabled
ONS daemon is running on node: node1
***Repeat same command for all nodes one by one. If you face any issue in stopping node applications use “-f” as force option to stop applications.
- Shut down the Oracle Clusterware or CRS:
[[email protected] bin]# crsctl check cluster -all
node1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
[[email protected] bin]# crsctl stop crs
CRS-2791: Starting shutdown of Oracle High Availability Services-managed resources on ‘node1’
CRS-2673: Attempting to stop ‘ora.crsd’ on ‘node1’
CRS-2790: Starting shutdown of Cluster Ready Services-managed resources on ‘node1’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN2.lsnr’ on ‘node1’
CRS-2673: Attempting to stop ‘ora.LISTENER.lsnr’ on ‘node1’
CRS-2673: Attempting to stop ‘ora.LISTENER_SCAN3.lsnr’ on ‘node1’
CRS-2673: Attempting to stop ‘ora.node2.vip’ on ‘node1’
————————————————-
CRS-2677: Stop of ‘ora.cssd’ on ‘node1’ succeeded
CRS-2673: Attempting to stop ‘ora.gipcd’ on ‘node1’
CRS-2677: Stop of ‘ora.gipcd’ on ‘node1’ succeeded
CRS-2673: Attempting to stop ‘ora.gpnpd’ on ‘node1’
CRS-2677: Stop of ‘ora.gpnpd’ on ‘node1’ succeeded
CRS-2793: Shutdown of Oracle High Availability Services-managed resources on ‘node1’ has completed
CRS-4133: Oracle High Availability Services has been stopped.
[[email protected] bin]# crsctl check cluster -all
CRS-4639: Could not contact Oracle High Availability Services
CRS-4000: Command Check failed, or completed with errors.
How to Start Oracle Real Application Clusters Database ?
- Start Oracle Clusterware or CRS.
- Start Node applications running on nodes.
- Start All ASM instances from all nodes.
- Start RAC Database Instances on all nodes.
- Start Oracle Home process accessing database.
- Start Oracle Clusterware or CRS:
[[email protected] bin]# crsctl start crs
CRS-4123: Oracle High Availability Services has been started
[[email protected] bin]# crsctl check cluster -all
node1:
CRS-4535: Cannot communicate with Cluster Ready Services
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
***Here, DBA can see “CRS-4639: Could not contact Oracle High Availability Services” or “CRS-4535: Cannot communicate with Cluster Ready Services” messages. Wait 5 minutes and then again check with “crsctl check cluster -all” command. This time Database administrator will get “CRS-4537: Cluster Ready Services is online”.
*****If still same issue DBA can start ora.crsd process to resolve this issue. Below is the command
[[email protected] bin]# crsctl start res ora.crsd -init
[[email protected] bin]# crsctl check cluster -all
node1:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
node2:
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online
- Start Node applications running on nodes:
[[email protected] bin]$ srvctl start nodeapps -n node1
[[email protected] bin]$ srvctl status nodeapps -n node1
VIP node1-vip is enabled
VIP node1-vip is running on node: node1
Network is enabled
Network is running on node: node1
GSD is disabled
GSD is not running on node: node1
ONS is enabled
ONS daemon is running on node: node1
***DBA has to execute this command for each node to start Real Application Clusters Cluster database.
- Start All ASM instances from all nodes:
[[email protected] bin]$ srvctl start asm -n node1
[[email protected] bin]$ srvctl status asm -n node1
ASM is running on node1
DBA has to start ASM instance on all database nodes.
- Start RAC Database Instances on all nodes:
[[email protected] bin]$ srvctl start database -d RACDB
[[email protected] bin]$ srvctl status database -d RACDB
Instance RACDB1 is running on node node1
Instance RACDB2 is running on node node2
- Start Oracle Home process accessing database:
[[email protected] bin]$ srvctl start listener -n node1
[[email protected] bin]$ srvctl status listener -n node1
Listener LISTENER is enabled on node(s): node1
Listener LISTENER is running on node(s): node1
