Author Photo

Ahmer's SysAdmin Recipes is a blog for Linux System Administrators. This blog provides recipes for Installation & Configuration of Linux, Ubuntu, Oracle Database, MySQL, Apache, Nginx, Oracle Cloud Control, FreeIPA, Kerberos & OpenLDAP, Subversion, PXE, DevOps, etc. over Red Hat Enterprise Linux (RHEL), CentOS, Ubuntu and Windows.

Please give me your feedback and help me improve this blog. Please let me know If you want me to write on a specific topic.

Saturday, 16 April 2016

Install Oracle Grid Infrastructure 12c as Stand Alone Server

Install Oracle Grid Infrastructure 12c as Stand Alone ServerOracle Grid Infrastructure 12c is the Oracle software that provides system support for an Oracle database including volume management, file system, and automatic restart capabilities. Oracle combined the two infrastructure products (i.e. Oracle ASM and Clusterware) into a single set of binaries that is installed in the Oracle Grid Infrastructure 12c home. If you plan to use Oracle Restart or Oracle ASM (Automatic Storage Management), then you must install Oracle Grid Infrastructure prior to installation of Oracle database, because Oracle Restart and Oracle ASM are part of Oracle Grid Infrastructure 12c.

Oracle ASM is the volume manager and the file system for Oracle database files that supports single-instance Oracle databases and Oracle RAC (Real Application Clusters) configurations. Oracle ASM also supports a general purpose file system for your application needs including Oracle database binaries. Oracle ASM is Oracle's recommended storage management solution that provides an alternative to conventional volume managers, file systems, and raw devices.

In this article, we will perform the installation and configuration of Oracle Grid Infrastructure 12c as a Stand Alone Server.

 

System Specification:

We are using a preconfigured CentOS 6.7 server with following specification.

CPU 2.4 Ghz (Single Core)
Memory 2 GB
Storage 50 GB (2 GB for Swap, 23 for /, 25 GB for ASM Disks)
tmpfs 1.2 GB
Operating System CentOS 6.7

 

Oracle Grid Infrastructure 12c pre-install configuration:

Before starting installation of Oracle Grid Infrastructure 12c, make sure that you have already perform steps to configure ASMLIB.

Read Also: ASMLIB : Installation and Configuration
  Create Consistent Disks with UDEV for Oracle ASM

Connect to the Server using SSH and check available ASM Disks.

[grid@gridserver ~]$ oracleasm listdisks
ASM_DATA1
ASM_DATA2
ASM_DATA3
ASM_FRA1
ASM_FRA2
ASM_FRA3
[grid@gridserver ~]$

I have 6 ASM Disks available that I have created via ASMLIB. I am planning to use ASM_DATAx Disks for oradata and ASM_FRAx for recovery_area.

Set Kernel parameters as follows:

[root@gridserver ~]# cat >> /etc/sysctl.conf << EOF
> kernel.shmmni = 4096
> kernel.sem = 250 32000 100 128
> fs.file-max = 6553600
> 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 = 1048576
> EOF

[root@gridserver ~]#

Set security limits for oracle and grid users.

[root@gridserver ~]# cat >> /etc/security/limits.conf << EOF
> grid soft nproc 2047
> grid hard nproc 16384
> grid soft nofile 1024
> grid hard nofile 65536
> oracle soft nproc 2047
> oracle hard nproc 16384
> oracle soft nofile 1024
> oracle hard nofile 65536
> EOF
[root@gridserver ~]#

Configure PAM (Pluggable Authentication Modules).

[root@gridserver ~]# cat >> /etc/pam.d/login << EOF
> session required pam_limits.so
> EOF
[root@gridserver ~]#

Add following script to session startup file.

[root@gridserver ~]# cat >> /etc/profile << EOF
> if [ $USER = "oracle" ] || [ $USER = "grid" ]; then
> if [ $SHELL = "/bin/ksh" ]; then
> ulimit -p 16384
> ulimit -n 65536
> else
> ulimit -u 16384 -n 65536
> fi
> umask 022
> fi
> EOF
[root@gridserver ~]#

Create owner of Oracle database server. I am not creating groups because they are already created during ASMLIB configuration.

[root@gridserver ~]# useradd -u 602 -g oinstall -G dba,asmdba oracle

Create directories and set permissions.

[root@gridserver ~]# mkdir -p /u01/app/oraInventory
[root@gridserver ~]# chown -R grid:oinstall /u01/app/oraInventory
[root@gridserver ~]# chmod -R 775 /u01/app/oraInventory
[root@gridserver ~]#
[root@gridserver ~]# mkdir -p /u01/app/grid/product/12.1.0/grid
[root@gridserver ~]# chown -R grid:oinstall /u01/app/grid
[root@gridserver ~]# chmod -R 775 /u01/app/grid/product/12.1.0/grid
[root@gridserver ~]#
[root@gridserver ~]# mkdir -p /u01/app/oracle
[root@gridserver ~]# mkdir /u01/app/oracle/cfgtoollogs
[root@gridserver ~]# chown -R oracle:oinstall /u01/app/oracle
[root@gridserver ~]# chmod -R 775 /u01/app/oracle
[root@gridserver ~]#
[root@gridserver ~]# mkdir -p /u01/app/oracle/product/11.2.0/db_1
[root@gridserver ~]# chown -R oracle:oinstall /u01/app/oracle/product/11.2.0/db_1
[root@gridserver ~]# chmod -R 775 /u01/app/oracle/product/11.2.0/db_1

Install required packages using yum.

[grid@gridserver ~]$ yum install -y binutils
[grid@gridserver ~]$ yum install -y compat-libstdc++
[grid@gridserver ~]$ yum install -y elfutils-libelf
[grid@gridserver ~]$ yum install -y elfutils-libelf-devel
[grid@gridserver ~]$ yum install -y expat
[grid@gridserver ~]$ yum install -y gcc
[grid@gridserver ~]$ yum install -y libstdc++
[grid@gridserver ~]$ yum install -y libstdc++-devel
[grid@gridserver ~]$ yum install -y gcc-c++
[grid@gridserver ~]$ yum install -y glibc
[grid@gridserver ~]$ yum install -y glibc-common
[grid@gridserver ~]$ yum install -y glibc-devel
[grid@gridserver ~]$ yum install -y glibc-headers
[grid@gridserver ~]$ yum install -y libaio
[grid@gridserver ~]$ yum install -y libaio-devel
[grid@gridserver ~]$ yum install -y libgcc
[grid@gridserver ~]$ yum install -y make
[grid@gridserver ~]$ yum install -y sysstat
[grid@gridserver ~]$ yum install -y unixODBC
[grid@gridserver ~]$ yum install -y unixODBC-devel
[grid@gridserver ~]$ yum install -y compat-libcap1
[grid@gridserver ~]$ yum install -y ksh
[grid@gridserver ~]$ yum install -y nfs-utils-lib nfs-utils

 

Oracle Grid Infrastructure 12c Installation:

Login as grid user and start installation.

[grid@gridserver ~]$ cd /soft/grid
[grid@gridserver grid]$ ./runInstaller
Starting Oracle Universal Installer...

Checking Temp space: must be greater than 120 MB.   Actual 13537 MB    Passed
Checking swap space: must be greater than 150 MB.   Actual 1983 MB    Passed
Checking monitor: must be configured to display at least 256 colors.    Actual 16777216    Passed
Preparing to launch Oracle Universal Installer from /tmp/OraInstall2016-04-11_02-00-28AM. Please wait ...

Oracle Grid Infrastructure 12c Installer - Software Updates

Select Skip Software updates.

Click on Next.

Oracle Grid Infrastructure 12c Installer - Installation Option

Select Install and Configure Oracle Grid Infrastructure for a Standalone Server.

Click on  Next.

Oracle Grid Infrastructure 12c Installer - Product Languages

Click on Next.

Oracle Grid Infrastructure 12c Installer - Create ASM Diskgroup

Select the 3 Disks ASM_DATA1, ASM_DATA2 & ASM_DATA3.

Click on Next.

Oracle Grid Infrastructure 12c Installer - Specify ASM Password

Set Password for SYS and ASMSNMP.

Click on Next.

Oracle Grid Infrastructure 12c Installer - OS Groups

Installer automatically selects default OS groups.

Click on Next.

Oracle Grid Infrastructure 12c Installer - Installation Location

Click on Next.

Oracle Grid Infrastructure 12c Installer - Create Inventory

Click on Next.

Oracle Grid Infrastructure 12c Installer - Root Scripts

Select Automatically run configuration scripts and enter root password.

Click on Next.

Oracle Grid Infrastructure 12c Installer - Summary

Installer skips the Prerequisite Check screen because it didn’t find any warning or failure.

Click on Install.

Oracle Grid Infrastructure 12c Installer - Install Product

Oracle Grid Infrastructure 12c Installer - Confirm Script Execution

Click on Yes.

Oracle Grid Infrastructure 12c Installer - Finish

Click on Close to finish installation.

Oracle Grid Infrastructure 12c as stand alone server has been installed.

Install Oracle Grid Infrastructure 12c as Stand Alone Server


YOU MIGHT ALSO LIKE:

No comments:

Post a Comment