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


No comments:

Post a Comment