RE: From SID to connected machine

From: Mark Leith <mark_at_cool-tools.co.uk>
Date: Wed, 16 May 2001 04:44:38 -0700
Message-ID: <F001.00304A9E.20010516042023@fatcity.com>

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 - 06:44:38 CDT