Stefan,
This is due to a registry entry - ORA_SID_AUTOSTART.
Open a registry editor, and navigate to
HKEY_LOCAL_MACHINE/SOFTWARE/ORACLE/HOMEn (where n is the number Oracle home
of the instance in question, should there be multiple instances), and you
should see ORA_SID_AUTOSTART set to TRUE, just change it to FALSE and it
your instance won't be started..
HTH
Mark
===================================================
Mark Leith | T: +44 (0)1905 330 281
Sales & Marketing | F: +44 (0)870 127 5283
Cool Tools UK Ltd | E: [EMAIL PROTECTED]
===================================================
http://www.cool-tools.co.uk
Maximising throughput & performance
-----Original Message-----
Stefan Jahnke
Sent: 06 June 2003 12:29
To: Multiple recipients of list ORACLE-L
Hi list
On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service
OracleService<SID>, most of the times, the database will also be mounted and
opened !
Doesn't matter wether I start the service via gui or via "net start
OracleService<SID>" or "oradim -STARTUP -SID <SID> -USRPWD <PWD> -STARTTYPE
srvc", the database will be opened right away.
I definitely don't want that. That sh%&%($t can sc%&$/w up my instance. Does
anybody encounter the same problems ? Couldn't find anything relevant on
metaling, though.
Help,
Stefan
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Stefan Jahnke
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
---
Incoming mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.487 / Virus Database: 286 - Release Date: 01/06/2003
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Mark Leith
INET: [EMAIL PROTECTED]
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).