oracledba.help works great on your mobile device too!

oracledba.help

Oracle 12c GI Cluster Installation

<- Install

Overview

What follows is the most common way to install the Oracle 12c (12.2.0.1) Grid Infrastructure (GI) for Linux enterprise environments. These instructions assume ASMFD used to configure and manage your disks. Change values in the examples to match your environment.

Prerequisites

TOC

Directory and File Prep

As root user:

 mkdir -p /u01/app/12.2.0.1/grid
 chown -R grid:oinstall /u01/app/12.2.0.1
 chown -R grid:oinstall /u01/app/12.2.0.1/grid

As grid user:

 Copy install file (ex: linuxx64_12201_grid_home.zip) to /u01/app/12.2.0.1/grid
 cd /u01/app/12.2.0.1/grid
 unzip linuxx64_12201_grid_home.zip

GI Installation

  • Ensure other initial nodes are up and can connect OK (ping, nslookup etc.).
  • Run the Cluster Verification Script.
    Ex: grid> /u01/app/12.2.0.1/grid/runcluvfy.sh stage -pre crsinst -n rac01,rac02 -fixup -verbose
  • ETA on install about 1.5 hours for a 2-node RAC.

Procedure

As grid user from node1:

 export ORACLE_HOME=/u01/app/12.2.0.1/grid
 cd $ORACLE_HOME
 ./gridSetup.sh

Configuration Option

 (x) Configure Oracle Grid Infrastructure for a New Cluster

Cluster Configuration

 (x) Configure an Oracle Standalone Cluster

Product Languages

 Press 

Grid Plug and Play

 Cluster Name: rac-cluster
 SCAN Name:    rac-scan
 SCAN Port:    1521
 [ ] Configure GNS

Cluster Node Information

 Should see current system. Example: rac01 | rac01-vip 
 
 (x) Add a single node
 Public Hostname:  rac02.localdomain
 Node Role: HUB
 Virtual Hostname: rac02-vip.localdomain
    
    OS Username: grid 
    OS PW:       ********
     ...
    Msg displayed: 
    "Successfully established passwordless SSH connectivity between the selected nodes."
  ... Shows OK (already established)
  ... Verification process runs for a moment

Network Interface Usage

 192.168.56.0  = Public        (pubnet)
 192.168.10.0  = ASM & Private (privnet)

Storage Option

 (x) Configure ASM using block devices

Grid Infrastructure Management Repository (GIMR)

 Create a separate ASM group for GIMR?
 (x) No

The GIMR resources will be placed in the GRID ASM disk group.

Create ASM Disk Group
Generally use:

  • (x) External = if not needing ASM based redundancy.
    (x) Normal = if needing ASM based redundancy.
  • Allocation Unit Size = 4mb
 OCR and Voting disk data...
 Disk group name: GRID

 Select Disks  
 [ ] /dev/sd_  <= Select disk(s) to be used for the GI (+GRID).

 [x] Configure Oracle ASM Filter Driver

Other disks (for +DATA, +FRA...) added later.

Do Not Enable if Using UDev!

[ ] Configure Oracle ASM Filter Driver

GIMR Data Disk Group (requires 40gb)

 Disk group name: MGMT
 [ ] /dev/sd_   <= Select disk(s) to be used for the GIMR (+MGMT).

If separate GIMR disk group enabled you will get this prompt.

ASM Password

  (x) Use same passwords for these accounts.

Failure Isolation

 (x) Do not use Intelligent Platform Management Interface (IPMI)

Management Options

 [ ] Register with Enterprise Manager (EM) Cloud Control

Operating System Groups

 Oracle ASM Administrator: asmadmin
 Oracle ASM DBA:           asmdba
 Oracle ASM Operator       asmoper

Installation Location

 Oracle base:       /u01/app/grid
 Software location: /u01/app/12.2.0.1/grid (displayed)

Create Inventory

  /u01/app/oraInventory

Root script execution

  [ ] Automatically run configuration scripts
  Disabling this makes it easier to debug.

Prerequisites Check

  Fix any issues then return to this point.
  If everything acceptable then press 

Summary

 Press 

Process runs...

  • If you run top on your remote node you should see the grid user
    running ractrans commands when remote operations running.

  • You will be prompted to run root scripts on each node.
    /u01/app/oraInventory/orainstRoot.sh
    /u01/app/12.2.0.1/grid/root.sh

    Look for the below type entry at the end of process to ensure it ran OK:
    CLSRSC-325: Configure Oracle Grid Infrastructure for a Cluster ... succeeded

 Select  when GI installation process completed.

Log locations:
/u01/app/grid/diag/crs/<node>/crs/trace/alert.log
/u01/app/grid/crsdata/<node>/crsconfig/rootcrs_<node>_<date>.log

Create grid BASH User Profile (.bashrc)

Uncomment ORACLE_SID entry setting it to the ASM instance name on this system (ASM1, ASM2 ...).

umask 022
# Get the aliases and functions (if .bash_profile)
#if [ -f ~/.bashrc ]; then
#	. ~/.bashrc
#fi

# Global Definitions
if [ -f /etc/bashrc ]; then
   . /etc/bashrc
fi

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

#TBD ORACLE_SID=+ASM1; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/12.2.0.1/grid; export ORACLE_HOME
ORACLE_TERM=xterm; export ORACLE_TERM

PATH=$ORACLE_HOME/bin:/usr/bin:/bin:/usr/local/bin:.local/bin:$HOME/bin
export PATH

export TEMP=/tmp
export TMPDIR=/tmp

# Aliases - Common
alias cl='clear;crontab -l'
alias l9='ls -alt | head -9' 
alias l20='ls -alt | head -20'
alias l50='ls -alt | head -50'
alias tf='date;ls -l|wc -l'

# Grid
alias clog='tail -f $ORACLE_BASE/diag/crs/$HOSTNAME/crs/trace/alert.log'
alias cdbase='cd $ORACLE_BASE'
alias cdhome='cd $ORACLE_HOME'
alias cdadmin='cd $ORACLE_BASE/diag/asm/$ORACLE_SID*/$ORACLE_SID*/trace'
alias cdnet='cd $ORACLE_HOME/network/admin'
alias sqp='rlwrap sqlplus / as sysasm'
alias src='source $HOME/.bashrc'

ASM Configuration Assistant

After the GI has been installed and BASH grid user profile updated you can use the ASM Configuration Assistant to manage your ASM environment. You'll want to create the remainder of your ASM disks for instance.

To launch run:
[grid] asmca &

Create Disk Groups

  1. Select Disk Groups
  2. Select the [Create] button.
    • Disk Group Name: DATA
    • Redundancy: (x) External
    • [x] AFD:DISK02 <= example
    • [OK] button.
  3. Select Disk Groups
  4. Select the [Create] button.
    • Disk Group Name: FRA
    • Redundancy: (x) External
    • [x] AFD:DISK03 <= example
    • [OK] button.

Cluster Verification Script DL