RE: From SID to connected machine

[Morton, Ronald D]

Title: From SID to connected machine

Linda,

 

Have you checked the v$session view?  I believe that it shows the OS user and machine associated with the session id.

Hope this helps.

 

Ron

-----Original Message-----
From: Hagedorn, Linda [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, May 15, 2001 9:56 PM
To: Multiple recipients of list ORACLE-L
Subject: From SID to connected machine

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