Practical Interview Question for Oracle Apps 11i DBA

On popular request from readers, I am posting Practical Technical Interview Questions for Oracle Applications (E-Business) 11i/R12 DBA’s.
   Interview Questions differ with your work experience (below is list of question for person with 1-3 years exp.) , person taking interview and specific to your CV .  
    If you have any real time Interview questions for Apps DBA’s which you wish to share with other Oracle DBA’s please leave it in comments sectionor mail me at ( atul @ onLineAppsDBA.com )

Q. What is difference between ICM, CRM and Standard Manager in Concurrent Manager ?

Q. Where are CM log files ?

Q. What will happen if ICM goes down ?

Q. If your output or log file from view report is not working what can be issue ?

Q. How to check if system is Autoconfig enabled ?

Q. How to check if system is rapid clone enabled ?

Q. Can c driver be applied while database is down ?

Q. What is difference between ad_bugs and ad_applied_patches ?

Q. Steps to reduce patch downtime  ?

Q. How to enable maintenance mode ?

Q. Is there way to apply patch without enabling maintenance mode ?

Q. What is significance of dbc file ?

Q. How Apps decide to use particular dbc file ?

Q. What are steps included in changing Apps Password ?

Q. How will you troubleshoot self service issue ?

Q. What all profile options you change in DMZ setup ?

Q. What are issues you encountered in last few projects ?

Q. What is maintenance mode, how to enable/disable it and how to by pass maintenance mode ?

Q. If users complain that they can’t see login page, how you will debug issue ?

Check more Oracle Apps (11i) DBA Interview Questions at http://www.teachmeoracle.com/forum/viewforum.php?f=21

Leave comments for topics which you wish to see on this site .

Share This Post with Your Friends over Social Media!

About the Author Atul Kumar

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

follow me on:

Leave a Comment:

16 comments
Md. Rizwan says December 10, 2007

Hi Atul

Good Questions, it would have been better if answer were included

Reply
Atul says December 10, 2007

Thanks Rizwan, I’ll try to answer these Qs once I find some time else in next set of questions I’ll post with answer

Reply
rajesh says April 30, 2008

hi Atul,
plz send the answers of these questions,
then it will very useful,
ok bye

Reply
rajesh says April 30, 2008

hi atul ,
plz post the answer for this question
what is APPS listener ? why it is used?
ok bye

Reply
Amit says April 30, 2008

Hi Rajesh

APPS Listner is different from Database listener. It is basically RPC listner and is used for various purpose checking log and out file for Concurrent request is one of them.

Check the 8.0.6_HOME/network/admin//listner.ora and you will be able to see entries related to FNDFS and FNDSM

Also check the file adalnctl.txt located at $COMMON_TOP/admin/log and you will see the log file of APPS listner.

Let me know if this helps

Amit

Reply
rajesh says April 30, 2008

hi amit
plz send the answers of these questions,
then it will very useful,
ok bye

Reply
rajesh says May 31, 2008

What is difference between ICM, CRM and Standard Manager in Concurrent Manager ?

Q. Where are CM log files ?

Q. What will happen if ICM goes down ?

Q. If your output or log file from view report is not working what can be issue ?

Q. How to check if system is Autoconfig enabled ?

Q. How to check if system is rapid clone enabled ?

Q. Can c driver be applied while database is down ?

Q. What is difference between ad_bugs and ad_applied_patches ?

Q. Steps to reduce patch downtime ?

Q. How to enable maintenance mode ?

Q. Is there way to apply patch without enabling maintenance mode ?

Q. What is significance of dbc file ?

Q. How Apps decide to use particular dbc file ?

Q. What are steps included in changing Apps Password ?

Q. How will you troubleshoot self service issue ?

Q. What all profile options you change in DMZ setup ?

Q. What are issues you encountered in last few projects ?

Q. What is maintenance mode, how to enable/disable it and how to by pass maintenance mode ?

Q. If users complain that they can’t see login page, how you will debug issue ?

Check more Oracle Apps (11i) DBA Interview Questions at

Reply
SubbaRao says May 31, 2008

Hi Rajesh,

can you post these questions on http://teachmeoracle.com/forum

Regards,
Subbu

Reply
lakshmikanthan says June 2, 2008

hi,
What is difference between adpatch & opatch ?where its located and check in oracle and application?

Thanks
lakshmi

Reply
lakshmikanthan says June 2, 2008

hi
What is difference between adpatch & opatch ?
where this path is located?
thanks
lakshmi

Reply
Amit says June 2, 2008

Hi Lakshmi

adpatch is the utility thru which you apply patch to Oracle application and opatch is the utility thru which you apply patch to Oracle database.

Amit

Reply
Atul says June 2, 2008

Further to Amit’s answer adpatch is located in $AD_TOP/bin on application tier (applmgr)

and opatch is under $ORACLE_HOME/OPatch on database (oracle)

Reply
Dipankar Ghosh says November 11, 2009

Further more,

1. Can I merge APPL_TOPs?
2. What is a “shared APPL_TOP”?
3. What is a “shared application tier file system”?

Reply
Amit says November 11, 2009

Hi Dipankar

-Yes you can merge APPL_TOP. That is when you reduce the number of nodes.

-Shared APPL_TOP- APPL_TOP and COMMON_TOP are shared

-Shared Application Tier files system- APPL_TOP,COMMON_TOP,iAS and 8.0.6 are shared.

Regards
Amit

Reply
Dipankar Ghosh says November 12, 2009

1. Name major/key names of configiuration files and it’s importance in Oracle Apps 11i

~ Dipankar

Reply
please send me answers for above questions says August 3, 2011

hi atul
good

Reply
Add Your Reply

[i]
[i]
[i]
[i]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[index]
[index]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]
[523.251,1046.50]