Re: How can I run multiply instances in Oracle at the same time?

"Reinier" <Reinier_Dickhout_at_hetnet.nl> wrote in message news:#XA5Q8lOAHA.335_at_net003s...
> Maybe there is a little confusion about terminology here. If I read yor
 post
> correctly you want two instances on one machine. Or you can say two
> different databases. A database is ususally consider to be the total of
> datafiles, control files etc.. (I'm not saying this is right however, not
> saying it's wrong either, just can't think of a good way to describe it
> myself) whereas an instance is usually consider to be the up and running
> version of a database (you bring the database down, when down still a
> database, but you connect to an idle instance when your database is
 down...
> still with me?)

Hi

Database = set of physical files
Instance =set of processes and memory structures that access that database.

The reason for the distinction becomes clear when you consider OPS. Here you have two (or more) instances but one database.

HTH

--
Niall Litchfield
Oracle DBA
Audit Commission UK