Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Exadata OEL6 to OEL7 upgrade. DB TimeZone issue

Hello all.
After upgrading OS on Exadata dbnodes from OEL6 to OEL7, all corresponding databases were started with UTC time zone and "local" timezone was ignored.

[root@hostname~]# timedatectl
      Local time: Wed 2021-03-03 12:46:04 PST
  Universal time: Wed 2021-03-03 20:46:04 UTC
        RTC time: Wed 2021-03-03 20:46:02
       Time zone: America/Los_Angeles (PST, -0800)
     NTP enabled: yes
NTP synchronized: yes
 RTC in local TZ: no
      DST active: no
 Last DST change: DST ended at
                  Sun 2020-11-01 01:59:59 PDT
                  Sun 2020-11-01 01:00:00 PST
 Next DST change: DST begins (the clock jumps one hour forward) at
                  Sun 2021-03-14 01:59:59 PST
                  Sun 2021-03-14 03:00:00 PDT
[root@hostname~]# date
Wed Mar  3 12:46:17 PST 2021

So, the sysdate and systimestamp returns date in UTC instead of PST.
No changes in srvctl envs, server env variables, $GRID_HOME/crs/install/s_crsconfig_$HOSTNAME_env.txt were done.

Does anybody fased with similar?
What should check additionally ?

Comments
Post Details
Added on Mar 3 2021
0 comments
118 views