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.

Patreon:   / omarbaig  

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;
g. Remain in command prompt (C:\21c_21.2\ords) and type "java -jar ords.war" and
when "Oracle REST Data Services initialized" appear use Oracle APEX, minimize command prompt do not close it.

Search Tags:
Omar Baig, Oracle Apex Installation, Oracle Database Installation, Oracle REST Data Services, Oracle Apex, Oracle Database, Email through Oracle Apex 20.1 4K, Email through Oracle Apex 19.2 4K, Email through Oracle Apex 19.1 4K, Email through Oracle Apex 18.2 4K, Email through Oracle Apex 18.1, HOW TO SEND EMAIL USING ORACLE APEX, Oracle APEX 20.1, Install APEX 20.1, Oracle APEX 20.1 Installation, Create Setup Page in an Oracle APEX 20.1, Create Setup Form in an Oracle APEX 20.1, How to Create Setup Page in an Oracle APEX 20.1, How to Create Setup Form in an Oracle APEX 20.1, Create Master Detail Page in an Oracle APEX 20.1, Create Master Detail Form in an Oracle APEX 20.1, How to Create Master Detail Page in an Oracle APEX 20.1, How to Create Master Detail Form in an Oracle APEX 20.1, How to Create Dashboard in Oracle APEX, How to Create User, How to Create Branch, Branches, How to Create Workspace, How to Create Page Navigation, How to Create Link, How to Create Interactive Grid, Oracle APEX - Interactive Grid, Intro to Interactive Grid in Oracle APEX, HOW TO CREATE BUTTON IN ORACLE APEX, How to Create Button - Oracle APEX 20.1, How to Delete Dashboard in Oracle APEX, Dynamic Actions in APEX, Oracle APEX - Complete Guide to Dynamic Actions, Oracle APEX 20.1 - Format all Forms, Oracle APEX Installation, How to Install Android Studio on Windows 10, install android studio, Oracle APEX 20.2, Oracle APEX 20.2 Installation, How to Install Oracle JDeveloper 12c, install jdeveloper 12.2.1.4, install jdeveloper 12.2.1.3, install iReport 5.6.0, How to Install iReport 5.6.0 in Windows 10, Oracle APEX 21.1, Oracle APEX 21.1 Installation, How to Install Oracle APEX 21.1, How to install Oracle Database 18c Express Edition, How to install Oracle Database 19c, How to Install Oracle Forms & Reports 11g in Windows 10, How to install Oracle Database 21c, Oracle Database 21c Installation, How to install Oracle Database 21c Express Edition, Oracle Database 21c Express Edition Installation, How to Deinstall Oracle Database 21c Express Edition, Oracle AEPX 21.2 Installation, How to Install Oracle AEPX 21.2, Oracle AEPX 21.2, How to Install Oracle Forms & Reports 12c in Windows 10, rep-50125 rwbuilder.conf java.lang.nullpointerexception 12c

#OmarBaig #OracleAPEX212 #503ServiceUnavailable