Monday, June 27, 2011

RAC Troubleshooting: SERVICES ARE GETTING TERMINATED UNEXPECTEDLY

Visit the Below Website to access unlimited exam questions for all IT vendors and Get Oracle Certifications for FREE
http://www.free-online-exams.com

RAC Troubleshooting:  SERVICES ARE GETTING TERMINATED UNEXPECTEDLY on RAC Database

Here what you have to do to troubleshoot RAC services termination unexpectedly

- Check all logs under $ORACLE_HOME/log/<hostname>/racg/*

- /var/log/syslog.log

- Check  /tmp/node1status.txt ,/tmp/node2status.txt after running the following commands :

Node-1
-------
$script /tmp/node1status.txt
$hostname
$crsctl check crs
$crs_stat
$crs_stat -t
$crs_stat -ls
$crs_stat -p
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$olsnodes -n
$olsnodes -v
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$srvctl config nodeapps -n <nodename1> -a -g -s -l
$srvctl config nodeapps -n <nodename2> -a -g -s -l
$srvctl config database -d <db_name> -a
$srvctl config service -d <db_name> -a
$srvctl config asm -n <node name>
$ocrcheck
$crsctl query css votedisk
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$olsnodes -p 
$ocrdump run this as root user
$ifconfig -a 
$/etc/hosts 
$exit;

Node-2
--------
$hostname
$script /tmp/node2status.txt
$crsctl check crs
$ocrcheck
$crsctl query crs activeversion
$crsctl query crs softwareversion
$oifcfg getif
$oifcfg iflist
$ps -ef | grep d.bin
$ps -ef | grep crs
$ps -ef | grep oprocd
$/sbin/ifconfig -a
$cat /etc/hosts
$ls -l /etc/hosts
$ls -ld /var/tmp/.oracle
$ls -ld /tmp/.oracle
$exit;
Get Oracle Certifications for all Exams
Free Online Exams.com

No comments: