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

This is inconsistent with your previous post:

roni.hursti_at_laatukolmio.fi wrote:

> 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.

So, MY_SID1 is a databases. (you *are* making database structure changes)

> 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

Which is also a database.

>
> ....
>
> In unix the change of sid (and thus database) should go like this:

Ah, you noticed yourself!

OK what this boils down to is, IMO:
- two databases: one production, one test - 24 x 7 shop (or a lazy dba)

Only from this post, I understand what situation you are describing: database cannot be down.
Well, some changes may have to be implemented outside office hours, that's the way it is... Sometimes, databases even have to be brought down to implement certain changes.

Two databases are physically separated. If the scenario you describe would exist, how do you keep track of changes to database MY_SID1 vs the ones in MY_SID2?
Either this is Parallel Server (2 instances accessing 1 database. This means your 'changes in database structure' will only need to go in once), or this is two databases, which is no problem, and almost what you descibe (mind you: not at all what you are probably trying to accomplish!).

hope this sheds some light.
What _is_ the idea of all this?

Frank Received on Thu Oct 19 2000 - 15:27:51 CDT