Forum Stats

  • 3,768,655 Users
  • 2,252,827 Discussions
  • 7,874,669 Comments

Discussions

503-service unavailable error after deploying apex listener on glassfish

Ketan Madhak
Ketan Madhak Member Posts: 34
edited Jul 1, 2015 2:56AM in APEX Discussions

Hi All,

I have installed apex 5.0,jdk-1.7,glassfish-3.1.2.2 on win7. Configured domain and deployed apex.war successfully on glassfish but when i m trying to access the links which generated on click of launch of application (apex listener)

http://xyz:8686/apex

https://xyx:8181/apex

It gives me an error 503-service unavailable.

Any help appreciated..


Thanks.

ReemaPuri

Best Answer

  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited Jul 1, 2015 2:56AM Accepted Answer

    Hi Ketan,

    Ketan Madhak wrote :
    
    Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not
    correctly configured, error: ORA-28000: the account is locked
    

        This is the root cause of your issue.

        The apex pool in ORDS corresponds to the database APEX_PUBLIC_USER and it is not correctly configured.

        Connect to the SQL Plus prompt with SYS user and SYSDBA privileges and run the following query:

    select username
        , account_status
        , profile
      from dba_users
    where username in ('APEX_PUBLIC_USER','APEX_LISTENER','APEX_REST_PUBLIC_USER');
    

        If the account status is LOCKED, EXPIRED, etc then unlock the user accounts for example:

    ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <password> ACCOUNT UNLOCK;
    

        Discard/delete the current ORDS configuration and re-configure ords.war/apex.war with correct passwords for the users. Re-deploy it to Glassfish Server.

    Regards,

    Kiran

Answers

  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited Jun 30, 2015 10:57AM

    Hi Ketan,

    Ketan Madhak wrote:
    
    I have installed apex 5.0,jdk-1.7,glassfish-3.1.2.2 on win7. Configured domain and deployed apex.war successfully on glassfish but when i m trying to access the links which generated on click of launch of application (apex listener) http://xyz:8686/apex https://xyx:8181/apex It gives me an error 503-service unavailable.

         What is the ORDS(formerly APEX Listener) version you are using?

         Please share your environment details.

         There is something wrong with your ORDS configuration. Have you searched OTN forum for related threads?

         It is mostly due to locked DB user or wrong configuration.

         Following are some threads that might help:

         If the issue still persist, you can create a new question with required details on appropriate forum :

         Hope this helps!

    Regards,

    Kiran

    ReemaPuri
  • Ketan Madhak
    Ketan Madhak Member Posts: 34
    edited Jul 1, 2015 12:41AM

    ords version is 2.0.10... i have done configuration as

    1) creation of conf directory

    2)java -jar ords.war configdir E:\SOFTWARE\ORACLE\ords.2.0.10\conf

    3) Rename ords.war to apex.war

    4) java  - jar apex.war

        Database server: Localhost

        Port:                       1521

        SID :                       xe

        APEX_PUBLIC_USER

        Password: XYZ

       Press 2 to use same password for APEX_LISTENER and APEX_REST_PUBLIC_USER

      Press 2 to exit.

    5)created two users adminlistener and managerlistener in glassfish server under Configuration->default-config->Security->Realms->file

    6)deployed apex.war under application->deploy in glassfish server.


  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited Jul 1, 2015 1:10AM

    Hi Ketan,

    Ketan Madhak wrote:
    
    ords version is 2.0.10... i have done configuration as
    

         Are you referring the ORDS 2.0 Documentation for this purpose?

         There are two steps you are missing:

    • Creating i.war and deploying it to Glassfish Server.

         Refer : http://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7044

    • Configuration of RESTful Services while installing ORDS.

         This includes two steps:

    • Configuring RESTful Services while installing Oracle APEX?

        Refer : https://docs.oracle.com/cd/E59726_01/install.50/e39144/listener.htm#HTMIG29335

        Refer : http://docs.oracle.com/cd/E37099_01/doc.20/e25066/install.htm#AELIG7217

         Why is the Configuring of RESTful Services important (when using Oracle APEX 5.0)? The reason is:

        The Configuring Static File Support in the Application Express Installation Guide(using ORDS) says:

        The configuration of RESTful Services is required when upgrading to Oracle Application Express release 5.0 and RESTful Services were not configured in a previous release.


        If you do not configure RESTful Services while using APEX 5.0 and ORDS then you will run into following issue :

    Regards,

    Kiran

  • Ketan Madhak
    Ketan Madhak Member Posts: 34
    edited Jul 1, 2015 2:07AM

    sorry i have forgot to mention deployment of "i".That was already deployed and second step  Configuring users required for RESTful Services  was also done and restarted domain but still facing same issue.

    Actually my configuration->default-config->netork-config->network listeners

    listening addresses are

    admin-listener  :  0.0.0.0

    http-listener-1    :  localhost

    http-listener-1    :  localhost

    that dsn't create problem right?

  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited Jul 1, 2015 2:21AM

    Hi Ketan,

    Ketan Madhak wrote:
    
    sorry i have forgot to mention deployment of "i".That was already deployed and second step  Configuring users required for RESTful Services  was also done and restarted domain but still facing same issue.
    
    

         Means you are still facing 503 - service unavailable?

         For debugging this issue you are facing on ORDS:

    • Locate the ORDS configuration folder.
    • Enable the Debug Tracing in defaults.xml (If entry is not there add the entry)
    • Enable the Detail Request Error messages in defaults.xml (If entry is not there add the entry)
    • Start(re-start) the Glassfish Server.
    • Navigate to the APEX URL
    • Copy/paste the debug log into the forum reply.(Usually the error is at the end of the log, paste/attach the whole log from where the first exception occurs)

    Regards,

    Kiran

  • Ketan Madhak
    Ketan Madhak Member Posts: 34
    edited Jul 1, 2015 2:33AM

    Request Path passes syntax validation

    Mapping request to database pool: PoolMap [_failed=false, _lastUpdate=-1, _pattern=null,

    _poolName=apex, _regex=null, _type=REGEX, _workspaceIdentifier=null, _serviceName=null]

    Applied database connection info

    Attempting to process with PL/SQL Gateway

    ==== Processing Request: ====

    GET /apex/

    ==== Headers in Request ====

    host: ecubeketan:8686

    connection: keep-alive

    accept: text/html,application/xhtml+xml,application/xml;q=0.9,image/webp,*/*;q=0.8

    user-agent: Mozilla/5.0 (Windows NT 6.1; WOW64) AppleWebKit/537.36 (KHTML, like Gecko)

    Chrome/43.0.2357.130 Safari/537.36

    referer: http://localhost:4444/common/applications/webApplicationLinks.jsf?

    appID=apex&contextRoot=/apex

    accept-encoding: gzip, deflate, sdch

    accept-language: en-US,en;q=0.8

    ==== Cookies in Request ====

    Using default page: apex

    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  in context: http://ecubeketan:8686/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:343)

      at oracle.dbtools.rt.web.WebException.serviceUnavailable(WebException.java:323)

      at oracle.dbtools.rt.web.WebErrorResponse.serviceUnavailable(WebErrorResponse.java:167)

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

      at oracle.dbtools.rt.web.HttpEndpointBase.service(HttpEndpointBase.java:132)

      at javax.servlet.http.HttpServlet.service(HttpServlet.java:770)

      at org.apache.catalina.core.StandardWrapper.service(StandardWrapper.java:1550)

      at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:281)

      at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)

      at org.apache.catalina.core.StandardPipeline.doInvoke(StandardPipeline.java:655)

      at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:595)

      at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:161)

      at org.apache.catalina.connector.CoyoteAdapter.doService(CoyoteAdapter.java:331)

      at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:231)

      at com.sun.enterprise.v3.services.impl.ContainerMapper$AdapterCallable.call

    (ContainerMapper.java:317)

      at com.sun.enterprise.v3.services.impl.ContainerMapper.service(ContainerMapper.java:195)

      at com.sun.grizzly.http.ProcessorTask.invokeAdapter(ProcessorTask.java:860)

      at com.sun.grizzly.http.ProcessorTask.doProcess(ProcessorTask.java:757)

      at com.sun.grizzly.http.ProcessorTask.process(ProcessorTask.java:1056)

      at com.sun.grizzly.http.DefaultProtocolFilter.execute(DefaultProtocolFilter.java:229)

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

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

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

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

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

      at oracle.dbtools.common.config.db.DatabaseConfig$DatabaseFactory.apply

    (DatabaseConfig.java:385)

      at oracle.dbtools.common.config.db.PerThreadConnectionCache

    $DisposableConnectionFactory.apply(PerThreadConnectionCache.java:239)

      at oracle.dbtools.common.config.db.PerThreadConnectionCache

    $DisposableConnectionFactory.apply(PerThreadConnectionCache.java:223)

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

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

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

      at oracle.dbtools.apex.OWA.getStatement(OWA.java:542)

      at oracle.dbtools.apex.OWA.init(OWA.java:311)

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

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

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

      ... 26 more

  • Ketan Madhak
    Ketan Madhak Member Posts: 34
    edited Jul 1, 2015 2:45AM

    Solved issue by unlock of user APEX_PUBLIC_USER.

  • Kiran Pawar
    Kiran Pawar Member Posts: 2,951 Bronze Crown
    edited Jul 1, 2015 2:56AM Accepted Answer

    Hi Ketan,

    Ketan Madhak wrote :
    
    Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex is not
    correctly configured, error: ORA-28000: the account is locked
    

        This is the root cause of your issue.

        The apex pool in ORDS corresponds to the database APEX_PUBLIC_USER and it is not correctly configured.

        Connect to the SQL Plus prompt with SYS user and SYSDBA privileges and run the following query:

    select username
        , account_status
        , profile
      from dba_users
    where username in ('APEX_PUBLIC_USER','APEX_LISTENER','APEX_REST_PUBLIC_USER');
    

        If the account status is LOCKED, EXPIRED, etc then unlock the user accounts for example:

    ALTER USER APEX_PUBLIC_USER IDENTIFIED BY <password> ACCOUNT UNLOCK;
    

        Discard/delete the current ORDS configuration and re-configure ords.war/apex.war with correct passwords for the users. Re-deploy it to Glassfish Server.

    Regards,

    Kiran

This discussion has been closed.