Database - RAC/Scalability (MOSC)

MOSC Banner

Oracle 19c, CDB/PDB, why is DBMS_STANDARD not accessible in a MOUNTED open_mode PDB?

.. if other packages, like DBMS_OUTPUT are accessible (from the hosting CDB) just fine?

I want to write a small piece of PLS code to pre-check, that when I connect as sysdba via OS auth (locally from the DB server) I am connected to the correct PDB, and that the PDB is in one of the expected open_modes, based on a select from v$pdbs, and raise a custom worded exception (and exit the sql script prematurely) when either of the 2 are not present as expected.

So that:

a) my script is not by mistake executed on the CDB, as it is meant to be executed on the PDB

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center