Is it possible to have 2 instances with same sid running on same machine under 2 different Oracle homes ?
yes (but not on Windows) - but why you want to is a mystery
Originally Posted by davey23uk
Is it possible only in case of RAC ?
Originally Posted by 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?
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
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?
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.
applications use tns entries, use different listener ports
Originally Posted by sunidba
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.
Click Here to Expand Forum to Full Width