This discussion is archived
1 Reply Latest reply: Oct 20, 2012 1:40 AM by Udo RSS

APEX Listener 2 - Error

FMignault Oracle ACE
Currently Being Moderated
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 Guru
    Currently Being Moderated
    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

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points