DB_ROLE_CHANGE trigger
infraredJul 19 2010 — edited Jul 20 2010hello, I'm creating my first trigger. I want to execute an external shell script. Right now the script simply echo's the date to a file.
I perform a switchover in DGMGRL, yet I don't believe the script gets run. Can someone verify my trigger is correct to do something like this?
Thanks
create or replace trigger update_nat after DB_ROLE_CHANGE on database
declare role varchar(100);
BEGIN
select database_role into role from v$database;
IF role='PRIMARY' then
dbms_scheduler.create_job(
job_name=>'update_nat',
job_type=>'executable',
job_action=>'/home/oracle/update-nat.sh',
enabled=>TRUE
);
END IF;
END;
/