| |||||
|
Oracle DBA Interview questions and Answers Part: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 (Continued from previous part...) There are lot of DBC file under $FND_SECURE, How its determined that which dbc file to use from $FND_SECURE ? This value is determined from profile option "Applications Database ID" What is RRA/FNDFS ? Report Review Agent(RRA) also referred by executable FNDFS is default text viewer in Oracle Applications 11i for viewing output files and log files. As most of apps dba's are not clear about Report Server and RRA, I'll discuss one on my blog and update link here . What is PCP is Oracle Applications 11i ? PCP is acronym for Parallel Concurrurent processing. Usually you have one Concurrent Manager executing your requests but if you can configure Concurrent Manager running on two machines (Yes you need to do some additional steps in order to configure Parallel Concurrent Processing) . So for some of your requests primary CM Node is on machine1 and secondary CM node on machine2 and for some requests primary CM is on machine2 and secondary CM on machine1. Why I need two Concurrent Processing Nodes or in what scenarios PCP is Used ?
Well If you are running GL Month end reports or taxation reports annually these reposrts might take couple of days. Some of these requests are very resource intensive so you can have one node running long running , resource intensive requests while other processing your day to day short running requets.
Output and Logfiles for requests executed on source Instance not working on cloned Instance
Here is exact problem description - You cloned an Oracle Apps Instance from PRODBOX to another box with Instance name say CLONEBOX on 1st of August. You can any CM logs/output files after 1st of August only becuase these all are generated on CLONEBOX itself, But unable to view the logs/output files which are prior to 1st August. What will you do and where to check ?
How to confirm if Report Server is Up and Running ?
Report Server is started by executable rwmts60 on concurrent manager Node and this file is under $ORACLE_HOME/bin .execute command on your server like What is difference between ICM, Standard Managers and CRM in Concurrent Manager ?
# ICM stand for Internal Concurrent Manager, which controls other managers. If it finds other managers down , it checks and try to restart them. You can say it as administrator to other concurrent managers. It has other tasks as well. (Continued on next part...)
|
||||