SAP Knowledge Base Article - Preview

2747101 - ORA-01857: not a valid time zone - during Oracle upgrade to 12.2

Symptom

During the upgrade to Oracle 12.2 from 12.1 the following problem arise in DBUA:

///////////////
ORA-01857: not a valid time zone,
ORA-06512: at line 24, ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2420,
ORA-06512: at "SYS.DBMS_PRVTAQIM", line 4712,
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1730,
ORA-01875: time zone minute must be between -59 and +59
ORA-06512: at line 24,
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 2420,
ORA-06512: at "SYS.DBMS_PRVTAQIM", line 4712,
ORA-06512: at "SYS.DBMS_AQADM_SYS", line 1730,
///////////////

ORA-01857.jpg



            


Read more...

Environment

 Oracle Release 12c

Keywords

DBUA, ORA-01857, ORA-06512, ORA-01875, Oracle, DBMS_PRVTAQIM, DBMS_AQADM_SYS, time, zone, upgrade, SYSTEM, AQ$, AQ

, KBA , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.