How To Install Oracle 10g RAC On Solaris 10 - Part 2 of 4

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

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

IP ADDRESSES & HOST NAMES

Node 1 Host Name : HOST1
Node 1 IP Address : 192.168.1.1
Node 1 Oracle VIP Host Name : HOST1-vip
Node 1 Oracle VIP IP Address : 192.168.1.2
Node 1 Heart-beat Host Name : HOST1-hb
Node 1 Heart-beat IP Address : 192.168.2.1
Node 2 Host Name : HOST2
Node 2 IP Address : 192.168.1.3
Node 2 Oracle VIP Host Name : HOST2-vip
Node 2 Oracle VIP IP Address : 192.168.1.4
Node 2 Heart-beat Host Name : HOST2-hb
Node 2 Heart-beat IP Address : 192.168.2.2

SOFTWARE VERSIONS & LOCATIONS

Clusterware Source Software : HOST1:/u02/SOFTWARE/CLUSTER/10.2
Clusterware Source Patch Software : HOST1:/u02/SOFTWARE/CLUSTER/PATCHES
Node 1 Clusterware $HOME : HOST1:/u01/app/crs/product/10.2.0
Node 2 Clusterware $HOME : HOST2:/u01/app/crs/product/10.2.0
ASM Source Software : HOST1:/u02/SOFTWARE/DATABASE/10.2
ASM Source Patch Software : HOST1:/u02/SOFTWARE/DATABASE/PATCHES
Node 1 ASM $HOME : HOST1:/u01/app/asm/product/10.2.0
Node 2 ASM $HOME : HOST2:/u01/app/asm/product/10.2.0
Database Source Software : HOST1:/u02/SOFTWARE/DATABASE/10.2
Database Source Patch Software : HOST1:/u02/SOFTWARE/DATABASE/PATCHES
Node 1 Database $HOME : HOST1:/u01/app/oracle/product/10.2.0
Node 2 Database $HOME : HOST2:/u01/app/oracle/product/10.2.0
Node 1 OPatch Location : HOST1:/u02/SOFTWARE/OPATCH/OPatch
Node 2 OPatch Location : HOST2:/u02/SOFTWARE/OPATCH/OPatch

DISK INFORMATION

OCR Location : /dev/rdsk/emcpower0a
Voting Disk Location : /dev/rdsk/emcpower0b
Redundancy Method : External
ASM SPFile : /dev/rdsk/emcpower1a
ASM Password File : /dev/rdsk/emcpower1b
Database SPFile : /dev/rdsk/emcpower2a
Database Password File : /dev/rdsk/emcpower2b
Database Primary Disk Group : /dev/rdsk/emcpower3a - +DATA
Database Recovery Disk Group : /dev/rdsk/emcpower4a - +REC

CLUSTER, INSTANCE & DATABASE NAMES

Cluster Name : CRS_NAME
Node 1 Instance Name : SID01
Node 2 Instance Name : SID02
RAC Database Name : SID00
ASM Name : ASM_NAME
Node 1 ASM Instance Name : +ASM1
Node 2 ASM Instance Name : +ASM2

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


ASMInstall_01.jpg
  • Click Next.

ASMInstall_02.jpg
  • Select Enterprise Edition.
  • Click Next.

ASMInstall_03.jpg
  • 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.

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

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

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

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

ASMInstall_08.jpg
  • Review Summary.
  • Click Install.

ASMInstall_09.jpg
  • Wait for approximately 10 mins…

ASMInstall_10.jpg
  • Click Next.

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

ASMInstall_12.jpg
  • Click Exit.

ASMInstall_13.jpg
  • Click Yes.

EXAMPLE ASM PATCH INSTALL


ASMPatch_01.jpg
  • Click Next.

ASMPatch_02.jpg
  • 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.

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

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

ASMPatch_05.jpg
  • Clear Enable OCM tick box.
  • Click Next.

ASMPatch_06.jpg
  • Review Summary.
  • Click Install.

ASMPatch_07.jpg
  • Wait for approximately 10 mins…

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

ASMPatch_09.jpg
  • Click Exit.

ASMPatch_10.jpg
  • Click Yes.

© copyright 2001-2014 ABCdba.com | all rights reserved