RE: Oracle Service on Win2k
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 OracleServiceSID, 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 OracleServiceSID 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).
RE: Oracle Service on Win2k
I need more coffee, please excuse my weekend ready brain from it's grammar fart. Mark -Original Message- Mark Leith Sent: 06 June 2003 13:00 To: Multiple recipients of list ORACLE-L 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 OracleServiceSID, 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 OracleServiceSID 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). --- 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).
RE: Oracle Service on Win2k
Maybe the obvious But Is the registry key ORA_SID_AUTOSTART set to true?? Jack -Original Message- Sent: Friday, June 06, 2003 1:29 PM 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 OracleServiceSID, 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 OracleServiceSID 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Jack van Zanen 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).
RE: Oracle Service on Win2k
Hi, Either - 1) ORADIM -EDIT -SID SID -STARTMODE MANUAL or - 2) regedit. Change HKLM\Software\Oracle\HomeX\ORA_SID_AUTOSTART. Change the value to FALSE. HTH. -Original Message- Sent: Friday, June 06, 2003 7:29 AM 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 OracleServiceSID, 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 OracleServiceSID 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). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Seefelt, Beth 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).
RE: Oracle Service on Win2k
Stefan, Have you tried using the NOMOUNT switch somewhere in your db instance startup? Julio -Original Message- From: Stefan Jahnke [mailto:[EMAIL PROTECTED] Sent: Friday, June 06, 2003 7:29 AM To: Multiple recipients of list ORACLE-L Subject: Oracle Service on Win2k Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleServiceSID, 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 OracleServiceSID 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: QuijadaReina, Julio C 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).
RE: Oracle Service on Win2k
Hang around and we'll learn you some grammer. Oh, and Oracle acknowledge they have a bug in the index builds. Multiple users had reported it, but it was Oracle's decision to sit on their thumbs and rotate until somebody handed them a trace file proving it. Now, they want us to set up a test case for them. So, what do we get out of the deal? Anything? Maybe an autographed picture of Larry on the toilet? -Original Message- And by the way ... which grammar problems ? Can't find any, since English is not even my mother tongue ;). -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Stephen Lee 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).
RE: Oracle Service on Win2k
Subject: Oracle Service on Win2k Hi list On Oracle 9.2.0.3.0 (patched from 9.2.0.1.0 ): When i start JUST the service OracleServiceSID, 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 OracleServiceSID or oradim -STARTUP -SID SID -USRPWD PWD -STARTTYPE srvc, the database will be opened right away. I definitely don't want that. Out of sheer (sick?) curiosity - why wouldn't you want that? What happens if manual-start-up-preferring DBA goes on 2 week vacation and server gets rebooted as a result of prolonged power failure? Consequence will be - the database will not re-open automatically as it was specifically told not to do so... Having seen results (utter panic striking one of our customers) I always wondered what could have possibly been the motive or rationalization for setting things up this way in the first place. Branimir -- Please see the official ORACLE-L FAQ: http://www.orafaq.net -- Author: Branimir Petrovic 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).