/etc/proflie:
# Set the LD_ASSUME_KERNEL environment variable only for RHEL AS 4
export LD_ASSUME_KERNEL=2.4.19 # for RHEL AS 4
# Oracle Environment
export ORACLE_BASE=/oracle
export ORACLE_HOME=/oracle/ora920
export ORACLE_TERM=xterm
# export TNS_ADMIN= Set if sqlnet.ora, tnsnames.ora, etc. are not in $ORACLE_HOME/network/admin
export NLS_LANG=AMERICAN
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
# Set shell search paths
#export PATH=$PATH:$ORACLE_HOME/bin
PATH=$ORACLE_HOME/bin:$PATH
echo "Welcome to login XXX"
echo "Choose Oracle Database :"
echo " "
echo "(1)Oracle 9i"
echo "(2)Oracle 10g"
echo " "
read choose
case $choose in
1) ORACLE_SID=xxx; export ORACLE_SID
export NLS_LANG=American_America.ZHT16BIG5
;;
2) ORACLE_SID=xxx; export ORACLE_SID
export NLS_LANG=American_America.ZHT16BIG5
export ORACLE_HOME=/oracle/ora10g
export PATH=/oracle/ora10g/bin:$PATH
;;
*) echo "You got wrong choose"
sleep 3
exit
;;
esac
umask 0022
hostname=`hostname`
export hostname
PS1='$hostname[$LOGNAME][$ORACLE_SID]:$PWD:>'
export PS1
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
Oracle .bash_profile:
# User specific environment and startup programs
# Set the LD_ASSUME_KERNEL environment variable only for RHEL AS 4
export LD_ASSUME_KERNEL=2.4.19 # for RHEL AS 4
# Oracle Environment
export NLS_LANG=AMERICAN;
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/local/lib
export LD_LIBRARY_PATH
# Set shell search paths
export PATH=$PATH:$ORACLE_HOME/bin
PATH=$PATH:$HOME/bin
umask 0022
export PATH
unset USERNAME