1 Reply Latest reply: Oct 20, 2012 3:40 AM by Udo RSS

    APEX Listener 2 - Error

    FMignault
      Hi ,

      I am trying to install the listener 2.0 on an Amazon EC2 instance. (AMI: amzn-ami-pv-2012.09.0.x86_64-ebs (ami-1624987f) )

      When I start as standalone (java -jar apex.war) I get the followin error :

      --------

      Oct 19, 2012 5:03:27 PM oracle.dbtools.standalone.Standalone execute
      INFO: Starting standalone Web Container in: /home/ec2-user/apex
      Oct 19, 2012 5:03:27 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Will deploy application path = /home/ec2-user/apex/apex/WEB-INF/web.xml
      Oct 19, 2012 5:03:28 PM oracle.dbtools.standalone.Deployer deploy
      INFO: Deployed application path = /home/ec2-user/apex/apex/WEB-INF/web.xml
      Oct 19, 2012 5:03:28 PM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /home/ec2-user/apex
      Oct 19, 2012 5:03:29 PM oracle.dbtools.common.config.db.DatabaseConfig badConfiguration
      SEVERE: The pool named: apex is not correctly configured, error: ORA-00604: error occurred at recursive SQL level 1
      ORA-01882: timezone region not found

      ConnectionPoolException [error=BAD_CONFIGURATION]
           at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:62)
           at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:146)
           at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:168)
           at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:68)
           at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:25)
           at oracle.dbtools.common.jdbc.BaseJDBCCallProvider.connection(BaseJDBCCallProvider.java:145)
           at oracle.dbtools.common.jdbc.BaseJDBCCallProvider.activated(BaseJDBCCallProvider.java:86)
           at oracle.dbtools.common.jdbc.ora.OraJDBCCallProvider.init(OraJDBCCallProvider.java:56)
           at oracle.dbtools.common.jdbc.ora.OraJDBCCallProvider.access$100(OraJDBCCallProvider.java:23)
           at oracle.dbtools.common.jdbc.ora.OraJDBCCallProvider$1.configurationChanged(OraJDBCCallProvider.java:80)
           at oracle.dbtools.common.config.file.ConfigurationFiles.changed(ConfigurationFiles.java:216)
           at oracle.dbtools.common.config.file.ConfigurationFiles.addListener(ConfigurationFiles.java:61)
           at oracle.dbtools.common.config.GlobalConfiguration.addListener(GlobalConfiguration.java:21)
           at oracle.dbtools.common.jdbc.ora.OraJDBCCallProvider.activate(OraJDBCCallProvider.java:32)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:616)
           at oracle.dbtools.common.service.__Reflections.invoke(__Reflections.java:85)
           at oracle.dbtools.common.service.Provider.activate(Provider.java:47)
           at oracle.dbtools.common.service.Provider.match(Provider.java:122)
           at oracle.dbtools.common.service.Providers.match(Providers.java:45)
           at oracle.dbtools.common.service.ServiceLocator.acquireAll(ServiceLocator.java:133)
           at oracle.dbtools.common.service.ServiceLocator.acquire(ServiceLocator.java:111)
           at oracle.dbtools.common.service.ServiceLocator.acquire(ServiceLocator.java:124)
           at oracle.dbtools.common.service.ServiceLocator.acquire(ServiceLocator.java:106)
           at oracle.dbtools.apex.Connections.init(Connections.java:72)
           at oracle.dbtools.apex.Connections.access$000(Connections.java:21)
           at oracle.dbtools.apex.Connections$1.configurationChanged(Connections.java:90)
           at oracle.dbtools.common.config.file.ConfigurationFiles.changed(ConfigurationFiles.java:216)
           at oracle.dbtools.common.config.file.ConfigurationFiles.addListener(ConfigurationFiles.java:61)
           at oracle.dbtools.apex.Connections.setup(Connections.java:66)
           at oracle.dbtools.rt.web.SCListener.contextInitialized(SCListener.java:59)
           at com.sun.grizzly.http.servlet.ServletContextImpl.initListeners(ServletContextImpl.java:173)
           at oracle.dbtools.standalone.MimeTypesServletContext.initListeners(MimeTypesServletContext.java:20)
           at com.sun.grizzly.http.servlet.ServletAdapter.configureServletEnv(ServletAdapter.java:527)
           at oracle.dbtools.standalone.SecureServletAdapter.configureServletEnv(SecureServletAdapter.java:122)
           at com.sun.grizzly.http.servlet.ServletAdapter.start(ServletAdapter.java:336)
           at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.start(GrizzlyAdapterChain.java:135)
           at com.sun.grizzly.http.SelectorThread.initEndpoint(SelectorThread.java:1175)
           at com.sun.grizzly.http.SelectorThread.listen(SelectorThread.java:1228)
           at com.sun.grizzly.http.embed.GrizzlyWebServer.start(GrizzlyWebServer.java:678)
           at oracle.dbtools.standalone.Deployer.start(Deployer.java:280)
           at oracle.dbtools.standalone.Standalone.execute(Standalone.java:96)
           at oracle.dbtools.common.cmds.DefaultCommand.execute(DefaultCommand.java:106)
           at oracle.dbtools.common.cmds.Commands.main(Commands.java:91)
           at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
           at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:57)
           at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
           at java.lang.reflect.Method.invoke(Method.java:616)
           at oracle.dbtools.jarcl.Entrypoint.main(Entrypoint.java:58)
      Default Database connection not configured properly
      Oct 19, 2012 5:03:29 PM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.0.268.17.05
      Application Express Listener server info: Grizzly/1.9.49

      Oct 19, 2012 5:03:29 PM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 10/19/12 5:03 PM
      Oct 19, 2012 5:03:29 PM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8080/apex started.


      ------------

      Looks like there is a problem with the Timezone.

      I saw a post regarding a similar error : ORA-01882: timezone region  not found

      Not sure if it's the same issue and I don't know where to set the -Duser.timezone parameter in the Listener config... and to what value it should be set.


      Thanks.

      Francis.
        • 1. Re: APEX Listener 2 - Error
          Udo
          Hi Francis,

          I think you've actually hit that timezone issue, because the root cause seems to be
          ORA-01882: timezone region not found
          which is more a database related issue: The database doesn't know the timezone your EC2 instance is using.
          Try running something like
          date
          date +"%Z %z"
          to find out your current time zone setting and either take the second value (numerical) of the second output to set your APEX Listener's timezone or one of the abbreviations that fits to your region and is in the list of supported time zone regions of your database version.
          You need to set this time zone when you start your JEE container. In your case, this is the embedded one ("Standalone Mode"), so the call would look like
          java -Duser.timezone=<yourtimezonehere> -jar apex.war
          -Udo