Home » RDBMS Server » Server Administration » how to find the client ip address
how to find the client ip address [message #238481] Fri, 18 May 2007 05:29 Go to next message
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
Re: how to find the client ip address [message #238510 is a reply to message #238481] Fri, 18 May 2007 06:49 Go to previous messageGo to next message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: how to find the client ip address [message #240157 is a reply to message #238510] Thu, 24 May 2007 04:47 Go to previous messageGo to next message
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?
Re: how to find the client ip address [message #240165 is a reply to message #240157] Thu, 24 May 2007 05:07 Go to previous message
Michel Cadot
Messages: 64103
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Install Oracle Java classes.

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


Current Time: Sat Dec 03 18:24:37 CST 2016

Total time taken to generate the page: 0.19215 seconds