Oracle Database 11g Installation

We would initiate the job by creating a VM on the base windows machine, the installation of Oracle / linux remains same with installation on base machine other than VM part.

Please follow the steps as specified in the image any explanation if required, that would be available at the bottom of the image.

11g

g1

g2

g3

g4

Over here u can use NAT as well.

1

Preferred using single file as u might see in newer versions of the VM.

2

3

Please select the first option and press enter.

4

Skip the media test option.

5

6

7

8

Please select Yes.

9

If u r aware of self creation of various partitions then u should change or rather leave it as it is.

a

Please select yes.b

If u wanna configure the n/w settings then u can use this option.

c

d

e

Please remember to select the Customize now or rather u will install the default config OS with no GUI.

f

Desktop Environments

                GNOME Desktop Environment

Applications

                 Graphical Internet

Development

Development Libraries,  Development Tools,  GNOME Software Development,  Java Development,  X Software Development  (Select libxpdevel and openmotif)

Servers

Server Configuration Tools,  Web Server,  Windows File Server

Base System

                Administration Tools,  Base , Java ,  Legacy Software Support (select compat­db) ,   System Tools  (select sysstat) , X Window System

a1

a2

a3

a4

a5

a6

Please Disbale the Firewall settings.

a8

Please Disable the Selinux Settings.

a7

Do not Enable the kdump setting as not necessary.

a9

b1

b2

b3

b4

Install VMware Tools.

b5

Drag n Drop the VMWare Tools package and unzip the same.

b7

b8

Drag n drop the .pl file to the terminal to install the vmware tools, Just keep on pressing enter.

b9

c1

  • vi /etc/sysctl.conf

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

c2

Post entry do > /sbin/sysctl -p

c3

vi  /etc/pam.d/login

add the line

session required pam_limits.so

c4

vi /etc/security/limits.conf

add the following lines

oracle              soft    nproc   2047

 oracle              hard    nproc   16384

 oracle              soft    nofile  1024

 oracle              hard    nofile  65536

c5

Create the required directories

c6

vi /home/oracle/.bash_profile

add the following code line

 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

c7

Now copy downloaded oracle installation files to the /tmp directory. Ensure that oracle user can access the files and folder.

c8

Switch the user to oracle and unzip both the 11g installer dir. This should create a single dir database. Post this logout and login with oracle

c9

d1

Now go to the database dir and run the runInstaller.

  • ./runInstaller

Now select the options as per your requirement to install the oracle db software.

d2

d3

d4

d6

d7

At this point you would come to know what’s missing and accordingly install the packages or perform changes in OS.

d8

d9

a1

a2

a3

a4

a5

a6

a7

a8

a9

a11

Run these scripts from root login.

a12 a13 a14

Now ur db is up and running and ready for use.