DBA > Job Interview Questions > Oracle DBA Interview questions and Answers

How many ORACLE HOME are Oracle Applications and

More DBA job interview questions and answers at http://dba.fyicenter.com/Interview-Questions/

(Continued from previous question...)

How many ORACLE HOME are Oracle Applications and whats significance of each ?

There are three $ORACLE_HOME in Oracle Applications, Two for Applications Tier (Middle Tier) and One in Database Tier.
# ORACLE_HOME 1 : On Applications Tier used to store 8.0.6 techstack software. This is used by forms, reports and discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying application Patch.
# ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by Web Listener and contains Apache.
# ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.

(Continued on next question...)

Other Job Interview Questions