Home » RDBMS Server » Backup & Recovery » Enviornmental Variable (Oracle 10.2.0 ; Centos 5)
Enviornmental Variable [message #343976] Thu, 28 August 2008 09:22 Go to next message
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 #343980 is a reply to message #343976] Thu, 28 August 2008 09:24 Go to previous messageGo to next message
BlackSwan
Messages: 25041
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/
Please read & FOLLOW the Posting Guidelines as stated in URL above

You are also new to CentOS.
Add the desired line to ".bash_profile" file or what ever your shell uses.

[Updated on: Thu, 28 August 2008 09:25] by Moderator

Report message to a moderator

Re: Enviornmental Variable [message #344000 is a reply to message #343976] Thu, 28 August 2008 09:59 Go to previous message
alanm
Messages: 282
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
Previous Topic: Restore 9i rman backups to 10g excutable on host2
Next Topic: V10 RMAN capabilities
Goto Forum:
  


Current Time: Tue Dec 06 14:29:19 CST 2016

Total time taken to generate the page: 0.08243 seconds