#!/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