Database Administration (MOSC)

MOSC Banner

PDB startup trigger not firing

edited Jul 4, 2022 9:57AM in Database Administration (MOSC) 3 commentsAnswered

Hi all,


It seems that the PDB startup trigger is not firing:


I want to use a trigger that fires when the PDB is opened.


alter session set container = PDB1;

create table sys_trigger_debug ( a timestamp, b varchar2(2000));


CREATE OR REPLACE NONEDITIONABLE TRIGGER "SYS"."PDB_START_TRIGGER" AFTER STARTUP ON PLUGGABLE DATABASE

DECLARE

V_STATUS VARCHAR2(12);

BEGIN

SELECT STATUS INTO V_STATUS FROM V$INSTANCE;

insert into sys_trigger_debug values (systimestamp,'V_STATUS:'||V_STATUS||',CON_NAME:'||SYS_CONTEXT('USERENV','CON_NAME'));

END;

/



Trigger created.


SQL> select status from dba_objects where object_name = 'PDB_START_TRIGGER';

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