My Oracle Support Banner

ORDS 3.0 / 18.X Behaves Differently Using Datagaurd with DBMS_SERVICE CALLS for Some Database Instances (Doc ID 2650041.1)

Last updated on FEBRUARY 15, 2023

Applies to:

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


NOTE: The example(s) provided are for demonstration purposes only and represents fictitious data. Any similarity to actual data, web sites and / or persons, living or dead, is purely coincidental and not intended in any manner.


When using URL mapping the database service name gets changed when it is called for certain databases

* Database
* All versions of ORDS 18.1 and up fail with the same error in WLS and with standalone ORDS.
* The problem does not reproduce with 3.0.xx ORDS.

Other Information
* lsnrctl status shows both the working and failing instances.
* Customer is using DataGuard, therefore testing with the SID will not work.
  Using Active Data Guard (ADG), and the SID comes from DB_UNIQUE_NAME, which is different between the active and standby database (hence the reason we're using the dynamically registered DEVL_ABC_SERVICE_NAME service name on the ADG database.
* The initial database was
  The current installation is a standard database


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

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