Thanks for the clarifications.

Gurmohan
www.freemath.info - The ultimate tool in learning and teaching math skills.




-----Original Message-----
From: Stroh Kathleen (DTI)
[mailto:oracledba-ezmlmshield-x61373975.[Email address protected]
Sent: Friday, September 30, 2005 10:22 AM
To: LazyDBA Discussion
Subject: RE: Instances on Windows 2000 !!!!!!!!!!


To answer your question:

Stopping the service on windows does indeed stop the database - more
forcefully than shutdown abort. Restarting the service will indeed
start up the database if its startup is set to AUTO in oradim. And if
oradim can find the pfile, or you're using spfile.

-----Original Message-----
From: Shergill Gurmohan
[mailto:oracledba-ezmlmshield-x8382003.[Email address protected]
Sent: Friday, September 30, 2005 10:07 AM
To: LazyDBA Discussion
Subject: RE: Instances on Windows 2000 !!!!!!!!!!

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


--------
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