Query to check ORDS user Locked

[admin]

SELECT * FROM dba_users WHERE account_status = 'LOCKED' AND username LIKE '%ORDS%';

ALTER USER "ORDS_PUBLIC_USER" ACCOUNT UNLOCK ;

ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY "ERPstuff@COM";


then

ORDS upto v21.4.x
Update the connection pool properties file in ORDS config directory and open XML file in there for each connection pool. Like default.

Update db.password with the password you used above in the database as text but it will be encrypted by ORDS. To encrypt use ! before the password,

<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE properties SYSTEM "http://java.sun.com/dtd/properties.dtd">
<properties>
<!-- Connection details -->
<entry key="db.connectionType">basic</entry>
<entry key="db.hostname">localhost</entry>
<entry key="db.port">1521</entry>
<entry key="db.sid">orcl</entry>
<entry key="db.username">APEX_PUBLIC_USER</entry>
<entry key="db.password">!ERPstuff@COM</entry>

</properties>

NOTE: prefix ! before password in order to encrypt

<entry key="db.password">!ERPstuff@COM</entry>

Onward ORDS Version 22.1.x

ords –config c:\ords\ords_221_config config –db-pool orcl secret db.password

by default it will update for default pool else you can add parameter --db-pool default

the above command will ask you password twice so provide same as you set above with alter command ERPstuff@COM

Restart your ORDS/Apache and test.