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:[EMAIL PROTECTED]]
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: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
