Changing Timezone Settings on Oracle Database Servers
Looking for updates if any for 12c.
Twice now in the past month, I have run across some clients that are wanting to change the timezone of their database due to a server relocation. Both cases ended up being a bit similar, one a single instance and the other on Exadata. Since I had to lookup how to do it the seconds time, I thought I would blog about it. Here’s the info on how to view the timezone settings and how to change them.
These settings shown were valid for DB 188.8.131.52 and above on Redhat/Oracle Linux 6.
Look at /etc/localtime to see the timezone setting for the server. The
setting should be set to an entry in the /usr/share/zoneinfo directory/subdirectory.
Grid Timezone Setting
Config File in Grid Home
The TZ entry in $GRID_HOME/crs/install/s_crsconfig__env.txt the timezone entry for the Grid Home; hence, the ASM and listener.
Grid Infrastructure Settings
If TZ is set via…
View original post 86 more words