My Oracle Support Banner

ORDS: Error 503 And ORA-28000 when Testing a RESTful Web Service After Migrating APEX based RESTful Web Services to ORDS (Doc ID 3025812.1)

Last updated on MAY 29, 2024

Applies to:

Oracle REST Data Services - Version 21.4.3 and later
Information in this document applies to any platform.

Symptoms

Migrated APEX based RESTful Web Services to ORDS.
Getting the following error when testing a REST module from APEX Builder:

ServiceUnavailableException [statusCode=503, logLevel=SEVERE, reasons=[ORDS was unable to make a connection to the database. This can occur if the database is unavailable, the maximum number of sessions has been reached or the pool is not correctly configured. The connection pool named: |apex|pu| had the following error(s): ORA-28000: The account is locked.

]]

 

The ORDS_PUBLIC_USER account is OPEN.

Changes

 Upgraded APEX and ORDS. Migrated APEX based RESTful Web Services to ORDS.

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!

In this Document
Symptoms
Changes
Cause
Solution


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