Oracle Database 11gR2(11.2.0.4.0) Installation on Oracle Linux Server 7.9 step by step :
Oracle Database 11gR2 Installation
In this blog we will discuss about the Oracle Database 11gR2(11.2.0.4.0) Installation on Oracle Linux Server 7.9 64-bit. The minimum of 2G swap space required for installing the binaries and secure Linux set to permissive.
Oracle Linux Server 7.9 is used in real time production environment & here we are installing database versions 11.2.0.4 on test server.
- To Download the Software
- Unzip Files
- Oracle Installation Prerequisites
- Automatic Setup Configuration
- Manual Setup Configuration
- Additional task
- Database Installation
Oracle Database Software Downloads :
You can download the Oracle software from OTN or MOS as per your environment.
OTN: Oracle Universal Installations (OUI) Software download
Unzip 11gR2(11.2.0.4.0) files :
unzip p13390677_112040_Linux-x86-64_1of7.zip</p>
unzip p13390677_112040_Linux-x86-64_2of7.zip</p>
Prerequisites for Oracle Installation :
To the Automatic Setup Configuration or the Automatic Setup Configuration there are some basic prerequisites which must be completed.
Automatic Setup Configuration:
We can use the Yum repository in Linux server to install any RPM (Redhat Package Manager). To use the Yum we must have installed Yum Repos. in the server.
yum search preinstall
yum install oracle-rdbms-server-11gR2-preinstall -y
Manual Setup Configuration:
If you do not used the “oracle-rdbms-server-11gR2-preinstall” package to install all the prerequisites then you will need to manually do the following tasks.
Add the following lines in 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
Esc:wq
Run this below commands to print the added lines via root owner :
/sbin/sysctl -p
Add the below lines in 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
Add the below line in the “/etc/pam.d/login” file.
session required pam_limits.so
The Below packages are required to install the oracle binaries without any error.
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 OS users and group.
groupadd -g 54321 oinstall
groupadd -g 54322 dba
groupadd -g 54323 oper
useradd -u 54321 -g oinstall -G dba,oper oracle
Set the password of “oracle” user.
passwd oracle
Additional Setup Configuration:
Whether you did the manual or automatic setup we must check the below parameter during the database installation and set it disabled.
Set secure Linux disabled by editing the “/etc/selinux/config” file.
SELINUX=permissive
Save the above changes and restart the server.
setenforce Permissive
If the Linux firewall is enabled, we need to stop the service and disable it.
Run this below commands via root owner to stop the firewall :
systemctl stop firewalld
systemctl disable firewalld
mkdir -p /mssdb/db/omonitor11g/11.2.0/db/
chown -R oracle:oinstall /mssdb/
chmod -R 775 /mssdb/
If you have VNC serve so take the login of your machine and run the installation. In case if there is any issue while getting the GUI screen you can also run the below command.
xhost + <machine-name>
Add the following lines at the end of the “.bash_profile” file.
[omonitor@mytestserver1 ]$ cat .bash_profile
# .bash_profile
# Get the aliases and functions
if [ -f ~/.bashrc ]; then
. ~/.bashrc
fi
export HISTSIZE=20000
HISTTIMEFORMAT='%F %T %t'
export HISTFILE
export ORACLE_HOME=/mssdb/db/omonitor11g/11.2.0/db/
export ORACLE_SID=msdb
PATH=$ORACLE_HOME/bin:$PATH; export PATH
export SQLPATH=/msdb/db/omonitor/scripts/healthcheck:/msdb/db/omonitor/scripts
ESC:wq
After set the above parameter you need to re-login again to same OS user to apply the bash parameter changes in effect.
or you can use the below command to set it immediately.
. ./.bash_profile
Database Installation steps on GUI interface:
[omonitor@mytestserver1 database]$ ./runInstaller
Starting Oracle Universal Installer…
Checking Temp space: must be greater than 120 MB. Actual 4290 MB Passed
Checking swap space: must be greater than 150 MB. Actual 4095 MB Passed
Uncheck the Security Updates
Email not required to pass you can leave it and click on ok.
Skip the Software Updates:
Install the Database software only:
Select single install database selection:
Select language:
Select the Enterprise Edition
Pass the ORACLE_BASE and ORACLE_HOME path.
Set the DBA group.
Check the warning and do the needful or if ignorable the click in ignore all button & then click next.
Click yes.
Click Next
Click next button.
Run the below script as a root owner.
See the below output.
Click on okay button.
Database software installation is completed successfully.
You can learn more – How to create database in oracle 11g using dbca
Please share this Blog with your colleagues or friends. Your suggestions and feedback are very helpful for everyone who come to this site and learn it from oracleocpworld.com.
Please comment here for your any query related to above post. You can email me on : oracleocpworld@gmail.com.
Pingback: How to create database in oracle 11g using dbca