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 <