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 , its worth reading customer review on Amazon.

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

About the Author Atul Kumar

Oracle ACE, Author, Speaker and Founder of K21 Technologies & K21 Academy : Specialising in Design, Implement, and Trainings.

follow me on:

Leave a Comment:

7 comments

useroracle says January 14, 2010

Hi Atul,

Can you pls forward the document regarding DUMP to Staging area creation?
I have read a lot of articles and even follow DOC where its not clear what I am trying to do and still not cleared.

I have downloaded all DUMPs from http://edelivery.oracle.com/EPD/Download/
Trying to create stage area

D:\Stage12\…..

My Source DUMP is

Rapid

D:\R12\B53824-01_1of4
D:\R12\B53824-01_2of4
D:\R12\B53824-01_3of4
D:\R12\B53824-01_4of4

(RDBMS)

D:\R12\V15667-01_1of2
D:\R12\V15667-01_2of2

(Tools)

D:\R12\V15675-01

(APPS_TOP)

D:\R12\…..

(Databases)

D:\R12\…..

First of all extract all ZIP files in above respective folders.
Utilities are installed here in C:\
C:\Windows
C:\VS2005
C:\Perl
C:\CYGWIN

I want to stage in D: drive because there is 250GB HDD space available.

Now I am going to start

C:\perl D:\R12\B53824-01_3of4\disk1\rapidwiz\adautostg.pl

…

Staging startCD .. 6944 File copied
Checking diskspace …OK.

Starging Databases …

Insert the DVD labeled Oracle Applications Rapid Install – Databases Disk 1 and
press :

Here what will be input ???
Pls let me know in details.

I have ready ORACLE DOC also but there is not in details what I am expecting.

Regards,
Raj Yadav

Atul Kumar says January 14, 2010

@ Raj,
If you are confused about staging area then don’t use this method.

If you have software as zip files then use this simple method –

Copy all zips in to one single folder
Unzip all files one at a time . This will create five folders (and sub folders) . Go to startCD or RedCD (I don’t remember name) and start installation .

Hope this helps

useroracle says January 14, 2010

Hi Atul,
Thank you very much. I did all.

Regards,
Raj

useroracle says January 14, 2010

Hi Atul,

I am not able to install Oracle Apps 12.1.1 in Windows 2007 SP-2.
Getting the following error when run the Rapidwiz.cmd “Windows cannot find ‘.\jre\NT\1.5.0\bin\java’. Make sure you typed then name correctly and then try again”.Can you pls let me know what exactly is ?

Thanks,
Raj Yadav

useroracle says January 14, 2010

Hi Atual,

I am not able to install EBS 12.1.1 in Windows 2003 SP-2.
Getting the following error when run the Rapidwiz.cmd “Windows cannot
find ‘.\jre\NT\1.5.0\bin\java’. Make sure you typed then name
correctly and then try again”.Can you pls let me know what exactly is ?

Thanks,
Raj Yadav

guest says July 25, 2010

I am getting messgae saying insert Disk 1 of RDBMS. When running adautostg.pl script to create staging area from files I downloaded from oracle web site. Any idea whey?

Raj Yadav says July 26, 2010

Hi,

Staging area is not created properly.
First create staging area and start setup.

If you are still getting problem mail to appstofusion@gmail.com
will try to assist you.

Thanks,
Raj Yadav

Add Your Reply