Two instance

[sunidba]

Hi,

Is it possible to have 2 instances with same sid running on same machine under 2 different Oracle homes ?

[davey23uk]

yes (but not on Windows) - but why you want to is a mystery

[bhattnirav]

yes (but not on Windows) - but why you want to is a mystery

Is it possible only in case of RAC ?

[davey23uk]

Is it possible only in case of RAC ?

what?

[bhattnirav]

As you are saying that 2 instances with same sid running on same machine under 2 different Oracle homes is possible (not on windows platform).

How it is possible?

[davey23uk]

by creating two instances under different oracle homes with the same sid, but only on non windows platforms

you just do it if you want to

[bhattnirav]

Thanks for your reply davey23uk.

On unix platform it will create smon process at O/S level for each sid.

So how it is possible with same sid name?

[sunidba]

Hi,

I just checked, and actually it is possible.
The process name will be same, but the pid will be different.

This doubt was arised in the context of 11i apps, where i was wondering if there are two instance of same name, how will the application recognize the right database.

Thx
Sunil

[davey23uk]

Hi,

I just checked, and actually it is possible.
The process name will be same, but the pid will be different.

This doubt was arised in the context of 11i apps, where i was wondering if there are two instance of same name, how will the application recognize the right database.

Thx
Sunil

applications use tns entries, use different listener ports

[paragp1981]

davey,
this is new learning for me. i will try it
but i am kind of confused like on unix you need to make those 2 same sid databases with not only different OH's but with different oracle users also. otherwise wont there semaphores clash ?
i mean semaphores are allocated userwise. So for them to make not clash i think we need to use different users.
Comments !!!!!!