Contact Premier Online Trainings Today

Oracle DBA - Oracle Database 11gR2 (11.2.0.4) installation

Date Added: 05 Feb.2017 Date Updated: 18 Feb.2017 Oracle DBA Full Blog

 

Oracle Database 11gR2 (11.2.0.4) installation on Oracle Linux 6.3

 

--->> Overview of installation

--->> Hardware Requirements

--->>  Host File

--->>  Kernel parameters

--->> Packages

--->>  Create the new groups and users

--->> Create the directories

--->>  Environment file settings

--->>  Extract the database software

--->> Start the installer

 

This article describes the installing of Oracle Database 11g Release 2 (11.2.0.4)(64bit) software on Oracle Linux 6.3(64-bit).

Overview of installation

·         Configure your system to support Oracle Database

·         Install Oracle Database on a local file system by using the Typical Installation option

·         Configure a general-purpose Oracle Database installation that uses the local file system for database file storage

Additional Installation Information

·         Install the software on a single system

·         Install Oracle Grid Infrastructure for a standalone server

·         Install an Oracle Real Application Clusters

Before you start, make sure your Linux server meets the minimum hardware requirements for Install the software on a single system

Hardware requirements:

·         1GB of RAM (plus appropriately sized swap space)

·         4.5GB of disk space for the software installation

·         1GB of disk space for your /tmp directory

 

--->>  Assign the IP address in host file

Hosts File

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

<IP-address>  <fully-qualified-machine-name>  <machine-name>

For example.

127.0.0.1       localhost.localdomain  localhost

192.168.0.2    linux.oracle.com      linux

 

--->> Add or amend the following lines in the "/etc/sysctl.conf" file

add (change) kernel parameters that are required for Oracle installation

fs.suid_dumpable = 1

fs.aio-max-nr = 1048576

fs.file-max = 6815744

kernel.shmall = 2097152

kernel.shmmax = 536870912

kernel.shmmni = 4096

kernel.sem = 250 32000 100 128

net.ipv4.ip_local_port_range = 9000 65500

net.core.rmem_default = 262144

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   16384

oracle              hard    nproc   16384

oracle              soft    nofile  4096

oracle              hard    nofile  65536

oracle              soft    stack   10240

 

--->> Check the packages installed or not

#rpm -qa <package name>

--->> Install the following packages if they are not already present.

# From Oracle Linux 6 DVD

cd /media/cdrom/Server/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*

--->>  Create the new groups and users.

Groups:-

groupadd -g 501 oinstall

groupadd -g 502 dba

groupadd -g 503 oper

groupadd -g 504 asmadmin

groupadd -g 506 asmdba

groupadd -g 505 asmoper

User :-

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

passwd oracle

 

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

mkdir -p /u01/app/PROD/product/11.2.0.4

chown -R oracle:oinstall /u01/app/PROD

chmod -R 775 /u01

 

--->>  Environment file settings

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

or create the custom env file

 [oracle@linux ~]$ cat PROD.env

ORACLE_BASE=/u01/app/PROD; export ORACLE_BASE

ORACLE_HOME=$ORACLE_BASE/product/11.2.0.4; export ORACLE_HOME

ORACLE_SID=PROD; export ORACLE_SID

PATH=$ORACLE_HOME/bin:$PATH; export PATH

[oracle@linux ~]$

--->>  Extract the database software

Open the terminal session to the server as the ‘oracle’ user.

unzip the software

$ cd /Stage/DB11g_64bit/

$ unzip -o p13390677_112040_Linux-x86-64_1of7.zip

$ unzip -o p13390677_112040_Linux-x86-64_2of7.zip

 

--->>  Start the installer

Software location as bleow

[oracle@linux database]$ pwd

/Stage/DB11g_64bit/database

[oracle@linux database]$ ./runInstaller

Once the GUI starts, respond as follows:

Configure Security Updates

Uncheck ‘I wish to receive security updates via My Oracle Support’

Next

Databaseinstallatoin1

 

Confirm with ‘Yes’

databaseinstallation2

 

Download Software Updates

Skip software updates

Next

Databaseinstallation3

Select create and configure database

databaseinstallation4

Select Desktop class

dbinstallation5

 

Enter Database name and password

dbinstallatin6

 

Click on yes

dbinstallation7

Click on next

dbinstallation8

 

dbinstallation9

Click on Check Again button and you’ll see that those notifications are disappeared. Check “Ignore all” checkbox and click next

dbinstallation10

Click on yes

dbinstallation11

Click on install

dbinstallation12

Installation progress, please wait few minits

dbinstallation13

Click on OK

dbinstallation14

 

Open the terminal session to the server as the ‘root’ user.

And run the bleow scripts

[root@linux Stage]# /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@linux Stage]# /u01/app/PROD/product/11.2.0.4/root.sh

Performing root user operation for Oracle 11g

The following environment variables are set as:

    ORACLE_OWNER= oracle

    ORACLE_HOME=  /u01/app/PROD/product/11.2.0.4

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@linux Stage]#

dbinstallation15

Click on close

Check the Database name and status

Open new terminal as oracle user

Run env file

$. PROD.env

$sqlplus ‘/as sysdba’

SQL> select name from v$database;

NAME

---------

PROD

SQL> select status from v$instance;

STATUS

------------

OPEN

SQL>