Skip to Main Content

ORDS, SODA & JSON in the Database

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Does pluggable mapping work with Data Guard?

OyvindIseneJun 13 2025 — edited Jun 13 2025

Section 7.3 in the latest manual (25.1) explains how to make all PDBs addressable by using the parameter db.serviceNameSuffix. This usually works for us in our environments with Data Guard, but sometimes ORDS connects to the standby side, and I wonder if that is because the service name used when connecting to a PDB is actually the PDB-name + the value for db.serviceNameSuffix ? Because that service is available by default on both primary and standby. I am considering experimenting with another value for db.serviceNameSuffix, like adding “_dg.” in front of the value for DB_DOMAIN, since that will give a service that only runs on primary. But perhaps that will fail if the value does not start with a dot (".")?

Comments
Post Details
Added on Jun 13 2025
0 comments
144 views