Re: Multiple Instances

From: Louis POTY <louisp_at_sdv.fr>
Date: 1995/08/04
Message-ID: <3vt8m4$liq_at_casimir.sdv.fr>#1/1

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?

>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.
>

Sure, it is possible.
Our development staff works on a single machine with at least three instances running. What you have to do is to correctly set ORACLE_HOME and ORACLE_SID before creating your new database. Each instance has its own SID, init<SID>.ora file, and all works fine. Received on Fri Aug 04 1995 - 00:00:00 CEST

This message: [ Message body ]
Next message: Sylvain Taccucci: "This is a test"
Previous message: Brenton Camac: "Oracle HINTS and performance"
In reply to: Andreas Hausleitner: "Multiple Instances"
Next in thread: Jim Gregory: "Re: Multiple Instances"
Reply: Jim Gregory: "Re: Multiple Instances"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message