The following tables detail the location and purpose of the Oracle database log files and trace files. This includes Database log files and Grid Infrastructure log files written to as part of a RAC cluster or Oracle's HA solutions. For example, Grid Interprocess Communication Daemon log file, Database Alert Log, rsmn trace files etc
| Component |
Log file location |
Notes |
| Clusterware Alert Log |
$ORA_CRS_HOME/log/hostname/alerthostname.log |
|
| Disk Monitor Daemon |
$ORA_CRS_HOME/log/hostname/diskmon |
|
| OCRDUMP, OCRCHECK, OCRCONFIG, CRSCTL |
$ORA_CRS_HOME/log/hostname/client |
|
| Cluster Time Synchronization Service |
$ORA_CRS_HOME/log/hostname/ctssd |
|
| Grid Interprocess Communication Daemon |
$ORA_CRS_HOME/log/hostname/gipcd |
|
| Oracle High Availability Services Daemon |
$ORA_CRS_HOME/log/hostname/ohasd |
|
| Cluster Ready Services Daemon |
$ORA_CRS_HOME/log/hostname/crsd |
|
| Grid Plug and Play Daemon |
$ORA_CRS_HOME/log/hostname/gpnpd |
|
| Mulitcast Domain Name Service Daemon |
$ORA_CRS_HOME/log/hostname/mdnsd |
|
| Event Manager Daemon |
$ORA_CRS_HOME/log/hostname/evmd |
|
| Cluster Synchronization Service Daemon |
$ORA_CRS_HOME/log/hostname/cssd |
|
| Server Manager |
$ORA_CRS_HOME/log/hostname/srvm |
|
| HA Service Daemon Agent |
$ORA_CRS_HOME/log/hostname/agent/ohasd/oraagent_oracle |
|
| HA Service Daemon CSS Agent |
$ORA_CRS_HOME/log/hostname/agent/ohasd/oracssdagent_root |
|
| HA Service Daemon ocssd Monitor Agent |
$ORA_CRS_HOME/log/hostname/agent/ohasd/oracssdmonitor_root |
|
| HA Service Daemon Oracle Root Agent |
$ORA_CRS_HOME/log/hostname/agent/ohasd/orarootagent_root |
|
| CRS Daemon Oracle Agent |
$ORA_CRS_HOME/log/hostname/agent/crsd/oraagent_oracle |
|
| CRS Daemon Oracle Root Agent |
$ORA_CRS_HOME/log/hostname/agent/crsd/orarootagent_root |
|
| Grid Naming Service Daemon |
$ORA_CRS_HOME/log/hostname/gnsd |
|
| SCAN Listener Logs |
$ORA_CRS_HOME/log/diag/tnslsnr/hostname/listener_scanN/trace |
where N is the node number |
| Component |
Log file location |
Notes |
| PMON trace file |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pmon_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Process Spawner Process |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pspN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Virtual Keeper of Time |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_vktm_PID.trc |
where SID is the database SID and PID is the OS process ID |
| General Task Execution |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_genN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Diagnostic Capture |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_diag_PID.trc |
where SID is the database SID and PID is the OS process ID |
| DB Resource Manager |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dbrm_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Interconnect Latency |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ping_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Automic CF to Memory |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_acms_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Diagnostic Process |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_diaN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Global ENQ Service Monitor |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmon_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Global ENQ Service Daemon |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmdN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Global Cache Serivce |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmsN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| RAC Management |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rmsN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Global Cache/ENQ HB Mon |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lmhb_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Memory Manager |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mman_PID.trc |
where SID is the database SID and PID is the OS process ID |
| DB Writer |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dbwN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Log Writer |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lgwr_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Checkpoint |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ckpt_PID.trc |
where SID is the database SID and PID is the OS process ID |
| System Monitor |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_smon_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Recovery |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_reco_PID.trc |
where SID is the database SID and PID is the OS process ID |
| ASM Rebalance Master |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rbal_PID.trc |
where SID is the database SID and PID is the OS process ID |
| ASM Background |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_asmb_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Manageability Monitor |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mmon_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Manageability Monitor Lite |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mmnl_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Mark AU Sync Coordinator |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_mark_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Instance ENQ Background |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_lckN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| Remote Slave Monitor |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rsmn_PID.trc |
where SID is the database SID and PID is the OS process ID |
| DG Broker Monitor |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_dmon_PID.trc |
where SID is the database SID and PID is the OS process ID |
| PQ Slave |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_pxxx_PID.trc |
where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| ASM Connection Pool |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_oxxx_PID.trc |
where SID is the database SID, xxx is the proc No and PID is the OS process ID |
| Archiver |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_arcN_PID.trc |
where SID is the database SID, N is the process No and PID is the OS process ID |
| REDO Transport |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_nsaN_PID.trc |
where SID is the database SID, N is the proc No and PID is the OS process ID |
| Global Transaction |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_gtxN_PID.trc |
where SID is the database SID, N is the proc No and PID is the OS process ID |
| Result Cache |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_rcbg_PID.trc |
where SID is the database SID and PID is the OS process ID |
| AQ Coordinator |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_qmnc_PID.trc |
where SID is the database SID and PID is the OS process ID |
| AQ Server Class |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_qxxx_PID.trc |
where SID is the database SID, xxx is the proc No and PID is the OS process ID |
| Space Mgmt Coordinator |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_smco_PID.trc |
where SID is the database SID and PID is the OS process ID |
| Job Queue Coordinator |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_cjqN_PID.trc |
where SID is the database SID, N is the proc No and PID is the OS process ID |
| Space Mgmt Slave |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_wxxx_PID.trc |
where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| Space Mgmt Slave |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_wxxx_PID.trc |
where SID is the database SID, xxx is the slave No and PID is the OS process ID |
| User Process |
$ORACLE_BASE/diag/rdbms/database_name/SID/trace/SID_ora_PID.trc |
where SID is the database SID and PID is the OS process ID |
