Thursday, September 3, 2015

Oracle 12.1.0.2c Standard Cluster: New Location / Name For Alert Log

Oracle 12.1.0.2c Standard Cluster: New Location / Name For Alert Log


There is a bug  I discovered an empty clusterware alert log in its conventional location i.e.  $ORACLE_HOME/log/in 12.1.0.2 standard cluster.
[grid@host01 ~]$ crsctl query crs activeversion;
Oracle Clusterware active version on the cluster is [12.1.0.2.0]

[root@host01 host01]# ls -l /u01/app/12.1.0/grid/log/host01/alerthost01.log

-rw-rw-r– 1 grid oinstall 0 Jun 15 14:10 /u01/app/12.1.0/grid/log/host01/alerthost01.log
But as commented by few people,  in 12c,  the location of alert log has been changed to $ORACLE_BASE/diag/crs//crs/trace/
Hence, I could successfully  the alert log on node host01 in directory  $ORACLE_BASE/diag/crs/host01/crs/trace/
[grid@host01 trace]$ ls -l $ORACLE_BASE/diag/crs/host01/crs/trace/alert*

-rw-rw—- 1 root oinstall 812316 Aug 11 10:22 /u01/app/grid/diag/crs/host01/crs/trace/alert.log
Another noticeable thing is that name of clusterware alert log has been changed to alert.log as compared to alert.log in 11g.
I would like to mention that I have verified the above only in 12.1.0.2 standard cluster.
In 12.1.0.1 flex cluster though, the location and name of  alert log location is same as in 11g i.e. $ORACLE_HOME/log/host01
[root@host01 host01]# crsctl query crs activeversion
Oracle Clusterware active version on the cluster is [12.1.0.1.0]

[root@host01 host01]# ls -l $ORACLE_HOME/log/host01/alert*
-rw-rw-r-- 1 grid oinstall 497364 Aug 11 11:00 /u01/app/12.1.0/grid/log/host01/alerthost01.log
Conclusion:
12.1.0.2 standard cluster
  • Name of alert log : alert.log
  • location of alert log: $ORACLE_BASE/diag/crs/host01/crs/trace
12.1.0.1 flex cluster
  • Name of alert log : alert.log
  • location of alert log: $ORACLE_HOME/log/host01

No comments: