R12 – OEL Login Script
Use this script (vis.sh) to initialise the Oracle environment.
I recommend you to start with this article to get R12 up and running.
Run as Oracle user:
$ . ./vis.sh
Note the dot and space in front of a script to assign variables to the current environment.
#!/bin/bash shopt -s expand_aliases ORACLE_SID=VIS ORACLE_HOST=`hostname -s` CONTEXT_NAME=${ORACLE_SID}_${ORACLE_HOST} TECH_HOME=/oracle/${ORACLE_SID}/db/tech_st/11.1.0 APPS_HOME=/oracle/${ORACLE_SID}/apps/apps_st/appl alias techenv=’. ${TECH_HOME}/$CONTEXT_NAME.env’ alias appsenv=’. ${APPS_HOME}/$CONTEXT_NAME.env’ APPSENV=”$APPS_HOME/$CONTEXT_NAME.env” if [ ! -f $APPSENV ]; then echo “Environment file $APPSENV is not found” exit else . $APPSENV fi for SCRIPT in $ADMIN_SCRIPTS_HOME/*.sh do BASE=`basename $SCRIPT | sed ‘s/.sh//g’` alias $BASE=”$SCRIPT” done TECHENV=”$TECH_HOME/$CONTEXT_NAME.env” if [ ! -f $TECHENV ]; then echo “Environment file $TECHENV is not found” exit else . $TECHENV fi for SCRIPT in $TECH_HOME/appsutil/scripts/$CONTEXT_NAME/*.sh do BASE=`basename $SCRIPT | sed ‘s/.sh//g’` alias $BASE=”$SCRIPT” done |