We have moved to http://onlineAppsDBA.com kindly check http://onlineAppsDBA.comin future
| Troubleshooting Concurrent Managers |
| Monday, October 23, 2006 |
|
Lets today focus on Concurrent Manager & Issues related to concurrent Manager & how to fix them .
First of all you should be familiar with Concurrent manager concepts , if you wish to know more about CM check few links at my site http://TeachMeOracle.com
http://teachmeoracle.com/cm.html
http://teachmeoracle.com/cm02.html
In above links you can find overview of CM, How to Start/Stop CM , parameters like CONCSUB, DISPLAY, SLEEP, PMON, QUESIZ ...
At http://teachmeoracle.com/cm03.html you can find basic overview of Troubleshooting Concurrent Manager
Lets classify how to start troubleshooting CM
Issues related to startup/shutdown of CM
If you try to start CM using adcmctl.sh or adstrtall.sh script & you encounter problem in starting CM then check for log files. All information related to why Concurrent Manager not coming up is recorder in log file at $APPLCSF/$APPLLOG with default name as $SID_$DD ( where DD is date on which you started Concurrent Manager ). This Concurrent Manager naming convention will be listed in file adcmctl.sh file (Concurrent Manager startup file). If $APPLCSF is not set then you can look for this file in $FND_TOP$APPLLOG
ICM is Up but some managers are still down
As you know adcmctl.sh script starts ICM (Internal Concurrent Manager) and its duty of ICM to start other Managers. If you see ICM is up with some other managers & Issue is with only Particular Managers then look for log files of these managers .
Concurrent -> Manager -> Administer -> Select manager which is not starting -> Click on "Processes" -> Click on "Manager Log" to find out error message.
These individual manager log file, you can access under $APPLCSF/$APPLLOG directory as well.
If you error message is not enough to find out cause of problem then you can enable debug on CM log files . You can enable diagnostics by changing DIAG_PARAM="" to DIAG_PARAM="Y" in adcmctl.sh (CM Startup script file)
Other things you can try for CM startup Issues :
Try to bounce CM & see all FNDLIBR processes are cleared before restrarting CM. You can run cmclean.sql command to clear any Invalid State against any request or manager. Check for any messages in log file. Check status of Manager from administer Concurrent Manager Window.
Concurrent -> Manager -> Administer (Login as System Administrator Responsibility)
More on CM Troubleshooting ..
Commonly faced issues in CM ..
Coming Soon
If you can't figure out or if there is any problem with Single Manager or all Concurrent Manager then you can raise this question in Forum http://teachmeoracle.com/forum under Concurrent Manager Section & I'll respond immediately (You need to register just once to raise your issues in Forum)
So raise as many questions you wish in Forum dedicated to Apps DBA's at
....................... http://teachmeoracle.com/forum .......................Labels: troubleshooting |
We have moved to kindly check onLineAppsDBA.com in future
|
|
|
 del.icio.us
¦
 Digg This
¦
 My Yahoo
¦
 Reddit
¦
 BlinkList
¦
 Furl It
¦
Email This
¦
Leave Your Comments
|
posted by Atul Kumar @ 3:12 PM
  |
|
| 14 Comments: |
-
Hi ATUL ji
Here is padmaja from greater hyderabad. These days am getting trained in Oracle Apps DBA. Really your Blog is really extra Ordinary and really usefull. Iam IMPRESSED!!
-
-
Hi ATUL sir
i am srinivasa rao from Bangalore
i am so much impressed reg CM issues in ur blog. i great thnkfull
to u
-
Hi ATUL sir
i am so much impressed for this blog.
-
-
-
Hi Atul,
Could you please tell us, how to get the Concurrent manager log content while startup and shutdown
by e-mail?..
Thanks
Abitha
-
Hi Atul,
We are facing an issue which seems like DBA issue.
We have a PL/SQL Concurrent Program where we insert data in custom tables (created in other schema) and then after insertion we submit a concurrent request from package to run report using the collected data.
Now, the issue is that when we run this package as a concurrent program it takes long time to complete (1 hour). We monitor the insertion in these tables and found that it get stuck in insertion of second table and it takes long time to insert data in 2nd table. However the same insert when we run from SQL it takes 20 seconds to complete.Concurrent program takes 1 hour to complete.
Could you please explain why it is so.
It seems an issue with the Concurrent Manager.
Request you to please share your thoughts on this.
regards,
ODev
-
Hi Atul,
We are facing an issue which seems like DBA issue.
We have a PL/SQL Concurrent Program where we insert data in custom tables (created in other schema) and then after insertion we submit a concurrent request from package to run report using the collected data.
Now, the issue is that when we run this package as a concurrent program it takes long time to complete (1 hour). We monitor the insertion in these tables and found that it get stuck in insertion of second table and it takes long time to insert data in 2nd table. However the same insert when we run from SQL it takes 20 seconds to complete.Concurrent program takes 1 hour to complete.
Could you please explain why it is so.
It seems an issue with the Concurrent Manager.
Request you to please share your thoughts on this.
regards
ODev
-
Hi Atul,
I am new to your blog very informative waiting for some more updates on CM and also on other topics ...Thanks Amar
-
Hi Atual,
I am new to your blog very informative ....expecting some more on CM Issues and also on other topics.
Thanks&Regards,
Amarnath
-
Hi Atul,
I am new to your blog very informative waiting for some more updates on CM and also on other topics ...Thanks Amar
-
Hi Athul
How are you.
Actually, i need to deactivate the Specify concurrent manager through backend.is it possible to done?
Regards
Sasikumar S
9943047774
-
Hi Atul,
I have some quesions. Please do reply it, I am waiting for you reply.
1> what is the significance of administrative server in oracle apps.
2> Please provide some scenario related with concurrent program performance related issue and the resolution.
Thanks,
Vivek
|
| |
| << Home |
| |
|
|
Hi ATUL ji
Here is padmaja from greater hyderabad. These days am getting trained in Oracle Apps DBA. Really your Blog is really extra Ordinary and really usefull. Iam IMPRESSED!!