1 Reply Latest reply on Apr 29, 2011 10:51 PM by Sandra Hunt

    Stand alone APEX listener install fails with timezone region  not found

    Sandra Hunt
      Hi,

      I have searched the forum but found only a thread for the installation with Goldfish.

      I am very new to all this so I apologise if my problem is too simple, but please help as I am very frustrated with it.

      I have a 10.2.0.4 database on Windows XP for testing with.

      I installed APEX into it successfully, then down loaded the listener.

      I have to Java installations, one under my Oracle Home, the other under Middleware where I have JDeveloper installed.

      If I try $ORACLE_HOME/jdk/bin/java -jar apex.war it throws a Unsupported class version so I tried with the Middleware jdk and it appeared to install.

      I then went to http://localhost:8080/apex/listenerConfigure and entered the password for APEX_PUBLIC_USER and the info for a basic connection, it fails with the following message

      Request could not be processed due to error:

      Sat Apr 30 00:06:30 CAT 2011

      ORA-00604: error occurred at recursive SQL level 1
      ORA-01882: timezone region not found

      Please if anyone can help me through asap this I would be most grateful
        • 1. Re: Stand alone APEX listener install fails with timezone region  not found
          Sandra Hunt
          Yay, I found the solution:

          I started by running:

          begin
          for v_rec in (select tzname,tz_offset(tzname) v_offset from v$timezone_names
          where tzabbrev='CAT') loop
          dbms_output.put_line('tzname '||v_rec.tzname||', offset '|| v_rec.v_offset);
          end loop;
          end;
          SQL> /
          tzname Africa/Khartoum, offset +03:00
          tzname Africa/Windhoek, offset +01:00
          tzname America/Anchorage, offset -08:00
          tzname US/Alaska, offset -08:00

          PL/SQL procedure successfully completed.

          I then added -Duser.timezone="+01:00" before the apex.war ie

          java –jar -Duser.timezone="+01:00" apex.war