To get shell script to Download the ldts for more than one concurrent program having same name but different Applications。
#!/bin/sh
SRCDIR=`pwd`
ORASID=`echo ${TWO_TASK:0:6} | tr '[A-Z]' '[a-z]'`
LOGDIR=${SRCDIR}
DATE=`date +%Y%m%d`
TIME=`date +%H%M%S`
FILE=${LOGDIR}/XX_GENERATE_LDT_INSTALL_${DATE}${TIME}.log
TEE="tee -a ${FILE}"
if [ ! -d ${LOGDIR} ] ; then
echo "Unable to locate ${LOGDIR}"
exit 1
fi
# +=================================================================================+
# | VALIDATE LOGIN ID AND PASSWORD
# +=================================================================================+
CHKLOGIN(){
if sqlplus -s /nolog </dev/null 2>&1
WHENEVER SQLERROR EXIT 1;
CONNECT $1 ;
EXIT;
!
then
echo OK
else
echo NOK
fi
}
# +=================================================================================+
# | GET APPS LOGIN ID AND PASSWORD
# +=================================================================================+
while [ "${APPSID}" = "" -o `CHKLOGIN "${APPSID}"` = "NOK" ]
do
echo "Enter APPS Userid/Passwd: "
read APPSID
done
APPS_SCHEMA_NAME=`echo ${APPSID} | awk -F"/" '{print $1}'`
APPS_USER=`echo $APPSID|cut -d '/' -f1`
APPS_PASSWD=`echo $APPSID|cut -d '/' -f2`
# +=================================================================================+
# | GET APPS DBHOST and DBPORT
# +=================================================================================+
while [ "${DBHOST}" = "" ]
do
echo "Enter APPS DB Host Name: "
read DBHOST
done
while [ "${DBPORT}" = "" ]
do
echo "Enter APPS DB Port: "
read DBPORT
done
# +=================================================================================+
# | GET CONCURRENT PROGRAM NAME
# +=================================================================================+
while [ "${CONPROGRNAME}" = "" ]
do
echo "Enter Concurrent Program Name: "
read CONPROGRNAME
echo "Entered Concurrent Program Name: ${CONPROGRNAME}"
done
# +=================================================================================+
# | GENERATE LDT FOR CONCURRENT PROGRAM
# +=================================================================================+
GENLDT(){
RESULT=`sqlplus -s <