Oracle Apps DBA Interview Questions – Install

Here is list of first 10 questions for Oracle Applications DBA Interview . These questions are also useful if you are preparing for Oracle Apps DBA Certification 1Z0-233 11i Install Patch and Maintain Applications

Q. Explain Single Node or Multi Node installation
Single Node
– All components of Apps 11i i.e. Database, CM, Forms, Web Server on single machine.
Multi Node – Apps 11i components on more than one Machine. 

Q. Explain single user or multi user installation ?
Single User – Both Database and Application tier are owned by Single Operating System Account 
Multi User – 11i Database Tier is owned by one O.S. User where as Application Tier is owned by different user. 

Note* In both cases Apps is installed as user ROOT 

Q. What is difference between express install or advanced install (system specific)
Express Install – Single User, Single Machine install where Apps 11i is installed on default location, Not much options during install.
Advanced Install –  Advanced install with option to define o.s. Users, Mount Points and advanced installation.

Q. What is difference between fresh database and vision database install types ?
Fresh Database –
Database is installed with Apps but with no data
Vision Database – Database installed with Apps with dummy data

Q. What are various components installed after 11.5.10 (11i) install ?
–9iAS (1.0.2.2.2) web server, Developer 6i Forms & Reports, Discoverer, Jinitiator

Q. What is O.S. level software requirement for installing Apps ?
ar, ld, make & X Display server for all unix machines (linux, solaris, IBM, HP Unix )
with following additional as per O.S.

Linux– gcc, g++, ksh
HP-Unix– cc, acc
IBM AIX – cc, linkx1C

For Windows you need
Microsoft C++, MKS Toolkit, GNU Make

Q. What is minimum approx. disk requirement for 11.5.10 (Note these disk requirement changes as per type of installation, languages installed and release )

For 11.5.10
Application Tier File System – 26 GB
Database Tier (Fresh install) – 31 GB
Database Tier (Vision install) – 65 GB

Q. What is staging area ?
Staging Area
is special directory structure where you can dump 11i installation software so that you don’t have to insert CD’s during install and these disks will automatically be picked by Installer. 

Q. How you set up staging area ?
Use adautostg.pl to create staging area orcreate required directory manually for staging like (following directories under Stage11i – startCD, oraApps, oraDB, oraiAS, oraAppsDB, oraNLS and inside these directories Disk1, Disk2…)

Q. Is it possible to install apps without staging area ?
Yes
These questions are very basic and for freshers who mention in their CV’s that they have installation experience, for advanced installation questions keep looking at this site 

 Stay tuned for some more questions on 1Z0-233 Oracle 11i Install Patch and Maintain

You can now register for email subscriptionvia link at right menu bar.

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:

4 comments
Anon says September 30, 2007

Looks good for newbies like me

Reply
mahesh says October 12, 2007

why using two users in apps?

Reply
Atul says June 21, 2008

You can use one user as well also called as single user. Usually its Two users (also called as multi user isntallation) for ownership of database (9i/10g) as one user and application tier (web/forms/report/CM) as another user

Reply
mahesh says July 1, 2008

Hi Sir,

Please can you give brief description for the differences Between
startup Upgrade in 10g and startup Migrate in 9i.

Please can you send me the all Startup/Shutdown Commands in DBA
and different Back ground Processors in 9i and 10g DBA.

Thanks,
Mahesh.S

Reply
Add Your Reply

Not found