0 Replies Latest reply: Apr 12, 2011 4:56 AM by 853520 RSS

    Oracle10g:  javavm timezones upgrade

    853520
      When using java stored procedures, the original 10g timezones javavm data files are outdated.

      What is the right procedure for an upgrade?
      I discovered one, which is successfull (New timezone data is available). But i do not know whether this procedure is 'state of the art'. Maybe side effects can show up.

      Steps taken.

      Set oracle_SID
      In SQLPlus Logon Sys as sysdba
      SQL> SHUTDOWN

      I used tzupdater tool to upgrade the tz information of a java runtime on a local computer.
      I took the tz folder of the java runtime an replaced the ORA_HOME/javavm/lib/tz folder with the new one.

      Restart using startup migrate
      SQL> STARTUP MIGRATE
      - connect as SYS and do the following
      SQL> create or replace java system;
      /

      - Shutdown the database. SQL> SHUTDOWN
      - Restart the each database normally
      SQL>startup

      I tested the procedure with the America/North_Dakota/Beulah timezone.
      Before upgrade, the GMT datetime was given (which is the default for unknown timezones)
      After upgrade , the correct datetime GMT-5 (during DTS) is given.


      Any feedback is welcome.