26.5. Updating after the Oracle Universal Installer

After Oracle 10g has been installed, make sure that ORACLE_HOME, PATH, and LD_LIBRARY_PATH are set for the oracle account.

Note

The path for ORACLE_HOME might be different on your system! Also note that LD_LIBRARY_PATH is needed for some Oracle binaries such as sysresv.
For 10g R1 (10.1.0.3) you may want to add the following lines to the ~oracle/.bash_profile file:
export ORACLE_HOME=$ORACLE_BASE/product/10.1.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin 
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
For 10g R2 (10.2.0.1.0) you may want to add the following lines to the ~oracle/.bash_profile file:
export ORACLE_HOME=$ORACLE_BASE/oracle/product/10.2.0/db_1
export PATH=$PATH:$ORACLE_HOME/bin
export LD_LIBRARY_PATH=$ORACLE_HOME/lib
After that run the following command to set all environment variables in ~oracle/.bash_profile:
$ . ~oracle/.bash_profile
This command will add the environment variables to the ~oracle/.profile and source in the file for the current shell by executing ". ~oracle/.bash_profile".

Note

Do not add a trailing "/" on the ORACLE_HOME environment variable. Otherwise you will get the error "ORACLE not available" when you try to connect to sys, see Chapter 29, Oracle 10g and Linux Installation Errors and Troubleshooting.