home *** CD-ROM | disk | FTP | other *** search
- :
- #
- # $Header: forms30.in.pp,v 6.31 90/04/18 11:58:48 atam Exp $ forms.in.pp
- #
-
- #
- # forms30.install
- #
- # This is the installation script to install SQL*Forms 3.0 on a
- # UNIX ORACLE system.
- #
- # It can be invoked by the master installation script, oracle.install,
- # or as a stand alone procedure.
- #
- # The master script, oracle.install, sets ORACLE_HOME and
- # ORACLE_SID before it runs this script.
- # If the script is run stand-alone, then these variables must be set and
- # exported before it is run.
- #
- # Default answers are shown in square brackets.
- #
-
- NETLIBNAME="nsl_s"
- PHYS_BLK_SIZE=2048
- VNDR_NETLIBS="-lnsl_s "
- CHOWN=/bin/chown
- MAKE=make
- ORACLE_LPPROG="/usr/bin/lp"
- ORACLE_PAGER="/usr/bin/more"
- ORACLE_LPSTAT="/usr/bin/lpstat"
-
- #
- # Initialize variables used in installation script.
- #
- PRODUCT=FORMS30
- product=forms30
- MKTG_NAME=SQL*Forms30
-
- #
- # Setup the environment variables for the installation script.
- #
- . $ORACLE_HOME/install/setup.ins
- #
- # Check to make sure that Oracle Tool Kit has been installed
- #
- if [ ! -f $ORACLE_HOME/orakit/install/.orakit ] ; then
- echo "
- Error installing $MKTG_NAME. Please install Ora*Kit
- and repeat $MKTG_NAME installation.
- " | tee -a $LOG
- exit 1
- fi
-
- #
- # Set correct protections for resource files
- #
- chmod 644 $ORACLE_HOME/${product}/admin/resource/*.r >> $LOG 2>&1
-
- #
- # Link sqlforms (in the lib directory) and put it into the bin directory.
- #
- cd $ORACLE_HOME/${product}/lib
- if [ "$LINK_PRODUCT" = "T" ] ; then
- echo ""
- echo $N "Would you like to relink $MKTG_NAME with PL/SQL? $C"
- DEFLT="Y" ;. $INSTALL_HOME/read.sh; ANS=$RDVAR
- case "$ANS" in
- n|N) LINK_PLS=F ;;
- q|Q) echo "User requested abort." ; sync ; exit 0 ;;
- *) LINK_PLS=T ;;
- esac
- echo ""
- echo ""
- echo $N "Would you like to relink $MKTG_NAME with SQL*Menu50? $C"
- DEFLT="N" ;. $INSTALL_HOME/read.sh; ANS=$RDVAR
- case "$ANS" in
- y|Y) LINK_MENU=T ;;
- q|Q) echo "User requested abort." ; sync ; exit 0 ;;
- *) LINK_MENU=F ;;
- esac
- echo ""
- echo ""
- echo "Linking and installing $MKTG_NAME executables..." | tee -a $LOG
- echo ""
- if [ "$LINK_PLS" = "T" ] ; then
- if [ "$LINK_MENU" = "F" ] ; then
-
- $MAKE -f sqlforms30.mk ORACLE_HOME=$ORACLE_HOME install \
- >> $LOG 2>&1
-
- else
- $MAKE -f sqlforms30.mk ORACLE_HOME=$ORACLE_HOME insmenu \
- >> $LOG 2>&1
- fi
- else
- if [ "$LINK_MENU" = "F" ] ; then
-
- $MAKE -f sqlforms30.mk ORACLE_HOME=$ORACLE_HOME PSFSPR= SCMSTR= \
- IFPLUT= NFPDMY=\$\(NFPDMY2\) NMPDMY=\$\(NMPDMY2\) install \
- >> $LOG 2>&1
-
- else
- $MAKE -f sqlforms30.mk ORACLE_HOME=$ORACLE_HOME PSFSPR= SCMSTR= \
- IFPLUT= NFPDMY=\$\(NFPDMY2\) NMPDMY=\$\(NMPDMY2\) insmenu \
- >> $LOG 2>&1
- fi
- fi
- if [ $? != 0 ] ; then
- echo "
- Relinking Error.
- The executables for $MKTG_NAME were not made successfully.
- Please check the log file, and repeat the installation
- procedure for $MKTG_NAME.
- " | tee -a $LOG
- fi
- else
- echo ""
- echo "Creating $MKTG_NAME command synonyms..." | tee -a $LOG
- echo ""
-
- $MAKE -f sqlforms30.mk ORACLE_HOME=$ORACLE_HOME link >> $LOG 2>&1
-
- if [ $? != 0 ] ; then
- echo "
- Relinking Error.
- The executables for $MKTG_NAME were not linked successfully.
- Please check the log file, and repeat the installation
- procedure for $MKTG_NAME.
- " | tee -a $LOG
- fi
- fi
-
- case $SUPER_USER in
- TRUE) cd $ORACLE_HOME/bin
- $CHOWN $ORACLE_OWNER sqlforms30 design30 runform30 \
- generate30 convert30 iad30 iap30 iag30 iac30;;
- esac
-
- # Go back to forms30 directory
- cd $ORACLE_HOME/${product}
-
- if [ "$UPDATE" != "Y" ] ; then
- #
- # Load any required tables/views into the data dictionary.
- #
- echo ""
- echo "Loading $MKTG_NAME tables..." | tee -a $LOG
- echo "iadtables.sql, iadindexes.sql, iadviews.sql, iadgrants.sql."| tee -a $LOG
- echo ""
- sqldba <<! >> $LOG 2>&1
- connect $SYSTEM_PASS
- @./admin/iadtable.sql
- @./admin/iadindex.sql
- @./admin/iadview.sql
- @./admin/iadgrant.sql
- !
- #
- # Load demo tables.
- #
- echo ""
- echo "Loading $MKTG_NAME SCOTT/TIGER demonstration tables..." | tee -a $LOG
- echo ""
- sqlplus scott/tiger <<!>> $LOG 2>&1
- start ./demo/demobld.sql
- exit
- !
-
- case $SUPER_USER in
- TRUE) $CHOWN $ORACLE_OWNER $ORACLE_HOME/iad*.lis >/dev/null 2>&1 ;;
- esac
- fi
-
- #
- # Need to set environment variable ORAKITPATH for SQL*Forms 3.0
- #
- echo ""
- echo "Adding ORAKITPATH definitions to .profile and .login files..." | tee -a $LOG
- echo ""
- if grep 'ORAKITPATH=' $ORACLE_HOME/.profile > /dev/null 2>&1 ; then
- if [ "`grep 'ORAKITPATH=.*forms30/admin/resource' $ORACLE_HOME/.profile \
- 2>/dev/null`" = "" ] ; then
- sed -e \
- '/ORAKITPATH=/s/$/:$ORACLE_HOME\/forms30\/admin\/resource/' \
- $ORACLE_HOME/.profile > /tmp/.profile$$
- mv /tmp/.profile$$ $ORACLE_HOME/.profile
- fi
- else
- echo 'ORAKITPATH=.:$ORACLE_HOME/forms30/admin/resource
- export ORAKITPATH' >> $ORACLE_HOME/.profile
- fi
-
- if grep 'ORAKITPATH' $ORACLE_HOME/.login > /dev/null 2>&1 ; then
- if [ "`grep 'ORAKITPATH.*forms30/admin/resource' $ORACLE_HOME/.login \
- 2>/dev/null`" = "" ] ; then
- sed -e \
- '/ORAKITPATH/s/$/:$ORACLE_HOME\/forms30\/admin\/resource/' \
- $ORACLE_HOME/.login > /tmp/.login$$
- mv /tmp/.login$$ $ORACLE_HOME/.login
- fi
- else
- echo 'setenv ORAKITPATH .:$ORACLE_HOME/forms30/admin/resource' >> $ORACLE_HOME/.login
- fi
-
- #
- # "install" user utilities
- #
-
- chmod 751 crscript genxtb 2>/dev/null
-
- #
- # Create version of iapxtb.c with sample user exits.
- #
- echo ""
- echo "Creating sample user exits..." | tee -a $LOG
- echo ""
- genxtb scott/tiger >> $LOG 2>&1
- sqldba <<! >> $LOG 2>&1
- connect scott/tiger
- @./lib/genxtb
- exit
- !
- genxtb scott/tiger ./lib/iapxtb.c >> $LOG 2>&1
- case $SUPER_USER in
- TRUE) $CHOWN $ORACLE_OWNER ./lib/iapxtb.c >/dev/null 2>&1 ;;
- esac
-
- #
- # Use "touch" to time stamp hidden file, for future verification of
- # product installation.
- touch "$ORACLE_HOME/$product/install/.$product" 2> /dev/null
-
- #
- # Hook for verification scripts -- this must happen last
- #
- case $ORACLE_VERIFY in
- T) if [ -f $ORACLE_HOME/$product/install/forms3.verify ] ; then
- chmod 755 $ORACLE_HOME/$product/install/forms3.verify
- $ORACLE_HOME/$product/install/forms3.verify
- fi ;;
- esac
-
- #
- # Do any cleanup and exit this script.
- #
- echo ""
- case $UPDATE in
- Y) echo "$MKTG_NAME update completed." | tee -a $LOG ;;
- *) echo "$MKTG_NAME installation completed." | tee -a $LOG ;;
- esac
- echo ""
- sync;sync;sync
- exit 0
-