Re: Autostarting databases
Hi Bob I took a look at the database service one of our servers. service properties: startup program: d:\oracle\ora816\bin\oracle.exe abcd (the sid of the database). startup mode = automatic. logon as local system account. allow service to interact with desktop. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 9:52 PM Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Yechiel Adar 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: Autostarting databases
strtSID.cmd is long gone, probably since version 8.1X Igor Neyman, OCP DBA [EMAIL PROTECTED] - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Thursday, November 14, 2002 12:13 AM Read Metalink Note: 62006.1 strtSID.cmd is created when you create a service using ORADIMxx, atleast on NT and DB version till 8.0.x, not sure about Win2K and Oracle Server 8.1.x and later Regards Naveen -Original Message- Sent: Thursday, November 14, 2002 1:23 AM To: Multiple recipients of list ORACLE-L Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Naveen Nahata 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.com -- Author: Igor Neyman 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: Autostarting databases
Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. Yechiel Adar Mehish - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, November 13, 2002 5:18 PM All Ive finally returned to my desk from the server room/user desktop trenches ;-) with hopefully some time to pose this autostarting problem to the list. I have about 12 oracle database(services) running on windows 2k server, I believe by starting the service should start the instance and stopping the service should shutdown the database. This not happening on the server, so the databases are not starting up automatically. I have to force start then using a batch file as such svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 ... initdb8i.sql connect internal/pw@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit I have tried to delete the service via oradim and recreating but doing that does not affect the auto starting problem. Here is an example of my use of oradim F:\ORA817\bin\ORADIM -delete -SID db8i F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst -TIMEOUT 60 One other issue is once I delete the service and create a new service, then try to delete again. win2k informs me the service is currently marked for deletion so you cant do anything else with the instance, a reboot to clear the marked service is necessary. I've checked the registry entries in the oracle home and it corresponds exactly to what is specified in the oradim statement and the path to the oracle.exe in the service is correct. Overall history: this server was NT 40, now upgraded to win2k server this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3 currently the default home is set to 8.1.7 The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases I have tried to 1. delete and recreate the sid using oradim 2. migrating an 8.1.6 to 8.1.7 using the migration wizard 3. Building a new database using 8.1.7 None of the databases will auto start! I have win2k pro with 8.1.6 on my machine and stopping and starting the service starts and stops the database Any suggestions for getting my db's to start upon boot up. I have deleted the service with oradim then recreated, as above then rebooted and the db does not start. This whole problem started whn the server was upgraded to win2k server. thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Yechiel Adar 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: Autostarting databases
Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. This file does exist for version 8 on NT, not sure about higher versions on Win2K. Regards Naveen -Original Message- Sent: Wednesday, November 13, 2002 8:49 PM To: Multiple recipients of list ORACLE-L All Ive finally returned to my desk from the server room/user desktop trenches ;-) with hopefully some time to pose this autostarting problem to the list. I have about 12 oracle database(services) running on windows 2k server, I believe by starting the service should start the instance and stopping the service should shutdown the database. This not happening on the server, so the databases are not starting up automatically. I have to force start then using a batch file as such svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 ... initdb8i.sql connect internal/pw@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit I have tried to delete the service via oradim and recreating but doing that does not affect the auto starting problem. Here is an example of my use of oradim F:\ORA817\bin\ORADIM -delete -SID db8i F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst -TIMEOUT 60 One other issue is once I delete the service and create a new service, then try to delete again. win2k informs me the service is currently marked for deletion so you cant do anything else with the instance, a reboot to clear the marked service is necessary. I've checked the registry entries in the oracle home and it corresponds exactly to what is specified in the oradim statement and the path to the oracle.exe in the service is correct. Overall history: this server was NT 40, now upgraded to win2k server this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3 currently the default home is set to 8.1.7 The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases I have tried to 1. delete and recreate the sid using oradim 2. migrating an 8.1.6 to 8.1.7 using the migration wizard 3. Building a new database using 8.1.7 None of the databases will auto start! I have win2k pro with 8.1.6 on my machine and stopping and starting the service starts and stops the database Any suggestions for getting my db's to start upon boot up. I have deleted the service with oradim then recreated, as above then rebooted and the db does not start. This whole problem started whn the server was upgraded to win2k server. thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Naveen Nahata 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: Autostarting databases
Bob: Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Then specify the parameters that are to be used for startup, like pfile=xx. Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. This method has been known to work. RWB Bob Metelsky [EMAIL PROTECTED]@fatcity.com on 11/13/2002 09:18:55 AM Please respond to [EMAIL PROTECTED] Sent by: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] cc: All Ive finally returned to my desk from the server room/user desktop trenches ;-) with hopefully some time to pose this autostarting problem to the list. I have about 12 oracle database(services) running on windows 2k server, I believe by starting the service should start the instance and stopping the service should shutdown the database. This not happening on the server, so the databases are not starting up automatically. I have to force start then using a batch file as such svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 ... initdb8i.sql connect internal/pw@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit I have tried to delete the service via oradim and recreating but doing that does not affect the auto starting problem. Here is an example of my use of oradim F:\ORA817\bin\ORADIM -delete -SID db8i F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst -TIMEOUT 60 One other issue is once I delete the service and create a new service, then try to delete again. win2k informs me the service is currently marked for deletion so you cant do anything else with the instance, a reboot to clear the marked service is necessary. I've checked the registry entries in the oracle home and it corresponds exactly to what is specified in the oradim statement and the path to the oracle.exe in the service is correct. Overall history: this server was NT 40, now upgraded to win2k server this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3 currently the default home is set to 8.1.7 The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases I have tried to 1. delete and recreate the sid using oradim 2. migrating an 8.1.6 to 8.1.7 using the migration wizard 3. Building a new database using 8.1.7 None of the databases will auto start! I have win2k pro with 8.1.6 on my machine and stopping and starting the service starts and stops the database Any suggestions for getting my db's to start upon boot up. I have deleted the service with oradim then recreated, as above then rebooted and the db does not start. This whole problem started whn the server was upgraded to win2k server. thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: 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: Autostarting databases
Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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: Autostarting databases
Bob, ORADIM is not to be relied on to properly setup the registry. Check the ORACLE_SID value in HKLM/Software/Oracle/HOMEn directories to make sure that it is there and set properly. See Note 136214.1 on MetaLink, it has details on setting up the auto startup/shutdown parameters. Jared On Wednesday 13 November 2002 07:18, Bob Metelsky wrote: All Ive finally returned to my desk from the server room/user desktop trenches ;-) with hopefully some time to pose this autostarting problem to the list. I have about 12 oracle database(services) running on windows 2k server, I believe by starting the service should start the instance and stopping the service should shutdown the database. This not happening on the server, so the databases are not starting up automatically. I have to force start then using a batch file as such svrmgrl.exe command='@C:\db_startup\initdb8i.sql' C:\sleep 3 ... initdb8i.sql connect internal/pw@db8i startup pfile=R:\OR_8I\ADMIN\DB8I\pfile\init.ora exit I have tried to delete the service via oradim and recreating but doing that does not affect the auto starting problem. Here is an example of my use of oradim F:\ORA817\bin\ORADIM -delete -SID db8i F:\ORA817\bin\ORADIM -NEW -SID db8i -INTPWD pw -STARTMODE auto -PFILE R:\OR_8I\ADMIN\DB8I\pfile\init.ora -SHUTMODE i -SHUTTYPE srvc,inst -TIMEOUT 60 One other issue is once I delete the service and create a new service, then try to delete again. win2k informs me the service is currently marked for deletion so you cant do anything else with the instance, a reboot to clear the marked service is necessary. I've checked the registry entries in the oracle home and it corresponds exactly to what is specified in the oradim statement and the path to the oracle.exe in the service is correct. Overall history: this server was NT 40, now upgraded to win2k server this server has oracle 7.3.4, 8.0.5, 8.1.6, 8.1.7.3 currently the default home is set to 8.1.7 The server is running aproc 12 8.1.6 instances and 10 8.1.7 databases I have tried to 1. delete and recreate the sid using oradim 2. migrating an 8.1.6 to 8.1.7 using the migration wizard 3. Building a new database using 8.1.7 None of the databases will auto start! I have win2k pro with 8.1.6 on my machine and stopping and starting the service starts and stops the database Any suggestions for getting my db's to start upon boot up. I have deleted the service with oradim then recreated, as above then rebooted and the db does not start. This whole problem started whn the server was upgraded to win2k server. thanks bob -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Jared Still 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: Autostarting databases
Read Metalink Note: 62006.1 strtSID.cmd is created when you create a service using ORADIMxx, atleast on NT and DB version till 8.0.x, not sure about Win2K and Oracle Server 8.1.x and later Regards Naveen -Original Message- Sent: Thursday, November 14, 2002 1:23 AM To: Multiple recipients of list ORACLE-L Check what SP is installed on the server. This is a common problem with Y2K SP1. Upgrade to SP2. This is windows 2k server service pack 3 Have a look at the strtsid.cmd script which is used for starting the instance/DB inside %ORACLE_HOME%\DATABASE. That must be a personal custom script. Ive searched all my nt and win2k servers and only have a TRCFMT.cmd which looks like a file to format trace files Let's try the simple solution first. How about using the Services utility in Control Panel to check the service for startup =AUTO. Yes its on auto Then specify the parameters that are to be used for startup, like pfile=xx. Your talking about the properties window of the service? Where it says You can specify the parameters that apply when you start the service from here If so that will start the database but the setting pfile=x does not retain. So, it seems like you can only pass that parameter, the pfile=xxx once Specify the userid that is supposed to start the database, preferably not the Administrator userid, but Oracle or a derivative of it. So your asying I need a win2k account for the database user? Ive never heard of that nor have seen parameters in any other configurations. This method has been known to work. RWB -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bob Metelsky 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.com -- Author: Naveen Nahata 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).