My Oracle Support Banner

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.

Symptoms

Environment

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

  
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
at oracle.dbtools.common.config.db.DatabasePools.validateConnection(DatabasePools.java:427)

 

 

Changes

 The service has been running successfully for some time, but has suddenly stopped working.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.