- 03 May, 2022
- 0 Comments
- 1 Min Read
RAC Administration
In this blog , we will try to understand the rac command that will help for rac administration
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 | crsctl stat res -tcrsctl query css votediskolsnodesenv |grep ORAcrsctl stat res -tcrsctl stat res -initcrsctl stat res -t -initcrsctl start crsps -ef|grep d.bincrsctl disable crsps -ef|grep smonsrvctl config database -dasmcmd showclustermodelocate crsd.trccrsctl check cluster -all |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | ps -ef|grep tnsps -ef|grep d.bincrsctl stat res -tcrsctl stat res -t -initcrsctl stop cluster -allcrsctl start cluster -allcrsctl check cluster -allcrsctl check crscrsctl stop crs |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 | crsctl stop crs -fcrsctl start crscrsctl enable crscrsctl disable crscrsctl stop hascrsctl start hascrsctl check cssdcluvfy comp scancluvfy comp ocr -n all –verboseocrconfig --helpocrconfig -local --helpocrconfig -showbackupocrconfig -showbackuplocolsnodes --helpolsnodessrvctl config scansrvctl status scansrvctl status scan_listenersrvctl config database -d RACCDBsrvctl status database -d RACCDB |
1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 | srvctl stop database -d RACCDBsrvctl status instance -d RACCDB -i RACCDB1srvctl status instance -d RACCDB -i RACCDB2srvctl stop instance -d RACCDB -i RACCDB1srvctl start instance -d RACCDB -i RACCDB1srvctl status listener -l LISTENERsrvctl status listener -l ASMNET1LSNR_ASMsrvctl stop listener -l LISTENERsrvctl start listener -l LISTENER |
1 2 3 | srvctl start database -d PRODB -o nomountsrvctl start database -d PRODB -o mountsrvctl start database -d PRODB -o open |
How to find the OCR location?
1 2 | cat /etc/oracle/ocr.loc /u01/app/12.2.0.1/grid/bin/crsctl query css votedisk |
How to find the OLR location?
1 2 | cat /etc/oracle/olr.lococrcheck -local -config |
What is GPNP Profile and What it contains?
1 | /u01/app/12.2.0.1/grid/gpnp/<hostname>/profiles/peer/profile.xml. |
ASM and Clusterware: Which One is Started First?
1 | kfed read /dev/oracleasm/disks/DATA1 | grep -E 'vfstart|vfend' |
1 2 3 4 5 6 7 | nslookup oraclelabnode2.localdomain.comyum install bind*yum install bind* --skip-brokenvi /etc/resolv.confservice named restartping google.comservice firewalld stop |