oracle rac 错误日志路径,ORACLE 11G RAC--日志路径

ORACLE集群在做问题排查时，需要查看日志。这些日志都集群中都是存放在那里的？

1.集群相关日志主要放在$ORACLE_CRS_HOME/log,$ORACLE_HOME/log中。

$ORACLE_CRS_HOME/log目录下内容如下

[oracle@rac1 log]$ pwd

/u01/app/11.2.0/11ggrid/log

[oracle@rac1 log]$ ls

crs/  diag/  rac1/

[oracle@rac1 log]$

$ORACLE_HOME/log内容如下

[oracle@rac1 log]$ cd $ORACLE_HOME

[oracle@rac1 dbhome_1]$ cd log

[oracle@rac1 log]$ pwd

/u01/app/oracle/product/11.2.0/dbhome_1/log

[oracle@rac1 log]$ ls

diag/  rac1/

[oracle@rac1 log]$

2.具体日志与目录的对应说明

CRS日志存放在$ORACLE_CRS_HOME/log/HOSTNAME/crsd下[oracle@rac1 crsd]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1/crsd

[oracle@rac1 crsd]$ ll

total 6212

-rw-r--r-- 1 root root 6338257 Sep 21 22:24 crsd.log

-rw-r--r-- 1 root root     812 Sep  7 00:06 crsdOUT.log

-rw-r--r-- 1 root root     114 Aug  7 20:10 crsd.trc[oracle@rac1 crsd]$ tail -10 crsd.log

TextMessage[rac1]

WAIT:

TextMessage[0]

]

2012-09-21 22:24:01.928: [UiServer][2604460944] Container [ Name: UI_DATA

RESULT:

TextMessage[223]

]

2012-09-21 22:24:01.928: [UiServer][2604460944] Done for ctx=0xc605e68

2012-09-21 22:24:01.937: [  CRSCCL][2648554384]clscsend completed:msgTag= 0xcccccccc version= 0 msgType= 0 msgId= 130 msglen = 991 clschdr.size_clscmsgh= 1079 src= (1, 4294366130) dest= (2, 4294385480)

[oracle@rac1 crsd]$CSS日志存放在“$ORA_CRS_HOME/log//cssd”目录

[oracle@rac1 cssd]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1/cssd

[oracle@rac1 cssd]$ ls

cssdOUT.log  ocssd.l01  ocssd.l02  ocssd.l03  ocssd.l04  ocssd.log  ocssd.trc

[oracle@rac1 cssd]$ more cssdOUT.log

08/07/12 20:08:56: CSSD starting

08/07/12 20:11:08: CSSD starting

08/15/12 23:23:27: CSSD starting

08/17/12 19:48:02: CSSD handling signal 15

08/17/12 19:48:02: CSSD killed

08/17/12 19:50:12: CSSD starting

08/17/12 22:42:00: CSSD handling signal 15

08/17/12 22:42:00: CSSD killed

08/17/12 22:44:22: CSSD starting

08/18/12 22:17:57: CSSD handling signal 15

08/18/12 22:17:57: CSSD killed

08/18/12 22:20:10: CSSD starting

09/07/12 00:05:14: CSSD starting

[oracle@rac1 cssd]$EVM日志存放在“$ORA_CRS_HOME/log//evmd”目录

[oracle@rac1 evmd]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1/evmd

[oracle@rac1 evmd]$ ls

evmd.log  evmdOUT.log  evmd.trc

[oracle@rac1 evmd]$ more evmd.log

Oracle Database 11g Clusterware Release 11.2.0.1.0 - Production Copyright 1996, 2009

Oracle. All rights reserved.

[  clsdmt][3046398864]Listening to (ADDRESS=(PROTOCOL=ipc)(KEY=rac1DBG_EVMD))

2012-08-07 20:12:17.831: [  clsdmt][3046398864]PID for the Process [19602], connkey

2

2012-08-07 20:12:17.839: [  clsdmt][3046398864]Creating PID [19602] file for home /u

01/app/11.2.0/11ggrid host rac1 bin evm to /u01/app/11.2.0/11ggrid/evm/init/

2012-08-07 20:12:17.865: [  clsdmt][3046398864]Writing PID [19602] to the file [/u01

/app/11.2.0/11ggrid/evm/init/rac1.pid]

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CLSVER

0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CLUCLS

0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: COMMCR

S  0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: COMMNS

0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CRSOCR

0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: CSSCLN

T  0

2012-08-07 20:12:18.302: [ default][3046692560] ENV Logging level for Module: EVMAGE

NT  0

2012-08-07 20:12:18.303: [ default][3046692560] ENV Logging level for Module: EVMAPP

0

2012-08-07 20:12:18.303: [ default][3046692560] ENV Logging level for Module: EVMCOM

M  0

2012-08-07 20:12:18.303: [    EVMD][3046692560] ENV Logging level for Module: EVMD

0

--More--(1%)

$ORA_CRS_HOME/log/和$ORACLE_HOME/log/目录中的racg目录中记录了RACG可执行文件对应的日志

[oracle@rac1 racg]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1/racg

[oracle@rac1 racg]$ ls

racgeut/  racgevtf/  racgmain/

[oracle@rac1 racg]$

$ORA_CRS_HOME/log//client和$ORACLE_HOME/log //client”目录记录了与srvctl、ocrdump、ocrconfig以及ocrcheck命令对应的日志 信息。

[oracle@rac1 rac1]$ pwd

/u01/app/oracle/product/11.2.0/dbhome_1/log/rac1

[oracle@rac1 rac1]$ ls

client/

[oracle@rac1 rac1]$

[[oracle@rac1 client]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1/client

[oracle@rac1 client]$ ls

clscfg.log          ocrcheck_25681.log   oifcfg11.trc  oifcfg6.trc

crsctl.log          ocrcheck_6982.log    oifcfg12.trc  oifcfg7.trc

crsctl.trc          ocrconfig_17191.log  oifcfg13.trc  oifcfg8.trc

gpnptool_17951.log  ocrconfig_17634.log  oifcfg14.trc  oifcfg9.trc

gpnptool_17951.trc  ocrconfig_18620.log  oifcfg1.trc   oifcfg.log

gpnptool_17959.log  ocrconfig_20321.log  oifcfg2.trc   oifcfg.trc

gpnptool_17959.trc  ocrconfig_25725.log  oifcfg3.trc   olsnodes.log

oclskd.log          ocrdump_25560.log    oifcfg4.trc   olsnodes.trc

ocrcheck_16786.log  oifcfg10.trc         oifcfg5.trc

[oracle@rac1 client]$

集群中ALERT文件的位置$ORACLE_CRS_HOME/LOG/HOSTNAME下

[oracle@rac1 rac1]$ pwd

/u01/app/11.2.0/11ggrid/log/rac1

[oracle@rac1 rac1]$ ls

admin/  alertrac1.log  crsd/  ctssd/    evmd/   gnsd/   mdnsd/  racg/

agent/  client/        cssd/  diskmon/  gipcd/  gpnpd/  ohasd/  srvm/

[oracle@rac1 rac1]$