Logon trigger blocking MRP start
Hi ,
We have encountered with an issue where the below logon trigger is blocking the mrp on standby after a DB restart . Is there anything wrong with the trigger ? or any similar behavior that you have noticed. ?
Trigger :
CREATE OR REPLACE TRIGGER "SYS"."BAN_RO_TO_PRIMARY" AFTER LOGON on database
declare
db_role varchar2(30);
v_dusername dba_users.username%TYPE;
v_duprofile dba_users.profile%TYPE;
begin
select database_role into db_role from v$database;
SELECT du.username,du.profile into v_dusername , v_duprofile FROM v$session vs join dba_users du on vs.username=du.username where vs.username = sys_context('USERENV','SESSION_USER') and vs.sid=SYS_CONTEXT('USERENV', 'SID');