Oracle Grid Infrastructure Timezone

See Also

Check

  • For 11.2.0.2 and above, TZ entry in $GRID_HOME/crs/install/s_crsconfig_mynodename_env.txt shows time zone for GI.

  • Previously TZ environment variable was used.

srvctl getenv database -d mydbname

srvctl getenv nodeapps -n mynodename

srvctl getenv asm

If you are still using 11.2, then use 'getenv listener' instead of 'getenv nodeapps':

srvctl getenv listener

To see the environment for the running pmon and Listener processes...

Linux

cat /proc/$(ps -ef | grep pmon | cut -d' ' -f2)/environ

cat /proc/$(ps -ef | grep tns | cut -d' ' -f2)/environ

AIX

ps eauwww $(ps -ef | grep pmon | cut -d' ' -f2)

ps eauwww $(ps -ef | grep tns | cut -d' ' -f2)

Set Timezone

  • For 11.2.0.2 and above, TZ entry in $GRID_HOME/crs/install/s_crsconfig_mynodename_env.txt sets time zone for GI.

  • Previously TZ environment variable was used.

srvctl setenv database -d mydbname -t 'TZ=Europe/London'

srvctl setenv nodeapps -n mynodename -t 'TZ=Europe/London'

srvctl setenv asm -t 'TZ=Europe/London'

If you are still using 11.2, then use 'setenv listener' instead of 'setenv nodeapps':

srvctl setenv listener -l myListener -t 'TZ=Europe/London'

Bibliography


Incorrect SYSDATE shown when connected via Listener in RAC (Doc ID 1390015.1)How to Check the Environment Variables for an Oracle Process (Doc ID 373303.1)