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: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 05 Mar 2007 09:11:19 -0800
Message-ID: <1173114678.817701@bubbleator.drizzle.com>


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.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org
Received on Mon Mar 05 2007 - 11:11:19 CST

Original text of this message

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