4 Replies Latest reply on May 13, 2016 2:58 PM by xilan

    503 - Service Unavailable - APEX_LISTENER account keeps locking

    RickieRich

      Hi All,

       

      I have an ongoing issue where the CSS and static files are not being picked up within our applications. I have attempted to reconfigure multiple times and after recommendations from another forum have enables ORDS Error logging;

       

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

       

      I believe this points to it being an issue with the APEX_LISTENER account; I have used the apex_rest_config.sql script (after already running java -jar ords.war) to set the password and immediately after that has completed I have tried to log into SQL PLUS with the APEX_LISTENER user and the password I have just set - I get a invalid username/password combo error. I have ensured to use the same passwords throughout.

       

      When I first log into APEX and then use the RESTful data Services - the listener account locks again.

       

      We are using APEX: 5.0.1.00.06 and ORDS 2.0.10.289.08.09 - 12.1.3, Apache tomcat.



      Does anybody have a suggestion to what this could be - I have run through every forum/discussion I can find but point me in the direction of any that could help.


      Thanks,

      RR


      I have just set the APEX_LISTENER BY ALTER USER APEX_LISTENER IDENTIFIED BY <PASSWORD>;  - I then retried the Employees 'GET' Method under SQL Workshop>RESTful services and was given the error;

       

      Caused by: oracle.dbtools.common.jdbc.ConnectionPoolException: The pool named: apex_rt is not correctly configured, error: ORA-01017: invalid username/password; logon denied

       

      It seems there is definitely a configuration issue but after following the Oracle documentation 4 times to reconfigure/redeploy I'm not sure where to go - Is there anyway to glean some further information?

       

      Message was edited by: RickieRich