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

ORDS Password and Configuration Issue

Recently, I encountered a situation where my password for ORDS had expired, leading to login errors for users.

In response, I promptly changed the password for the ORDS_PUBLIC user. Additionally, I attempted to change the password profile to "unlimited" without anticipating the upcoming issue.

Unfortunately, this action resulted in the following error:

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

As a next step, I began searching online for different solutions and ended up on Jeff Smith's page, which explained in detail two methods for each ORDS version.

Given that I was using ORDS version 22.2.0.175, I opted for the second method. However, it didn't work for me.

I meticulously followed each step for approximately two hours, but to no avail.

Ultimately, I decided to address the problem by deleting ORDS from the production environment, following these steps:

1. Uninstall ORDS:

java -jar space.war

(Replace "space" with your WAR file name; in your case, it could be "ords.war").

2. Install ORDS:

java -jar space.war --config c:\app\ords\config install

(Note: "advanced" won't work with this new version).

3. Copy the WAR file:

Before copying, make sure to create a backup of the existing WAR file. Then, copy the new WAR file to your Tomcat directory.

Important Note: When installing ORDS, ensure that you accurately enter the localhost and service name, matching your database's TNS.ora file. Failing to specify --config during the ORDS installation command can result in mapping errors, leading to the message:

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.