OraFAQ Forum: Data Guard » GET IP Address of client

Home » Server Options » Data Guard » GET IP Address of client (Oracle 9i(9.2.0.8) AIX)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

GET IP Address of client [message #390641]

Mon, 09 March 2009 02:06

mohsinsalam
Messages: 7
Registered: January 2006

Junior Member

Hi There,
we have three-tiered environment how can i get IP address of client through database query. can any one let me the steps or procedure for this achivment.
we are user oracle 9i (9.2.0.8) on AIX with jboss application server.
Thanks in Advance
Mohsin

[EDITED by LF: disabled smilies]

[Updated on: Mon, 09 March 2009 02:20] by Moderator

Report message to a moderator

Re: GET IP Address of client [message #390642 is a reply to message #390641]

Mon, 09 March 2009 02:19

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Check SYS_CONTEXT:

select sys_context('userenv', 'ip_address') from dual

Report message to a moderator

Previous Topic:	last archive log applied + archive log lag in standby db
Next Topic:	dat guard

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Wed Apr 01 05:52:29 CDT 2026