 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
