Find IP Address of connected Client

[jaya_geek]

hi

suppose one client machine is connected to my oracle server, and after perform 1,2 transactions he is disconnected. how to find his IP address?


If we want to monitor upcoming connection's IP's( Now onwards) , that is ok, we can store that IP into a table by using a trigger. But how to find the IP, which is connected before i create my trigger? is there any way?




Jaya

[susarlasireesha]

To find ip address
select sys_context('userenv','ip_address') from dual;

To find all client machine use
SELECT UTL_INADDR.get_host_address(terminal) FROM v$session
where status='ACTIVE'

[jaya_geek]

hi all
@sirisha

thanx4 reply
your 2 methods shows the current session details means IP address of the machine, if it is connected right now. but i told that.....i want IP address of the machine, which was connected in previous days. ex: before 10 days.

Jaya

[susarlasireesha]

So remove where clause
i.e., use
SELECT UTL_INADDR.get_host_address(terminal) FROM v$session

hi all
@sirisha

thanx4 reply
your 2 methods shows the current session details means IP address of the machine, if it is connected right now. but i told that.....i want IP address of the machine, which was connected in previous days. ex: before 10 days.

Jaya

[jaya_geek]

hi all

will it work after shutdown of my database? i mean.......one person connected and disconnected to my database.........next i shut it down....and started it up...............still i want his IP from my database records.......


i heard that...........we can get it from archives..........by using logminer.......can we see that IP? actually i have 2 check it.....

Jaya

[Mirzaz]

Its giving error:


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