Installing Oracle 11.2.0.3 Database on Oracle Enterprise Linux 6.3 64bit

First of all check the Hostname and IP on which we are going to install the Oracle Database.

Hostname: OEL64.localdomain

IP: 192.168.0.10

Confirm the bit version of Operating System:

[root@OEL64 ~]# uname -i
x86_64
[root@OEL64 ~]#

Download the 11.2.0.3 Database Files (p10404530_112030_Linux-x86-64_1of7.zipp10404530_112030_Linux-x86-64_2of7.zip) from Oracle Site and put it on the server.

Now we will start configuring perquisite.

1. Hosts File

The “/etc/hosts” file must contain a fully qualified name for the server.

[root@OEL64 ~]# cat /etc/hosts
127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4
::1 localhost localhost.localdomain localhost6 localhost6.localdomain6

192.168.0.10 OEL64.localdomain OEL64
[root@OEL64 ~]#

2. Oracle Installation Prerequisites

Add or amend the following lines in the “/etc/sysctl.conf” file.

fs.suid_dumpable = 1
fs.aio-max-nr = 1048576
fs.file-max = 6815744
kernel.shmall = 2097152
kernel.shmmax = 536870912
kernel.shmmni = 4096
# semaphores: semmsl, semmns, semopm, semmni
kernel.sem = 250 32000 100 128
net.ipv4.ip_local_port_range = 9000 65500
net.core.rmem_default=4194304
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

Run the following command to change the current kernel parameters.

/sbin/sysctl -p

Add the following lines to the “/etc/security/limits.conf” file.

oracle              soft    nproc   2047
oracle              hard    nproc   16384
oracle              soft    nofile  4096
oracle              hard    nofile  65536
oracle              soft    stack   10240

Install the following packages if they are not already present.

Go to media and go to the packages directory:

[root@OEL64 Packages]# pwd
/media/OL6.3 x86_64 Disc 1 20120626/Server/Packages
[root@OEL64 Packages]#

Install the below packages:

rpm -Uvh binutils-2*x86_64*
rpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*
rpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*
rpm -Uvh compat-libstdc++-33*x86_64*
rpm -Uvh glibc-common-2*x86_64*
rpm -Uvh glibc-devel-2*x86_64*
rpm -Uvh glibc-devel-2*i686*
rpm -Uvh glibc-headers-2*x86_64*
rpm -Uvh elfutils-libelf-0*x86_64*
rpm -Uvh elfutils-libelf-devel-0*x86_64*
rpm -Uvh gcc-4*x86_64*
rpm -Uvh gcc-c++-4*x86_64*
rpm -Uvh ksh-*x86_64*
rpm -Uvh libaio-0*x86_64*
rpm -Uvh libaio-devel-0*x86_64*
rpm -Uvh libaio-0*i686*
rpm -Uvh libaio-devel-0*i686*
rpm -Uvh libgcc-4*x86_64*
rpm -Uvh libgcc-4*i686*
rpm -Uvh libstdc++-4*x86_64*
rpm -Uvh libstdc++-4*i686*
rpm -Uvh libstdc++-devel-4*x86_64*
rpm -Uvh make-3.81*x86_64*
rpm -Uvh numactl-devel-2*x86_64*
rpm -Uvh sysstat-9*x86_64*
rpm -Uvh compat-libstdc++-33*i686*
rpm -Uvh compat-libcap*

If in case any package fails then use the –force option or sometime –nodeps can also help. take help from man page.

3. Create the new groups and users.

groupadd -g 501 oinstall
groupadd -g 502 dba
groupadd -g 503 oper
groupadd -g 504 asmadmin
groupadd -g 506 asmdba
groupadd -g 505 asmoper

useradd -u 502 -g oinstall -G dba,asmdba,oper oracle
passwd oracle

Note. We are not going to use the “asm” groups, since this installation will not use ASM.

Additional Setup

Set the password for the “oracle” user.

passwd oracle

Amend the “/etc/security/limits.d/90-nproc.conf” file as described below.

# Change this
*          soft    nproc    1024

# To this
* - nproc 16384

Set secure Linux to permissive by editing the “/etc/selinux/config” file, making sure the SELINUX flag is set as follows.

SELINUX=permissive

Once the change is complete, restart the server.

If you have the Linux firewall enabled, you will need to disable or configure it.

Create the directories in which the Oracle software will be installed.

mkdir -p /u01/app/oracle/product/11.2.0.3/db_1
chown -R oracle:oinstall /u01
chmod -R 775 /u01

Login as the oracle user and add the following lines at the end of the “.bash_profile” file.

# Oracle Settings
TMP=/tmp; export TMP
TMPDIR=$TMP; export TMPDIR

ORACLE_HOSTNAME=OEL64.localdomain; export ORACLE_HOSTNAME
ORACLE_UNQNAME=APEX; export ORACLE_UNQNAME
ORACLE_BASE=/u01/app/oracle; export ORACLE_BASE
ORACLE_HOME=$ORACLE_BASE/product/11.2.0.3/db_1; export ORACLE_HOME
ORACLE_SID=APEX; 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

Installation:

Start the Oracle Universal Installer (OUI) by issuing the following command in the database directory.

./runInstaller

Follow the screen shot below to install the database:

Image

Unchecked and then press Next.

Image

Click Yes and press Next.

Image

Select as per your requirement and press Next.

Image

Select as per your choice for me: Create and configure the database, press Next.

Image

Select the server class as per your choice. Press Next.

Image

Here i am going to install single instance database and Press Next.

Image

I selected the typical option, anyone can choose as per their choice. Press Next.

Image

 

Correct and fill up the details and set the passwords accordingly. Press Next.

Image

Put the typical password, as i gave the simple password so i got this error press yes. and Press next.

Image

Nothing to change, press Next.

Image

Verify the details and Press Install.

Image

Wait till end and we will get the below one:

Image

Save this information somewhere for the EM and press OK. We need to run the two scripts as per the below print screen from the root user.

Image

 

Run the script from the root user:

[root@OEL64 ~]# /u01/app/oraInventory/orainstRoot.sh
Changing permissions of /u01/app/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.

Changing groupname of /u01/app/oraInventory to oinstall.
The execution of the script is complete.
[root@OEL64 ~]#

 

[root@OEL64 ~]# /u01/app/oracle/product/11.2.0.3/db_1/root.sh
Performing root user operation for Oracle 11g

The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0.3/db_1

Enter the full pathname of the local bin directory: [/usr/local/bin]:
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 script.
Now product-specific root actions will be performed.
Finished product-specific root actions.
[root@OEL64 ~]#

And click OK on screen.

Image

Press Close.

Verify the database:

$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Thu Oct 10 23:17:20 2013

Copyright (c) 1982, 2011, Oracle. All rights reserved.

Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL>
SQL>
SQL> show parameter db_name

NAME TYPE VALUE
———————————— ———– ——————————
db_name                               string     APEX
SQL>

We are done with the installation.

Many Thanks for viewing.

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s