Saturday, October 20, 2007

Installing Oracle 11g Release 1 on Red Hat Linux EL/AS 4 (32-bit)

Print this post

1. Hardware:
* Minimum Hardware Requirements

    - 1.0 GB (10242 MB) of physical RAM
    - The following table describes the relationship between installed RAM and the configured swap space requirement.
           RAM                                                       Swap Space
           =====                                                  =============
           Between 512 MB and 2048 MB              1.5 times the size of RAM
           Between 2049 MB and 8192 MB            Equal to the size of RAM
           More than 8192 MB                              0.75 times the size of RAM

    - 400 MB of disk space (and less than 2Tb of disk space) in the /tmp directory.
    - between 1.5 GB and 3.5 GB of disk space for the Oracle software, depending on the installation type.
    - 1.6 GB of disk space for a preconfigured database that uses file system storage (optional)

2. Software:
* Required RPMs ( To Check, rpm -q <package name> ; To Install rpm -Uvh <package.rpm> 

    o Kernel 2.6.9-34 (or higher)  (To Check, uname -r )
    o elfutils-libelf-devel-0.97-5
    o glibc-devel-2.3.4-2.19
    o gcc-3.4.5-2 
    o libstdc++-devel-3.4.5-2
    o gcc-c++-3.4.5-2
    o libaio-devel-0.3.105-2
    o sysstat-5.0.5
    o unixODBC-devel-2.2.11
    o glibc-kernheaders-2.4-9.1.98.EL
    o glibc-headers-2.3.4-2.19.

3. Environment:
Required Environment Variable
umask for the oracle account must be 0022
the "ulimit" stack size value should be at least 32768 (ulimit -s 32768)

* Modify your kernel settings in /etc/sysctl.conf (RedHat) as follows.

If the current value for any parameter is higher than the value listed in this table, do not change the value of that parameter.

Range values (such as net.ipv4.ip_local_port_range) must match exactly.

    kernel.shmall = 2097152
    kernel.shmmax = 1/2 of physical RAM. This would be the value 2147483648 for a 4Gb RAM system.
    kernel.shmmni = 4096
    kernel.sem = 250 32000 100 128
    fs.file-max = 512 x processes (for example 65536 for 128 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

To activate these new settings into the running kernel space, run the "sysctl -p" command
* Hostname command should return the fully qualified hostname as shown

    % hostname
    hostname.domainname  ( set hostname in /etc/hosts, /etc/sysconfig/network)

* If any Java packages are installed on the system, unset the Java environment variables, for example JAVA_HOME.
* The oracle account used to install Oracle 11.1.0.X, should not have the Oracle install related variables set by default.

For example setting ORACLE_HOME, PATH, LD_LIBRARY_PATH to include Oracle binaries in .profile, .login file and

/etc/profile.d should be completely avoided.

Create group oinstall ( groupadd oinstall )

Creating user oracle with primary group oinstall ( useradd -g oinstall oracle )

4. Set Shell Limits for the oracle User. Assuming that the "oracle" Unix user will perform the installation, do the following:

- Add the following settings to /etc/security/limits.conf
    oracle     soft      nproc     2047
    oracle     hard     nproc     16384
    oracle     soft      nofile      1024
    oracle     hard     nofile      65536
- Add or edit the following line in the /etc/pam.d/login file, if it does not already exist:
    session required
- Add the following lines to /etc/profile:
    if [ $USER = "oracle" ]; then
      if [ $SHELL = "/bin/ksh" ]; then
          ulimit -p 16384
          ulimit -n 65536
          ulimit -u 16384 -n 65536

5. Create, change ownership, and change permission of the $ORACLE_BASE/../ directory, using the appropriate

    The default oraInventory location for first-time installs has changed to $ORACLE_BASE/../oraInventory in 11gR1 

    This means that the account used to install the Oracle software must have write permissions from $ORACLE_BASE/../

    (take /mount_point/app/) and downwards.

6. Configuring the oracle User's Environment, Note that setting $ORACLE_BASE (not $ORACLE_HOME) in the environment

    will ease a couple of entries in the Oracle Universal Installer.

7. Now you are ready to invoke your Oracle Universal Installer. Be sure that you are LOGGED ON as the oracle account.

    Log directly into the install session. Do not use any variety of "su".


Installing Oracle Database 11g on Linux

To install the Oracle software, you must use the Oracle Universal installer.

1. For this installation, you need either the DVDs or a downloaded version of the DVDs.

From the directory where the DVD files were unzipped, open a terminal window and enter the following:



2.The product you want to install is Oracle Database 11g. Make sure the product is selected and click Next.


3.You will perform a basic installation with a starter database. Enter orcl for the Global Database Name and oracle

for Database Password and Confirm Password. Then, click Next.


4.You need to specify your Inventory directory. The location should be set to /u01/app/oracle/oraInventory.

Accept the default Operating System group name, oinstall. Then, click Next.


5.The installer now verifies that the system meets all the minimum requirements for installing and configuring

the chosen product. Please correct any reported errors before continuing. When the check successfully

completes, click Next.




6.Oracle Configuration Manager allows you to associate your configuration information with your Metalink account.

You can choose to enable it on this window. Then, click Next.


7. Review the Summary window to verify what is to be installed. Then, click Install.


8. The progress window appears.


9.The Configuration Assistants window appears.


10.Your database is now being created.


11. When the database has been created, you can unlock the users you want to use. Click OK.


12. You need to execute and as the root user.


13.Open a terminal window and enter the following commands. Follow the prompts as instructed.

su -
cd /u01/app/oracle/oraInventory
cd ../product/11.1.0/db_1


14.Switch back to the Universal Installer and click OK.


15. Click Exit. Click Yes to confirm exit.


Testing Your Installation

To test that your installation completed successfully, perform the following steps:

1.Open a browser and enter the following URL:


where <hostname> should be changed to your machine name, IP address, or localhost.

Because Enterprise Manager Database Control is a secure site, you need a certificate. Select the

Accept this certificate permanently option, and then click OK.

2.Enter system as the User Name and oracle as the Password, and then click Login.

3.The Database Control Home Page appears. Your installation was successful.


Oracle 11g is Successfully Installed.

No comments: