Oracle Database Appliance (ODA) (MOSC)

MOSC Banner

After ODA 19.6 upgrade databases display wrong sysdate from connections via listener

Hi, Since the guy affected to my SR has gone awol, I’ll try to ask my question here.

We’ve finished the 18.8 to 19.6 ODA upgrade that include an Oracle Linux 6 to Oracle Linux 7 upgrade.

Users are reporting a 1 hour time drift from their app. Problem confirmed via sqlplus on my workstation.

Seems like the databases started with a wrong timezone :

SQL> select to_char(ORIGINATING_TIMESTAMP,'YYYY/MM/DD HH24:MI:SS TZH:TZM') from V$DIAG_ALERT_EXT WHERE trim(COMPONENT_ID)='rdbms' and MESSAGE_TEXT like ('PMON started with%') order by originating_timestamp desc;

TO_CHAR(ORIGINATING_TIMEST

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center