| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: instance and database
John,
You are welcome. I am glad Icould be of help.
Arup Nanda
www.proligence.com
>From: john <john_g123_9_at_yahoo.com>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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_at_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: <F001.0050F6DF.20021130135843_at_fatcity.com>
>X-Comment: Oracle RDBMS Community Forum
>X-Sender: john <john_g123_9_at_yahoo.com>
>Sender: root_at_fatcity.com
>Errors-To: ML-ERRORS_at_fatcity.com
>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: root_at_fatcity.cts.com
>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 <jherrick_at_igs.net> 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_at_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...
> > > OracleService<SID1>
> > > OracleService<SID2>
> > >
> > > 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: john_g123_9_at_yahoo.com
> > >
> > > 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: ListGuru_at_fatcity.com (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: jherrick_at_igs.net
> >
> > 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: ListGuru_at_fatcity.com (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: john_g123_9_at_yahoo.com
>
>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: ListGuru_at_fatcity.com (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: Arup Nanda INET: arupnanda_at_hotmail.com 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: ListGuru_at_fatcity.com (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).Received on Sat Nov 30 2002 - 22:48:57 CST
 |
 |