Default service for PDB active in CDB$ROOT

  • From: Jack van Zanen <jack@xxxxxxxxxxxx>
  • To: "oracle-l@xxxxxxxxxxxxx" <oracle-l@xxxxxxxxxxxxx>
  • Date: Thu, 12 Sep 2019 15:56:57 +1000

Hi All

this is the output of v$active_services in one of our databases.

IBMSDEV_CFG                                                      CDB$ROOT               CDB$ROOT
bkppdb1                                                          IBMSPDB1
IBMSDEV_DGB                                                      CDB$ROOT
SYS$BACKGROUND                                                   CDB$ROOT
SYS$USERS                                                        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 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

Other related posts:

  • » Default service for PDB active in CDB$ROOT - Jack van Zanen