Orale10GRAC巡检脚本.docVIP

=====================SRVCTL srvctl check========================1.列出配置的所有HYPERLINK javascript.:;HYPERLINK javascript:;数据库srvctl config database 2.显示指定集群数据库的所有服务srvctl config service -d GDTV 3.查看所有实例和服务的状态srvctl status database -d GDTV 4.查看单个实例的状态srvctl status service -d GDTV -s service_name 5.特定节点上节点应用程序的状态srvctl status nodeapps -n DBSERVER1srvctl status nodeapps -n DBSERVER2 6.列出RAC数据库的配置srvctl config database -d GDTV 7.显示节点应用程序的配置 —（VIP、GSD、ONS、监听器）srvctl config nodeapps -n DBSERVER1 -a -g -s -lsrvctl config nodeapps -n DBSERVER2 -a -g -s -l ======================process check==================8. Oracle进程检查 Ps –ef |grep ora_ 9. CRS进程检查 ps -ef | grep oracm $ps –df |grep d.bin 应有：crsd.bin ocssd.bin evmd.bin crsctl check crs crs_stat –t crs_stat –ls ==============alert.log check==================================== 8.查看各个instance的alert.log ==================instance parameters check======================== 9.查看spfile.ora 查看profile ================listener status check==============================10.$hostname$export ORACLE_SID=GDTV1$lsnrctl status $hostname$export ORACLE_SID=GDTV2$lsnrctl status listener日志检查/u01/app/oracle/product/9.2.0/network/log/listener.log /u01/app/oracle/product/9.2.0/network/log/listener.log ================oracrs status check============================ 11.1 crs日志检查ocssd.log/u01/product/oracle/oracm/log$tail -20 cm.log ======================SQLcheck==========================$hostname$export ORACLE_SID=GDTV1sqlplus /as sysdba or sqlplusHYPERLINK mailto:/as sysdba@GDTV1/as sysdba@GDTV1--run on dbHYPERLINK javascript.:;HYPERLINK javascript:;serveras sysdba!!!--collect by lyf 200609set pagesize 1000set linesize 120set echo onCOLUMN name_col_plus_show_param FORMAT a36 HEADING NAMECOLUMN value_col_plus_show_param FORMAT a30 HEADING VALUEcol tablespace_name format a15host hostname 1.集群中所有正在运行的实例 SELECTinst_id, instance_number inst_no, instance_name inst_name, parallel, status, database_status