Oracle RAC Administration and Monitoring Scripts -1
To check clusterware status, execute following command.
[root@racdb1 ~]$ . oraenv ORACLE_SID = [root] ? +ASM1
[root@racdb ~]$ 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 check cluster status, execute following command.
[root@racdb ~]$ crsctl check cluster CRS-4537: Cluster Ready Services is online CRS-4529: Cluster Synchronization Services is online CRS-4533: Event Manager is online [root@racdb ~]$
To check all cluster resource status, execute following command.
[root@Prodecidbrac01 ~]# crsctl status resource -t -------------------------------------------------------------------------------- Name Target State Server State details -------------------------------------------------------------------------------- Local Resources -------------------------------------------------------------------------------- ora.DATAC1.dg ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE ora.DBFS_DG.dg ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE ora.LISTENER.lsnr ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE ora.RECOC1.dg ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE ora.asm ONLINE ONLINE Prodecidbrac01 Started,STABLE ONLINE ONLINE Prodecidbrac02 Started,STABLE ora.net1.network ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE ora.ons ONLINE ONLINE Prodecidbrac01 STABLE ONLINE ONLINE Prodecidbrac02 STABLE -------------------------------------------------------------------------------- Cluster Resources -------------------------------------------------------------------------------- ora.LISTENER_SCAN1.lsnr 1 ONLINE ONLINE Prodecidbrac02 STABLE ora.LISTENER_SCAN2.lsnr 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.LISTENER_SCAN3.lsnr 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.MGMTLSNR 1 ONLINE ONLINE Prodecidbrac01 169.254.94.159,STABL E ora.cvu 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.dbm01.db 1 ONLINE OFFLINE STABLE 2 ONLINE OFFLINE Instance Shutdown,ST ABLE ora.ebys.db 1 ONLINE ONLINE Prodecidbrac01 Open,STABLE 2 ONLINE ONLINE Prodecidbrac02 Open,STABLE ora.ebytest.db 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE Instance Shutdown,ST ABLE ora.mgmtdb 1 ONLINE ONLINE Prodecidbrac01 Open,STABLE ora.oc4j 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.repdb.db 1 ONLINE ONLINE Prodecidbrac01 Open,STABLE 2 ONLINE ONLINE Prodecidbrac02 Open,STABLE ora.scan1.vip 1 ONLINE ONLINE Prodecidbrac02 STABLE ora.scan2.vip 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.scan3.vip 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.test.db 1 OFFLINE OFFLINE STABLE 2 ONLINE OFFLINE Instance Shutdown,ST ABLE ora.test.db 1 OFFLINE OFFLINE STABLE 2 OFFLINE OFFLINE Instance Shutdown,ST ABLE ora.Prodeci.db 1 ONLINE ONLINE Prodecidbrac01 Open,STABLE 2 ONLINE ONLINE Prodecidbrac02 Open,STABLE ora.Prodecidbrac01.vip 1 ONLINE ONLINE Prodecidbrac01 STABLE ora.Prodecidbrac02.vip 1 ONLINE ONLINE Prodecidbrac02 STABLE -------------------------------------------------------------------------------- [root@Prodecidbrac01 ~]#
RAC Cluster Command ( Scripts )
To stop Clusterware on specific node, execute following command. Set ASM profile before executing crsctl command.
[root@racdb1 ~]$ . oraenv ORACLE_SID = [root] ? +ASM1 [root@racdb ~]$ crsctl stop crs
To start Clusterware on specific node, execute following command. Set ASM profile before executing crsctl command.
[root@racdb1 ~]$ . oraenv ORACLE_SID = [root] ? +ASM1 [root@racdb ~]$ crsctl start crs
To disable Clusterware on specific node, execute following command. Set ASM profile before executing crsctl command.
[root@racdb ~]$ crsctl disable crs
To enable Clusterware on specific node, execute following command. Set ASM profile before executing crsctl command.
[root@racdb ~]$ crsctl enable crs
To Query Voting disk location, execute following command. Set ASM profile before executing crsctl command.
[oracle@racdb ~]$ crsctl query css votedisk ## STATE File Universal Id File Name Disk group -- ----- ----------------- --------- --------- 1. ONLINE bd81ab8e27a64fbebf7b6b326c5f614d (/Prod/mapper/HDD_E0_S03_1418288932p1) [DATA] 2. ONLINE 450684e276874ff9bff52d481befa809 (/Prod/mapper/HDD_E0_S15_1420185788p1) [DATA] 3. ONLINE fd1efd6de5204f6bbfe9793a480c517f (/Prod/mapper/HDD_E0_S06_1423843312p1) [DATA] Located 3 voting disk(s).
To find OCR files location, execute following command.
[root@racdb ~]# cat /etc/oracle/ocr.loc #Prodice/file +DATA getting replaced by Prodice +DATA/Prodeci-c/OCRFILE/registry.255.923150247 ocrconfig_loc=+DATA/Prodeci-c/OCRFILE/registry.255.923150247 local_only=false [root@racdb ~]#
To check the status of the Oracle Cluster registry , execute following command.
[root@racdb ~]# ocrcheck Status of Oracle Cluster Registry is as follows : Version : 4 Total space (kbytes) : 409568 Used space (kbytes) : 2412 Available space (kbytes) : 407156 ID : 2022573354 Prodice/File Name : +DATA Prodice/File integrity check succeeded Prodice/File not configured Prodice/File not configured Prodice/File not configured Prodice/File not configured Cluster registry integrity check succeeded Logical corruption check succeeded [root@racdb ~]#
To add voting disk, execute following command. Set ASM profile before executing crsctl command.
crsctl add css votedisk new_vote_disk_path
To Delete voting disk, execute following command. Set ASM profile before executing crsctl command.
crsctl delete css votedisk new_vote_disk_path
To Add voting disk to ASM Disk, execute following command.
crsctl add votedisk asm_disk_group
To Replace or Migrate voting disk, execute following command.
crsctl replace votedisk asm_diskgroup / vote_disk_path
To find OCR backup location, execute following command. Set ASM profile before executing crsctl command.
ocrconfig –showbackup auto
To change OCR Backup location, execute following command.
ocrconfig –backuploc Shared_PATH
To Add OCR files location, execute following command.
ocrconfig –add Location_PATH
To Replace or Change OCR files location, execute following command.
ocrconfig –replace New_PATH
To Repair OCR files location, execute following command. Cluster or Oracle RAC Services should be power off.
ocrconfig –repair –add +DATAC1
There are lots of options used with SRVCTL command, i described them below.
-d Database Name -i Instance Name -s Service Name -n Node Name -r Preferred list -a Available list -p TAF (Transparent application failover policy) -v Verbose
Click this link for srvctl commands here.
Thank you for giving your valuable time to read the above information.
If you want to be updated with all our articles send us the Invitation or Follow us:
Ramkumar’s LinkedIn: https://www.linkedin.com/in/ramkumardba/
LinkedIn Group: https://www.linkedin.com/in/ramkumar-m-0061a0204/
Facebook Page: https://www.facebook.com/Oracleagent-344577549964301
Ramkumar’s Twitter : https://twitter.com/ramkuma02877110
Ramkumar’s Telegram: https://t.me/oracleageant
Ramkumar’s Facebook: https://www.facebook.com/ramkumarram8