Shell Programming and Scripting

1. -rwxrwxrwx   1 oracle     oinstall      3318 Aug 17 19:00 step1.sh

2. >step1.sh <parameters>

3. ======================================================
#!usr/bin/ksh
#set -x
################################################################################
# Script to extract Package Body, Function and Procedure source from Database and to create ORA file for each object.
# 
#################################################################################

# Set the variables to be used

# Specify the location where the wrap folder is created
wrappath=/acc/NATDUB11/wrapping
binPath=/usr/bin
logDir=${wrappath}/logs
objectDir=${wrappath}/objects
utilityDir=${wrappath}/utility
plbDir=${wrappath}/plb
listSQLFile=${utilityDir}/listFCUBS.sql
extractSQLFile=${utilityDir}/extractFCUBS.sql

listFile=${logDir}/filelistFCUBS.txt
extractlogFile=${logDir}/extractFCUBS.log

${binPath}/rm -f ${listFile} ${extractlogFile}
echo "Existing files removal done" >>${extractlogFile}

echo "##################STEP1 starts for ${2}##################"
echo "##################STEP1 starts for ${2}##################" >>${extractlogFile}

echo "Variables set"  >>${extractlogFile}

# Set Oracle Home
ORACLE_HOME=/ora9i/app/oracle/product/9.2.0.1.0
export ORACLE_HOME
errVal=1
successVal=0

# Preliminary checks
if [ $# -ne 2 ]
then
    ${binPath}/echo "Error: Incorrect Number of Parameters" >&2
    ${binPath}/echo "USAGE: $0 <dbusername>/<dbpassword>@<db schemaname> < dbusername >" >&2
    echo "Error: Incorrect Number of Parameters" >>${extractlogFile}
    exit ${errVal}
fi

if test ! -s ${listSQLFile} 
then
    ${binPath}/echo "Error: Cannot find List SQL file - ${listSQLFile}" >&2
    echo "Error: Cannot find List SQL file - ${listSQLFile}" >>${extractlogFile}
    exit ${errVal}
fi

if test ! -s ${extractSQLFile}
then
    ${binPath}/echo "Error: Cannot find Extract SQL file - ${extractSQLFile}" >&2
    echo "Error: Cannot find Extract SQL file - ${extractSQLFile}" >>${extractlogFile}
    exit ${errVal}
fi

echo "Preliminary checks done"
echo "Preliminary checks done" >>${extractlogFile}

# Fetch the list of objects
${ORACLE_HOME}/bin/sqlplus -l -s ${1} @${listSQLFile} ${2}>${listFile};<<EOF
exit;
EOF

echo "Fetched object names and type details, ${listFile} created"
echo "Fetched object names and type details, ${listFile} created" >>${extractlogFile}


# Fetch the object source and create the respective file for each object
echo "Extracting sources..."
while read inputlistfile
do
    ObjectName="$(${binPath}/echo $inputlistfile | ${binPath}/cut -f1 -d',')"
    ObjectType="$(${binPath}/echo $inputlistfile | ${binPath}/cut -f2 -d',')"
    #echo ${ObjectName} '~~~' ${ObjectType}
    echo "Extacting source for ${ObjectName} ${ObjectType}">>${extractlogFile}
    ${ORACLE_HOME}/bin/sqlplus -l -s ${1} @${extractSQLFile} ${2} ${ObjectName} "${ObjectType}">>${extractlogFile};
    #exit;
done <${listFile}
echo "Source extraction done"
echo "Source extraction of the objects done into ${objectDir} as LST files" >>${extractlogFile}

# Rename the lst file as ora file in the objects directory
cd ${objectDir}
for f in *.lst ; 
do
    mv $f `basename $f lst`ora; 
done

echo "ORA Files created in " ${objectDir}
echo "Files renamed as ORA files in "${objectDir} >>${extractlogFile}

cd ${utilityDir}

echo "Extraction Done"
echo "Extraction Done" >>${extractlogFile}

echo "##################STEP1 ends for ${2}##################"
echo "##################STEP1 ends for ${2}##################" >>${extractlogFile}
======================================================

Thanks