oracledba.help

ASM Installation for Stand-Alone Database

<- Install

Overview

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

Prerequisites

TOC

Directory and File Prep

As root user:

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

As grid user:

 1. Download files to your local disk.
 2. Copy install file (ex: linuxx64_12201_grid_home.zip) to /u01/app/12.2.0.1/grid
 3. cd /u01/app/12.2.0.1/grid
 4. unzip linuxx64_12201_grid_home.zip

Procedure

Log into GUI as the grid user.

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

Configuration Option

 (x) Configure Oracle Grid Infrastructure for a Standalone Server (Oracle Restart)

Create ASM Disk Group

 Generally use:
 • Disk group name: GRID(x) External = if not needing ASM based redundancy. 
(x) Normal = if needing ASM based redundancy. • Allocation Unit Size = 4mb OCR and Voting disk data... Select Disks [ ] /dev/sd_ <= Select disk(s) to be used for the GI (+GRID). [x] Configure Oracle ASM Filter Driver

Other disks groups can be added later (Ex: +DATA, +FRA etc.).

Do Not Enable if Using UDev!

[ ] Configure Oracle ASM Filter Driver

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/12.2.0.1
 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...
  • You will be prompted to run root scripts.
  • Look for the below type entry at the end of script output to ensure it ran OK:
    Successfully configured Oracle Restart for a standalone server
  • Select  when GI installation process completed.

Create grid BASH User Profile (.bashrc)

Uncomment ORACLE_SID entry setting it to the ASM instance name on this system (ASM, 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

#ORACLE_SID=+ASM; 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 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 to manage your ASM environment. You'll want to create the remainder of your ASM disks. Example: DATA, FRA etc.

To launch run:
[grid] asmca &

Oracle Docs