RE: From SID to connected machine

From: Hagedorn, Linda <lindah_at_epocrates.com>
Date: Wed, 16 May 2001 10:43:28 -0700
Message-ID: <F001.003051F4.20010516105050@fatcity.com>

Thanks for the idea.  It's not telling me the machine, though...

SID        USERNAME        OSUSER     PROCESS   MACHINE            TERMINAL 

---------- -------------- ---------- --------- ------------------- ----------
        58 PALMAPP        oracle               jdbcclient          unknown 


       129 PALMAPP        oracle               jdbcclient          unknown

       149 PALMAPP        oracle               jdbcclient          unknown   

       158 PALMAPP        oracle               jdbcclient          unknown  
       204 PALMAPP        oracle               jdbcclient          unknown  
5 rows selected.

By trial and error I've found the source machine is va8.  If you have any other ideas, please let me know and I'll try them out while the sessions are present.

-----Original Message-----
From: Mark Leith [mailto:mark_at_cool-tools.co.uk] Sent: Wednesday, May 16, 2001 5:20 AM
To: Multiple recipients of list ORACLE-L Subject: RE: From SID to connected machine

Try this statement out:

select sid,
       username,
       osuser,
       process,
       machine,
       terminal,

  from v$session
where username = 'PALMAPP;

HTH Mark
-----Original Message-----
Sent: Wednesday, May 16, 2001 02:56
To: Multiple recipients of list ORACLE-L

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: Mark Leith
  INET: mark_at_cool-tools.co.uk


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 - 12:43:28 CDT