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 [...]

R12 – Managing

This article applies to:
EBS 12.0.4 on OEL5.3
EBS 12.1.1 on OEL5.4
RDBMS 10g on OEL5.3
RDBMS 11g on OEL5.3 and OEL5.4
I recommend you to start with this article to get R12 up and running.
Login
This is my own login script which you can see here.
Login to OEL as Oracle and run login script:
$ . ./vis.sh
Ensure you also got the [...]