Friday, December 5, 2014

Oracle Database Installations --- Details!!

++ Basic INFO - Oracle Database Installations ++

1. Before installing make sure, you are set all required PATH and Environment parameters

2. Go to $ vi /etc/hosts and set hostname 

3. Go to $ vi ~ /.bash_profile and set ORACLE_HOME environment values as below ...
ORACLE_HOSTNAME= iam-dev.com; export ORACLE_HOSTNAME
ORACLE_UNQNAME=orcl; export ORACLE_UNQNAME
ORACLE_BASE=/home/app/database; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1; export ORACLE_HOME
ORACLE_SID=orcl; export ORACLE_SID
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/jlib:$ORACLE_HOME/rdbms/jlib; export CLASSPATH

To take this effect: run $ . ~ /.bash_profile command for 'oracle' and 'root' users.
My case, i have logged in both root as well as oracle and modified the ~ /.bash_profile file.

4. Go to $ vi /etc/profile

At the end of the file add;

export JAVA_HOME=/usr/java/jdk1.7.0_60
export PATH=$PATH:/usr/java/jdk1.7.0_60/bin
export ORACLE_HOME=/home/app/database/product/11.2.0/dbhome_1
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib

5. Unzip the installers 

6. Sample screen shot shows the database details.


Thanks
VK