Oracle Apps (E-Business Suite) DBA Interview Questions

Q. How you will troubleshoot if concurrent request is taking long time ?

Q. If you are applying a patch.It was started successfully. In the middle you realise nothing happening and no update in patch log file,worker log file (No updates & no error message). What to do & How to troubleshoot ?

Q. Why there are three ORACLE_HOMEs in 11i or R12 ?

Q.What is difference between shared appltop and staged appltop ?

Q. what are the request incompatibilities ? how conflict resolution manager solve them?

Q.Where and how you update workflow notification mailer configuration setting ? (This depends on which workflow mailer you are running C Mailer or Java Mailer )

Q. If you want to change Concurrent Manager log and out file location , Is it possible ? If Yes, How ? If No, why not ?

Q. What are conflict resolution managers in CM ?

Q. What are interoperability patches ?

Q. How frequent you run Gather Schema Statistics program & with what option ? Why you need to run it ? What is cost based optimizer ?

Q. Name few common issues you encountered recently related to Web Server, Forms Server, Concurrent Manager (CM), Jinitiator, Database, Cloning, Patching .

Q. What all things you will check after cloning and before handing over instance to end users ?

Q. If users complain that reports are not running, what you will do to troubleshoot ?

Q. What is Rep-300 toolkit error ? Did you ever encounter this ?

Q. Share configuration/setup you have done w.r.t. Apps (expect some questions on that setup) ?