APEX Unavailable After the Expiration of the APEX_PUBLIC_USER Password - 503 Service Unavailable or 404 Page not Found
(Doc ID 2058706.1)
Last updated on AUGUST 04, 2018
Applies to:Oracle Database Cloud Service - Version N/A and later
Oracle REST Data Services - Version 2.0 and later
Oracle Application Express (APEX) - Version 4.2 and later
Information in this document applies to any platform.
Database Cloud Service: APEX unavailable
The database is up and running using SQL Plus. The EM Console and Glassfish consoles for the instance also run without error.
Steps to reproduce the issue
- Run the APEX URL: http://<public ip address>/apex/
https://<public ip address>/ords/
https://<public ip address>/ords/<pdbname>
- The following error is seen:
503 Service Unavailable.
404 Not found error with detail - The request could not be mapped to any database
The following errors may be seen in the web server related logs:
ORA-28001 ORA-28001: the password has expired (Associated with the HTTP-503 error.)
ORA-01017: invalid username/password; logon denied (Associate with the HTTP-403 error.)
If running ORDS in standalone mode, the ords.log will contain information similar to the following as well as the ORA-28001 / ORA-01017 error:
INFO: Validating pool: |apex||
May 29, 2018 7:25:31 PM
SEVERE: The username or password for the connection pool named apex, are invalid, expired, or the account is locked
oracle.dbtools.common.jdbc.ConnectionPoolConfigurationException: The username or password for the connection pool named apex, are invalid, expired, or the account is locked
The service has been running successfully for some time, but has suddenly stopped working.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!