Re: Oracle instance and database question

From: Eugen Nyffeler <eugen.nyffeler_at_ubs.com>
Date: Mon, 27 Apr 1998 11:32:51 +0200
Message-ID: <354450C2.C215342A@ubs.com>

Eric Wong wrote:

<snip>

> I am having a similar question, running multiple databases from one
> Oracle server.
>
> I am new to Oracle database, & I have a database setup & running on an
> Oracle database server.
>
> The question is, how can I create another database (is that called
> another instance) on the same machine?
>
> Thanks for any info.
>
> Eric

Hi Eric

It depends what you try to do. If this two databases should share the same datafiles (*.dbf files) then it would be something like a paralell server (but to my knowledge the two instances should run on different servers.)
If the two databases are independet with own datafiles then this are two different databases or aka two instances.

How to set up, see the Oracle7 Sever Administrator Guide starting at page 2-4. This should guide you trough the process.

rgds
eugen Received on Mon Apr 27 1998 - 04:32:51 CDT