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 MAY 27, 2020

Applies to:

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

Symptoms

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

Versions
_______________
* Database 12.2.0.1
* 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 11.2.0.4.
  The current installation is a standard database 12.2.0.1


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
Cause
Solution
References


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