Hi All
this is the output of v$active_services in one of our databases.
*****DEV605.au1.ocm.s1592130.oraclecloudatcustomer.com
CDB$ROOT
IBMSDEV_CFG CDB$ROOT
IBMSDEV.au1.ocm.s1592130.oraclecloudatcustomer.com CDB$ROOT
bkppdb1 IBMSPDB1
IBMSDEV_DGB CDB$ROOT
SYS$BACKGROUND CDB$ROOT
SYS$USERS CDB$ROOT
*****ibmspdb1.au1.ocm.s1592130.oraclecloudatcustomer.com
CDB$ROOT
IBMSDEVXDB CDB$ROOT
bkpdev605 DEV605
The issue is that the pdb default services (with stars in front) are active
in the cdb$root and if we use this service name in our tns connect string
we end up in cdb$root.
This was working normally until we did a switchover test and somehow these
services appeared and became active in cdb$root
Anyone seen this before
Oracle 12.2.0.2 Jan2019 PSU
Jack van Zanen
-------------------------
This e-mail and any attachments may contain confidential material for the
sole use of the intended recipient. If you are not the intended recipient,
please be aware that any disclosure, copying, distribution or use of this
e-mail or any attachment is prohibited. If you have received this e-mail in
error, please contact the sender and delete all copies.
Thank you for your cooperation
