Useful RAC Commands

oifcfg getif

netstat -p udp

ocfconfig -h

crsctl check crs

crsctl lsmodules css

crsctl trace check css

ocrconfig -showbackup

srvctl config database -d TRXQAC -a -t

srvctl config asm -n serv708

srvctl config listener -n serv708

srvctl status database -d DGDBA -f -v

./cluvfy comp peer -n node1, node2 | more

./cluvf comp -list

./cluvf state -pre crsinst -n node1,node2 -verbose

cluvfy -stage -pre crsinst -n serv171

export SRVM_TRACE=TRUE

truss -aefio /tmp/truss.log crsctl check boot

cat /etc/oracle/ocr.loc

cd $CRS_HOME/log/serv171/racg

ocrcheck

cd /tmp/.oracle

ps -ef | grep init

olsnodes -p

oifcfg getif (select * from v$cluster_interconects)

clusterware miscount : 2 heartbeats network miscount default 30 secon, disk IOT css disktimeout default to 200 seconds (do not change miscount or disktime unless from Oracle Support)

ocrdump

string OCRDUMPFILE | more

ocrconfig -export

****************************RAC DEBUGS******************************************

errpt -a

crsctl lsmodules crs

      crsctl lsmodules evm

      crsctl lsmodules css

$CRSHOME/bin/diagcollection.pl

Syntax,

sudo -u root crsctl debug log res "ora.vip.com:1"

sudo -u root crsctl debug log res "ora.serv709.LTCDGDBA_SERV709.lsnr:0"

sudo -u root crsctl debug log res "ora.serv709.LTCDGDBA_SERV709.lsnr:1"

voting disk and heart beat timeouts (ocssd.log)

racg:  /apps/oracle/product/CRS/log/serv708/racg

ifconfig -a

oifcfg getif

srvctl modify nodeapps -A ip -address/netmask/interface -node node

eDit ORA_CRS_HOME/bin/racgwrap (baisc trace _USR_ORA_DEBUG=1, SQL trace _USR_ORA_DEBUG=10)

export SRV_TRACE=true

netstat -s (receiving package diskcards, fragmentation or reassembly errors for IP and UDP, collisions, errors, dropped packages

ifconfig -a

ocrcheck, $CRS_HOME/log/serv157/client

ocrconfig -showbackup

ocrconfig -export

ocrdump

crs_stat -v resource_name