00 Setup
 
01 Patch GI and DB with PSU 12.1.0.2.5

Contents

  1. 1 Overview
  2. 2 References
  3. 3 Tried to Set Up NFS for Software Installation
  4. 4 Procedure
    1. 4.1 Install OEL7
    2. 4.2 Use Pre-Installation RPM
    3. 4.3 Oracle Groups
    4. 4.4 Update Security
    5. 4.5 Create Software Installation Directory
    6. 4.6 Install UNZIP
    7. 4.7 Unzip the Uploaded Software
    8. 4.8 Set Aside Devices for ASM
    9. 4.9 Install Grid Infrastructure 12.1.0.2
    10. 4.10 Added FRA Disk Group
    11. 4.11 Install Oracle 12c RDBMS Software

Overview

This is a rough guide to the steps I followed to set up GORDON prior to transferring the REPOS database from GRIDCTRL .

References

Tried to Set Up NFS for Software Installation

Encountered the issue described in Unable to Use NFS under VirtualBox .

This means that I will have to have a larger local disk than normal in order to install the software, and have to use the local disk for the database data files.

Procedure

Install OEL7

Used V46135-01.iso to install OEL7. This was a minimal installation.

Updated OEL7 through yum :

yum upgrade

Use Pre-Installation RPM

Followed the procedure in Use Pre-Installation RPM .

Oracle Groups

The following groups are established for use by the oracle user:

Group Name Purpose
oinstall Owns Grid Infrastructure software
dba SYSDBA access for database super-user
asmdba SYSASM access for managing ASM
oper SYSOPER access for database operations
dbkm SYSKM access for managing encryption keys
dbbackup SYSBACKUP access for managing Oracle database backups
dbdg SYSDG access for managing Oracle Data Guard

Update Security

Used the following commands (as root ) to change the password for the oracle and grant it sudo access: 

visudo # allow wheel group to do sudo without a password
groupadd asmdba
groupadd oper
groupadd dbkm
groupadd dbbackup
groupadd dbdg
usermod oracle -g oinstall -G oinstall,wheel,dba,oper,asmdba,dbkm,dbbackup,dbdg

Create Software Installation Directory

Used the following commands (as root ) to create the software directory at /opt/app/oracle/software : 

mkdir -p /opt/app/oracle/software
chown -R oracle:oinstall /opt/app

Install UNZIP

Since this was a minimal installation, no UNZIP package was available. I had to install UNZIP as follows:

sudo yum install unzip

Unzip the Uploaded Software

The following ZIP archives were uploaded to /opt/app/oracle/software : 

linuxamd64_12102_database_1of2.zip
linuxamd64_12102_database_2of2.zip
linuxamd64_12102_grid_1of2.zip
linuxamd64_12102_grid_2of2.zip

As oracle user, I ran the following commands to unzip the software prior to installation: 

cd /opt/app/oracle/software
unzip -q linuxamd64_12102_grid_1of2.zip -d .
unzip -q linuxamd64_12102_grid_1of2.zip -d .
unzip -q linuxamd64_12102_database_1of2.zip -d .
unzip -q linuxamd64_12102_database_2of2.zip -d .

Set Aside Devices for ASM

Two (2) disks are set aside for ASM disk groups:

ASM Group Name Device Size (GB) Purpose
DATA /dev/sdb 20 Database files
FRA /dev/sdc 30 Fast Recovery Area

The ownership of these disks is changed as follows to enable discovery by the installer: 

chown oracle:dba /dev/sdb
chown oracle:dba /dev/sdc

Install Grid Infrastructure 12.1.0.2

Followed the procedure in Install 12.1.0.2 GI Standalone .

Added FRA Disk Group

Followed the procedure in Create New ASM Disk Group Using ASMCA to add the FRA disk group as /dev/sdc .

Install Oracle 12c RDBMS Software

Followed the procedure in Install Oracle RDBMS 12.1.0.2 With Grid Infrastructure .