Disclaimer

Sunday, 20 February 2022

Cluster Log Records Showing Different Time Than OS Time on 19c RAC

 Problem:

On OS the time is showing 16:00 while the Clusterware and DB logs time are showing 20:00

OS Time

 

Cluster's Log Time:

 

Analysis:

The configured timezone in the cluster environment config file was different from the OS timezone:


OS Timezone: is UTC

cat /etc/sysconfig/clock


Cluster Timezone: is Dubai

cat $GRID_HOME/crs/install/s_crsconfig_nodex1_env.txt

 

Solution:

change the Cluster timzone to be similar to OS timezone:

# vi $GRID_HOME/crs/install/s_crsconfig_nodex1_env.txt




Note: The clusterware and DB logs will pick the new timezone once you restart the clusterware.


No comments:

Post a Comment

Understanding SQL Plan Baselines in Oracle Database

  Understanding SQL Plan Baselines in Oracle Database SQL Plan Baseline is the feature in Oracle started from Database 11g that helps to pre...