Default service for PDB active in CDB$ROOT

From: Jack van Zanen <jack_at_vanzanen.com>
Date: Thu, 12 Sep 2019 15:56:57 +1000
Message-ID: <CAFeFPA8rUzn_ahurED-R5MEKw5h6M13cE2RQdV7L7Nyvr+OfsQ_at_mail.gmail.com>

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

--
http://www.freelists.org/webpage/oracle-l

Received on Thu Sep 12 2019 - 07:56:57 CEST