In the services panel the oracle database or instance services will be listed as OracleService???? where question marks are your sid names. The status column will tell you whether the service is up [if it has started in this column] or not.
A related curiosity that comes to my mind is if stopping and restarting these services actually stops and starts the database and instance or it simply makes the instance and database connectable when started and not connectable when stopped but database exists at all times. May be Mudhalvan can clarify this also.
Gurmohan
www.freemath.info - The ultimate tool in learning and teaching math skills.
-----Original Message-----
From: Mudhalvan Moovarkku
[mailto:oracledba-ezmlmshield-x3982000.[Email address protected]
Sent: Friday, September 30, 2005 4:09 AM
To: LazyDBA Discussion
Subject: RE: Instances on Windows 2000 !!!!!!!!!!
Hi Venugopal,
Open Services from Control Panel --> Administrative Tools and
Check You will know
Regards
Mudhalvan M.M
-----Original Message-----
From: VGaddipati
[mailto:oracledba-ezmlmshield-x17819260.[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
--------
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