Oracle Apps 11i DBA Interview Questions

Google
 
Web teachmeoracle.com
Home Overview Architecture Installation Patching Training Feedback
 
My Blog
WebServer
Concurrent
Autoconfig
Cloning
Training
Apps Interview Q's
Tuning
Contact Us
 
 
My Favourites
Health Check 11i
11i Interview Q's
 
 
    If you want to submit any technical questions for oracle apps 11i which might be helpful for other's to understand applications Mail Me.     Q. 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.

another scenario is when your requests are very critical and you want high resilience for your Concurrent Processing Node , you can configure PCP. So if node1 goes down you still have CM node available processing your requests.
 
Q. Output & 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 & where to check ?

Log , Output file path & location is stored in table FND_CONCURRENT_REQUESTS. Check
select logfile_name, logfile_node_name, outfile_name, outfile_node_name from fnd_concurrent_requests where request_id=&requestid ;
where requestid is id of request for which you are not able to see log or out files. You should see output like
/u01/PRODBOX/log/l123456.req, host1,/u01/PRODBOX/out/o123456.out, host1

Update it according to your cloned Instance Variables.
 

    Best of luck for your interview. If you are not happy with quality of questions or want to submit Oracle 11i Apps Interview questions Mail Me.

To check more questions Click Next.

  
Previous Page Next Page
 

Oracle Apps 11i | Oracle Portal | Collaboration Suite | My Blog
Copyright © teachmeoracle.com
This work is copyright protected, Copying content from this site is illegal