ASM Installation for Standalone Database

<- Legacy

TOC

Overview

What follows is the most common way to install the Oracle 12c (12.1.0.2) ASM via the Grid Infrastructure (GI) for Linux enterprise environments (AKA Oracle Restart).

Prerequisites

• Your system has at least 4512 mb of RAM.
• LINUX OS Prerequisites performed.
• Linux disk partitions have been created (fdisk).
• Disks Configured via UDev
• Confirm shared disks available and have correct privileges. The links should be owned by root and devices by grid:asmadmin.
  • ls -al /dev/asm*
  • ls -rlt /dev/sd?1
• Download files to your local disk.

Procedure

Run Installer

 Log into GUI as the grid user.
 cd /u01/orasw/grid
 ./runInstaller

Installation Option

 (x) Install and Configure Oracle Grid Infrastructure for a Standalone Server

Product Languages

 [Next]

Create ASM Disk Group
If Udev used [Change Discovery Path] to: /dev/asm-disk*

 Generally use:
 • Disk group name: GRID
 • Redundancy: 
   (x) External = if not needing ASM based redundancy.
   (x) Normal   = if needing ASM based redundancy.
 • Allocation Unit Size = 1mb

 Add Disks  
   ☑ /dev/asm-disk01 🠈 Select disk(s) to be used for the GI (+GRID).
   ☐ /dev/asm-disknn ...Other disks for +DATA and +FRA added later.

ASM Password

  (x) Use same passwords for these accounts.

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/grid/product/12.1.0.2/grid

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.

Summary

  If everything acceptable then press 

Install Product

  Process runs...
  • You will be prompted to run root scripts.
  • Look for the below type entry at the end of 2nd script output to ensure it ran OK:
    Successfully configured Oracle Restart for a standalone server

Finish

  Select  when GI installation process completed.

Create grid BASH User Profile (.bashrc)

umask 022

# 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
fi

ORACLE_SID=+ASM; export ORACLE_SID
ORACLE_BASE=/u01/app/grid; export ORACLE_BASE
ORACLE_HOME=/u01/app/grid/product/12.1.0.2/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 asmlog='tail -f $ORACLE_BASE/log/diag/asmcmd/user_grid/$HOSTNAME/alert/alert.log'
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 (asmca) to manage your ASM environment. You'll want to create the remainder of your ASM disks for instance.

Create Disk Groups

If Udev used [Change Discovery Path] to: /dev/asm-disk*

Launch ASMCA

 su - grid
 OS> asmca &

Create DATA Group

 Select [Create]
 Disk Group Name: DATA
 Redundancy:      🖸 External
                  ☑ /dev/asm-disk02 🠈 Select corresponding disk(s) for group.
 [OK]

Create FRA Group

 Select [Create]
 Disk Group Name: FRA
 Redundancy:      🖸 External
                  ☑ /dev/asm-disk03 🠈 Select corresponding disk(s) for group.
 [OK]

Oracle Docs

GI Services Post Install

--------------------------------------------------------------------------------
Name           Target  State        Server                   State details
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.DATA.dg
               ONLINE  ONLINE       lnxsb                    STABLE
ora.FRA.dg
               ONLINE  ONLINE       lnxsb                    STABLE
ora.GRID.dg
               ONLINE  ONLINE       lnxsb                    STABLE
ora.LISTENER.lsnr
               ONLINE  ONLINE       lnxsb                    STABLE
ora.asm
               ONLINE  ONLINE       lnxsb                    Started,STABLE
ora.ons
               OFFLINE OFFLINE      lnxsb                    STABLE
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.cssd
      1        ONLINE  ONLINE       lnxsb                    STABLE
ora.diskmon
      1        OFFLINE OFFLINE                               STABLE
ora.evmd
      1        ONLINE  ONLINE       lnxsb                    STABLE
--------------------------------------------------------------------------------