Oracle 11g Database on linux Redhat Server 5.5

Oracle 11g Database on linux Redhat Server 5.5

1. Install Linux Redhat Enterprise Server 5.5:

Create a virtual machine using VirtualBox, Hyper-v or Vmware. Attach the iso to the VM. Start the installation:

Press "Enter" to install with graphical mode

Choose "Skip" to ignore the testing of the CD media

Choose the language

Select the language of the keyboard

If you have a Subscription number you can add it for update or install other packages from Redhat

Format the Disk but we will go back again to modify the swap

Modify the swap size (x2 physical memory)

Enter a password for the root account

Disable the Firewall

Disable SELinux

Enter a user account and set a password

Login with root account

The install of Redhat server is complete, we need to make other configuration.
Open a terminal and tape "setup". Go to "Network configuration"

Select "Edit Devices"

Choose the network device

Fix the IP address and validate with "OK"

We need to change the hostname and fix the DNS address

Enter the Hostname

Oracle install needs a graphical install, so it's better to change the Display sittings

Reboot the system after these changes

We'll configure the repository so we can install the packages we need for Oracle. Insert the CD media of Redhat Server and copy "Server" folder in "/tmp"

Now go to "Applications" and "Add/Remove Software"

Click "Edit" and "Repository Manager". Click on "Add"

Give a name for the repository and specified the "Server" folder.

Now let’s create a user and groups for Oracle installation

#groupadd  oinstall
#groupadd  dba
#useradd -m -g oinstall -G dba -d /home/oracle -s /bin/bash -c "Oracle Software Owner" oracle
#passwd oracle

Change the "/etc/sysctl.conf" file to add (change) kernel parameters that are required for Oracle installation

The file should be as follows:

net.ipv4.ip_forward = 0
net.ipv4.conf.default.rp_filter = 1
net.ipv4.conf.default.accept_source_route = 0
kernel.sysrq = 0
kernel.core_uses_pid = 1
net.ipv4.tcp_syncookies = 1
kernel.msgmnb = 65536
kernel.msgmax = 65536
kernel.shmmax = 2147483648
kernel.shmall = 2097152
kernel.shmmni = 4096
kernel.sem = 250 32000 100 128
fs.file-max = 6815744
fs.aio-max-nr = 1048576
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default = 1048576
net.core.rmem_max = 4194304
net.core.wmem_default = 262144
net.core.wmem_max = 1048576

To make the active in the current session, run /sbin/sysctl -p command

Change "/etc/pam.d/login" file and add the followingn line:

session required pam_limits.so

Change "/etc/security/limits.conf" and add the following lines:

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

Create necessary directories for Oracle home

#mkdir -p /u01/home/oracle/product/11.2.0/db_1
#chown -R oracle:oinstall /u01

Change the entry of .bash_profile file of the oracle user and add following lines:

/home/oracle/.bash_profile

export ORACLE_HOME=/u01/home/oracle/product/11.2.0/db_1
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib
export PATH=$ORACLE_HOME/bin:$PATH

Now copy downloaded oracle installation files to the /tmp directory

You need to logout from root account and login with oracle account. Open a terminal, point to install directory and execute this command (Before that make sure that oracle user has the right to execute from the install directory, so use chmod to grant these rights):

#cd /tmp/database
#./runinstaller

Select Create and configure a database and click next

Provide the name of the database and the password and click next

You'll get some errors, no worries you need to install these packages.

Check again.

Our database

The installation finished successfully.

Switch to the installation page and run both shell scripts with root user.







Login in with oracle user, open a new terminal, export ORACLE_SID variable and connect to the database.

#export ORACLE_SID=orcl