Having Same ORACLE_SID's in two different ORACLE_HOME
I am on a HP UNIX 11i server. I will be setting many Oracle instances installed under different ORACLE HOME's.
I am assuming ORACLE_SID can be same if instance was created under different ORACLE_HOME's"
ORACLE_HOME=/qa/oracle/production/11.1.0
ORACLE_SID=test
ORACLE_HOME=/prd/oracle/production/11.1.0
ORACLE_SID=test
I do not have an env to try, right now in design phase.
I think answer to my question is yes, but just checking any unforeseen things.
Thanks a lot.