1 Reply Latest reply: Nov 3, 2013 8:30 PM by 7561c6f9-928e-4af3-91f6-100781be7d22 RSS

    Apex Listener 503 Error

    7561c6f9-928e-4af3-91f6-100781be7d22

      Hey everyone

       

      I'm having trouble installing the apex listener.

       

      I've installed the following

       

         - Oracle Database 12c Release 1

         - Oracle Application Express 4.2.3.00.08

         - Oracle Application Express Listener 2.0.4

       

      Running Windows 7 64 bit

       

      I've followed the readme file in pdbss_1027.zip to install Oracle Multitenant Self-Service Provisioning in apex.

       

      Any guidance in the direction I should look into would be greatly appreciated.

       

      Logs are as follows

       

      Oct 29, 2013 5:21:40 PM oracle.dbtools.rt.web.HttpEndpointBase modApex

      SEVERE: The pool named: apex is not correctly configured, error: IO Error: The N

      etwork Adapter could not establish the connection

      oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not

      correctly configured, error: IO Error: The Network Adapter could not establish the connection

              at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:65)

              at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:207)

              at oracle.dbtools.common.config.db.DatabaseConfig.getPool(DatabaseConfig.java:346)

              at oracle.dbtools.common.config.db.DatabaseConfig.getPool(DatabaseConfig.java:326)

              at oracle.dbtools.common.config.db.DatabaseConfig.access$200(DatabaseConfig.java:42)

              at oracle.dbtools.common.config.db.DatabaseConfig$DatabaseFactory.apply(DatabaseConfig.java:380)

              at oracle.dbtools.common.config.db.PerThreadConnectionCache$DisposableConnectionFactory.apply(PerThreadConnectionCache.java:233)

              at oracle.dbtools.common.config.db.PerThreadConnectionCache$DisposableConnectionFactory.apply(PerThreadConnectionCache.java:217)

              at oracle.dbtools.common.util.PerThreadCache.get(PerThreadCache.java:60)

              at oracle.dbtools.common.config.db.PerThreadConnectionCache.get(PerThreadConnectionCache.java:49)

              at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:78)

              at oracle.dbtools.common.jdbc.ora.OraPrincipal.connection(OraPrincipal.java:69)

              at oracle.dbtools.apex.ModApexContext.getConnection(ModApexContext.java:372)

              at oracle.dbtools.apex.Procedure.getProcedure(Procedure.java:167)

              at oracle.dbtools.apex.OWA.validateProcedure(OWA.java:386)

              at oracle.dbtools.apex.security.Security.isValidRequest(Security.java:220)

              at oracle.dbtools.apex.ModApex.validateRequest(ModApex.java:264)

              at oracle.dbtools.apex.ModApex.doGet(ModApex.java:93)

              at oracle.dbtools.apex.ModApex.service(ModApex.java:300)

              at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:350)

              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:91)

              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(Unknown Source)

       

       

      default.xml in apex listener

       

      <?xml version="1.0" encoding="UTF-8" standalone="no"?>

      <!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">

      <properties>

      <comment>Saved on Tue Oct 29 17:07:41 EST 2013</comment>

      <entry key="db.servicename">CDB2</entry>

      <entry key="debug.printDebugToScreen">false</entry>

      <entry key="security.disableDefaultExclusionList">false</entry>

      <entry key="db.password">******</entry>

      <entry key="cache.maxEntries">500</entry>

      <entry key="error.maxEntries">50</entry>

      <entry key="security.maxEntries">2000</entry>

      <entry key="cache.directory">/tmp/apex/cache</entry>

      <entry key="jdbc.DriverType">thin</entry>

      <entry key="log.maxEntries">50</entry>

      <entry key="db.hostname">localhost</entry>

      <entry key="jdbc.MaxConnectionReuseCount">1000</entry>

      <entry key="log.logging">false</entry>

      <entry key="jdbc.InitialLimit">3</entry>

      <entry key="jdbc.MaxLimit">10</entry>

      <entry key="cache.monitorInterval">60</entry>

      <entry key="cache.expiration">7</entry>

      <entry key="jdbc.statementTimeout">900</entry>

      <entry key="jdbc.MaxStatementsLimit">10</entry>

      <entry key="misc.defaultPage">apex</entry>

      <entry key="misc.compress"/>

      <entry key="jdbc.MinLimit">1</entry>

      <entry key="cache.type">lru</entry>

      <entry key="cache.caching">false</entry>

      <entry key="db.port">1521</entry>

      <entry key="error.keepErrorMessages">true</entry>

      <entry key="cache.procedureNameList"/>

      <entry key="cache.duration">days</entry>

      <entry key="jdbc.InactivityTimeout">1800</entry>

      <entry key="debug.debugger">false</entry>

      </properties>