Database Administration (MOSC)

MOSC Banner

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');

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