With Oracle 10g there has been a small but useful change made to Oracle’s Optimal Flexible Architecture.
The Optimal Flexible Architecture standards are a guideline for setting up Oracle databases to minimize downtime and maximize scalability. For more information, check out my article on OFA.
In 10g, Oracle has added one level to the ORACLE_HOME path. An Oracle home directory which was formerly
/u01/app/oracle/product/9.2.0 is now one more level deeper at
By adding install type and an install number as the final level of the Oracle home variable it is now possible to have two or more installs of the same version of Oracle in the same Oracle directory.
Oracle offers up the idea of using
db_2 and so-on for full database releases and
client_2 and so-on for client installs I can also see using this method to install Oracle applications servers in the same directory as well.