If you are getting below error while launching ORDS, follow steps mentioned to resolve the error:

“ORDS was unable to make a connection to the database. The database user specified by db.username configuration setting is expired. The connection pool named: |default|lo| had the following error(s): ORA-28001: the password has expired”

Solution:

This error occurs when password for user ORDS_PUBLIC_USER is expired or this user is locked.

ORDS_PUBLIC_USER is the database user that’s used to create your ORDS connection pool(s).

Each database configured with ORDS gets one

Run below SQL command to unlock ORDS_PUBLIC_USER user.

alter session set container=XEPDB1;

select * from dba_users where username LIKE '%ORDS%PUBLIC%USER%';

alter user ORDS_PUBLIC_USER IDENTIFIED BY "Mypassword!"