Per another article/suggestion, have create trigger OPEN_ALL_PLUGGABLES to open PDB databases upon restart of server. It created successfully, no errors and is enabled, yet doesn't work. When I use sql developer to run the trigger, get
Empty package OPEN_ALL_PLUGGABLES defintion (no public members). I've searched for the solution, but haven't found any suggestions.
--------------------------------------------------------
-- DDL for Trigger OPEN_ALL_PLUGGABLES
--------------------------------------------------------
CREATE OR REPLACE NONEDITIONABLE TRIGGER "SYS"."OPEN_ALL_PLUGGABLES" after startup on database
BEGIN
execute immediate 'alter pluggable database all open';
END open_all_pdbs;
/
ALTER TRIGGER "SYS"."OPEN_ALL_PLUGGABLES" ENABLE;