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

Home -> Community -> Usenet -> c.d.o.server -> Re: Find SID for oracle.exe

Re: Find SID for oracle.exe

From: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Tue, 6 Mar 2007 12:51:50 +0000
Message-ID: <j0f7tBfmPW7FFwxh@jimsmith.demon.co.uk>


In message <1173114678.817701_at_bubbleator.drizzle.com>, DA Morgan <damorgan_at_psoug.org> writes
>Jim Smith wrote:
>> In message <1173041871.506416_at_bubbleator.drizzle.com>, DA Morgan
>><damorgan_at_psoug.org> writes
>>> astalavista wrote:
>>>> Hi,
>>>> On windows I have several instance,
>>>> if look at the task manager I see several oracle.exe.
>>>> Is there a simple way to find the SID of each oracle.exe
>>>> Thanks in advance
>>>
>>> There is no relationship between SID and oracle.exe.
>> Of course there is. It just might not be easy to find.
>
>One can use any oracle.exe to open any database. All one need
>do is change the ORACLE_SID environment variable.

I suggest you read the original post carefully. The OP was asking about the association between running processes and SID.

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Tue Mar 06 2007 - 06:51:50 CST

Original text of this message

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