instance and database
Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: instance and database
Before you get into svrmgrl, check your %ORACLE_SID% environmental variable. Whichever SID it's set to, that's the database you are going to startup/shutdown. You can do set ORACLE_SID=NEW_SID to change it. Having two or more instances associated with a database is called Oracle Parallel Server (pre-9i) or Real Application Cluster (9i). You would need a cluster of minimum two nodes with a shared disk to implement it. It's possible to set up RAC on a single node under Windows or Linux. Regards, Richard Ji -Original Message- Sent: Saturday, November 30, 2002 9:39 AM To: Multiple recipients of list ORACLE-L Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Richard Ji 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: instance and database
= Original Message From [EMAIL PROTECTED] = Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? -- Yes this is correct. question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? -- The default instance. is there a way to give the startup command to get only a particular instance started ? -- Yes, set the ORACLE_SID environment variable to the SID that you want started and just issue startup in svrmgrl. Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? -- I believe you have to have RAC/Parallel Server for this kind of setup. I've never had a reason to do this. Hopefully someone else who has done this before could shed more light on this topic. can someone explain the difference between the two scenarios ? -- I can't answer this one for you. Sorry. -Scott Stefick __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: sstefick 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: instance and database
1) Identify the database you wish to start using an environment variable (good old DOS) c:\ set ORACLE_SID=SID1 c:\ svrmgrl You can also use LOCAL=SID1...It will override ORACLE_SID Both of these variables can also be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful to 'hide' a remote database so that you don't have to specify 'connect user/passwd@remotedb' you can just 'connect user/pass' You can also set either at the System environment level using a right-click on My Computer / Properties / Environment using variable names LOCAL or ORACLE_SID It's good form to do a 'select * from V$database' after you connect to make sure you are working on the right database =8-0 2) A database can be opened by multiple instances when it's configured in an OPS (Oracle Parallel Server) environment. Not to sound 'flip' here but I wouldn't worry about OPS until you get your mind around how a single instance works :) OPS is now known as RAC - Real Application Clusters Cheers Jeff Herrick On Sat, 30 Nov 2002, john wrote: Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Jeff Herrick 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: instance and database
thanks Scott, Jeff, Richard for this one. also many thanks for arup for helping out with the earlier db shutdown problem that i had earlier. --- Jeff Herrick [EMAIL PROTECTED] wrote: 1) Identify the database you wish to start using an environment variable (good old DOS) c:\ set ORACLE_SID=SID1 c:\ svrmgrl You can also use LOCAL=SID1...It will override ORACLE_SID Both of these variables can also be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful to 'hide' a remote database so that you don't have to specify 'connect user/passwd@remotedb' you can just 'connect user/pass' You can also set either at the System environment level using a right-click on My Computer / Properties / Environment using variable names LOCAL or ORACLE_SID It's good form to do a 'select * from V$database' after you connect to make sure you are working on the right database =8-0 2) A database can be opened by multiple instances when it's configured in an OPS (Oracle Parallel Server) environment. Not to sound 'flip' here but I wouldn't worry about OPS until you get your mind around how a single instance works :) OPS is now known as RAC - Real Application Clusters Cheers Jeff Herrick On Sat, 30 Nov 2002, john wrote: Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Jeff Herrick 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: instance and database
John, You are welcome. I am glad Icould be of help. Arup Nanda www.proligence.com From: john [EMAIL PROTECTED] Reply-To: [EMAIL PROTECTED] To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Subject: Re: instance and database Date: Sat, 30 Nov 2002 13:58:43 -0800 MIME-Version: 1.0 Received: from newsfeed.cts.com ([209.68.248.164]) by mc4-f27.law16.hotmail.com with Microsoft SMTPSVC(5.0.2195.5600); Sat, 30 Nov 2002 14:52:34 -0800 Received: from fatcity.UUCP (uucp@localhost)by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id OAA62840;Sat, 30 Nov 2002 14:52:30 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b72/bab) via UUCP id 0050F6DF; Sat, 30 Nov 2002 13:58:43 -0800 Message-ID: [EMAIL PROTECTED] X-Comment: Oracle RDBMS Community Forum X-Sender: john [EMAIL PROTECTED] Sender: [EMAIL PROTECTED] Errors-To: [EMAIL PROTECTED] Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 72; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Return-Path: [EMAIL PROTECTED] X-OriginalArrivalTime: 30 Nov 2002 22:52:34.0078 (UTC) FILETIME=[2BCE4BE0:01C298C3] thanks Scott, Jeff, Richard for this one. also many thanks for arup for helping out with the earlier db shutdown problem that i had earlier. --- Jeff Herrick [EMAIL PROTECTED] wrote: 1) Identify the database you wish to start using an environment variable (good old DOS) c:\ set ORACLE_SID=SID1 c:\ svrmgrl You can also use LOCAL=SID1...It will override ORACLE_SID Both of these variables can also be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful to 'hide' a remote database so that you don't have to specify 'connect user/passwd@remotedb' you can just 'connect user/pass' You can also set either at the System environment level using a right-click on My Computer / Properties / Environment using variable names LOCAL or ORACLE_SID It's good form to do a 'select * from V$database' after you connect to make sure you are working on the right database =8-0 2) A database can be opened by multiple instances when it's configured in an OPS (Oracle Parallel Server) environment. Not to sound 'flip' here but I wouldn't worry about OPS until you get your mind around how a single instance works :) OPS is now known as RAC - Real Application Clusters Cheers Jeff Herrick On Sat, 30 Nov 2002, john wrote: Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Jeff Herrick 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com
RE: instance and database
John, You're welcome. I'm always happy when I can help. -Scott = Original Message From [EMAIL PROTECTED] = thanks Scott, Jeff, Richard for this one. also many thanks for arup for helping out with the earlier db shutdown problem that i had earlier. --- Jeff Herrick [EMAIL PROTECTED] wrote: 1) Identify the database you wish to start using an environment variable (good old DOS) c:\ set ORACLE_SID=SID1 c:\ svrmgrl You can also use LOCAL=SID1...It will override ORACLE_SID Both of these variables can also be set in the registry under HKEY_LOCAL_MACHINE\Software\Oracle. LOCAL can be useful to 'hide' a remote database so that you don't have to specify 'connect user/passwd@remotedb' you can just 'connect user/pass' You can also set either at the System environment level using a right-click on My Computer / Properties / Environment using variable names LOCAL or ORACLE_SID It's good form to do a 'select * from V$database' after you connect to make sure you are working on the right database =8-0 2) A database can be opened by multiple instances when it's configured in an OPS (Oracle Parallel Server) environment. Not to sound 'flip' here but I wouldn't worry about OPS until you get your mind around how a single instance works :) OPS is now known as RAC - Real Application Clusters Cheers Jeff Herrick On Sat, 30 Nov 2002, john wrote: Oracle 8i on NT4.0 via the Oracle Database Configuration Assistant create another database. ie create another database with its instance and by default the db name and instance are same. say i proceed forward and create it. so now the box would have 2 separate services... OracleServiceSID1 OracleServiceSID2 is that correct ? question: if yes then next if i would start the svrmgrl and do a startup then which instance would be started ? is there a way to give the startup command to get only a particular instance started ? Next, the docs mention that it is possible to have two or more instance(s) associated with a given database. The above example shows two separate database, each with its one unique database. So how does one implement or have 2 instances for a given database ? can someone explain the difference between the two scenarios ? __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: Jeff Herrick 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). __ Do you Yahoo!? Yahoo! Mail Plus - Powerful. Affordable. Sign up now. http://mailplus.yahoo.com -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: john 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: sstefick 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