ORDS 3.0 Install Fails: ORA-28043: Invalid Bind Credentials for DB-OID Connection (Doc ID 2319661.1)

Last updated on FEBRUARY 09, 2023

Applies to:

Symptoms

When configuring and installing ORDS 3.0, the installation fails with the following error:

...
Enter 1 if you want to verify/install Oracle REST Data Services schema or 2 to skip this step [1]:1
Enter the database password for ORDS_PUBLIC_USER:
Confirm password:
Oct 15, 2017 9:51:22 PM oracle.dbtools.rt.config.setup.SchemaSetup getInstallOrUpgrade
WARNING: Failed to connect to user ORDS_PUBLIC_USER jdbc:oracle:thin:@//<HOSTNAME>:<PORT>/abc_dev_abcdev1
ORA-28043: invalid bind credentials for DB-OID connection

The installation continues, and ORDS starts up in standalone mode, and throws the same error:
INFO: Updated configuration with generated keys
2017-10-15 21:54:31.829:INFO:/ords:main: INFO: Using configuration folder: <DIR>
2017-10-15 21:54:31.836:INFO:/ords:main: FINEST: |ApplicationContext [configurationFolder=<DIR>, services=Application Scope]|
Oct 15, 2017 9:54:31 PM
INFO: Validating pool: |apex|pu|
Oct 15, 2017 9:54:32 PM
SEVERE: The connection pool named: apex_pu is not correctly configured, due to the following error(s): ORA-28043: invalid bind credentials for DB-OID connection

The same failure occurs when attempting to configure ORDS through the SQL Developer interface.

However, it is possible to run the uninstall of the ORDS database components successfully using:
java -jar ords.war uninstall

Changes

Cause

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