Find IP Address of connected Client
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?
[B][COLOR="DarkOrange"]Jaya[/COLOR][/B]
Re: Find IP Address of connected Client
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'
Re: Find IP Address of connected Client
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.
[B][COLOR="DarkRed"]Jaya[/COLOR][/B]
Re: Find IP Address of connected Client
So remove where clause
i.e., use
SELECT UTL_INADDR.get_host_address(terminal) FROM v$session
[QUOTE=jaya_geek;26949]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.
[B][COLOR="DarkRed"]Jaya[/COLOR][/B][/QUOTE]
Re: Find IP Address of connected Client
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.....
[B][COLOR="Blue"]Jaya[/COLOR][/B]
Re: Find IP Address of connected Client
Its giving error:
:confused::(:confused:
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