Home » Applications » Oracle Fusion Apps & E-Business Suite » Script to completely shutdown the concurrent manager (Oracle E-Business Suite 11i (Did not test with 12 yet))
icon1.gif  Script to completely shutdown the concurrent manager [message #331709] Fri, 04 July 2008 14:41
pgattu
Messages: 1
Registered: July 2008
Junior Member
Use this script to shutdown the concurrent manager completely. It will wait till all processes die.

#!/bin/sh
# Author: Praveen Gattu
# Created: June 2007

# Figure out how you want to pass the variables DB_USER (username
# for APPS schema) and DB_PSWD (password for APPS). You can
# hardcode in this script (not recommended), prompt the user
# to enter them, etc.

# stop the concurrent manager
$SCRIPTS_TOP/adcmctl.sh stop $DB_USER/$DB_PSWD

# check if the processes are alive
SPOOL_FILE="$APPLTMP/stop_cm_$TWO_TASK.tmp"
while [ "$RETURN_VALUE" != "0" ]; do
sqlplus -silent $DB_USER/$DB_PSWD << _EOF_
spool $SPOOL_FILE
select concurrent_queue_name, running_processes
from fnd_concurrent_queues
where running_processes > 0;
spool off
_EOF_

egrep --silent "no rows selected" $SPOOL_FILE
RETURN_VALUE=$?

if [ $RETURN_VALUE -ne 0 ]; then
echo "Concurrent manager processes are still active. Sleeping for 10 seconds..."
sleep 10
fi
done

rm $SPOOL_FILE
echo "** Concurrent Manager and its processes are stopped **"


-- Praveen Gattu
(303) 880-7455
pgattu[at]gmail.com
Previous Topic: Putaway Rule in WMS
Next Topic: Transaction links to GL
Goto Forum:
  


Current Time: Wed Dec 07 05:07:27 CST 2016

Total time taken to generate the page: 0.05272 seconds