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;