Issues in Tracing Client IP Address.
Hi Experts,
I am using below trigger to trace my client's IP Address. I am having n-tier architecture, i have exe running on client's pc, server exe running on application server and a separate database server.
CREATE OR REPLACE TRIGGER LOGON_TRIGGER
AFTER LOGON ON DATABASE
DECLARE
v_user_identifier varchar2(64);
BEGIN
SYS_CONTEXT('USERENV', 'IP_ADDRESS')
INTO v_user_identifier
FROM dual;
DBMS_SESSION.SET_IDENTIFIER(v_user_identifier);
END;
/
By this trigger client_identifier column of v$session is getting populated by clients's IP address.
My problem is out of 5 i can see IP Address of only 1 machine. In remaining machines all network configuration is same except IP address. Can anybody help me why i am not getting IP Address of remaining 4 machines.
-- Thanks.