Re: New Instance

The Instance is the shared memory area (SGA) plus the background processes which manage the database (which is the physical collection of control files, data files and redo logs). Accordingly, until you get into parallel server, one database is always managed by one Instance, and an Instance can only ever manage one database.

In parallel server, whilst it remains true that each individual Instance can only manage the one database, it becomes possible for the one database to be managed by multiple Instances.

Regards
HJR

--
=============================!!=============================
The views expressed are my own only, and definitely NOT those of Oracle
Corporation
=============================!!=============================


"James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message
news:XBrahhAJToK7EwnE_at_rees-chappell.demon.co.uk...


> I'm always confused between an "Instance" and a "Database".

> Don't you have one database, and one or more instances, or is it the

> other way round?

>

> In article <NKcW6.389$Tt6.128756_at_monger.newsread.com>, Van Messner

> <vmessner_at_bestweb.net> writes

> >I hesitate to even mention it in this group but you can also run the

 ((low


> >whisper) database creation assistant) and have a lot of the drudge work

 done


> >for you.

> >

> >Van

> >

> >

> >"James Chappell" <james_at_rees-chappell.demon.co.uk> wrote in message

> >news:YnW54KAyW+J7Ew9M_at_rees-chappell.demon.co.uk...

> >> How do I create a second instance on my NT box? I'm running Oracle

 8.0.6


> >> at the moment.

> >>

> >> Thanks in advance for help.

> >>

> >> --

> >> James Chappell

> >

> >

>

> --

> James Chappell