Different Logs Locations in Oracle RAC Environment | Oracle Database
In a single instance Oracle Database Environment (without ASM), it is easier to track different logs which helps you find information regarding different running processes, active or inactive sessions, active/inactive transactions, Start/Shutdown instances, errors or issues and a lot of more details. But in case of a Oracle RAC Environment, we have a lot of more Oracle Components in the Architecture which increases the workspace for a DBA and it gets trouble-full to memorize everything. In case of issues in Oracle RAC Environment, it gets very difficult as there are a number of running processes and threads which will be having their individual logs to shows their activity status.
What I am providing you here is a little help to find out the logs easily if you know where you have to look for:
The Cluster Ready Services Daemon (crsd) Log Files
Log files for the CRSD process (crsd) can be found in the following directories:
$CRS_HOME/log/hostname/crsd
Oracle Cluster Registry (OCR) Log Files
The Oracle Cluster Registry (OCR) records log information in the following location:
$CRS_HOME/log/hostname/client
Cluster Synchronization Services (CSS) Log Files
You can find CSS information that the OCSSD generates in log files in the following locations:
$CRS_HOME/log/hostname/cssd
Event Manager (EVM) Log Files
Event Manager (EVM) information generated by evmd is recorded in log files in the following locations:
$CRS_HOME/log/hostname/evmd
RACG Log Files
The Oracle RAC high availability trace files are located in the following two locations:
CRS home/log/hostname/racg
$ORACLE_HOME/log/hostname/racg
Oracle Clusterware log files
Cluster Ready Services Daemon (crsd) Log Files:
$CRS_HOME/log/hostname/crsd
Cluster Synchronization Services (CSS):
$CRS_HOME/log/hostname/cssd
Event Manager (EVM) information generated by evmd:
$CRS_HOME/log/hostname/evmd
Oracle RAC RACG:
$CRS_HOME/log/hostname/racg
$ORACLE_HOME/log/hostname/racg
Oracle RAC 11g Release 2 log files
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
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 (For use only if Oracle database version is prior 11.1):
$GRID_HOME/log/<host>/racg
Cluster Synchronization Service daemon:
$GRID_HOME/log/<host>/cssd
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
No comments:
Post a Comment