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

[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.