http://server:port/apex/apex_admin getting a 503: Service Unavailable
Hi,
I'm configuring APEX Listener 2.0.1.64.14.25 (latest version) in Weblogic 10.3.5.0.
I've already configured successfully in my local machine. However, now I'm trying in a different server (testing environment).
I've completed all the steps provided by Oracle. When I try to access http://server:port/apex/apex_admin (or any other url within the apex pool), I get a 503 - Service Unavailable error (server name and port were omitted, of course) I was able to enable logging in the screen to see what is going on, details below. Any help on understanding what is going on will be greatly appreciated. The log message indicates that it is a problem with a ORACLE user account that is locked, however I do not know which user it is. I already have unlocked the APEX_LISTENER_USER account, so that could not be the reason.
A few facts:
- I have not installed the i.war deployment as I only need to run a PL/SQL package that uses HTP.P over the url, in the form of (http://server:port/apex/SCHEMA.PACKAGE.PROCEDURE). I assumed that i.war was only needed if I wanted to use the APEX visual environment. Could this be the problem?
- APEX has been previously installed in the DB I'm using. The only verification I made to make sure that APEX is properly installed is to run the following query and make sure that is returned "VALID": SELECT STATUS FROM DBA_REGISTRY COMP_ID = 'APEX';
Log file printed on screen when accessing the APEX url:
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/APPS.TEST_PACKAGE.SelectionForm
==== Headers in Request ====
Host: u4vmwladev01.us.dell.com:35710
Connection: keep-alive
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.172 Safari/537.22
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8,pt-BR;q=0.6,pt;q=0.4
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3
Cookie: GAAnon=7609ce12-1a9b-4e2f-8919-09a3aac37931; StormPCookie=js=1&bandwidth=NA; eSupportSegment=s=dhs&c=br&l=pt&cs=brdhs1; SITESERVER=ID=cadb98b3e6d64112890de032615ce476; s_hwp=brdhs1%7C%7Cnull%7C%7C11%3A3%3A2013%3A16%3A45%7C%7CN%7C%7CN%7C%7Cnull%7C%7C0%7C%7Cnull%7C%7Cnull%7C%7CN%7C%7Cnull%7C%7Cnull%7C%7Cnull; s_vi=[CS]v1|289F1A10051D036D-6000010A80110462[CE]; ADMINCONSOLESESSION=ZyFpRDDDtDSdb31vdQlDJ8Qyzs5LqncGGhJDgDyQWvhKYWGnF1nY!-200560660
==== Cookies in Request ====
GAAnon = 7609ce12-1a9b-4e2f-8919-09a3aac37931
StormPCookie = js=1&bandwidth=NA
eSupportSegment = s=dhs&c=br&l=pt&cs=brdhs1
SITESERVER = ID=cadb98b3e6d64112890de032615ce476
s_hwp = brdhs1%7C%7Cnull%7C%7C11%3A3%3A2013%3A16%3A45%7C%7CN%7C%7CN%7C%7Cnull%7C%7C0%7C%7Cnull%7C%7Cnull%7C%7CN%7C%7Cnull%7C%7Cnull%7C%7Cnull
s_vi = [CS]v1|289F1A10051D036D-6000010A80110462[CE]
ADMINCONSOLESESSION = ZyFpRDDDtDSdb31vdQlDJ8Qyzs5LqncGGhJDgDyQWvhKYWGnF1nY!-200560660
isValidRequest(), procedure name:
Validating: APPS.TEST_PACKAGE.SelectionForm
==== Request Processed ====
PL/SQL Gateway is unavailable, will try to process as a RESTful Service
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path does not have a path segment, cannot dispatch
No candidate found for: GET APPS.TEST_PACKAGE.SelectionForm in context: http://server:port/apex/
Unable to process as a RESTful Service, reverting to Unavailable error reported by PL/SQL Gateway
WebException [statusCode=503]
at oracle.dbtools.rt.web.WebException.webException(WebException.java:326)
at oracle.dbtools.rt.web.WebException.serviceUnavailable(WebException.java:306)
at oracle.dbtools.rt.web.WebErrorResponse.serviceUnavailable(WebErrorResponse.java:167)
at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:345)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: ORA-28000: the account is locked
at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:65)
at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:166)
at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:187)
at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:71)
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:390)
at oracle.dbtools.apex.security.Security.isValidRequest(Security.java:225)
at oracle.dbtools.apex.ModApex.validateRequest(ModApex.java:266)
at oracle.dbtools.apex.ModApex.doGet(ModApex.java:94)
at oracle.dbtools.apex.ModApex.service(ModApex.java:302)
at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:337)
... 25 more
Edited by: 994534 on Mar 18, 2013 7:51 AM
I'm configuring APEX Listener 2.0.1.64.14.25 (latest version) in Weblogic 10.3.5.0.
I've already configured successfully in my local machine. However, now I'm trying in a different server (testing environment).
I've completed all the steps provided by Oracle. When I try to access http://server:port/apex/apex_admin (or any other url within the apex pool), I get a 503 - Service Unavailable error (server name and port were omitted, of course) I was able to enable logging in the screen to see what is going on, details below. Any help on understanding what is going on will be greatly appreciated. The log message indicates that it is a problem with a ORACLE user account that is locked, however I do not know which user it is. I already have unlocked the APEX_LISTENER_USER account, so that could not be the reason.
A few facts:
- I have not installed the i.war deployment as I only need to run a PL/SQL package that uses HTP.P over the url, in the form of (http://server:port/apex/SCHEMA.PACKAGE.PROCEDURE). I assumed that i.war was only needed if I wanted to use the APEX visual environment. Could this be the problem?
- APEX has been previously installed in the DB I'm using. The only verification I made to make sure that APEX is properly installed is to run the following query and make sure that is returned "VALID": SELECT STATUS FROM DBA_REGISTRY COMP_ID = 'APEX';
Log file printed on screen when accessing the APEX url:
Request Path passes syntax validation
Mapping request to database pool: PoolMap [_poolName=apex, _regex=null, _workspaceIdentifier=null, _failed=false, _lastUpdate=-1, _template=null, _type=REGEX]
Applied database connection info
Attempting to process with PL/SQL Gateway
==== Processing Request: ====
GET /apex/APPS.TEST_PACKAGE.SelectionForm
==== Headers in Request ====
Host: u4vmwladev01.us.dell.com:35710
Connection: keep-alive
Accept: text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
User-Agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.22 (KHTML, like Gecko) Chrome/25.0.1364.172 Safari/537.22
Accept-Encoding: gzip,deflate,sdch
Accept-Language: en-US,en;q=0.8,pt-BR;q=0.6,pt;q=0.4
Accept-Charset: ISO-8859-1,utf-8;q=0.7,*;q=0.3
Cookie: GAAnon=7609ce12-1a9b-4e2f-8919-09a3aac37931; StormPCookie=js=1&bandwidth=NA; eSupportSegment=s=dhs&c=br&l=pt&cs=brdhs1; SITESERVER=ID=cadb98b3e6d64112890de032615ce476; s_hwp=brdhs1%7C%7Cnull%7C%7C11%3A3%3A2013%3A16%3A45%7C%7CN%7C%7CN%7C%7Cnull%7C%7C0%7C%7Cnull%7C%7Cnull%7C%7CN%7C%7Cnull%7C%7Cnull%7C%7Cnull; s_vi=[CS]v1|289F1A10051D036D-6000010A80110462[CE]; ADMINCONSOLESESSION=ZyFpRDDDtDSdb31vdQlDJ8Qyzs5LqncGGhJDgDyQWvhKYWGnF1nY!-200560660
==== Cookies in Request ====
GAAnon = 7609ce12-1a9b-4e2f-8919-09a3aac37931
StormPCookie = js=1&bandwidth=NA
eSupportSegment = s=dhs&c=br&l=pt&cs=brdhs1
SITESERVER = ID=cadb98b3e6d64112890de032615ce476
s_hwp = brdhs1%7C%7Cnull%7C%7C11%3A3%3A2013%3A16%3A45%7C%7CN%7C%7CN%7C%7Cnull%7C%7C0%7C%7Cnull%7C%7Cnull%7C%7CN%7C%7Cnull%7C%7Cnull%7C%7Cnull
s_vi = [CS]v1|289F1A10051D036D-6000010A80110462[CE]
ADMINCONSOLESESSION = ZyFpRDDDtDSdb31vdQlDJ8Qyzs5LqncGGhJDgDyQWvhKYWGnF1nY!-200560660
isValidRequest(), procedure name:
Validating: APPS.TEST_PACKAGE.SelectionForm
==== Request Processed ====
PL/SQL Gateway is unavailable, will try to process as a RESTful Service
Attempting to process as a RESTful Service
Determining if request can be dispatched as a Tenanted RESTful Service
Request path does not have a path segment, cannot dispatch
No candidate found for: GET APPS.TEST_PACKAGE.SelectionForm in context: http://server:port/apex/
Unable to process as a RESTful Service, reverting to Unavailable error reported by PL/SQL Gateway
WebException [statusCode=503]
at oracle.dbtools.rt.web.WebException.webException(WebException.java:326)
at oracle.dbtools.rt.web.WebException.serviceUnavailable(WebException.java:306)
at oracle.dbtools.rt.web.WebErrorResponse.serviceUnavailable(WebErrorResponse.java:167)
at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:345)
at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:130)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:820)
at weblogic.servlet.internal.StubSecurityHelper$ServletServiceAction.run(StubSecurityHelper.java:227)
at weblogic.servlet.internal.StubSecurityHelper.invokeServlet(StubSecurityHelper.java:125)
at weblogic.servlet.internal.ServletStubImpl.execute(ServletStubImpl.java:300)
at weblogic.servlet.internal.TailFilter.doFilter(TailFilter.java:26)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.security.jps.ee.http.JpsAbsFilter$1.run(JpsAbsFilter.java:111)
at oracle.security.jps.util.JpsSubject.doAsPrivileged(JpsSubject.java:313)
at oracle.security.jps.ee.util.JpsPlatformUtil.runJaasMode(JpsPlatformUtil.java:413)
at oracle.security.jps.ee.http.JpsAbsFilter.runJaasMode(JpsAbsFilter.java:94)
at oracle.security.jps.ee.http.JpsAbsFilter.doFilter(JpsAbsFilter.java:161)
at oracle.security.jps.ee.http.JpsFilter.doFilter(JpsFilter.java:71)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at oracle.dms.servlet.DMSServletFilter.doFilter(DMSServletFilter.java:136)
at weblogic.servlet.internal.FilterChainImpl.doFilter(FilterChainImpl.java:56)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.wrapRun(WebAppServletContext.java:3715)
at weblogic.servlet.internal.WebAppServletContext$ServletInvocationAction.run(WebAppServletContext.java:3681)
at weblogic.security.acl.internal.AuthenticatedSubject.doAs(AuthenticatedSubject.java:321)
at weblogic.security.service.SecurityManager.runAs(SecurityManager.java:120)
at weblogic.servlet.internal.WebAppServletContext.securedExecute(WebAppServletContext.java:2277)
at weblogic.servlet.internal.WebAppServletContext.execute(WebAppServletContext.java:2183)
at weblogic.servlet.internal.ServletRequestImpl.run(ServletRequestImpl.java:1454)
at weblogic.work.ExecuteThread.execute(ExecuteThread.java:209)
at weblogic.work.ExecuteThread.run(ExecuteThread.java:178)
Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not correctly configured, error: ORA-28000: the account is locked
at oracle.dbtools.common.jdbc.ConnectionPoolException.badConfiguration(ConnectionPoolException.java:65)
at oracle.dbtools.common.config.db.DatabaseConfig.badConfiguration(DatabaseConfig.java:166)
at oracle.dbtools.common.config.db.DatabaseConfig.createPool(DatabaseConfig.java:187)
at oracle.dbtools.common.config.db.DatabaseConfig.getConnection(DatabaseConfig.java:71)
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:390)
at oracle.dbtools.apex.security.Security.isValidRequest(Security.java:225)
at oracle.dbtools.apex.ModApex.validateRequest(ModApex.java:266)
at oracle.dbtools.apex.ModApex.doGet(ModApex.java:94)
at oracle.dbtools.apex.ModApex.service(ModApex.java:302)
at oracle.dbtools.rt.web.HttpEndpointBase.modApex(HttpEndpointBase.java:337)
... 25 more
Edited by: 994534 on Mar 18, 2013 7:51 AM
