1 Reply Latest reply: Aug 1, 2013 5:06 AM by FreddieEssex RSS

    timezone upgrading

    user13134974

      Hi , I am going to upgrade my database from 10g 10.2.0.3 to 11.2.0.3 . After running utlu112i.sql I got recommendation to upgrade time as 4. Presently my timezone value is 3. Could you please help me in this regard. what patch I will use to upgrade timezone 4. OS AIX 6.1

       

       

      Regards

       

      Rabi

        • 1. Re: timezone upgrading
          FreddieEssex

          Presumably you mean upgrade to DST version 14?

           

          Check this Oracle Note for details - Actions For DST Updates When Upgrading To Or Applying The 11.2.0.3 Patchset (Doc ID 1358166.1)

          See Section B.3b) When upgrading from 10.1.0.x , 10.2.0.x or 11.1.0.x to 11.2.0.3:

           

          Also take a look at the following MOS Note:

          Updating the RDBMS DST version in 11g Release 2 (11.2.0.1 and up) using DBMS_DST (Doc ID 977512.1)