Re: Instance, database ?? what is the difference?

An instance is the set of processes, threads and memory structures to manage one (1) database.
One instance manages one database. One database is associated with one instance, unless you have Oracle Parallel Server, where a second instance on a different server will also manage that database (typically done in high-availability situations)
If you are going to create a second database, you are going to create a second instance. Whether your system will allow that or not is purely an issue of resources, not of Oracle.

Hth,

--
Sybrand Bakker, Oracle DBA
Mike Ng <mike_at_email.tech-trans.com> wrote in message news:387315db_3_at_news1.prserv.net...
> Hi all,
>
> I have a stupid question about the oracle.
> In a standalone machince, can I set up multiple database at this machine?
> Also, can this database server has multiple instances?
> Actually, I cannot clarify the difference between instance and database
> clearly. Anyone can give me some hints.
> Thank you in advance.
>
> Mike
>
>
Received on Wed Jan 05 2000 - 04:01:24 CST