Friday, February 26, 2016

oracle Apps DB env file

#!/bin/ksh

export ORACLE_VERSION=11.2.0.4
export ORACLE_BASE=/apps/oracle

export ORACLE_DATABASE=ORACLE_SID
export ORACLE_SID=ORACLE_SID

export ORACLE_HOME=$ORACLE_BASE/product/SID/db11g/11.2.0.4

export ORACLE_ADMIN=/apps/oracle/admin
export ORACLE_PROFILES=/apps/oracle/local/profiles
export ORACLE_BIN=/apps/oracle/local/bin

export ORACLE_DOC=${ORACLE_HOME}/odoc
export ORACLE_TERM=vt220

export ORA_NLS10=$ORACLE_HOME/nls/data/9idata
export PATH=$ORACLE_HOME/jdk/bin:$ORACLE_HOME/appsutil/jre/bin:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/usr/NX/bin:/sbin/:.:$ORACLE_HOME/bin:$ORACLE_HOME/OPatch:$ORACLE_PROFILES:$ORACLE_BIN:

export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/usr/lib:/lib
export LIBPATH=$ORACLE_HOME/lib:/usr/lib:/lib
export SHLIB_PATH=$ORACLE_HOME/lib

unset ORA_NLS32
unset TWO_TASK
unset ORA_NLS33

export PFILE=${ORACLE_ADMIN}/${ORACLE_DATABASE}/pfile/init${ORACLE_SID}.ora

export TNS_ADMIN=/apps/PROPERTY/local/network/admin/${ORACLE_SID}_L

echo; env | sort | egrep 'ORA|PFI|TNS'; echo;

No comments: