Oracle 12c Multitenant PDB - Save state of DBMS_SERVICE for PDB along with OPEN_MODE

Stefan Koehler

Hi guys,

please extend the "save state" functionality with custom defined PDB services (DBMS_SERVICE) for Oracle 12c Multitenant PDBs. The full Oracle GI stack or the GI stand-alone stack (Oracle Restart) is not deployed everywhere. The defined PDB services with DBMS_SERVICE should be automatically started with the opened PDBs and not via trigger or custom defined scripts.

The same kind of ability for PDB startup state was introduced with 12.1.0.2. Please extend this with PDB services as well for all the non-GI stack installations.

Thank you.

Regards

Stefan

Pravin Takpire

looks like a good proposal

User_VX993

is creating a trigger to restart a custom services is the only way for now?  I have a standalone PDB, not on GI/RAC so I'm wondering if creating a trigger is the only way for now?

Franck Pachot

Hi, just seeing this. I think this is implemented currently. The problem is that we cannot have this depend on the database role.