RE: From SID to connected machine

From: Hagedorn, Linda <lindah_at_epocrates.com>
Date: Wed, 16 May 2001 11:09:37 -0700
Message-ID: <F001.00305292.20010516111353@fatcity.com>

I can get all the session info, but the machine name isn't externalized.  By elimination I've found the problem machine is va8.  Since I have the processes in place and they're not hurting anything, I have time to research. 

Here is the sid/pid logic, and the grep from the os.  Still no source machine name.  Any other ideas?

SVRMGR> select a.spid, b.sid, b.serial#, substr(b.program,1,20) "program", 
     2>         substr(b.machine,1,10) "machine",
     3>         substr(b.status,1,10) "status", b.command
     4>         from v$process a, v$session b
     5>         where a.addr=b.paddr  
     6>         and b.sid in (58,129,149,158,204) ;   

SPID      SID        SERIAL#    program              machine    status   COMMAND  

--------- ---------- ---------- -------------------- ---------- -------- ----------
8088             158      60638 JDBC-1.0-Client      jdbcclient INACTIVE          0
8090             149      31846 JDBC-1.0-Client      jdbcclient INACTIVE          0
8092             204      63261 JDBC-1.0-Client      jdbcclient INACTIVE          0

8094             129       2493 JDBC-1.0-Client      jdbcclient INACTIVE          0 8096              58      11498 JDBC-1.0-Client      jdbcclient INACTIVE          0 5 rows selected.

 
$ ps -ef -o pid,args | grep 80

 8092 oraclencp (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
 8094 oraclencp (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
 8096 oraclencp (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
 8090 oraclencp (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))
 8088 oraclencp (DESCRIPTION=(LOCAL=no)(ADDRESS=(PROTOCOL=BEQ)))

Thanks, Linda
-----Original Message-----
From: Ruth Gramolini [mailto:rgramolini_at_tax.state.vt.us] Sent: Wednesday, May 16, 2001 7:16 AM
To: Multiple recipients of list ORACLE-L Subject: Re: From SID to connected machine

Linda,
You have to look at v$process which give the pid. This is the OS process number.  You can link it to v$session to get the username.

HTH,
Ruth
----- Original Message -----
To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Tuesday, May 15, 2001 9:55 PM

> Hello,
>
> I'm looking to trace a sid from oracle to a pid on unix to a
> connection/socket/port to another machine.  Server is Sun Solaris 2.8.
>
> I'm trying to deimplement a userid and there is a connect string to it
> buried somewhere on one or more of eight different application machines.
> The engineers have looked for the connection, but are unable to find it.
I
> need to tell them which machine it's coming from.  If anyone has the steps
> to do this, I'd appreciate a note back.  I've tried to match the pid to
the
> lots of logs, but cannot find a match.
>
> Thank you very much.  Any information or referral to documentation is
> appreciated.
>
> Linda
>
>
> The userid connection on topsessions:
>
> PALMAPP     SID 149
> PALMAPP     SID  58
> PALMAPP     SID 129
> PALMAPP     SID 204
> PALMAPP     SID 158
>
> The netstat output.  I believe the connection is coming from either va8 or
> va11.
>
> kong.epocrates.com.1521 va8.epocrates.com.4501 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va8.epocrates.com.4502 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va8.epocrates.com.4503 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va8.epocrates.com.4504 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va8.epocrates.com.4505 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va11.epocrates.com.4117 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va11.epocrates.com.4118 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va11.epocrates.com.4119 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va11.epocrates.com.4121 32120      0 10136      0
> ESTABLISHED
> kong.epocrates.com.1521 va11.epocrates.com.4122 32120      0 10136      0
> ESTABLISHED
>
>
>

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Ruth Gramolini
  INET: rgramolini_at_tax.state.vt.us


Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).

Received on Wed May 16 2001 - 13:09:37 CDT