Oracle Apps 11i / R12 Interview Question (Installation)
On popular request from newbie I am posting few more Apps DBA Interview Questions (around Installation). If you are new to Oracle Apps and prefer book then you can order one from Amazon written by Joyjeet Banerjee – Cracking the Oracle Apps DBA Interview: 325 Frequently Asked Questions
Q1. Which user you use to install Oracle Apps 11i/R12 on Unix/Linux ?
A: root
Q2.Which script/executable you use to install Oracle Apps 11i/R12 “runInstaller” or “rapidwiz” ?
A: rapidwiz
Q3. When you install apps (11i/R12) it stores configuration in text file , what is name of this file and where is this stored ?
A. File name in 11i is config.txt and in R12 file name is config_$SID.txt
This is stored in three locations in R12; Database $ORACLE_HOME/appsutil, $INST_TOP and/tmp/<time stamp>/ In 11i config.txt is stored in /tmp/config.txt
Q4. What are hosts file entry requirement for 11i/R12 in Linux/Unix ?
A.You should have an entry in /etc/hosts like <IP Address> <hostname>.<domain_name> <hostname>
Q5. What is staging area ?
.
A.You can install E-Business Suite either from CD’s or by staging CD’s in to file system on machine . Staging area is useful because
a) You don’t have to insert disk and leave installation so that installer picks up required software automatically from staging area Staging Area creates five Top level directories – Start Here, APPL_TOP, RDBMS,Tools, Database
Q6. How to create staging area
A.You create staging area using adautostg.pl
Q7. If you wish to install Apps 11i/R12 using Virtual Host Name instead of actual name , Is it possible and if Yes how ?
A.Yes, This is possible by using op-servername like rapidwiz -servername <virtual_host_name>
Q8.If your installation fails for some reason , is it possible to restart installation ?
A. Yes, using option -restart like rapidwiz -restart
Q9. What is port pool ?
A. Port pool is mechanism for determining default base value of port for each service/process (web server, forms server, database..) which determines unique value for each pool. Port Pool ranges from 0-99 i.e.
for Port Pool 0 – Web Port 8000, forms port 9000, Database Port 1521 for Port Pool 1 – Web Port 8001, forms port 9001, Database Port 1522 and so on
.
Q10.What is express install ?
A. This install method assumes default values for many customizable inputs that you need to enter in case of normal install. This is useful if you wish to install apps with minimum inputs but disadvantage is that you can’t configure a lot (limited to only few configurable options). More information here
Q11.Give overview of pre installation checks you would do before Oracle Apps Installation on Unix/Linux
A.– Check all operating system packages/rpms are installed – Create operating system users and groups – Create mount point or ensure mount point are in place – Check entry in /etc/hosts file on Unix
Q12. What software you need to install Oracle Application on Windows ?
A. VC++, MKS Tool kit, GNU Make , for more information check here
If you are planning to buy book question – Cracking the Oracle Apps DBA Interview: 325 Frequently Asked Questions 
.
If you are looking for answer or would like to share interview questions with readers on this site then mail me at atul [@] onlineAppsDBA.com