java.sql.SQLException: ORA-28001: the password has expired
Local Apex password expired solution:
------------------------------------
APEX_200200
ALTER USER APEX_200200 IDENTIFIED BY "Password";
ALTER USER system ACCOUNT UNLOCK;
APEX_LISTENER
ALTER USER APEX_200200 IDENTIFIED BY "Password";
ALTER USER APEX_200200 ACCOUNT UNLOCK;
YOUR_SCHEMA
ALTER USER YOUR_SCHEMA IDENTIFIED BY "Password";
ALTER USER YOUR_SCHEMA ACCOUNT UNLOCK;
APEX_PUBLIC_USER
ALTER USER APEX_PUBLIC_USER IDENTIFIED BY "Password";
ALTER USER APEX_PUBLIC_USER ACCOUNT UNLOCK;
APEX_REST_PUBLIC_USER
ALTER USER APEX_REST_PUBLIC_USER IDENTIFIED BY "Password";
ALTER USER APEX_REST_PUBLIC_USER ACCOUNT UNLOCK;
APEX_INSTANCE_ADMIN_USER
ALTER USER APEX_INSTANCE_ADMIN_USER IDENTIFIED BY "Password";
ALTER USER APEX_INSTANCE_ADMIN_USER ACCOUNT UNLOCK;
ORDS_PUBLIC_USER
ALTER USER ORDS_PUBLIC_USER IDENTIFIED BY "Password";
ALTER USER ORDS_PUBLIC_USER ACCOUNT UNLOCK;
.png)
