OraFAQ Forum: Server Administration » how to find the client ip address

Home » RDBMS Server » Server Administration » how to find the client ip address

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

how to find the client ip address [message #238481]

Fri, 18 May 2007 05:29

nani_ar
Messages: 58
Registered: March 2006

Member

hi all,

I would like to find the ip address of the client maching connected to my oracle database. How to find it out? my database is OLTP and 400 users are being connected. I would like to have the ip address of the clients currently connected..

Sorry, if it is posted in the wrong forum..

All the replies are welcome

With regards

nani

Report message to a moderator

Re: how to find the client ip address [message #238510 is a reply to message #238481]

Fri, 18 May 2007 06:49

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

select sid, machine, UTL_INADDR.get_host_address (machine) 
from v$session 
where type='USER' and username is not null 
order by sid 
/

Regards
Michel

Report message to a moderator

Re: how to find the client ip address [message #240157 is a reply to message #238510]

Thu, 24 May 2007 04:47

nani_ar
Messages: 58
Registered: March 2006

Member

hi,
nice to get ur response...

but when i execute the same thing i m getting

select sid, machine, UTL_INADDR.get_host_address (machine)
*
ERROR at line 1:
ORA-29540: class oracle/plsql/net/InternetAddress does not exist
ORA-06512: at "SYS.UTL_INADDR", line 21
ORA-06512: at "SYS.UTL_INADDR", line 33
ORA-06512: at line 1

what shud be done?

Report message to a moderator

Re: how to find the client ip address [message #240165 is a reply to message #240157]

Thu, 24 May 2007 05:07

Michel Cadot
Messages: 68737
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Install Oracle Java classes.

Regards
Michel

Report message to a moderator

Previous Topic:	Configuring Sandalone Database
Next Topic:	Is there a way to track changes in system parameters? (merged)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Feb 25 04:22:02 CST 2025