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 for Me (Login
required).
          
Search for additional results

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