Oracle Database 11gR2 Installation On Oracle Linux 6

Oracle Database 11gR2 Installation On Oracle Linux 6

by

Oracle Database 11gR2 Installation On Oracle Linux 6 : In this paragraph describes Oracle Database 11gR2 Installation On Oracle Linux 6. The article is based on a server installation with a minimum of 2G swap. An example of this type of Linux installation can be seen here.

  • Download Software
  • Unzip Files
  • Hosts File
  • Oracle Installation Prerequisites
    • Automatic Setup
    • Manual Setup
    • Additional Setup
  • Installation
  • Post Installation

Download Software :

Download the Oracle software from OTN or MOS depending on your support status.

OTN: Oracle Universal Installations (OUI) Silent Installations

Unzip Files :

unzip linux.x64_11gR2_database_1of2.zip

unzip linux.x64_11gR2_database_2of2.zip

Hosts File :

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

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

Oracle Installation Prerequisites :

Perform either the Automatic Setup or the Manual Setup to complete the basic prerequisites. The Additional Setup is required for all installations.

Automatic Setup:

commands must run on root user.

yum search preinstall

yum install oracle-rdbms-server-11gR2-preinstall.x86_64 -y

It is probably worth doing a full update as well, but this is not strictly speaking necessary.

yum update -y

Manual Setup:

If you have not used the “oracle-database-server-11gR2-preinstall” package to perform all prerequisites, you will need to manually perform the following setup tasks.

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

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=262144
net.core.rmem_max=4194304
net.core.wmem_default=262144
net.core.wmem_max=1048586

Then run this following commands on root user :

/sbin/sysctl -a | grep <param-name>

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

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

Add the following line to the “/etc/pam.d/login” file, if it does not already exist.

session    required     pam_limits.so

The following packages are listed as required, including the 32-bit version of some of the packages. Many of the packages should be installed already.

yum install binutils -y
yum install compat-libstdc++-33 -y
yum install compat-libstdc++-33.i686 -y
yum install gcc -y
yum install gcc-c++ -y
yum install glibc -y
yum install glibc.i686 -y
yum install glibc-devel -y
yum install glibc-devel.i686 -y
yum install ksh -y
yum install libgcc -y
yum install libgcc.i686 -y
yum install libstdc++ -y
yum install libstdc++.i686 -y
yum install libstdc++-devel -y
yum install libstdc++-devel.i686 -y
yum install libaio -y
yum install libaio.i686 -y
yum install libaio-devel -y
yum install libaio-devel.i686 -y
yum install libXext -y
yum install libXext.i686 -y
yum install libXtst -y
yum install libXtst.i686 -y
yum install libX11 -y
yum install libX11.i686 -y
yum install libXau -y
yum install libXau.i686 -y
yum install libxcb -y
yum install libxcb.i686 -y
yum install libXi -y
yum install libXi.i686 -y
yum install make -y
yum install sysstat -y
yum install unixODBC -y
yum install unixODBC-devel -y
yum install zlib-devel -y
yum install elfutils-libelf-devel -y

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

Set the password for the “oracle” user.

passwd oracle

Additional Setup:

The following steps must be performed, whether you did the manual or automatic setup.

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 disabled by editing the “/etc/selinux/config” file.

SELINUX=permissive

If you have the Linux firewall enabled, you will need to stop and disable it.

run this following commands on root user :

For the ipchains service.

service ipchains stop

For the iptables service.

service iptables stop

Stop the ipchains service from starting when you restart the server.

chkconfig ipchains off

Stop the iptables service from starting when you restart the server.

chkconfig iptables off

For checking status of iptables service.

service iptables status

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

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

Unless you are working from the console, or using SSH tunnelling, login as root and issue the following command.

xhost + <machine-name>

Add the following lines at the end of the “/home/oracle/.bash_profile” file.

# Oracle Settings
export TMP=/tmp;
export TMPDIR=$TMP;
export ORACLE_HOSTNAME=orakldba.localdomain;
export ORACLE_UNQNAME=ORCL;
export ORACLE_BASE=/u01/app/oracle;
export ORACLE_HOME=$ORACLE_BASE/product/11.2.0/db_1;
export ORACLE_SID=ORCL;
export PATH=/usr/sbin:$PATH;
export PATH=$ORACLE_HOME/bin:$PATH;
export LD_LIBRARY_PATH=$ORACLE_HOME/lib:/lib:/usr/lib;
export CLASSPATH=$ORACLE_HOME/jlib:$ORACLE_HOME/rdbms/jlib;

After settings done on .bash_profile run :

[oracle@orakldba ~]$
[oracle@orakldba ~]$ . ./.bash_profile
[oracle@orakldba ~]$

Installation:

Log into the oracle user. If you are using X emulation then set the DISPLAY environmental variable.

DISPLAY=<machine-name>:0.0; export DISPLAY

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

[oracle@orakldba database]$
[oracle@orakldba database]$
[oracle@orakldba database]$ ./runInstaller
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 4237 MB Passed
Checking swap space: must be greater than 150 MB. Actual 2046 MB Passed
Checking monitor: must be configured to display at least 256 colors. Actual 16777216 Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2020-08-15_01-04-33AM. Please wait …[oracle@orakldba database]$ You can find the log of this install session at:
/u01/app/oraInventory/logs/installActions2020-08-15_01-04-33AM.log

Configure Security Updates:

Installation Option :

Choose System Class :

Node Selection Option :

Choose Installation Type :

Typical Configuration :

Create Inventory :

Prerequisite Checks :

Summary :

Install Product :

Database Configuration Assistant Start :

Database Configuration Assistant Finish :

Script Execution Step :

Execute this two scripts login as root user :

[root@orakldba ~]#
[root@orakldba ~]# /tmp/CVU_11.2.0.1.0_oracle/runfixup.sh

Response file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.response
Enable file being used is :/tmp/CVU_11.2.0.1.0_oracle/fixup.enable
Log file location: /tmp/CVU_11.2.0.1.0_oracle/orarun.log
Setting Kernel Parameters…
The value for semmni in response file is not greater than value of semmni for current session. Hence not changing it.
The value for semmni in response file is not greater than value for semmni in /etc/sysctl.conf file. Hence not changing it.
[root@orakldba ~]#
[root@orakldba ~]#
[root@orakldba ~]# /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@orakldba ~]#
[root@orakldba ~]#
[root@orakldba ~]# /u01/app/oracle/product/11.2.0/db_1/root.sh
Running Oracle 11g root.sh script…
The following environment variables are set as:
ORACLE_OWNER= oracle
ORACLE_HOME= /u01/app/oracle/product/11.2.0/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.sh script.
Now product-specific root actions will be performed.
Finished product-specific root actions.

FINISH :

Post Installation :

Edit the “/etc/oratab” file setting the restart flag for each instance to ‘Y’.

ORCL:/u01/app/oracle/product/11.2.0/db_1:N

After completed installation check database status:

I hope my written content will helped you. Your suggestions/feedback are most welcome from orakldba.com.
Keep learning… Have a great day!!!
Please comment here for your any query related to above content. You could write to mail me through : orakldba@gmail.com.

Leave a Comment