Usefull Oracle RAC Database management commands

In this post i want to share Usefull quick note for can manage RAC database

Let start. First is first .. Shutdown and Start sequence of Oracle RAC

-STOP ORACLE RAC Components sequence

Devamını oku: Usefull Oracle RAC Database management commands

• srvctl stop listener -n racnode1
• srvctl stop database -d SID
• srvctl stop asm -n racnode1 -f
• srvctl stop asm -n racnode2 -f
• srvctl stop nodeapps -n racnode1 -f
• crsctl stop crs

-START ORACLE RAC Components

• crsctl start crs
• crsctl start res ora.crsd -init
• srvctl start nodeapps -n racnode1
• srvctl start nodeapps -n racnode2
• srvctl start asm -n racnode1
• srvctl start asm -n racnode2
• srvctl start database -d SID
• srvctl start listener -n racnode1

-To start and stop oracle clusterware (run as the superuser) :

[root@node1 ~]# crsctl stop crs
[root@node1 ~]# crsctl start crs

-To start and stop oracle cluster resources running on all nodes :

[root@node1 ~]# crsctl stop cluster -all
[root@node1 ~]# crsctl start cluster -all

-To check the current status of a cluster :

[oracle@node1~]$ crsctl check cluster
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

-To check the current status of CRS :

[oracle@node1 ~]$ crsctl check crs
CRS-4638: Oracle High Availability Services is online
CRS-4537: Cluster Ready Services is online
CRS-4529: Cluster Synchronization Services is online
CRS-4533: Event Manager is online

-To display the status cluster resources :

[oracle@node1 ~]$ crsctl status resource -t

To check version of Oracle Clusterware :

To check current status of OHASD (Oracle High Availability Services) daemon :
[oracle@node1 ~]$ crsctl check has
CRS-4638: Oracle High Availability Services is online

• Enabling and disabling CRS daemons (run as the superuser) :

[root@node1 ~]# crsctl enable crs
CRS-4622: Oracle High Availability Services autostart is enabled.

[root@node1 ~]# crsctl disable crs
CRS-4621: Oracle High Availability Services autostart is disabled.

-To start RAC listener :
[oracle@node1 ~]$ srvctl start listener

-To display the status of the database :
[oracle@node1 ~]$ srvctl status database -d SID
Instance SID1 is running on node node1
Instance SID2 is running on node node2

-To display the status services running in the database :

[oracle@node1 ~]$ srvctl status service -d SID
Service SRV_SID is running on instance(s) SID1,SID2

-To start or stop the ASM instance on racnode01 cluster node :

[oracle@node1 ~]$ srvctl start asm -n racnode1
[oracle@node1 ~]$ srvctl stop asm -n racnode1

-To stop or start SCAN listener and the SCAN VIP resources :

[oracle@node1 ~]$ srvctl stop scan_listener
[oracle@node1 ~]$ srvctl start scan_listener
[oracle@node1 ~]$ srvctl stop scan
[oracle@node1 ~]$ srvctl start scan