1 Reply Latest reply: Mar 21, 2013 4:02 PM by RCE RSS

    http://server:port/apex/apex_admin getting a 503: Service Unavailable

    997537
      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