ORDS 503 and 404 Problem Fix

 

Many Oracle APEX developers & users face ORDS 503 Service Unavailable problems like: 

•  ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-28000: The account is locked.
• ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|| had the following error(s): ORA-28001: the password has expired
• The username or password for the connection pool named: |apex||, are invalid, expired, or the account is locked.

Many Oracle APEX developers & users encountered ORDS 404 Service Unavailable problems like: 

• The request could not be mapped to any database. Check the request URL is correct, and that URL to database mappings have been correctly configured.

 

The Problem:

·         Those errors raised because of Password management related profile. Since APEX public accounts assigned to DEFAULT profile and the PASSWORD_LIFE_TIME Parameter for DEFAULT Profile is: 180 days means APEX accounts reached the limit and Passwords expired/ account locked.

The Solution:

·         to solve the problem, changed the passwords of APEX Accounts and unlock those accounts:

 

 alter user apex_210200 identified by apex2022 account unlock;

 alter user APEX_LISTENER identified by Apex2022 account unlock;

 alter user APEX_PUBLIC_USER identified by Apex2022 account unlock;

 alter user APEX_REST_PUBLIC_USER identified by Apex2022 account unlock;

 alter user ORDS_PUBLIC_USER identified by Apex2022 account unlock;

 

 

After 180 days the problem will raise again. So, to make sure this will not happen again, create a new profile with unlimited PASSWORD_LIFE_TIME and assign APEX accounts to the new profile:

 

create profile apex_profile

limit password_life_time unlimited;

 

NOTE:
Be sure that the new passwords for APEX accounts are the same passwords you set at the time of installing ORDS, otherwise you will get an error: