Practical Interview Question for Oracle Apps 11i DBA

Hi Atul

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

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

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

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

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

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

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

Hi Rajesh,

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

Regards,
Subbu

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

Thanks
lakshmi

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

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

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)

Further more,

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

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

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

~ Dipankar

hi atul
good