Oracle Apps environment setup script



SCRIPT 1
********
Fndsetup


#!/bin/ksh
#
#
# Description: FND setup script
# This script should be run by all users to provide
# access to the various Oracle Applications
# environments located on the machine.
#
# Location: <oracle $HOME>/local
# Set permissions to 755
#
# Modifications:
#
alias OAPROD=". /u02/app/applmgr/script/OAPROD"
alias OAPRODNCA=". /u03/app/appsnca/script/OAPRODNCA"
echo " "
echo " "
echo "Type OAPROD to setup Oracle Applications Rel. 10.7"
echo "Type OAPRODNCA to setup Oracle Applications Rel. 10.7 NCA"
echo " "
# echo "OAPROD and OAPRODNCA are temporarily unavailable due to upgrade."
echo " "


SCRIPT 2
********
OAPROD
#!/bin/ksh
#
#
# Description: Oracle Applications environment setup script
#
# Location: <applmgr $HOME>/script
# Set permissions to 755
#
# Modifications:
#
#
# Applications specific environment setup
PATH=${PATH}:/u02/app/applmgr/script; export PATH
#
# PostScript printing
# LPDEST=hp5it;export LPDEST
# PRINTER=hp5it;export PRINTER
#
# Setup up Ghostscript variables
# PATH=${PATH}:/opt/AEgs/bin; export PATH
# GS_FONTPATH=/usr/openwin/lib/X11/fonts/Type1/outline:/opt/AEgs/share/fonts; export
GS_FONTPATH
#
GS_LIB=/usr/openwin/lib/X11/fonts/Type1:/usr/openwin/lib/X11/fonts/Type3:/opt/AEgs/s
hare/fonts; export GS_LIB
#
# Setup COBOL variables
# PATH=${PATH}:/opt/cobol/bin; export PATH
#
echo " "
echo "*** Connecting to Database <SID>"
echo " "
. /u01/app/oracle/local/orasetup <SID>

# Concurrent Managers should run with dedicated SQL*Net connections
# TWO_TASK=oaprd_ded; export TWO_TASK
#
echo " "
echo "*** Connecting to Oracle Applications <OA env> Database"
echo " "
. /u02/app/applmgr/r10/APPLSYS.env
echo " "
echo "*** Connecting to Custom Applications"
echo " "
. /u02/app/applmgr/ext/APPLEXT.env
echo " "
echo "Type found to invoke Oracle Applications <OA env> Database"
#echo "Oracle Applications is temporarily unavailable"
echo " "

SCRIPT 3
********
OAPRODNCA
#!/bin/ksh
#
#
# Description: Oracle Applications NCA environment setup script
#
# Location: <appsnca $HOME>/script
# Set permissions to 755
#
# Modifications:
#
#
echo " "
echo "*** Connecting to Database OADEV"
echo " "
. /u01/app/oracle/local/orasetup oadev
#
echo " "
echo "*** Connecting to Oracle Applications Rel. 10.7"
echo " "
. /u03/app/appsnca/r10/APPLSYS.env
#
echo " "
echo "*** Connecting to Custom Applications"
echo " "
. /u03/app/appsnca/ext/APPLNCA.env

SCRIPT 4
********
APPLEXT.env

#!/bin/ksh
#
#
# Description: Script to set the custom application
# environment variables. Called by the
# environment setup script (e.g. OADEV).
#
# Location: <applmgr $HOME>/<EXT>
# Set permissions to 755
#
# Modifications:
#
#
APPL_EXT_TOP=/applmgr/ext
export APPL_EXT_TOP
APEX_TOP="$APPL_EXT_TOP/apex"
export APEX_TOP
AREX_TOP="$APPL_EXT_TOP/arex"
export AREX_TOP
#
# Create custom function variable
#
EXT_FUNCTIONS="$APPL_EXT_TOP/functions"
export EXT_FUNCTIONS
#
# Invoke the custom env files
#
#. $APEX_TOP/APEXENV
#. $AREX_TOP/arexenv


SCRIPT 5
********
APPLNCA.env

#!/bin/ksh
#
#
# Description: Script to set the custom NCA application environment
# variables. Called by the environment setup script
# (e.g. OADEV).
#
# Location: <appsnca $HOME>/<EXT>
# Set permissions to 755
#
# Modifications:
#
#
APPL_EXT_TOP=/applmgr1/ext
export APPL_EXT_TOP
APEX_TOP="$APPL_EXT_TOP/apex"
export APEX_TOP
AREX_TOP="$APPL_EXT_TOP/arex"
export AREX_TOP
#
# Add custom forms to FORMS45_PATH
#
FORMS45_PATH="$FORMS45_PATH:$APPL_EXT_TOP/forms:$APPL_EXT_TOP/resource"
export FORMS45_PATH