503 - The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

503 - The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

This article will help you in two ways, 

1) Update the ords_public_user password

2) Resolve 503 error - The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked. Changing weblogic port after deploying ORDS on Oracle WebLogic Server

Initially, we installed and configured weblogic with default port i.e. 7001. ORDS was deployed on weblogic. After that we wanted to change the weblogic port from 7001 to 8080 to run the APEX. After changing port ORDS stop working and throwing below error, 

<Mar 17, 2023, 12:27:27,801 PM India Standard Time> <Error> <oracle.dbtools.rest> <BEA-000000> <<54319e0f-61e7-44fc-8213-a6a5965fdc41-00000070> GET 10.132.141.180 /ords/ 503 The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked]]

        at oracle.dbtools.http.errors.ServletResponseExceptionMapper.mapError(ServletResponseExceptionMapper.java:45)

        at oracle.dbtools.http.errors.ErrorLogger.log(ErrorLogger.java:27)

        at oracle.dbtools.http.errors.ErrorPageFilter.doFilter(ErrorPageFilter.java:106)

        at oracle.dbtools.http.filters.HttpFilter.doFilter(HttpFilter.java:47)

        at oracle.dbtools.http.filters.FilterChainImpl.doFilter(FilterChainImpl.java:64)

        Truncated. see log file for complete stacktrace

Caused By: oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked

I have cross check if my APEX and ORDS users are unlocked or not,

It seems, everything is fine, so why am I getting this error?

I thought if I could reset the password for all the users again that would help, but it didn't help me.

Next thought, when I was reading the error again it saying "The username or password for the connection pool named |default|lo|, are invalid, expired, or the account is locked". It means somewhere it is going wrong.

You know, ORDS config directory also stores the username and password. Here, my ORDS version is 22.4. And in this version you can find the cwallet.sso file under /u01/ords/conf/database/orcl directory. You might have some different directory structure based on your ORDS installation.

Here, I reset the password in ORDS as well with the following command.

Step 1 - Run this command from ords directory 

            > ords --config /u01/ords/conf config secret db.password

Step 2 - Restart the weblogic and hit the URL http://<ip address>:8080/ords again.

It works for me and I am able to get the APEX log-in screen.

You can refer to Jeff Smith's blog for additional resources about the above error for ORDS 22.4 and earlier versions.

https://www.thatjeffsmith.com/archive/2017/06/how-to-update-the-ords_public_user-password/

Thanks & Regards,

Chandan Tanwani