How to find IP Address and Port No. from client connecting to Database

[suwatchai_s]

I know some detail from v$session. but I want to know, which object i can select to find ip address and port no. from client connect to my database.

Thanks,
Kim.

[pando]

you can only get port from listener.log

you can get ip using sys_context functions

[ggnanaraj]

You can get ip from listener.log...see snippet from log below...

11-APR-2003 13:34:31 * (CONNECT_DATA=(SID=zap)(CID=(PROGRAM=D:\oracle\ora81\bin\Sqlplusw.exe)(HOST=SUN101)(USER=rgg))) * (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.66.239)(PORT=4143)) * establish * zap * 0

HTH.

[Srinivas_Sharma]

IP can be found out with this...

select sys_context('userenv','ip_address') from dual;

HTH

SS

[suwatchai_s]

Thank you, for every one

Assume, I am DBA. How can I monitor by using select statement to view who,ip address, port no connect to my database.

I use SQL Plus. If I use sys_context i will get my ip address. I want ip address from anyone connect to me, not my ip.

becuase I will develop monitoring tool on web base. I can monitor from anywhere by web.

How do I?

[BHUSHAN]

dont u use following query
select terminal,machine,username from v$session
where username is not null