can you tie an ip address to a pid?

[Mark Grossman]

running hp-ux 11.0 with Oracle 7.3.4 db

If a customer gives us their ip address, is there a way to tie this to their process
id(s)?

Ive been told that a past sysadmin had some utility or script to do this. When a customer had a problem he'd run this and then kill their processes based on ip address. I'm fairly new at this and I cant find any way to do this. I've tried the 'owners' utility(among others) but it doesnt show pid.
thanks,
Mark Grossman

[frank beall_1]

Try
who -a

This will show you the ip address,user and pid.

[Mark Grossman]

Frank,
thanks, but unfortunately these customers login to Oracle apps and not to Unix. So all i see is a user called applmgr from the Unix side.

thanks again,
Mark

[Steven Sim Kok Leong]

Hi,

1) netstat -f inet|grep oralsnr
- if oralsnr is defined in /etc/services as the oracle listener service name

2) netstat -f inet|grep 1521
- if your oracle listener is listening at port 1521

3) Use lsof
- if you are unable to identify the service from the netstat output but you are able to identify the process(es) that runs your Oracle server daemons.

Regards.

Steven Sim.

[Rick Garland]

lsof would be your best bet.
It is available from the HP Porting Archive.

[Mark Grossman]

thanks Steven and Rick - the netstat still doesnt get me the pid - but I will try lsof, as Ive been reading a lot about that the last few days.

thanks,
Mark