ASM Installation for Standalone Database
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]
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 --------------------------------------------------------------------------------