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/<hostname>/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/<hostname>/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/<hostname>和$ORACLE_HOME/log/<hostname>目錄中的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/<hostname>/client和$ORACLE_HOME/log /<hostname>/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]$