Re: How to create another instance on the same manchine?

sc <cfs3526_at_hotmail.com> schreef in berichtnieuws 957905054.716880_at_newsreader-hpw1.net.bms.com...
> It is probably a dumb question. In oracle 8, to use Database assistant to
> create another database, is this 'New Database' an 'Instance'? If not,
 how
> can you create another instance on the same NT machine with the same
> database?
>
> Thank you very much for your help.
>
>

The New database is an instance.
An instance is a collection of processes and memory structures managing _ONE_ database.
One instance can manage one database.
One database can only be managed by _one_ instance, the only exception being Oracle Parallel Server.
While technically possible it doesn't make much sense to run Oracle Parallel Server on one single server as one of it's main goals is failover.

Hth,

Sybrand Bakker, Oracle DBA Received on Tue May 09 2000 - 00:00:00 CDT