Install SQLT Script


#!/bin/ksh
#
#   Script to install SQLT
#
# -- usage: /oracle/admin/scripts/install_sqlt.ksh <DBNAME>
#
####################################################################################

DBNAME=$1
APP_ID=$2


log=/oracle/admin/scripts/install_sqlt_$DBNAME.log
mkdir -p /ora01/SQLT/$DBNAME
cp /oracle/admin/scripts/sqlt.zip  /ora01/SQLT/$DBNAME

cd /ora01/SQLT/$DBNAME
unzip sqlt.zip
cd /ora01/SQLT/$DBNAME/sqlt/install

sqlplus -s "/ as sysdba" <<EOF
@sqdrop.sql
exit
EOF

sqlplus -s "/ as sysdba" <<EOF
@sqcinternal.sql
exit
EOF


exit