Location of Different Logfiles In Exadata Environment
On the cell nodes
=============
#1. Cell alert.log file
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log
or
if the CELLTRACE parameter is set just do cd $CELLTRACE
#2. MS logfile
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.log.
or
if the CELLTRACE parameter is set just do cd $CELLTRACE
#3. OS watcher output data
/opt/oracle.oswatcher/osw/archive/
To get OS watcher data of specific date :
cd /opt/oracle.oswatcher/osw/archive
find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
where 12- year 01- Month 13-day
#4. Os message logfile
/var/log/messages
#5. VM Core files
/var/log/oracle/crashfiles
More details can be found in the following note:
Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)
#6. SunDiag output files.
/tmp/sundiag_.tar.bz2
#7. Cell patching issues related logfiles:
/var/log/cellos
The major logfile of patch application output you will find in the db node from where you are patching in the location /tmp/<cell version>/patchmgr.stdout and patchmgr.err
#8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/MegaCli64 -fwtermlog -dsply -a0
On the Database nodes
=====================
#1. Database alert.log
$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log
Ex: /u01/app/oracle/diag/rdbms/dbfs/DBFS2/trace/alert_DBFS2.log
#2. ASM alert.log
$ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/ alert_+ASM {instance number}.log
Ex: /u01/app/oracle/diag/asm/+asm/+ASM2/trace/alert_+ASM2.log
#3. Clusterware CRS alert.log
$GRID_HOME/log/{node name}/alert{node name}.log
Ex: /u01/app/11.2.0/grid/log/dmorldb02/alertdmorldb02.log
#4. Diskmon logfiles
$GRID_HOME/log/{node name}/diskmon/diskmon.lo*
Ex: /u01/app/11.2.0/grid/log/dmorldb02/diskmon/diskmon.log
#5. OS Watcher output files
/opt/oracle.oswatcher/osw/archive/
To get OS watcher data of specific date :
cd /opt/oracle.oswatcher/osw/archive
find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
where 12- year 01- Month 13-day
#6. Os message logfile
/var/log/messages
#7. VM Core files for Linux
/u01/crashfiles
More details can be found in the following note:
Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)
#8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/MegaCli64 -fwtermlog -dsply -a0
On the cell nodes
=============
#1. Cell alert.log file
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/alert.log
or
if the CELLTRACE parameter is set just do cd $CELLTRACE
#2. MS logfile
/opt/oracle/cell/log/diag/asm/cell/{node name}/trace/ms-odl.log.
or
if the CELLTRACE parameter is set just do cd $CELLTRACE
#3. OS watcher output data
/opt/oracle.oswatcher/osw/archive/
To get OS watcher data of specific date :
cd /opt/oracle.oswatcher/osw/archive
find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
where 12- year 01- Month 13-day
#4. Os message logfile
/var/log/messages
#5. VM Core files
/var/log/oracle/crashfiles
More details can be found in the following note:
Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)
#6. SunDiag output files.
/tmp/sundiag_.tar.bz2
#7. Cell patching issues related logfiles:
/var/log/cellos
The major logfile of patch application output you will find in the db node from where you are patching in the location /tmp/<cell version>/patchmgr.stdout and patchmgr.err
#8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/MegaCli64 -fwtermlog -dsply -a0
On the Database nodes
=====================
#1. Database alert.log
$ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log
Ex: /u01/app/oracle/diag/rdbms/dbfs/DBFS2/trace/alert_DBFS2.log
#2. ASM alert.log
$ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/ alert_+ASM {instance number}.log
Ex: /u01/app/oracle/diag/asm/+asm/+ASM2/trace/alert_+ASM2.log
#3. Clusterware CRS alert.log
$GRID_HOME/log/{node name}/alert{node name}.log
Ex: /u01/app/11.2.0/grid/log/dmorldb02/alertdmorldb02.log
#4. Diskmon logfiles
$GRID_HOME/log/{node name}/diskmon/diskmon.lo*
Ex: /u01/app/11.2.0/grid/log/dmorldb02/diskmon/diskmon.log
#5. OS Watcher output files
/opt/oracle.oswatcher/osw/archive/
To get OS watcher data of specific date :
cd /opt/oracle.oswatcher/osw/archive
find . -name '*12.01.13*' -print -exec zip /tmp/osw_`hostname`.zip {} \;
where 12- year 01- Month 13-day
#6. Os message logfile
/var/log/messages
#7. VM Core files for Linux
/u01/crashfiles
More details can be found in the following note:
Where / How to find OS crashcore file in Exadata Systems [Linux] (Doc ID 1389225.1)
#8. Disk controller firmware logs:
/opt/MegaRAID/MegaCli/MegaCli64 -fwtermlog -dsply -a0
No comments:
Post a Comment