High Availability Data Guard, Sharding and Global Data Services (MOSC)

MOSC Banner

Logon Trigger does not work on standby

In Oracle version 12.2.0.1, I have written the following logon trigger, which works normally on the PRIMARY database but does not work on the PHYSICAL STANDBY database.How can this issue be resolved? THANKS

create or replace trigger logon
AFTER logon on TEST.SCHAMA
declare
ip varchar2(30);
owner varchar2(30);
BEGIN
SELECT SYS_CONTEXT('USERENV','SESSION_USER') into owner from dual;
SELECT SYS_CONTEXT('USERENV','IP_ADDRESS') into ip from dual;
if owner='TEST'
THEN
IF ip not in ('192.168.10.1','192.168.10.2')
THEN raise_application_error(-20001,'User '||owner||' is not allowed to connect from '||ip);
END IF;

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