ASM Installation, ASM Patching & ASM Build

BACKGROUND & OVERVIEW

The following documentation provides instructions for building an Oracle Real Application Cluster (RAC) database residing on a Sun Solaris 10 (Version 5.10) operating system.

This document is Part 2 of a 4-Part Installation Guide.

ASSUMPTIONS & PRE-REQUISITES

This document expects and assumes the following:

• Part 1 of the How To Install Oracle 10g RAC On Solaris 10 guide has been completed successfully.
• The instructions are carried out by a qualified DBA, fully conversant with Oracle, including RAC.
• Access to the internet is available.
• All necessary client software, e.g. Telnet and X-Server is available.
• The necessary RAC software has been installed under /u02/SOFTWARE.
  • The guide assumes sub-directories of CLUSTER, COMPANION, DATABASE and OPATCH exist.
• The resultant database will be part of a RAC configuration.
• All references to SIDxx should be replaced with correct database name.
• All $variable references assume the .profile as described in the File Listings section has been implemented and run.
• All root.sh references are used to indicate a script to be submitted as root has to be run. The exact name of the script may vary depending upon which piece of software is being installed or patched. The exact name of the script to be used will be displayed by the GUI.
• The screen shots displayed are for guidance only, the values displayed on them do not necessarily correspond to the values used in the worked examples.

SETTINGS USED FOR THE WORKED EXAMPLE

• For the purposes of the Step-By-Step Guide a worked example has been used.

• The following settings and values have been used in the example:

IP ADDRESSES & HOST NAMES

SOFTWARE VERSIONS & LOCATIONS

DISK INFORMATION

CLUSTER, INSTANCE & DATABASE NAMES

STEP-BY-STEP GUIDE

1. Configure the DISPLAY variable, if not already set.
2. Start x-server, if not already running.
3. Start ASM installation…
4. Run runInstaller and follow the instructions as demonstrated in the Example ASM Install section below.
   • On HOST1
     • export ORACLE_BASE=/u01/app/oracle
     • export ORACLE_HOME=/u01/app/asm/product/10.2.0
     • cd /u02/SOFTWARE/DATABASE/10.2
     • ./runInstaller
     • Required answers and actions - see the Example ASM Install section for the detailed plan:
       • OraAsm10g_home1
       • /u01/app/asm/product/10.2.0
       • ASM SYS password
       • ASM disk group name
       • ASM disk path name(s)
       • Run root.sh on each node.
5. Configure the DISPLAY variable, if not already set.
6. Start x-server, if not already running.
7. Start ASM Patch installation…
8. Run runInstaller and follow the instructions as demonstrated in the Example ASM Patch section below.
   • On HOST1
     • export ORACLE_BASE=/u01/app/oracle
     • export ORACLE_HOME=/u01/app/asm/product/10.2.0
     • srvctl stop asm -n HOST1
     • srvctl stop asm -n HOST2
     • srvctl stop listener -n HOST1
     • srvctl stop listener -n HOST2
     • cd /u02/SOFTWARE/DATABASE/PATCHES/10.2.0.4/Disk1
     • ./runInstaller
     • Required answers and actions - see the Example ASM Patch section for the detailed plan:
       • OraAsm10g_home1
       • /u01/app/asm/product/10.2.0
       • Run root.sh on each node.
     • srvctl start listener -n HOST1
     • srvctl start listener -n HOST2
     • srvctl start asm -n HOST1
     • srvctl start asm -n HOST2
9. Tidy up the ASM installation…
   • On HOST1
     • . oraenv
       • +ASM1
       • /u01/app/asm/product/10.2.0
     • sqlplus / as sysdba
       • CREATE DISKGROUP rec EXTERNAL REDUNDANCY DISK '/dev/rdsk/emcpower2a';
       • SHUTDOWN IMMEDIATE;
       • EXIT
     • cd /u01/app/asm/product/10.2.0/dbs
       • Update the init+ASM.ora file with the following entry:
         • asm_diskgroups='DATA','REC'
     • sqlplus / as sysdba
       • STARTUP
       • CREATE spfile='/dev/rdsk/emcpower2a' FROM pfile;
       • SHUTDOWN IMMEDIATE;
       • EXIT
     • Replace the init+ASM1.ora with one containg the line - spfile='/dev/rdsk/emcpower2a'
     • sqlplus / as sysdba
       • STARTUP
       • EXIT
   • On HOST2
     • . oraenv
       • +ASM2
       • /u01/app/asm/product/10.2.0
     • cd /u01/app/asm/product/10.2.0/dbs
     • Replace the init+ASM2.ora with one containg the line - spfile='/dev/rdsk/emcpower2a'
     • sqlplus / as sysdba
       • SHUTDOWN IMMEDIATE;
       • STARTUP
       • EXIT
10. ASM has now been installed, patched and built - now go to Part 3.

EXAMPLE ASM INSTALL

• Click Next.

• Select Enterprise Edition.
• Click Next.

• Enter Name of the ASM_HOME.
  • If unsure, check the value by clicking Installed Products.
• Enter full Path of the ASM_HOME directory.
• Click Next.

• Select Cluster Installation.
• Click Select All.
• Click Next.

• Ensure there are 0 requirements to be verified.
• Click Next.

• Select Configure ASM.
• Enter ASM SYS Password - twice
• Click Next.

• Enter Disk Group Name.
• Select External Redundancy.
• Select Candidate Disks.
• Select Disk Path Name(s).
• Click Next.

• Review Summary.
• Click Install.

• Wait for approximately 10 mins…

• Click Next.

• Run the root.sh scripts as instructed. - use default answers.
• Click Next.

• Click Exit.

• Click Yes.

EXAMPLE ASM PATCH INSTALL

• Click Next.

• Enter Name of the ASM_HOME.
  • If unsure, check the value by clicking Installed Products.
• Enter full Path of the ASM_HOME directory.
• Click Next.

• Select Cluster Installation.
• Click Select All.
• Click Next.

• Ensure there are 0 requirements to be verified.
• Click Next.

• Clear Enable OCM tick box.
• Click Next.

• Review Summary.
• Click Install.

• Wait for approximately 10 mins…

• Run the root.sh scripts as instructed. - use default answers.
• Click Next.

• Click Exit.

• Click Yes.