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...
> > 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: [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).
_________________________________________________________________
Help STOP SPAM with the new MSN 8 and get 2 months FREE* http://join.msn.com/?page=features/junkmail
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Arup Nanda
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).
