| Script to completely shutdown the concurrent manager [message #331709]
||Fri, 04 July 2008 14:41
Registered: July 2008
Use this script to shutdown the concurrent manager completely. It will wait till all processes die.|
# 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
while [ "$RETURN_VALUE" != "0" ]; do
sqlplus -silent $DB_USER/$DB_PSWD << _EOF_
select concurrent_queue_name, running_processes
where running_processes > 0;
egrep --silent "no rows selected" $SPOOL_FILE
if [ $RETURN_VALUE -ne 0 ]; then
echo "Concurrent manager processes are still active. Sleeping for 10 seconds..."
echo "** Concurrent Manager and its processes are stopped **"
-- Praveen Gattu