database env
864103Oct 15 2012 — edited Oct 16 2012hi all ,
oracle 11 rac with asm on linux
please your advice concern the below
[oracle@medi01 ~]$ echo $ORACLE_HOME
[oracle@medi01 ~]$ . .bash_profile
[oracle@medi01 ~]$ echo $ORACLE_HOME
/home/app/oracle/product/11.2.0
[oracle@medi01 ~]$ echo $ORACLE_SID
MEDI1
[oracle@medi01 ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.2.0 Production on Mon Oct 15 10:54:04 2012
Copyright (c) 1982, 2010, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Release 11.2.0.2.0 - 64bit Production
With the Real Application Clusters and Automatic Storage Management options
SQL>
[oracle@medi01 ~]$ vi ~/.bash_profile
export DB_HOME=$ORACLE_BASE/product/11.2.0
export ORACLE_HOME=$DB_HOME
export ORACLE_SID=MEDI1
export ORACLE_TERM=xterm
export BASE_PATH=/usr/sbin:$PATH
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
if [ $USER = "oracle" ]; then
if [ $SHELL = "/bin/ksh" ]; then
ulimit -p 16384
ulimit -n 65536
else
ulimit -u 16384 -n 65536
fi
fi
alias grid_env='. /home/oracle/grid_env'
alias db_env='. /home/oracle/db_env'
umask 0022
vi db_env
export ORACLE_SID=MEDI1
export ORACLE_HOME=$DB_HOME
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
export ORACLE_SID=+ASM1
export ORACLE_HOME=$GRID_HOME
export PATH=$ORACLE_HOME/bin:$BASE_PATH
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib
my question why it's not work as perminent i always when log in to server
apply . .bash_profile
???