To prevent concurrent requests executing on a newly cloned environment 2 steps will be required.
1) Prevent Concurrent Managers from starting as part of the Clone
2) Change data concerning concurrent requests so they do not execute when the concurrent managers start.
To prevent Applications Services (including Concurrent Managers) from starting automatically during Rapid Clone an enhancement request has been raised to see if this can be considered an option during the clone.
Until this feature is available there is the following workaround.
1. Edit the $COMMON_TOP/clone/bin/adcfgclone.pl
2. Go to the end of the file
3. Change the following lines:-
print "\n Starting application Services for $s_dbSid:\n";print "Running:\n";print(" $s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/
TO:
print "\nNOT Starting application Services for $s_dbSid:\n";#print "Running:\n";#print(" $s_com/admin/scripts/$s_contextname/adstrtal.$ext $s_apps_user/
4. Run "perl adcfgclone.pl appsTier" as normal.
The services will not start Automatically when the clone completes allowing data to be changed safely.
There is a need to change 2 sets of concurrent requests to prevent execution
a) Terminate 'Running' Requestsb) Set Pending jobs to 'On Hold'
a) Set Terminating or Running to Completed/TerminatedUPDATE fnd_concurrent_requestsSET phase_code = 'C', status_code = 'X'WHERE status_code ='T'OR phase_code = 'R'/
b) Place Pending/(Normal/Standby) to On HoldUPDATE fnd_concurrent_requestsSET hold_flag = 'Y'WHERE phase_code = 'P'AND status_code in ('Q','I')/
Once these changes have been committed then the Application services including concurrent manager can be restarted and the concurrent jobs will not be executed.
1 comment:
oh, have you heard about the service of open mdf file restore password? it is the fastest way to open not accessible files
Post a Comment