Database Install/Upgrade/Opatch (MOSC)

MOSC Banner

Upgrade Oracle database 12.1.0.2.0 to 19.3.0 - "not a valid time zone"

Hi folks,

I'm seeing an issue with time zone when I run my autoupgrade. I'm upgrading from 12.1.0.2.0 to 19.3.0. See the error sample below.

021-05-14 16:52:12.944 INFO 92%Upgraded
2021-05-14 16:54:36.193 ERROR
DATABASE NAME: DBATEST
        CAUSE: ERROR at Line 807265 in [/u01/app/oracle/cfgtoollogs/autoupgrade/DBATEST/DBATEST/108/dbupgrade/catupgrd20210514162552dbatest0.log]
       REASON: ORA-01857: not a valid time zone
       ACTION: [MANUAL]
       DETAILS: 01857, 00000, "not a valid time zone"
// *Cause:
// *Action:

2021-05-14 16:54:36.222 ERROR
DATABASE NAME: DBATEST
        CAUSE: ERROR at Line 807266 in [/u01/app/oracle/cfgtoollogs/autoupgrade/DBATEST/DBATEST/108/dbupgrade/catupgrd20210514162552dbatest0.log]
       REASON: ORA-06512: at line 35
       ACTION: [MANUAL]
       DETAILS: 06512, 00000, "at %sline %s"
// *Cause:  Backtrace message as the stack is unwound by unhandled
//          exceptions.
// *Action: Fix the problem causing the exception or write an exception
//          handler for this condition. Or you may need to contact your
//          application administrator or DBA.

2021-05-14 16:54:36.247 ERROR
DATABASE NAME: DBATEST
         CAUSE: ERROR at Line 807267 in [/u01/app/oracle/cfgtoollogs/autoupgrade/DBATEST/DBATEST/108/dbupgrade/catupgrd20210514162552dbatest0.log]
        REASON: ORA-06512: at "SYS.DBMS_PRVTAQIM", line 631
        ACTION:

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