8 Replies Latest reply: Sep 1, 2012 1:27 PM by Srini Chavali-Oracle RSS

    database timezone change after upgradation

      Hi All,

      I did the upgrade from to grid Oracle restart with asm on linux.
      The upgradation was done successfully. now the client is compalning that the time zone change from CDT to UTC.

      SQL> select DBTIMEZONE from dual;


      It was 00:00 before upgrade. I dont know how the time zone got changed after upgradation.

      As i can see OS is also using UTC time zone. Now I am confused.

      Sat Aug 25 17:57:02 UTC 2012

      Os is also using UTC. I guess the database will also use the same time zone which OS uses.

      If time zone is changed now. How to change it to previous time zone?
      Please suggest.