Oracle APEX 21.2 | 503 Service Unavailable | ORA 28000 The account is locked

Today we learn how to resolve error "503 Service Unavailable" or "The connection pool named: |apex|| had the following error(s): ORA-28000: The account is locked." in Oracle APEX 21.2 and earlier InshaAllah.

We have Oracle Database 21c Pluggable Installed.

Reason
1. "APEX_PUBLIC_USER" is lock

a. Come to command prompt and press "Ctrl+C" to stop the "ORDS"
b. Open SQL Plus
c. Connect with "sys / as sysdba"
d. Run this command
ALTER SESSION SET CONTAINER = ORCLPDB;
e. Run this command for your satifaction
SELECT username, account_status
FROM dba_users
WHERE username LIKE 'APEX%';
f. Run this command
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY oracle ACCOUNT UNLOCK;
when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt do not close it.

Search Tags:

#OmarBaig #OracleAPEX212 #503ServiceUnavailable

[arefinctg]

503 Service Unavailable - The connection pool named: |default|lo| does not exist

[aaronguni]

My public user is open but im still receiving the same error