Home » Server Options » Data Guard » GET IP Address of client (Oracle 9i( AIX)
GET IP Address of client [message #390641] Mon, 09 March 2009 02:06 Go to next message
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 ( on AIX with jboss application server.
Thanks in Advance

[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 Go to previous message
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
select sys_context('userenv', 'ip_address') from dual
Previous Topic: last archive log applied + archive log lag in standby db
Next Topic: dat guard
Goto Forum:

Current Time: Thu Aug 17 21:50:13 CDT 2017

Total time taken to generate the page: 0.08867 seconds