Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> From SID to connected machine

From SID to connected machine

From: Hagedorn, Linda <lindah_at_epocrates.com>
Date: Tue, 15 May 2001 18:13:11 -0700
Message-ID: <F001.0030469D.20010515175543@fatcity.com>

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


  Received on Tue May 15 2001 - 20:13:11 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US