Home  >  Oracle Database Administration (DBA)  >  RAC  >  Oracle clusterware log files (for 11.2 Oracle clusterware)

Oracle Database uses a unified log directory structure to consolidate the Oracle Clusterware component log files. This consolidated structure simplifies diagnostic information collection and assists during data retrieval and problem analysis.

With Oracle grid infrastructure 11g release 2 (11.2), Oracle Automatic Storage Management (Oracle ASM) and Oracle Clusterware are installed into a single home directory, which is referred to as the Grid Infrastructure home. Configuration assistants start after the installer interview process that configures Oracle ASM and Oracle Clusterware.

The installation of the combined products is called Oracle grid infrastructure. However, Oracle Clusterware and Oracle Automatic Storage Management remain separate products.

Notations

$GRID_HOME  is used in 11.2 Oracle clusterware to specify the grid (clusterware + ASM location). In previous releases we used $CRS_HOME or $ORA_CRS_HOME as environment variable for the clusterware software location (oracle cluster home). For this reason, we can set all these 3 environment variable with the same value (in .profile), but this is not mandatory. In this case we can consider GRID_BASE /oracle/grid if we want.

$GRID_HOME=/oracle/grid/11.2

$ORA_CRS_HOME=/oracle/grid/11.2

$CRS_HOME=/oracle/grid/11.2

In 11.2 grid infrastructure, the Oracle Clusterware Component Log Files are all situated in the $GRID_HOME/log/<hostname>

For instance, if my host name is tzdev1rac, all my Oracle Clusterware Component Log Files (for 11.2) are situated in $GRID_HOME/log/tzdev1rac:

pwd
/oracle/grid/11.2/log/tzdev1rac                ($GRID_HOME = /oracle/grid/11.2)
 

ls -altr
total 64
drwxrwxr-t   5   oracle   dba         256 Jul 28 20:18 racg
drwxr-x---   2    root     dba         256 Jul 28 20:18 gnsd
drwxrwxr-t  4    root     dba          256 Jul 28 20:18 agent
drwxr-x---   2   oracle   dba         256 Jul 28 20:18 admin
drwxrwxr-x  5   oracle   dba         256 Jul 28 20:18 ..
drwxr-xr-t   17   root     dba       4096 Jul 28 20:18 .
drwxr-x---   2    oracle  dba         256 Jul 28 20:24 gipcd
drwxr-x---   2    oracle  dba         256 Jul 28 20:25 mdnsd
drwxr-x---   2    root     dba         256 Jul 28 20:25 ohasd
drwxr-x---   2    oracle  dba         256 Jul 28 20:27 evmd
drwxr-x---   2    root     dba         256 Jul 31 01:08 ctssd
drwxr-x---   2    root     dba         256 Aug 1 12:44 crsd
drwxr-x---   2    oracle  dba         256 Aug 1 21:15 cssd
drwxr-x---   2    oracle  dba         256 Aug 2 14:06 diskmon
drwxr-x---   2    oracle  dba         256 Aug 2 14:46 gpnpd
-rw-rw-r--   1    root     system 16714 Aug 2 14:46 alerttzdev1rac.log
drwxr-x---   2    oracle  dba       4096 Aug 2 14:51 srvm
drwxr-x---   2    oracle  dba       4096 Aug 3 02:59 client
 

Where can we find the log files related to the listeners?

For listener.log     ($ORACLE_BASE was set during the instalation and $DIAGNOSTIC_DEST wasn't set)

      => $ORACLE_BASE/diag/tnslsnr/tzdev1rac/listener/trace/listener.log   

As of Oracle Database 11g Release 1, the diagnostics for each database instance are located in a dedicated directory, which can be specified through the DIAGNOSTIC_DEST initialization parameter. The structure of the directory specified by DIAGNOSTIC_DEST is as follows:
<diagnostic_dest>/diag/rdbms/<dbname>/<instname>   This location is known as the Automatic Diagnostic Repository (ADR) Home.

For example, if the database name is proddb and the instance name is proddb1, the ADR home directory would be <diagnostic_dest>/diag/rdbms/proddb/proddb1.

The following files are located under the ADR home directory:

Trace files - located in subdirectory <adr-home>/trace

Alert logs - located in subdirectory <adr-home>/alert. In addition, the alert.log file is now in XML format, which conforms to the Oracle ARB logging standard.

Core files - located in the subdirectory <adr-home>/cdumd

Incident files - the occurrence of each serious error (for example, ORA-600, ORA-1578, ORA-7445) causes an incident to be created. Each incident is assigned an ID and dumping for each incident (error stack, call stack, block dumps, and so on) is stored in its own file, separated from process trace files. Incident dump files are located in <adr-home>/incident/<incdir#>. You can find the incident dump file location inside the process trace file.

This parameter can be set on each instance. Oracle recommends that each instance in a cluster specify a DIAGNOSTIC_DEST directory location that is located on shared disk and that the same value for DIAGNOSTIC_DEST be specified for each instance.

If you want to see how the ADR Homes are configurated in the database you can run:

column INST_ID format 999

column NAME format a20

column VALUE format a45

select INST_ID, NAME, VALUE from V$DIAG_INFO;

More information about  this subject ( Oracle clusterware log files (for 11.2 Oracle clusterware) ) you can get from  www.in-oracle.com