HI all,

I have this question and it may be dumb and easy for a lot of people in here but I am Oracle DBA not Linux sys admin and unfortunately, I have to do some of the linux admin work. Anyway, the quesion I have is:

in Linux you have .bashrc file and you would add something like this for Oracle:

export ORACLE_HOME=/home/oracle/product/9.2.0
export ORACLE_BASE=/home/oracle
export NLS_LANG=AMERICAN_AMERICA.WE8ISO8859P1
export ORA_NLS33=$ORACLE_HOME/ocommon/nls/admin/data
export ORACLE_SID=HULIST01
export TNS_ADMIN=$ORACLE_HOME/network/admin
export CLASSPATH=$ORACLE_HOME/JRE:$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib:$ORA
CLE_HOME/network/jlib
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib:/usr/openwin/lib
export PATH=$PATH:$HOME/bin:$ORACLE_HOME/bin



could someone please give me a full explanation of what is the purpose of add the above command in .bashrc?????

Sorry, I am new and I would like to understand of what I am doing

thanks a bunch

OK, basically what you are doing is setting variables, then installing the variable/value pairs into the environment, in this case the bash shell.

In a nutshell this means that any process started from that bash shell inherits those variables from the shell.

So, when you launch your oracle DB server, it's going to look in its environment and read the values of those variables in order to configure itself. In other words, the database expects to be able to (is programmed to) read the values of ORACLE_HOME, ORACLE_BASE, etc. and do relevant internal things with them.

Hope this helps.