Inventory location :
/var/opt/oracle/oraInst.loc or /etc/oraInst.loc
OUI log files :
/logs/InstallActions.log
/logs/oraInstall.out
/logs/oraInstall.err
/logs/silentInstall.log
/cfgtoollogs/oui/InstallActions.log
/cfgtoollogs/oui/oraInstall.out
/cfgtoollogs/oui/oraInstall.err
/cfgtoollogs/oui/silentInstall.log
DB Alert log : $ORACLE_BASE/diag/rdbms/{DBNAME}/{sid}/trace/alert_{sid}.log
<adr-home>/alert
ASM Alert log : $ORACLE_BASE/diag/asm/+asm/+ASM{instance number}/trace/ alert_+ASM{instance number}.log
Listener log : $ORACLE_BASE/diag/tnslsnr/{HOSTNAME}/listener/trace/listener.log
SCAN Listeners : $GRID_HOME/log/diag/tnslsnr/<NodeName>/listener_scan1/trace/listener_scan1.log
$GRID_HOME/log/diag/tnslsnr/<NodeName>/listener_scan2/trace/listener_scan2.log
$GRID_HOME/log/diag/tnslsnr/<NodeName>/listener_scan3/trace/listener_scan3.log
DB Alert log (11gR1) : $GRID_HOME/log/{node name}/alert{node name}.log
Diskmon log files : $GRID_HOME/log/{node name}/diskmon/diskmon.lo*
Os message logfiles : /var/log/messages
OS Watcher output files : /opt/oracle.oswatcher/osw/archive/ (linux)
12.1.0.2 onwards :
Clusterware alert log(.log) and all other files are in $ADR_BASE/diag/crs/`hostname`/crs with .trc extension
11g :
Clusterware alert log: $GRID_HOME/log/<host>/alert<host>.log
Disk Monitor daemon: $GRID_HOME/log/<host>/diskmon
OCRDUMP, OCRCHECK, OCRCONFIG, CRSCTL: $GRID_HOME/log/<host>/client
Cluster Time Synchronization Service: $GRID_HOME/log/<host>/ctssd
Grid Interprocess Communication daemon: $GRID_HOME/log/<host>/gipcd
Oracle High Availability Services daemon: $GRID_HOME/log/<host>/ohasd
Cluster Ready Services daemon: $GRID_HOME/log/<host>/crsd
Cluster Synchronization Service daemon: $GRID_HOME/log/<host>/cssd
Grid Plug and Play daemon: $GRID_HOME/log/<host>/gpnpd
Mulitcast Domain Name Service daemon: $GRID_HOME/log/<host>/mdnsd
Event Manager daemon: $GRID_HOME/log/<host>/evmd
RAC RACG ( if pre-11.1 db installed): $GRID_HOME/log/<host>/racg
Server Manager: $GRID_HOME/log/<host>/srvm
HA Service Daemon Agent: $GRID_HOME/log/<host>/agent/ohasd/oraagent_oracle11
HA Service Daemon CSS Agent: $GRID_HOME/log/<host>/agent/ohasd/oracssdagent_root
HA Service Daemon ocssd Monitor Agent: $GRID_HOME/log/<host>/agent/ohasd/oracssdmonitor_root
HA Service Daemon Oracle Root Agent: $GRID_HOME/log/<host>/agent/ohasd/orarootagent_root
CRS Daemon Oracle Agent: $GRID_HOME/log/<host>/agent/crsd/oraagent_oracle11
CRS Daemon Oracle Root Agent: $GRID_HOME/log/<host> agent/crsd/orarootagent_root
Grid Naming Service daemon: $GRID_HOME/log/<host>/gnsd
10g RAC Log Directory : Cluster Ready Services Daemon (crsd) Log Files
• The Cluster Ready Services Daemon (crsd) Log Files
$CRS_home/log/hostname/crsd
• Oracle Cluster Registry (OCR) Log Files
$CRS_Home/log/hostname/client
• Cluster Synchronization Services (CSS) Log Files
$CRS_Home/log/hostname/cssd
• Event Manager (EVM) Log Files
$CRS_Home/log/hostname/evmd
• RACG Log Files
$ORACLE_HOME/log/hostname/racg
select ORIGINATING_TIMESTAMP,HOST_ID,HOST_ADDRESS,DETAILED_LOCATION,MODULE_ID,
CLIENT_ID,PROCESS_ID,USER_ID,MESSAGE_ID,MESSAGE_GROUP,MESSAGE_TEXT,PROBLEM_KEY,FILENAME
from V$DIAG_ALERT_TEXT WHERE trim(COMPONENT_ID)='tnslsnr';
Using adrci :
select ORIGINATING_TIMESTAMP ,message_text from X$DBGALERTEXT where ORIGINATING_TIMESTAMP> systimestamp - INTERVAL '0 10:00:00.0' DAY TO SECOND(1);
SELECT name,value FROM v$diag_info;
adrci> show tracefiles %.log
adrci> show trace listener.log
adrci> show trace alert_db11.log
