topic Re: lsof, IPC and oracle in Operating System - HP-UX

lsof, IPC and oracle

LE_1 — Thu, 11 Dec 2003 07:22:14 GMT

Hi,

Here's my problem:
On a HPUX 11i box :

I have several X process with the same name TOTO ; they connect (dedicated server) to a oracle database via IPC (not SQL*Net)
Now there are X process oracleORACLE_SID
How can I do the link between the PID of one process TOTO with the PID of the oracle shadow
process associated ?

I tried different options with lsof but with
a IPC connection, I didn't success

(You can try with several TOTO=sqlplus for example)

Thanks

Re: lsof, IPC and oracle

Graham Cameron_1 — Thu, 11 Dec 2003 07:57:00 GMT

From SQLPLUS

select s.sid, s.serial#, s.audsid, s.username, s.osuser, s.machine, s.terminal, s.process, p.spid, s.program
from v$process p,v$session s
where p.addr = s.paddr

The SPID col is the client, the PROCESS col is the shadow.

-- Graham

Re: lsof, IPC and oracle

Massimo Bianchi — Thu, 11 Dec 2003 08:04:48 GMT

Graham, the process column is the PID of the shadow process, not the PID of the client connecting to the shadow.

Massimo (still thinking to the answer..)

Re: lsof, IPC and oracle

Massimo Bianchi — Thu, 11 Dec 2003 08:06:33 GMT

SORRY, SORRY, SORRY !!

Graham is perfectly correct, I read the wrong column :)

SORRY, SORRY, SORRY !!

Massimo

Re: lsof, IPC and oracle

LE_1 — Thu, 11 Dec 2003 08:53:53 GMT

Thanks for your answers
Your sql select is ok
but I would like to find a
way with OS commands.

Re: lsof, IPC and oracle

Michael Schulte zur Sur — Thu, 11 Dec 2003 09:04:44 GMT

Hi,

try to see, if the Oracle process and the application process dont have a father/son relationship. The Oracle process should be the son of the application process, it it is a local connect.

greetings,

Michael

Re: lsof, IPC and oracle

Graham Cameron_1 — Thu, 11 Dec 2003 09:06:50 GMT

Is it not simply that the Shadow process has the TOTO process as its parent, so you can get it from ps.

For example, the command:
UNIX95= ps -efH
will give all processes by hierarchy and you can grep or awk out the ones you want.
(NB ps -H is expensive - see "man ps")

-- Graham