12 Replies Latest reply: Sep 26, 2012 7:27 AM by Dimitri Gielis RSS

    Problem installing 2.0 EA

    pchiu
      I am using 1.1.4 without problem and today I am trying the new 2.0 EA.
      Environment:
      Apex 4.1.1
      oracle linux 6
      database: 11g XE
      Grassfish : 3.1.2.2
      java version "1.6.0_20"
      OpenJDK Runtime Environment (IcedTea6 1.9.7) (rhel-1.39.1.9.7.el6-x86_64)
      OpenJDK 64-Bit Server VM (build 19.0-b09, mixed mode)

      I ran java -jar apex.war and enter all the parameters, using standalone mode.
      Here is the error log on the screen, any idea what went wrong?
              
      # java -jar apex.war 
      This Listener instance has not yet been configured.
      Please complete the following prompts
      
      Enter the location to store configuration data:/etc
      Aug 12, 2012 3:31:17 AM oracle.dbtools.common.config.cmds.ConfigDir execute
      INFO: Set config.dir to /etc in: /u01/app/oracle/src/tmp/apex.war
      Aug 12, 2012 3:31:20 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /etc/apex
      Enter the name of the database server [localhost]:
      Enter the database listen port [1521]:
      Enter 1 to specify the database service name, or 2 to specify the database SID [1]:2
      Enter the database SID [xe]:
      Enter the database user name [APEX_PUBLIC_USER]:
      Enter the database password for APEX_PUBLIC_USER:
      Confirm password:
      Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:2
      Aug 12, 2012 3:31:36 AM oracle.dbtools.common.config.file.ConfigurationFiles update
      INFO: Updated configurations: defaults, apex, apex_al, apex_rt
      Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
      Enter the APEX static resources location or Enter to skip:/u01/apex/images
      Enter the HTTP port [8080]:8888
      Aug 12, 2012 3:31:59 AM oracle.dbtools.standalone.Standalone execute
      INFO: NOTE:
      
      Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.
      
      Aug 12, 2012 3:31:59 AM oracle.dbtools.standalone.Standalone execute
      INFO: Starting standalone Web Container in:  /etc/apex
      Aug 12, 2012 3:31:59 AM oracle.dbtools.standalone.Deployer deploy
      INFO: Will deploy application path = /etc/apex/apex/WEB-INF/web.xml
      Aug 12, 2012 3:31:59 AM oracle.dbtools.standalone.Deployer deploy
      INFO: Deployed application path = /etc/apex/apex/WEB-INF/web.xml
      Aug 12, 2012 3:31:59 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
      INFO: Using configuration folder: /etc/apex
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.sid=xe
      debug.debugger=false
      debug.printDebugToScreen=false
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=false
      log.maxEntries=50
      misc.compress=
      misc.defaultPage=apex
      security.disableDefaultExclusionList=false
      security.maxEntries=2000
      db.username=APEX_PUBLIC_USER
      Using JDBC driver: Oracle JDBC driver version: 11.2.0.1.0
      Aug 12, 2012 3:32:01 AM oracle.dbtools.rt.web.SCListener contextInitialized
      INFO: Oracle Application Express Listener initialized
      Application Express Listener version : 2.0.0.215.16.37
      Application Express Listener server info: Grizzly/1.9.49
      
      Aug 12, 2012 3:32:01 AM com.sun.grizzly.Controller logVersion
      INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 8/12/12 3:32 AM
      Aug 12, 2012 3:32:01 AM oracle.dbtools.standalone.Standalone execute
      INFO: http://localhost:8888/apex started.
      cache.caching=false
      cache.directory=/tmp/apex/cache
      cache.duration=days
      cache.expiration=7
      cache.maxEntries=500
      cache.monitorInterval=60
      cache.procedureNameList=
      cache.type=lru
      db.hostname=localhost
      db.password=******
      db.port=1521
      db.sid=xe
      debug.debugger=false
      debug.printDebugToScreen=false
      error.keepErrorMessages=true
      error.maxEntries=50
      jdbc.DriverType=thin
      jdbc.InactivityTimeout=1800
      jdbc.InitialLimit=3
      jdbc.MaxConnectionReuseCount=1000
      jdbc.MaxLimit=10
      jdbc.MaxStatementsLimit=10
      jdbc.MinLimit=1
      jdbc.statementTimeout=900
      log.logging=false
      log.maxEntries=50
      misc.compress=
      misc.defaultPage=apex
      security.disableDefaultExclusionList=false
      security.maxEntries=2000
      db.username=APEX_LISTENER
      Aug 12, 2012 3:32:17 AM com.sun.grizzly.http.servlet.ServletAdapter doService
      SEVERE: service exception:
      java.lang.NullPointerException
              at oracle.dbtools.common.config.db.DatabasePoolConfig.addMap(DatabasePoolConfig.java:121)
              at oracle.dbtools.common.config.db.DatabasePoolConfig.readPoolConfig(DatabasePoolConfig.java:259)
              at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDBFromTime(DatabasePoolConfig.java:175)
              at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDB(DatabasePoolConfig.java:152)
              at oracle.dbtools.common.config.db.DatabasePoolConfig.getInstance(DatabasePoolConfig.java:291)
              at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.poolInfo(DatabaseConnectionFilter.java:60)
              at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.applyDatabaseConnectionInfo(DatabaseConnectionFilter.java:71)
              at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
              at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
              at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
              at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
              at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
              at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
              at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
              at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
              at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
              at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
              at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
              at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
              at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
              at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
              at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
              at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
              at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
              at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
              at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
              at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
              at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
              at java.lang.Thread.run(Thread.java:636)
        • 1. Re: Problem installing 2.0 EA
          646561
          Hi

          Is there any response to this issue?

          I have the same issue too (different environment though), logs posted below.

          Apex 3.2
          SUSE Linux ES 11
          Weblogic 12c - 12.1.1
          java version "1.6.0_33"
          Oracle JRockit(R) (build R28.2.4-14-151097-1.6.0_33-20120618-1634-linux-x86_64, compiled mode).


          I have created the config parameters using "java -jar apex.war", and have these files on my server. But at no point is there a mention of where to place these files, and they are never repackaged into the apex.war. So I'm assuming there are some steps missing from the docs provided.

          Please could you get back to us on this as we could really do with running multiple data sources.......


          Log output:

          cache.caching=false
          cache.directory=/tmp/apex/cache
          cache.duration=days
          cache.expiration=7
          cache.maxEntries=500
          cache.monitorInterval=60
          cache.procedureNameList=
          cache.type=lru
          db.hostname=10.176.247.99
          db.password=******
          db.port=1521
          db.sid=ITD112
          debug.debugger=false
          debug.printDebugToScreen=false
          error.keepErrorMessages=true
          error.maxEntries=50
          jdbc.DriverType=thin
          jdbc.InactivityTimeout=1800
          jdbc.InitialLimit=3
          jdbc.MaxConnectionReuseCount=1000
          jdbc.MaxLimit=10
          jdbc.MaxStatementsLimit=10
          jdbc.MinLimit=1
          jdbc.statementTimeout=900
          log.logging=false
          log.maxEntries=50
          misc.compress=
          misc.defaultPage=apex
          security.disableDefaultExclusionList=false
          security.maxEntries=2000
          db.username=APEX_LISTENER
          Aug 15, 2012 2:58:53 PM oracle.dbtools.common.config.db.DatabasePoolConfig loadFromDBFromTime
          SEVERE: null
          ConnectionPoolException [error=BAD_CONFIGURATION]
          at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:25)
          at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:50)
          at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:32)
          at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDBFromTime(DatabasePoolConfig.java:169)
          at oracle.dbtools.common.config.db.DatabasePoolConfig.getPoolInfo(DatabasePoolConfig.java:55)
          at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.poolInfo(DatabaseConnectionFilter.java:60)
          at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.applyDatabaseConnectionInfo(DatabaseConnectionFilter.java:71)
          at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
          at javax.servlet.http.HttpServlet.service(HttpServlet.java:844)
          at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:242)
          at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:216)
          at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:132)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:338)
          at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:221)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3284)
          at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3254)
          at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
          at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
          at weblogic.servlet.provider.WlsSubjectHandle.run(WlsSubjectHandle.java:57)
          at weblogic.servlet.internal.WebAppServletContext.doSecuredExecute(WebAppServletContext.java:2163)
          at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2089)
          at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2074)
          at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1513)
          at weblogic.servlet.provider.ContainerSupportProviderImpl$WlsRequestExecutor.run(ContainerSupportProviderImpl.java:254)
          at weblogic.work.ExecuteThread.execute(ExecuteThread.java:256)
          at weblogic.work.ExecuteThread.run(ExecuteThread.java:221)
          Caused by: oracle.ucp.UniversalConnectionPoolException: Error during pool creation in Universal Connection Pool Manager
          at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
          at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
          at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:575)
          at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:94)
          at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:48)
          ... 24 more
          Caused by: oracle.ucp.UniversalConnectionPoolException: Universal Connection Pool already exists in the Universal Connection Pool Manager. Universal Connection Pool cannot be added to the Universal Connection Pool Manager
          at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:421)
          at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:389)
          at oracle.ucp.util.UCPErrorHandler.newUniversalConnectionPoolException(UCPErrorHandler.java:403)
          at oracle.ucp.admin.UniversalConnectionPoolManagerBase.setConnectionPool(UniversalConnectionPoolManagerBase.java:614)
          at oracle.ucp.admin.UniversalConnectionPoolManagerBase.createConnectionPool(UniversalConnectionPoolManagerBase.java:571)
          ... 26 more
          • 2. Re: Problem installing 2.0 EA
            pchiu
            weekly bump

            Does anyone successfully run 2.0 EA in quick and easy standalone mode? Thanks.
            • 3. Re: Problem installing 2.0 EA
              Svetoslav Gyurov
              Hi,

              This is because you're running XE and images are stored in the XML DB repository. You should run listener with --apex-images parameter and point the directory containing the APEX images. The images could be found within the latest patch (or any previous patch depending on your version of APEX).

              I found that these error messages are related to that whether you installed APEX Listener with RESTful services or not. I supposed you didn't patched APEX to support RESTful services ?

              I've just published short guide on how to run APEX Listener with Oracle XE:
              http://sve.to/2012/08/23/how-to-run-standalone-oracle-apex-listener-2-0-with-oracle-11g-xe-and-apex-4-1-1/

              Regards,
              Sve
              • 4. Re: Problem installing 2.0 EA
                Udo
                Hi,

                in the log output you've provided I see
                db.username=APEX_PUBLIC_USER
                ... for the first database user and
                db.username=APEX_LISTENER
                ... for the RESTful Services database users. This one is new in 2.0 EA. Could it be you haven't created APEX_LISTENER yet? While APEX_PUBLIC_USER is part of the default APEX installation, APEX_LISTENER is created by a patch for APEX included in the 2.0 EA package.

                -Udo
                • 5. Re: Problem installing 2.0 EA
                  pchiu
                  These commands should confirm that my connection is working.
                  oracle@11gxe:~$ sqlplus apex_listener/sdfsdfsdfsdfs@localhost:1521/xe
                  
                  SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 23 13:47:11 2012
                  
                  Copyright (c) 1982, 2011, Oracle.  All rights reserved.
                  
                  
                  Connected to:
                  Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
                  
                  SQL> exit
                  Disconnected from Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
                  oracle@11gxe:~$ sqlplus apex_public_user/sjfsdkjfsdfs@localhost:1521/xe
                  
                  SQL*Plus: Release 11.2.0.2.0 Production on Thu Aug 23 13:47:35 2012
                  
                  Copyright (c) 1982, 2011, Oracle.  All rights reserved.
                  
                  
                  Connected to:
                  Oracle Database 11g Express Edition Release 11.2.0.2.0 - 64bit Production
                  
                  SQL> exit
                  • 6. Re: Problem installing 2.0 EA
                    pchiu
                    Hi Svetoslav,

                    The 4.1 to 4.11 patch was done many months ago and I did apply the RESTFUL patch that came with 2.0EA. The apex-images path is correct as well.
                    I have a feeling that I have existing RESTFUL setup in my 4.1.1/listener 1.1.4 that giving me problem now.

                    I am going to setup a VM and try it again using a fresh new installation and see what happen. Thank you for your blog.
                    • 7. Re: Problem installing 2.0 EA
                      Svetoslav Gyurov
                      Hi,

                      I found APEX Listener to have a strange behavior for which I'll probably start a new thread. I found the same error messages and few more for wrong username and password if APEX_LISTENER has different password than APEX_PUBLIC_USER. Although I explicitly setup APEX Listener without RESTful services and have set db.username=APEX_PUBLIC_USER after another exception I'm seeing in the log file that db.username is equal to APEX_LISTENER.

                      Anyway PC8888 do you see APEX login page or you see blank page ? Also if it's a blank page, what is the page source ? What you could try is to set same password for both users APEX_LISTENER and APEX_PUBLIC_USER.

                      Udo, having APEX_PUBLIC_USER is enough for running APEX Listener, the messages in log files are wrong.

                      Regards,
                      Sve
                      • 8. Re: Problem installing 2.0 EA
                        Udo
                        Although I explicitly setup APEX Listener without RESTful services and have set db.username=APEX_PUBLIC_USER after another exception I'm seeing in the log file that db.username is equal to APEX_LISTENER.
                        You should find two entries for the two connection pools, and though I haven't tested it myself yet, I'd expect you'll only see the latter one if you configured APEX Listener to use them. If you really didn't do that, this would be an error. Can you reproduce that, i.e. did you try to delete your configuration and restart from scratch?
                        Udo, having APEX_PUBLIC_USER is enough for running APEX Listener, the messages in log files are wrong.
                        I know that, but I'm not sure the messages are wrong, because it has been chosen to use the RESTful services in one of the steps of the configuration dialogue at the first startup.
                        What you could try is to set same password for both users APEX_LISTENER and APEX_PUBLIC_USER.
                        ... which also depends on what you've configured.

                        -Udo
                        • 9. Re: Problem installing 2.0 EA
                          pchiu
                          There is no error when I start up the standalone apex listener. Error shows up (my first post) when I hit the listener via my browser. It said "INTERNAL ERROR" on my browser.

                          Anyway, I setup VM, fresh installation of everything and it works $*&#*&$#. My conclusion is somehow my apex installation inside 11g is messed up. Looking at all database objects via toad, nothing invalid. I can only guess it is originated from apex version 3, upgrade multiple times to 4.1.1 and end up where I am.

                          I am going to export everything, purge apex and install everything. Thank you everybody for your help.
                          • 10. Re: Problem installing 2.0 EA
                            Dimitri Gielis
                            I'm having the same issue in one of my VMs (Oracle Linux 6.3, Oracle DB 11.2.0.2, APEX 4.1.1 patched to support REST, APEX Listener 2.0 EA)

                            I restarted the configuration multiple times, this is my last attempt to configure and run in standalone (I would normally deploy to Glassfish, but want to get standalone to work first) :
                            [oracle@oel apex_listener]$ java -jar apex.war
                            Sep 16, 2012 11:34:39 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
                            INFO: Using configuration folder: /home/oracle/apex
                            Enter the name of the database server [localhost]:
                            Enter the database listen port [1521]:
                            Enter 1 to specify the database service name, or 2 to specify the database SID [1]:
                            Enter the database service name:orcl
                            Enter the database user name [APEX_PUBLIC_USER]:
                            Enter the database password for APEX_PUBLIC_USER:
                            Confirm password:
                            Enter 1 to enter passwords for the RESTful Services database users (APEX_LISTENER,APEX_REST_PUBLIC_USER), 2 to use the same password as used for APEX_PUBLIC_USER or, 3 to skip this step [1]:2
                            Sep 16, 2012 11:35:04 AM oracle.dbtools.common.config.file.ConfigurationFiles update
                            INFO: Updated configurations: defaults, apex, apex_al, apex_rt
                            Enter 1 if you wish to start in standalone mode or 2 to exit [1]:1
                            Enter the APEX static resources location or Enter to skip:/home/oracle/apex/images
                            Enter the HTTP port [8080]:8082
                            Sep 16, 2012 11:35:21 AM oracle.dbtools.standalone.Standalone execute
                            INFO: NOTE:
                            
                            Standalone mode is designed for use in development and test environments. It is not supported for use in production environments.
                            
                            Sep 16, 2012 11:35:21 AM oracle.dbtools.standalone.Standalone execute
                            INFO: Starting standalone Web Container in:  /home/oracle/apex
                            Sep 16, 2012 11:35:21 AM oracle.dbtools.standalone.Deployer deploy
                            INFO: Will deploy application path = /home/oracle/apex/apex/WEB-INF/web.xml
                            Sep 16, 2012 11:35:22 AM oracle.dbtools.standalone.Deployer deploy
                            INFO: Deployed application path = /home/oracle/apex/apex/WEB-INF/web.xml
                            Sep 16, 2012 11:35:22 AM oracle.dbtools.common.config.file.ConfigurationFolder logConfigFolder
                            INFO: Using configuration folder: /home/oracle/apex
                            cache.caching=false
                            cache.directory=/tmp/apex/cache
                            cache.duration=days
                            cache.expiration=7
                            cache.maxEntries=500
                            cache.monitorInterval=60
                            cache.procedureNameList=
                            cache.type=lru
                            db.hostname=localhost
                            db.password=******
                            db.port=1521
                            db.servicename=orcl
                            debug.debugger=false
                            debug.printDebugToScreen=false
                            error.keepErrorMessages=true
                            error.maxEntries=50
                            jdbc.DriverType=thin
                            jdbc.InactivityTimeout=1800
                            jdbc.InitialLimit=3
                            jdbc.MaxConnectionReuseCount=1000
                            jdbc.MaxLimit=10
                            jdbc.MaxStatementsLimit=10
                            jdbc.MinLimit=1
                            jdbc.statementTimeout=900
                            log.logging=false
                            log.maxEntries=50
                            misc.compress=
                            misc.defaultPage=apex
                            security.disableDefaultExclusionList=false
                            security.maxEntries=2000
                            db.username=APEX_PUBLIC_USER
                            Using JDBC driver: Oracle JDBC driver version: 11.2.0.1.0
                            Sep 16, 2012 11:35:32 AM oracle.dbtools.rt.web.SCListener contextInitialized
                            INFO: Oracle Application Express Listener initialized
                            Application Express Listener version : 2.0.0.215.16.37
                            Application Express Listener server info: Grizzly/1.9.49
                            
                            Sep 16, 2012 11:35:32 AM com.sun.grizzly.Controller logVersion
                            INFO: GRIZZLY0001: Starting Grizzly Framework 1.9.49 - 9/16/12 11:35 AM
                            Sep 16, 2012 11:35:32 AM oracle.dbtools.standalone.Standalone execute
                            INFO: http://localhost:8082/apex started.
                            cache.caching=false
                            cache.directory=/tmp/apex/cache
                            cache.duration=days
                            cache.expiration=7
                            cache.maxEntries=500
                            cache.monitorInterval=60
                            cache.procedureNameList=
                            cache.type=lru
                            db.hostname=localhost
                            db.password=******
                            db.port=1521
                            db.servicename=orcl
                            debug.debugger=false
                            debug.printDebugToScreen=false
                            error.keepErrorMessages=true
                            error.maxEntries=50
                            jdbc.DriverType=thin
                            jdbc.InactivityTimeout=1800
                            jdbc.InitialLimit=3
                            jdbc.MaxConnectionReuseCount=1000
                            jdbc.MaxLimit=10
                            jdbc.MaxStatementsLimit=10
                            jdbc.MinLimit=1
                            jdbc.statementTimeout=900
                            log.logging=false
                            log.maxEntries=50
                            misc.compress=
                            misc.defaultPage=apex
                            security.disableDefaultExclusionList=false
                            security.maxEntries=2000
                            db.username=APEX_LISTENER
                            Sep 16, 2012 11:35:38 AM com.sun.grizzly.http.servlet.ServletAdapter doService
                            SEVERE: service exception:
                            java.lang.NullPointerException
                                 at oracle.dbtools.common.config.db.DatabasePoolConfig.addMap(DatabasePoolConfig.java:121)
                                 at oracle.dbtools.common.config.db.DatabasePoolConfig.readPoolConfig(DatabasePoolConfig.java:259)
                                 at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDBFromTime(DatabasePoolConfig.java:175)
                                 at oracle.dbtools.common.config.db.DatabasePoolConfig.loadFromDB(DatabasePoolConfig.java:152)
                                 at oracle.dbtools.common.config.db.DatabasePoolConfig.getInstance(DatabasePoolConfig.java:291)
                                 at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.poolInfo(DatabaseConnectionFilter.java:60)
                                 at oracle.dbtools.rt.jdbc.DatabaseConnectionFilter.applyDatabaseConnectionInfo(DatabaseConnectionFilter.java:71)
                                 at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)
                                 at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
                                 at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.doFilter(ServletAdapter.java:1059)
                                 at com.sun.grizzly.http.servlet.ServletAdapter$FilterChainImpl.invokeFilterChain(ServletAdapter.java:999)
                                 at com.sun.grizzly.http.servlet.ServletAdapter.doService(ServletAdapter.java:434)
                                 at oracle.dbtools.standalone.SecureServletAdapter.doService(SecureServletAdapter.java:65)
                                 at com.sun.grizzly.http.servlet.ServletAdapter.service(ServletAdapter.java:379)
                                 at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
                                 at com.sun.grizzly.tcp.http11.GrizzlyAdapterChain.service(GrizzlyAdapterChain.java:196)
                                 at com.sun.grizzly.tcp.http11.GrizzlyAdapter.service(GrizzlyAdapter.java:179)
                                 at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:849)
                                 at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:746)
                                 at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1045)
                                 at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:228)
                                 at com.sun.grizzly.DefaultProtocolChain.executeProtocolFilter(DefaultProtocolChain.java:137)
                                 at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:104)
                                 at com.sun.grizzly.DefaultProtocolChain.execute(DefaultProtocolChain.java:90)
                                 at com.sun.grizzly.http.HttpProtocolChain.execute(HttpProtocolChain.java:79)
                                 at com.sun.grizzly.ProtocolChainContextTask.doCall(ProtocolChainContextTask.java:54)
                                 at com.sun.grizzly.SelectionKeyContextTask.call(SelectionKeyContextTask.java:59)
                                 at com.sun.grizzly.ContextTask.run(ContextTask.java:71)
                                 at com.sun.grizzly.util.AbstractThreadPool$Worker.doWork(AbstractThreadPool.java:532)
                                 at com.sun.grizzly.util.AbstractThreadPool$Worker.run(AbstractThreadPool.java:513)
                                 at java.lang.Thread.run(Thread.java:679)
                            You don't get that error immediate, only when you try to access the url in a browser.

                            I checked the users (APEX_PUBLIC_USER, APEX_LISTENER, APEX_REST_PUBLIC_USER) where created correctly and I can login in SQL*Plus with those users.
                            I tried the same password for all and different passwords for the users in the configuration. I also recompiled all invalid objects in APEX (after applying the patch).

                            I enabled the extra debugging parameters, but that doesn't really show more info.
                            • 11. Re: Problem installing 2.0 EA
                              685473
                              Hi,

                              Try the newest version APEX listener 2.0.0.268.17.04.

                              I had the same error as you described.
                              With the latest version the error has been solved.

                              Regards,

                              Mathieu Meeuwissen
                              • 12. Re: Problem installing 2.0 EA
                                Dimitri Gielis
                                Same here, with EA2 the issues is resolved.