Q. How you will start Discoverer in Oracle Apps 11i ?
In order to start dicoverer you can use script addisctl.sh under
$OAD_TOP/admin/scripts/$CONTEXT_NAME or
startall.sh under $ORACLE_HOME/discwb4/util
(under Middle/Application Tier)
Q. How many ORACLE HOME are Oracle Apps and whats significance of each ?
There are three $ORACLE_HOME in Oracle Apps, Two for Application Tier (Middle Tier) and
One in Database Tier.
ORACLE_HOME 1 : On Application Tier used to store 8.0.6 techstack software. This is used by forms, reports
& discoverer. ORACLE_HOME should point to this ORACLE_HOME which applying Apps Patch.
ORACLE_HOME 2: On Application Tier used by iAS (Web Server) techstack software. This is used by
Web Listener & contains Apache.
ORACLE_HOME 3: On Database Tier used by Database Software usually 8i,9i or 10g database.
Q. Where is HTML Cache stored in Oracle Apps Server ?
Oracle HTML Cache is available at $COMMON_TOP/_pages for some previous versions
you might find it in $OA_HTML/_pages
Q. Where is plssql cache stored in Oracle Apps ?
Usually two type of cache session & plssql stored under
$IAS_ORACLE_HOME/Apache/modplsql/cache
Good luck for your interview. If you are not happy with
quality of questions or want to submit Oracle 11i Apps Interview questions Mail Me.