Re: Multiple Instances

From: Gopalakrishnan Hariharan <pranav_at_ix.netcom.com>
Date: 1995/08/03
Message-ID: <3vp89r$2u8_at_ixnews3.ix.netcom.com>#1/1


In <3vo37u$fr3_at_alijku06.edvz.uni-linz.ac.at> andreas_at_convex.edvz.uni-linz.ac.at (Andreas Hausleitner) writes:
>
>Hi Oraclers!
>
>Does anyone know how it is possible to start more than one instance on
>a machine. Each instance has a database. If I want to start more
 instances
>all tried to use the same sgadefSID.dbf (Do I have to install Oracle
 multiple
>times?).
>
>Or is it possible to maintain several databases with one instance?
>
>We are using Oracle 7.0.16.6 on HP9000/735 with HP-UX 9.05.
>
>Thanks for your reply,
>
>Andreas Hausleitner
>
>----------------------------------------------------------------------
>Andreas Hausleitner, DI
>University of Linz / Austria
>Computing Center
>Department for Supercomputing FAX : +43 732 2468-688
>Altenberger Str. 69 Tel.: +43 732 2468-203
>A-4040 LINZ email: hausleitner_at_edvz.uni-linz.ac.at
>----------------------------------------------------------------------

the ORACLE_SID has to be set to the sida, sidb etc prior to starting sqldba (sqldba has a PFILE parameter. i have not used it) ksh: export ORACLE_SID=sid_1
csh: setenv ORACLE_SID sid_1
sh: ORACLE_SID=sid_1; export ORACLE_SID

An instance can be associated with only one database. many instances can be associated with the same database (parallel server option) Received on Thu Aug 03 1995 - 00:00:00 CEST

Original text of this message