Hi Venugopal,

Good Try this command

net start|grep "OracleService"

C:\Documents and Settings\mmudhalvan>net start |find "OracleService"
OracleServiceCAPITAL

Regards
Mudhalvan M.M

_____

From: [Email address protected] [mailto:[Email address protected]
Sent: Friday, September 30, 2005 6:09 PM
To: Mudhalvan, Moovarkku
Subject: RE: Instances on Windows 2000 !!!!!!!!!!



That's fine, and we have other ways also like through task manager and '
lsnrctl status' etc,. But what we are looking at is a command (just like
in Unix) which would enumerate(output) the number of instances so that
the command can be embedded in a program.

Kind Regards,
Venugopal R.
Technical Architect (Database Services).
Manugistics Software Services (India) Pvt Ltd.




"Mudhalvan Moovarkku " <[Email address protected]

09/30/2005 01:38 PM

To
[Email address protected]
cc
Subject
RE: Instances on Windows 2000 !!!!!!!!!!






**A LazyDBA.com subscriber has responded to your lazydba.com post**
**LazyDBA.com mail shield has forwarded you this email,
**and removed any attachments, and kept your email address secret
**from this person, and any viruses/trojans.
**If you reply to this email, the person will see your email address as
normal
**Anything below this line is the original email text


Hi Venugopal,

Open Services from Control Panel --> Administrative
Tools and
Check You will know

Regards
Mudhalvan M.M

-----Original Message-----
From: VGaddipati
[Email address protected]
Sent: Friday, September 30, 2005 4:52 PM
To: LazyDBA Discussion
Subject: Instances on Windows 2000 !!!!!!!!!!

Hi Folks,

Is there any way to know as to how many instances are (SID) there
(running or shutdown) on a windows 2000 box?

Help would be greatly appreciated.

Kind Regards,
Venugopal R.
Technical Architect (Database Services).
Manugistics Software Services (India) Pvt Ltd.


--------
website: http://www.LazyDBA.com
Please don't reply to RTFM questions
Oracle documentation is here: http://tahiti.oracle.com To unsubscribe:
see http://www.lazydba.com/unsubscribe.html
To subscribe: see http://www.lazydba.com By using this list you agree
to these terms:http://www.lazydba.com/legal.html






Oracle LazyDBA home page