11gR2 RAC on Sun Solaris SPARC 10 64 bit

Introduction :

Overview of new concepts in 11gR2 Grid Infrastructure

SCAN

  • The single client access name (SCAN) is the address used by all clients connecting to the cluster.
  • The SCAN name is a domain name registered to three IP addresses, either in the domain name service (DNS) or the Grid Naming Service (GNS).
  • The SCAN name eliminates the need to change clients when nodes are added to or removed from the cluster.
  • Clients using SCAN names can also access the cluster using EZCONNECT.
  • The Single Client Access Name (SCAN) is a domain name that resolves to all the addresses allocated for the SCAN name.
  • Allocate three addresses to the SCAN name.
  • During Oracle grid infrastructure installation, listeners are created for each of the SCAN addresses, and Oracle grid infrastructure controls which server responds to a SCAN address request.
  • Provide three IP addresses in the DNS to use for SCAN name mapping. This ensures high availability.
  • The SCAN addresses need to be on the same subnet as the VIP addresses for nodes in the cluster.
  • The SCAN domain name must be unique within your corporate network.
OCR and Voting on ASM storage

The ability to use ASM diskgroups for Clusterware OCR and Voting disks is a new feature in the Oracle
Database 11g Release 2 Grid Infrastructure.If you choose this option and ASM is not yet configured, OUI
launches ASM configuration assistant to configure ASM and a diskgroup.

Passwordless automatic SSH connectivity

If SSH has not been configured prior the Installation, you can prompt the installer to this for you. The
configuration can be tested as well.

Clusterware and ASM share the same Oracle Home

The clusterware and ASM share the same home thus we call it Grid Infrastructure home (prior 11gR2 ASM
and RDBMS could be installed either in same Oracle home or in separate Oracle homes)

Hardware Requirements
  • Physical memory (at least 1.5 gigabyte (GB) of RAM)
# /usr/sbin/prtconf | grep "Memory size"
  • An amount of swap space equal the amount of RAM
# /usr/sbin/swap -s
  • Temporary space (at least 1 GB) available in /tmp
# df -h /tmp
  • A processor type (CPU) that is certified with the version of the Oracle software being installed
  • At minimum of 1024 x 786 display resolution, so that Oracle Universal Installer (OUI) displays correctly
  • All servers that will be used in the cluster have the same chip architecture, for example, all SPARC processors or all x86 64-bit processors
  • Disk space for software installation locations

You will need at least 4.5 GB of available disk space for the Grid home directory, which includes both the binary files for Oracle Clusterware and Oracle Automatic Storage Management (Oracle ASM) and their associated log files, and at least 4 GB of available disk space for the Oracle Database home directory.

  • Shared disk space

An Oracle RAC database is a shared everything database. All data files, control files, redo log files, and the server parameter file (SPFILE) used by the Oracle RAC database must reside on shared storage that is accessible by all the Oracle RAC database instances. The Oracle RAC installation that is described in this guide uses Oracle ASM for the shared storage for Oracle Clusterware and Oracle Database files. The amount of shared disk space is determined by the size of your database.

Software Requirements List for Solaris Operating System (SPARC 64-Bit):

Solaris 10 U6 (5.10-2008.10) or later
Packages and Patches for all installations
Solaris 10
SUNWarc
SUNWbtool
SUNWcsl
SUNWhea
SUNWlibC
SUNWlibm
SUNWlibms
SUNWsprot
SUNWtoo
SUNWi1of (ISO8859-1)
SUNWi1cs (ISO8859-15)
SUNWi15cs
SUNWxwfnt
119963-14 or later (SunOS? 5.10: Shared library patch for C++)
120753-06 or later (SunOS? 5.10: Microtasking libraries (libmtsk) patch)
139574-03 or later (SunOS? 5.10: file crle ldd stings elfdump patch, required for Oracle Clusterware))

For e.g :

# pkginfo SUNWarc
# patchadd –d | grep 11963

IP Address Requirements

  • A public IP address for each node
  • A virtual IP address for each node
  • Three single client access name (SCAN) addresses for the cluster.

(Define the SCAN in your corporate DNS (Domain Name Service) You must ask your network administrator
to create a single name, that resolves to 3 IP addresses using a round robin algorithm. The IP addresses must
be on the same subnet as your public network in the cluster.)

Installation method

This document details the steps installing a 2-node Oracle 11gR2 RAC cluster on Solaris:

  • The Oracle Grid Homes binaries are installed on the local disk of each of the RAC nodes.
  • The files required by Oracle Clusterware (OCR and Voting disks) are stored in ASM -The installation is explained without GNS and IPMI
Prepare the cluster nodes for Oracle RAC
User Accounts
Create OS groups using the command below Enter commands as the root user:
#/usr/sbin/groupadd oinstall
#/usr/sbin/groupadd dba
#/usr/sbin/groupadd asmadmin
#/usr/sbin/groupadd asmdba
#/usr/sbin/groupadd asmoper
Create the users that will own the Oracle software using the commands:
#/usr/sbin/useradd -g oinstall -G asmadmin,asmdba,asmoper -d /u01/oragrid -m grid
#/usr/sbin/useradd -g oinstall -G dba,asmdba -d /u01/oracle -m oraprod
Note: you might have to disable aufotfs temporary to be able to create the home folders:
#svcadm disable autofs
Set the password for the oracle account using the following command. Replace password with your own
password.
passwd oraprod
Changing password for user oracle.
New UNIX password: xxxxx
retype new UNIX password: xxxx
passwd: all authentication tokens updated successfully.
passwd oragrid
Changing password for user oracle.
New UNIX password:xxxx
retype new UNIX password: xxxx
passwd: all authentication tokens updated successfully
Repeat Step 1 through Step 3 on each node in your cluster
Edit hosts file

NOTE: The SCAN VIP MUST NOT be in the /etc/hosts file. This will result in only 1 SCAN VIP for the
entire cluster.

# cat /etc/hosts
#
#
# Public IPs
127.0.0.1 localhost
192.168.10.67 rac1.ods.com rac1
192.168.10.68 rac2.ods.com rac2
# Private IPs
192.168.0.100 rac1-priv.ods.com rac1-priv
192.168.0.101 rac2-priv.ods.com rac2-priv
# VIP
192.168.10.69 rac1-vip.ods.com rac1-vip
192.168.10.70 rac2-vip.ods.com rac2-vip

SCAN IP’s used
192.168.10.71/72/73 — rac.ods.com ( Registered in DNS not in hosts file)

Configuring Kernel Parameters

We need to set the following kernel parameters to values greater than or equal to the recommended values
shown below.

#vi /etc/system
set noexec_user_stack=1
set semsys:seminfo_semmni=100
set semsys:seminfo_semmns=1024
set semsys:seminfo_semmsl=256
set semsys:seminfo_semvmx=32767
set shmsys:shminfo_shmmax=4294967296
set shmsys:shminfo_shmmni =100
#init 6
Create the Oracle Inventory Directory

To create the Oracle Inventory directory, enter the following commands as the root user:

# mkdir -p /u01/11.2.0/oraInventory
# chown -R oragrid:oinstall /u01/11.2.0/oraInventory
# chmod -R 775 /u01/app/oraInventory
Creating the Oracle Grid Infrastructure Home Directory

To create the Grid Infrastructure home directory, enter the following commands as the root user:

# mkdir -p /u01/11.2.0/grid
# chown -R oragrid:oinstall /u01/11.2.0/grid
# chmod -R 775 /u01/11.2.0/grid
Creating the Oracle Base Directory

To create the Oracle Base directory, enter the following commands as the root user:

# mkdir -p /u01/app/
# mkdir /u01/app/cfgtoollogs --needed to ensure that dbca is able to run after the rdbms installation.
# chown -R oraprod:oinstall /u01/app/
# chmod -R 775 /u01/app/
Creating the Oracle RDBMS Home Directory

To create the Oracle RDBMS Home directory, enter the following commands as the root user:

# mkdir -p /u01/app/product/11.2.0/db_1
# chown -R oraprod:oinstall /u01/app/product/11.2.0/db_1
# chmod -R 775 /u01/app/product/11.2.0/db_1
Prepare the shared storage for Oracle RAC
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s1
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s2
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s3
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s4
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s5
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s6
# chown oragrid:oinstall /dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s*
# chmod 660 /dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s*
Oracle Grid Infrastructure Install
Basic Grid Infrastructure Install

Set the DISPLAY either on the server or through SSH forwarding (Using Xming Software and putty)

#su - oragrid
./runInstaller
Execute orainstR00t.sh and root.sh on all RAC NODES.
bash-3.00# ./orainstRoot.sh
Changing permissions of /u01/11.2.0/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/11.2.0/oraInventory to oinstall.
The execution of the script is complete.
bash-3.00# ./root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= oragrid
ORACLE_HOME= /u01/11.2.0/grid
Enter the full pathname of the local bin directory: [/usr/local/bin]:
Creating /usr/local/bin directory...
Copying dbhome to /usr/local/bin ...
Copying oraenv to /usr/local/bin ...
Copying coraenv to /usr/local/bin ...
Creating /var/opt/oracle/oratab file...
Entries will be added to the /var/opt/oracle/oratab file as needed by
Database Configuration Assistant when a database is created
Finished running generic part of root script.
Now product-specific root actions will be performed.
Using configuration parameter file: /u01/11.2.0/grid/crs/install/crsconfig_params
Creating trace directory
User ignored Prerequisites during installation
OLR initialization – successful
root wallet
root wallet cert
root cert export
peer wallet
profile reader wallet
pa wallet
peer wallet keys
pa wallet keys
peer cert request
pa cert request
peer cert
pa cert
peer root cert TP
profile reader root cert TP
pa root cert TP
peer pa cert TP
pa peer cert TP
profile reader pa cert TP
profile reader peer cert TP
peer user cert
pa user cert
Adding Clusterware entries to inittab
CRS-2672: Attempting to start 'ora.mdnsd' on 'rac1'
CRS-2676: Start of 'ora.mdnsd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'rac1'
CRS-2676: Start of 'ora.gpnpd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'rac1'
CRS-2672: Attempting to start 'ora.gipcd' on 'rac1'
CRS-2676: Start of 'ora.cssdmonitor' on 'etrac1' succeeded
CRS-2676: Start of 'ora.gipcd' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'rac1'
CRS-2672: Attempting to start 'ora.diskmon' on 'rac1'
CRS-2676: Start of 'ora.diskmon' on 'rac1' succeeded
CRS-2676: Start of 'ora.cssd' on 'rac1' succeeded
ASM created and started successfully.
Disk Group CRS created successfully.
clscfg: -install mode specified
Successfully accumulated necessary OCR keys.
Creating OCR keys for user 'root', privgrp 'root'..
Operation successful.
CRS-4256: Updating the profile
Successful addition of voting disk 3ac4a8d317664f69bf93e37655b7039f.
Successfully replaced voting disk group with +CRS.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 3ac4a8d317664f69bf93e37655b7039f
/dev/rdsk/c3t60060160DC302C001B4D9758B623E111d0s1) [CRS]
Located 1 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'rac1'
CRS-2676: Start of 'ora.asm' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.CRS.dg' on 'rac1'
CRS-2676: Start of 'ora.CRS.dg' on 'rac1' succeeded
CRS-2672: Attempting to start 'ora.registry.acfs' on 'rac1'
CRS-2676: Start of 'ora.registry.acfs' on 'rac1' succeeded

RDBMS Software Install

#su - oraprod
Go to the software location
set the DISPLAY variable
$./runInstaller
Run ASMCA to create diskgroups
As the grid user start the ASM Configuration Assistant (ASMCA)
#su - orgrid
$exprot ORACLE_HOME= /u01/11.2.0/grid/
$export ORACLE_BASE=/u01/11.2.0
$export ORACLE_SID=+ASM1
$export PATH=$PATH:$ORACLE_HOME/bin
$./asmca
Create database using dbca

As the oraprod user start the Database Configuration Assistant (DBCA)

#su – oraprod
$exprot ORACLE_HOME= /u01/app/product/11.2.0/db_1
$export ORACLE_BASE=/u01/app
$export PATH=$PATH:$ORACLE_HOME/bin
$./dbca
Tagged with →  
Share →
0 comments
Skip to toolbar