ORACLE - Why I need shared APPL_TOP ?

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

(Continued from previous question...)

ORACLE - Why I need shared APPL_TOP ?

If you have two/three (Multiple) Middle Tier for Large User base then you have to install APPL_TOP, COMMON_TOP & ORA_TOP equal to number of Nodes in your configuration. So if you have three middle tier then you need these three top three times & if there are n nodes you need n time these three top's . This result in lots of Space Requirement & bigger problem is patching so If you have 5 nodes you need to apply apps patch 5 times.

So Oracle Came Up with solution to have single APPL_TOP which is shared across all nodes in apps. This will save space as well patch timing. This concept of sharing APPL_TOP file system across all Middle Tier Nodes is called as APPL_TOP

You will say if I can share APPL_TOP why Can't I share COMMON_TOP & ORA_TOP as well which are also part of Application Tier , Yes you can & this concept is called as Shared Application Tier.

(Continued on next question...)

Other Job Interview Questions

• How can you tell if a query will scale for production?
• What is a database?
• Oracle Apps DBAs - What is port pool ?
• Can you provide quality examples of your previous projects?
• Oracle Apps DBAs - What is port pool ?
• Oracle Apps DBAs - How would you know about which servers are running on a particular node ?
• Why are you here?
• Who is the most important user of a database?
• Which is faster: Inserting one million rows of data, or updating one million rows of data?
• Oracle Apps DBAs - if you find that under $FND_TOP/secure directory, there are many .dbc files, how would you know which is the correct one ?
• More...