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 double dots to keep assign variables to the current environment.

#!/bin/bash
ORACLE_SID=VIS
ORACLE_HOST=`hostname -s`
CONTEXT_NAME=${ORACLE_SID}_${ORACLE_HOST}
APPSENV="/oracle/VIS/apps/apps_st/appl/$CONTEXT_NAME.env"
if [ ! -f $APPSENV ];
then
   echo "Environment file $APPSENV is not found"
else
   . $APPSENV
fi
#for R12.0.4
TECHENV=/oracle/VIS/db/tech_st/10.2.0/$CONTEXT_NAME.env
#for R12.1.1
TECHENV=/oracle/VIS/db/tech_st/11.1.0/$CONTEXT_NAME.env
if [ ! -f $TECHENV ];
then
   echo "Environment file $TECHENV is not found"
else
   . $TECHENV
fi
for SCRIPT in $ORACLE_HOME/appsutil/scripts/$CONTEXT_NAME/*.sh
do
    BASE=`basename $SCRIPT | sed ’s/.sh//g’`
    alias $BASE="$SCRIPT"
done
IASENV="$ORA_CONFIG_HOME/10.1.3/$CONTEXT_NAME.env"
if [ ! -f $IASENV ];
then
   echo "Environment file $IASENV is not found"
else
   . $IASENV
fi
for SCRIPT in $ADMIN_SCRIPTS_HOME/*.sh
do
    BASE=`basename $SCRIPT | sed ’s/.sh//g’`
    alias $BASE="$SCRIPT"
done

This entry was written by Kent , posted on Friday May 08 2009at 09:05 am , filed under Technical and tagged , , , . Bookmark the permalink . Post a comment below or leave a trackback: Trackback URL.

Comments are closed.