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

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?)

Anyway, you want two sets of datafiles, control-file etc.. so two physical different databases. Also two initSID.ora files to startup two different instances but you want to use one RDBMS. This is absolutely no problem.

Reinier.

<roni.hursti_at_laatukolmio.fi> wrote in message news:8smhpq$lkf$1_at_nnrp1.deja.com...
> What I would like to have is:
>
> To have multible ORACLE_SID:s in one machine with one Oracle.
>
> Situation is something like this:
>
> We want have two sid's: MY_SID1 and MY_SID2
>
> When database structure changes we make the modification to MY_SID1.
> At this time users use the MY_SID2.
> After making the changes and tests to MY_SID1,
> we notify the users to change sid to MY_SID1.
>
> When new database structure changes comes we make the changes to MY_SID2
> ....
>
> In unix the change of sid (and thus database) should go like this:
> $ export ORACLE_SID=MY_SID2
> $ sqlplus system/manager @<<zz
> desc my_table
> zz
> -->
> Name Null? Type
> ------------------------------- -------- ----
> DUMMY VARCHAR2(1)
>
> $ export ORACLE_SID=MY_SID1
> $ sqlplus system/manager @<<zz
> desc my_table
> zz
> -->
> Name Null? Type
> ------------------------------- -------- ----
> DUMMY NUMBER(1)
>
> Regards
>
> Roni
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 20 2000 - 01:27:21 CDT