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
This entry was written by Kent Willumsen , posted on Friday May 08 2009at 09:05 am , filed under R12 Installation, Technical Knowledge and tagged , , , . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Comments are closed.