You can have more than one ORACLE_HOME
for every node, primarily for migration projects that will be spread over an extended period of time. There is an inherent risk in running multiple ORACLE_HOMES
, in that you may mistakenly use the wrong ones. It is my personal recommendation that the ongoing risk is worth it when using the Step-Ordered Approach to Migrating, because it reduces the overall downtime (see Chapter 7).
An ORACLE_HOME
consists of installed binary files along with Oracle-supplied scripts. The database comprises memory structures, background processes, control files, parameter files, data files, and temporary and undo files. There are other types of ORACLE_HOME
(s) that contain ORACLE installed software, as each of them is only an environmental variable pointing to a specific disk location. Other types will have other names like: CRS_HOME
or AGENT_HOME
that may be identified as an ORACLE_HOME
in the Oracle documentation. This means you can have multiple...