Changes to OFA for Oracle 10g

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 /u01/app/oracle/product/10g/db_1.

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_1, db_2 and so-on for full database releases and client_1, 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.

To read more about OFA, check out my earlier article on the topic and Oracle’s explanation of OFA.

oracle, sql, dba, database administration, database development, database security, database, oracle security

3 thoughts on “Changes to OFA for Oracle 10g”

  1. I am interested to know about the compatibility of Oracle 10g on a Pentium III machine. I got to know that its recommended requirement is PIV, but it can also be used on PIII. Can you tell me the problems we will face if we install 10g on a PIII?

    Also, if Oracle 9i has better performance than 10g on a PIII machine. Please help.

  2. Amit, I have run Oracle 10g on Pentium 3 and 4 systems. For compatibility the operating system version is more important than the processor.

    That having been said, the faster the better, but more than processor you should be concerned about having plenty of RAM. I would say 1GB minimum RAM to get started with 9i or 10g. Of course everything depends on your application.

    You can get all the documentation from You will need an OTN account, but they’re free.

    I’m guessing you’re fairly new to Oracle. Expect your first couple installs to be slow, with a lot of time spent in the documentation, but they will get quicker as time goes on. Good luck!

Leave a Reply

Your email address will not be published. Required fields are marked *