ORDS Not Working With TNS Or Customer JDBC (Doc ID 2966860.1)

Last updated on JANUARY 03, 2025

Applies to:

Oracle REST Data Services - Version 22.2 and later
Oracle Cloud Infrastructure - Database Service - Version N/A and later
Information in this document applies to any platform.

Symptoms

Steps to reproduce the issue:

1. Install ORDS in the CDB using TNS

2. Enable Addressable PDBS (db.serviceNameSuffix) if not set already

https://docs.oracle.com/en/database/oracle/oracle-rest-data-services/22.2/ordig/using-multitenant-architecture-oracle-rest-data-services.html#GUID-694B2F89-CE4F-4AB0-88E2-EB35D03DEC3C

3. ORDS_ENABLE a schema

4. Try to access a resource in a PDB, e.g.:

http://localhost:8080/ords/ORCLPDB1/myschema/_sdw/

Expected:

Resource should be accessible as it is with db.connectionType = basic or when using a wallet zip (db.wallet.zip.path and db.wallet.zip.service)

Actual:

Request fails, resource not accessible {

"code": "NotAuthorizedOrNotFound",

"title": "Procedure not authorized or not found",

"message": "The procedure named <PDBNAME> could not be accessed or found",

"o:errorCode": "ORDS-22001",

"cause": "The procedure may not be declared, or the user executing this request may not have been granted execute privilege on the procedure, or a function specified by security.requestValidationFunction configuration property has prevented access",

"action": "Check the spelling of the procedure, check that the execute privilege has been granted to the caller and check the configured security.requestValidationFunction function",

* Connection #0 to host localhost left intact

NOTE. The error says procedure not foound, but it is a PDB it is looking for.

Error:

------------------

ORDS-22001