OraFAQ Forum: Networking and Gateways » client ip adress connected on my database

Home » RDBMS Server » Networking and Gateways » client ip adress connected on my database (oracle 9i , solaris)

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

client ip adress connected on my database [message #304699]

Thu, 06 March 2008 04:53

koff10
Messages: 58
Registered: December 2006
Location: france

Member

Hi all,
I'm trying to locate client adress ip connected on my oracle database.
How can I proceed ?
Help please, Thanks
koff10

Report message to a moderator

Re: client ip adress connected on my database [message #304702 is a reply to message #304699]

Thu, 06 March 2008 05:07

Michel Cadot
Messages: 68731
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: client ip adress connected on my database [message #304740 is a reply to message #304702]

Thu, 06 March 2008 08:02

koff10
Messages: 58
Registered: December 2006
Location: france

Member

Michel Cadot wrote on Thu, 06 March 2008 12:07

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

Hi,
"UTL_INADDR.get_host_address" is ip address of the machine where database is . it not what I want.

I would like to get ip address of client connected in my database.

thanks

Report message to a moderator

Re: client ip adress connected on my database [message #304742 is a reply to message #304740]

Thu, 06 March 2008 08:06

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

Senior Member
Account Moderator

Try it.

Regards
Michel

Report message to a moderator

Re: client ip address connected on my database [message #309931 is a reply to message #304742]

Sun, 30 March 2008 02:06

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Michal,
Above code is correct but in windows system we almost get below error Smile

ERROR at line 1:
ORA-29257: host xxxxxxxxxxxxxxx unknown
ORA-06512: at "SYS.UTL_INADDR", line 19
ORA-06512: at "SYS.UTL_INADDR", line 40
ORA-06512: at line 1

You should post below code right Smile

to fix above error.

select sid, machine,
       UTL_INADDR.get_host_address (substr(machine,instr(machine,'\')+1)) ip from v$session
where type='USER' and username is not null
/

http://orafaq.com/usenet/comp.databases.oracle.server/2007/01/04/0202.htm

Report message to a moderator

Re: client ip address connected on my database [message #309934 is a reply to message #309931]

Sun, 30 March 2008 02:37

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

Senior Member
Account Moderator

Where is the pleasure if you have nothing to discover and workaround? Smile

Regards
Michel

[Updated on: Sun, 30 March 2008 02:39]

Report message to a moderator

Re: client ip adress connected on my database [message #310368 is a reply to message #304699]

Tue, 01 April 2008 01:02

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

You can also see client IP from listener log file.

Report message to a moderator

Previous Topic:	CMAN parameters meaning (was: "Would you like to explain more?")
Next Topic:	Os authentification on oracle database using MS ACCESS and oracle ODBC

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 20 02:58:24 CST 2025