Tuesday, December 17, 2019

Oracle RAC Troubleshooting


Login as root
crsctl check cluster -all
crsctl stat res -t -init

crsctl stop crs
crsctl start crs

srvctl config scan
srvctl config scan_listener


ps -elf |grep tns

script /var/tmp/`hostname`_listener_status.txt
lsnrctl status LISTENER
lsnrctl status LISTENER_SCAN1
lsnrctl status ASMNET1LSNR_ASM
lsnrctl service LISTENER
lsnrctl service LISTENER_SCAN1
lsnrctl service ASMNET1LSNR_ASM
exit

script /var/tmp/`hostname`_listener_status.txt

script /var/tmp/`hostname`_listener_status_`date +%s`.txt
find . -mmin -20 -type f -exec zip -r /var/tmp/`hostname`_logs.zip {} \;

zip -r /var/tmp/`hostname`_logs.zip $(find . -mmin -20 -type f)

No comments:

Post a Comment