Enviornmental Variable [message #343976] |
Thu, 28 August 2008 09:22 |
glanson
Messages: 11 Registered: August 2008
|
Junior Member |
|
|
I use secure shell to login to oracle. Each time i login i have to set the environmental variables. How can i set it permanently?
I am new to oracle. Please help.
|
|
|
|
Re: Enviornmental Variable [message #344000 is a reply to message #343976] |
Thu, 28 August 2008 09:59 |
alanm
Messages: 284 Registered: March 2005
|
Senior Member |
|
|
hi,
you need to create a bash_profile for your oracle user or add various lines to the profile.
similar to
[oracle@grid1 ~]$ more .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
# User specific environment and startup programs
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/10.2.0/db10g; export ORACLE_HOME
ORACLE_SID=emrep; export ORACLE_SID
OPATCH=$ORACLE_HOME/OPatch
ORACLE_TERM=xterm; export ORACLE_TERM
PATH=/usr/sbin:$PATH; export PATH
PATH=$ORACLE_HOME/bin:$PATH; export PATH
LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib; export LD_LIBRARY_PATH
CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH
#LD_ASSUME_KERNEL=2.4.1; export LD_ASSUME_KERNEL
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
PATH=$PATH:$HOME/bin
export PATH
unset USERNAME
# Avoid problems with file copies if stty commands exit in the users profile.
if [ -t 0 ]; then
stty intr ^C
fi
# Set default user filemask
umask 022
[oracle@grid1 ~]$
regards
Alan
|
|
|