Re: Regarding CMCLEAN.sql

  • From: "Tipton, Josh" <Josh.Tipton@xxxxxxxxxxxxxx>
  • To: ora-apps-dba@xxxxxxxxxxxxx
  • Date: Tue, 28 Aug 2007 08:58:32 -0500

Make sure all scheduled concurrent tasks are terminated before you stop the 
managers. That was my problem when I did the migration. 

----- Original Message -----
From: ora-apps-dba-bounce@xxxxxxxxxxxxx <ora-apps-dba-bounce@xxxxxxxxxxxxx>
To: ora-apps-dba@xxxxxxxxxxxxx <ora-apps-dba@xxxxxxxxxxxxx>
Sent: Tue Aug 28 02:07:13 2007
Subject: Re: Regarding CMCLEAN.sql

Hi Kumar,
 
Check the Node Name is exist in OAM..


 
On 8/27/07, kumar 123 <kumar_a_z@xxxxxxxxx> wrote: 


        Hi Apps DBA's,
        
            I have a query regarding cmclean.sql.
        Yesterday there were one hardware level migration happened for Middle 
tier(EBSO).After that i stared the concurrent manager,once started i found that 
under concurrent--->Administer form ,that standard manager the process were not 
equal i.e actual is showing 15 and target is showing 16,so i stopped the 
concurrent manager then ran cmclean.sql and then started the concurrent manager 
.
        
        i found everything was running smoothly,then i released it to 
customer.Again after some time i got a callback stating that all running and 
scheduled jobs got terminated.So what i did is that ,restored 
fnd_concurrent_request table(I took that table's backup before running cmclean) 
.Now it was fine. 
        
        fortunately this happened in test instance.
        
        I need ur help on this ,because i have prod migration next week for 
this same customer.Please tell me exactly what will happen if we run cmclean(I 
tried in lot of sites and metalink,but there were no exact answer ,so i m not 
able to understand it,even if i lookinto  that script). 
        
        
        
        Regards,
        Kumar
        
        




-- 


Thanks & Regards
Venkatesh K
+91 9966441136 

******************************************************************************
This email contains confidential and proprietary information and is not to be 
used 
or disclosed to anyone other than the named recipient of this email, 
and is to be used only for the intended purpose of this communication.
******************************************************************************

Other related posts: