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 PR
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
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
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\Oracl
>= 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
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 Serve
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
Or