Do two ORACLE_HOMEs create on the same host?

Question

Oracle

Good evening,
Can you tell me if it is possible to install two different versions of the database on the same host, for example 11.2.0.4 and 11.2.0.3?
On Windows 2012.
Regards, Roman

Answer 1

No problem. With multiple ORACLE_HOMEs on the same host, no. Access to the database by beq will be carried out by environment variables. Run the Listener from a newer instance. Most likely, it will listen to both databases (if the version of the database is equal to or greater than the version of the second database by 1, that is, 11 listens to 11g and 10g but not 9i). Do not pay attention to the answer above, it has nothing to do with ports.
example of setting variables for several databases: true in linux:
first database:
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1
export ORACLE_SID=SID1
second database:
export ORACLE_BASE=/u01/ app/oracle
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_2
export ORACLE_SID=SID2
For windows it's the same but replace export with set. In general, access by beq is not so often needed. And when accessing over the network, create 2 tns aliases with different sids.