Oracle Apps DBA

My photo
More than 5+ Years of IT Experience in administering Enterprise wide Multi Vendor UNIX Servers, Oracle Databases (8i to 11gR2), Middle-tiers, Applications and Clusters. I am a Sun Certified System Administrator (SCSA) for Solaris 10, oracle 10g database certified associate(OCA), Oracle 10g Database certified professional (OCP) and Oracle E-Business suite R12 certified professionl(OCP)

Oracle Database and Applications

Wednesday, 8 October 2008

Installing oracle database 11g on Red Hat Enterprise Linux 4.0

perform system pre-requisite:

Download the software from the following link

http://www.oracle.com/technology/software/products/database/oracle11g/111060_linuxsoft.html

Unzip the files:

#unzip linux_11gR1_database.zip

Verify Hosts File


The /etc/hosts file must contain a fully qualified name for the server:


Install the following redhat packages

packages present in Linux 4 Disk1
rpm -Uvh binutils-2.*
rpm -Uvh elfutils-libelf-0.*
rpm -Uvh glibc-2.*
rpm -Uvh glibc-common-2.*
rpm -Uvh libgcc-3.*
rpm -Uvh libstdc++-3.*
rpm -Uvh compat-libstdc++-33*
rpm -Uvh make-3.*
rpm -Uvh unixODBC-2.*
packages present in Linux 4 Disk2

rpm -Uvh glibc-devel-2.*
rpm -Uvh gcc-3.*
rpm -Uvh gcc-c++-3.*
rpm -Uvh libstdc++-devel-3.*

packages present in Linux 4 Disk3

rpm -Uvh libaio-0.*
rpm -Uvh libaio-devel-0.*
rpm -Uvh sysstat-5.*

packages present in Linux 4 Disk4

rpm -Uvh elfutils-libelf-devel-0.*
rpm -Uvh unixODBC-devel-2.*

Set Kernel Parameters
Oracle recommend the following minimum parameter settings:
kernel.shmall = 2097152
kernel.shmmax = 2147483648 # Smallest of -> (Half the size of the physical memory) or (4GB - 1 byte)
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
fs.file-max = 65536 # 512 * PROCESSES
net.ipv4.ip_local_port_range = 1024 65000
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=262144

The current values of the kernel parameters can be verified with the following command

#sysctl -p

Add the following entries in /etc/security/limits.conf file:

oracle soft nproc 2047
oracle hard nproc 16384
oracle soft nofile 1024
oracle hard nofile 65536

Create oracle user and dba group

#groupadd dba

#useradd -g dba -d /export/home -p 123456 oracle


create oracle directories & change the permissions

create the directories where you are going to install your Oracle 11g server and create the ORACLE_BASE directory. This is the place where Oracle will be installed. Make sure there is at least 3 GB on the partition/mount point before moving to the next step. After installed, my basic installation took about 3.4 GB on disk (without the starter database!). As your database grows, it will need more space.

# mkdir /u01/app/oracle
#chmod -R 775 /u01/app/oracle
# chown -R oracle:dba /u01/app/oracle

Setting oracle Environment variables:

Edit the oracle user's .bash_profile file or .bashrc file

ORACLE_BASE=/u01/app/oracle
ORACLE_HOME=$ORACLE_BASE/product/11.1.0/db_1
ORACLE_SID=ORCL
LD_LIBRARY_PATH=$ORACLE_HOME/lib
PATH=$PATH:$ORACLE_HOME/bin

export ORACLE_BASE ORACLE_HOME ORACLE_SID LD_LIBRARY_PATH PATH


Start the Installation:

Go to the stage area where the unzipped 11g software is present.

Fire up the installer as the oracle user itself. This will start the following window:

# su - oracle
$ cd /path/to/extracted/zip/fi
le
$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 80 MB. Actual 58633 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2900 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2007-07-11_04-38-56PM. Please wait ...
Oracle Universal Installer, Version 11.1.0.2.0 Pro
duction
Copyright (C) 1999, 2007, Oracle. All rights reserved.



















































































































At this point, it will ask you to run some scripts as root. Run the scripts as root user when it asks, since the install depends on a few modifications on the base system (like creating the /etc/oratab file).
















$ su - root
Password:

# /u01/app/oracle/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oracle/oraInventory to 770.
Changing groupname of /u01/app/oracle/oraInventory to oinstall.
The execution of the script is complete

# /u01/app/oracle/product/11.1.0/db_1/root.sh
Running Oracle 11g root.sh script...

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.1.0/db_1
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...

Creating /etc/oratab file...
Entries will be added to the /etc/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
After the execution of this scripts just click ok


















just click exit button to finsh the installation


Now verify the Installation by connecting to the database.

The Database should be up and running

No comments: