by Vinh Tran
Published July 2012
Using Oracle RAC 11.2.0.3, Oracle Solaris 11, and Oracle Solaris Cluster 4.0
How to create an Oracle Solaris Zones cluster, install and configure Oracle Grid Infrastructure 11.2.0.3 and Oracle Real Application Clusters (Oracle RAC) 11.2.0.3 in the zone cluster, and create an Oracle Solaris Cluster 4.0 resource for the Oracle RAC instance.
z11gr2A
This article describes how to create an Oracle Solaris Zones cluster in an Oracle Solaris Cluster environment on Oracle Solaris 11, install and configure Oracle Grid Infrastructure 11.2.0.3 and Oracle Real Application Clusters (Oracle RAC) 11.2.0.3 in the zone cluster, and create an Oracle Solaris Cluster 4.0 resource for the Oracle RAC instance.
This is one of three similar articles that explain how to do the same thing but with different versions of the software. This table summarizes them:
Article | RAC Version | Solaris Version | Cluster Version |
---|---|---|---|
How to Deploy Oracle RAC 11.2.0.3 on Oracle Solaris Zone Clusters | 11.2.0.3 | 10 | 3.3 |
How to Deploy Oracle RAC 12c on an Exclusive-IP Oracle Solaris Zones Cluster | 12c | 11.2 | 4.2 |
Oracle Solaris Cluster provides the capability to create high-availability zone clusters. A zone cluster consists of several Oracle Solaris Zones, each of which resides on its own separate server; the zones that comprise the cluster are linked together into a single virtual cluster. Because zone clusters are isolated from each other, they provide increased security. Because the zones are clustered, they provide high availability for the applications they host. Multiple zone clusters can exist on single physical cluster, providing a means to consolidate multicluster applications on a single cluster.
Installing Oracle RAC inside a zone cluster allows you to have separate database versions or separate deployments of the same database (for example, one for production and one for development). Using this architecture, you can also deploy different parts of your multitier solution into different virtual zone clusters. For example, you could deploy Oracle RAC and an application server in different zones of the same cluster. This approach allows you to isolate tiers and administrative domains from each other, while taking advantage of the simplified administration provided by Oracle Solaris Cluster.
For information on different configurations available for deploying Oracle RAC in a zone cluster, see the "Running Oracle Real Application Clusters on Oracle Solaris Zone Clusters" white paper.
This document describes the following procedures:
Note: This document is not a performance best practices guide and it does not cover the following topics:
Note: For information about installing Oracle Solaris Cluster 4.0, see "How to Install and Configure a Two-Node Cluster Using Oracle Solaris Cluster 4.0 on Oracle Solaris 11."
This article describes how to set up Oracle RAC in an Oracle Solaris Cluster four-node zone cluster configuration using Oracle Automatic Storage Management (see Figure 1).
Three significant steps have to be performed:
Figure 1. Four-Node Zone Cluster Configuration
Ensure that the following prerequisites have been met:
ha-cluster-full
package name./etc/system
file in the global zone. The following is an example of the recommended value:
shmsys:shminfo_shmmax 4294967295
set rlim_fd_cur=1024
/dev/did/rdsk
devices, are known. Listing 1 is an example of how to identify a shared disk from the global zone of any cluster node:
phyhost1# cldev status
=== Cluster DID Devices ===
Device Instance Node Status
--------------- ---- ------
/dev/did/rdsk/d1 phyhost1 Ok
/dev/did/rdsk/d10 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d14 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d15 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d16 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d17 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d18 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d19 phyhost2 Ok
/dev/did/rdsk/d2 phyhost1 Ok
/dev/did/rdsk/d20 phyhost2 Ok
/dev/did/rdsk/d21 phyhost3 Ok
/dev/did/rdsk/d22 phyhost3 Ok
/dev/did/rdsk/d23 phyhost4 Ok
/dev/did/rdsk/d24 phyhost4 Ok
/dev/did/rdsk/d6 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d7 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d8 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
/dev/did/rdsk/d9 phyhost1 Ok
phyhost2 Ok
phyhost3 Ok
phyhost4 Ok
Listing 1. Identifying a Shared Disk
The output shows that disks d6
, d7
, d8
, d9
, d10
, d14
, d15
, d16
, d17
, and d18
are shared by phyhost1
, phyhost2
, phyhost3
, and phyhost4
.
The following shared disks will be used for the Oracle Automatic Storage Management disk group to store Oracle Cluster Registry and voting files:
/dev/did/rdsk/d6s6
/dev/did/rdsk/d7s6
/dev/did/rdsk/d8s6
The following shared disks will be used for the Oracle Automatic Storage Management disk group to store data files:
/dev/did/rdsk/d9s6
/dev/did/rdsk/d10s6
/dev/did/rdsk/d14s6
/dev/did/rdsk/d15s6
In this example, slice 6 is 102 GB in size. Please check the Oracle Grid Infrastructure Installation Guide for disk size requirements.
vzhost1d
, IP address 10.134.35.99, is used for the SCAN IP address.vzhost1c-vip
, IP address 10.134.35.100, is used as the VIP address for vzhost1c
.vzhost2c-vip
, IP address 10.134.35.101, is used as the VIP address for vzhost2c
.vzhost3c-vip
, IP address 10.134.35.102, is used as the VIP address for vzhost3c
.vzhost4c-vip
, IP address 10.134.35.103, is used as the VIP address for vzhost4c.
Note: Do not manually plumb these IP addresses anywhere, including in the cluster, on the network.
sc_ipmp0
.
# ipmpstat -g
GROUP GROUPNAME STATE FDT INTERFACES
sc_ipmp0 sc_ipmp0 degraded 10.00s net0 [net1]
sysconfig
tool to create a system configuration profile: # sysconfig create-profile -o /var/tmp/zc2.xml -g location,identity,naming_services,users<
DNS Server IP address: 192.168.1.10
DNS Server IP address: 192.168.1.11
Search domain: us.oracle.com
Search domain: oracle.com
Search domain:
Domain Name: solaris.us.oracle.com
The software can find a name server only if that server is on the local subnet.
zone.cfg
with the content shown in Listing 2:
create
set zonepath=/export/zones/z11gR2A
set limitpriv ="default,proc_priocntl,proc_clock_highres"
add dedicated-cpu
set ncpus=16
end
add capped-memory
set physical=12g
set swap=12g
set locked=12g
end
add node
set physical-host=phyhost1
set hostname=vzhost1c
add net
set address=vzhost1c
set physical=e1000g0
end
end
add node
set physical-host=phyhost2
set hostname=vzhost2c
add net
set address=vzhost2c
set physical=e1000g0
end
end
add node
set physical-host=phyhost3
set hostname=vzhost3c
add net
set address=vzhost3c
set physical=e1000g0
end
end
add node
set physical-host=phyhost4
set hostname=vzhost4c
add net
set address=vzhost4c
set physical=e1000g0
end
end
add net
set address=vzhost1d
end
add net
set address=vzhost1c-vip
end
add net
set address=vzhost2c-vip
end
add net
set address=vzhost3c-vip
end
add net
set address=vzhost4c-vip
end
add device
set match="/dev/did/rdsk/d6s6"
end
add device
set match="/dev/did/rdsk/d7s6"
end
add device
set match="/dev/did/rdsk/d8s6"
end
add device
set match="/dev/did/rdsk/d9s6"
end
add device
set match="/dev/did/rdsk/d10s6"
end
add device
set match="/dev/did/rdsk/d14s6"
end
add device
set match="/dev/did/rdsk/d15s6"
end
add device
set match="/dev/did/rdks/d16s6"
end
add device
set match="/dev/did/rdsk/d17s6"
end
add device
set match="/dev/did/rdsk/d18s6"
end
Listing 2. Creating the zone.cfg
File
vzhost1d
, resolves to multiple IP addresses, configure a separate global net resource for each IP address that the SCAN host name resolves to. For example, if the SCAN resolves to three IP addresses (10.134.35.97, 10.134.35.98, and 10.134.35.99), add the following global net resource to the zone.cfg
file.
add net
set address=10.134.35.97
end
add net
set address=10.134.35.98
end
add net
set address=10.134.35.99
end
root
, run the commands shown in Listing 3 from one node to create the cluster:
# clzonecluster configure -f /var/tmp/zone.cfg z11gr2a
# clzonecluster install -c /var/tmp/zc2.xml z11gr2A
# clzonecluster status
=== Zone Clusters ===
--- Zone Cluster Status ---
Name Node Name Zone HostName Status Zone Status
---- --------- ------------- ------ -----------
z11gr2A phyhost1 vzhost1c Offline Installed
phyhost2 vzhost2c Offline Installed
phyhost3 vzhost3c Offline Installed
phyhost4 vzhost4c Offline Installed
# clzc boot z11gr2A
# clzc status
=== Zone Clusters ===
--- Zone Cluster Status ---
Name Node Name Zone HostName Status Zone Status
---- --------- ------------- ------ -----------
z11gr2A phyhost1 vzhost1c Online Running
phyhost2 vzhost2c Online Running
phyhost3 vzhost3c Online Running
phyhost4 vzhost4c Online Running
Listing 3. Creating the Oracle Solaris Zone Cluster
As root
, perform the following steps from one node to create the Oracle RAC framework:
clsetup
from one global zone cluster node, as shown in Listing 4.
# /usr/cluster/bin/clsetup
*** Main Menu ***
Please select from one of the following options:
1) Quorum
2) Resource groups
3) Data Services
4) Cluster interconnect
5) Device groups and volumes
6) Private hostnames
7) New nodes
8) Other cluster tasks
?) Help with menu options
q) Quit
Option: 3
*** Data Services Menu ***
Please select from one of the following options:
* 1) Apache Web Server
* 2) Oracle
* 3) NFS
* 4) Oracle Real Application Clusters
* 5) SAP Web Application Server
* 6) Highly Available Storage
* 7) Logical Hostname
* 8) Shared Address
* ?) Help
* q) Return to the Main Menu
Option: 4
*** Oracle Solaris Cluster Support for Oracle RAC ***
Oracle Solaris Cluster provides a support layer for running Oracle
Real Application Clusters (RAC) database instances. This option allows
you to create the RAC framework resource group, storage resources,
database resources and administer them, for managing the Oracle
Solaris Cluster support for RAC.
After the RAC framework resource group has been created, you can use
the Oracle Solaris Cluster system administration tools to administer a
RAC framework resource group that is configured on a global cluster.
To administer a RAC framework resource group that is configured on a
zone cluster, instead use the appropriate Oracle Solaris Cluster
command.
Is it okay to continue (yes/no) [yes]?
Please select from one of the following options:
1) Oracle RAC Create Configuration
2) Oracle RAC Ongoing Administration
q) Return to the Data Services Menu
Option: 1
>>> Select Oracle Real Application Clusters Location <<<
Oracle Real Application Clusters Location:
1) Global Cluster
2) Zone Cluster
Option [2]: 2
>>> Select Zone Cluster <<<
From the list of zone clusters, select the zone cluster where you would like to
configure Oracle Real Application Clusters.
1) z11gr2A
?) Help
d) Done
Selected: [z11gr2A]
>>> Select Oracle Real Application Clusters Components to Configure <<<
Select the component of Oracle Real Application Clusters that you are configuring:
1) RAC Framework Resource Group
2) Storage Resources for Oracle Files
3) Oracle Clusterware Framework Resource
4) Oracle Automatic Storage Management (ASM)
5) Resources for Oracle Real Application Clusters Database Instances
Option [1]: 1
>>> Verify Prerequisites <<<
This wizard guides you through the creation and configuration of the Real Application
Clusters (RAC) framework resource group.
Before you use this wizard, ensure that the following prerequisites are met:
* All pre-installation tasks for Oracle Real Application Clusters are completed.
* The Oracle Solaris Cluster nodes are prepared.
* The data services packages are installed.
* All storage management software that you intend to use is installed and configured
on all nodes where Oracle Real Application Clusters is to run.
Press RETURN to continue
>>> Select Nodes <<<
Specify, in order of preference, a list of names of nodes where Oracle Real
Application Clusters is to run. If you do not explicitly specify a list, the list
defaults to all nodes in an arbitrary order.
The following nodes are available on the zone cluster z11skgxn:
1) vzhost1c
2) vzhost2c
3) vzhost3c
4) vzhost4c
r) Refresh and Clear All
a) All
?) Help
d) Done
Selected: [vzhost1c, vzhost2c, vzhost3c, vzhost4c]
Options: d
>>> Review Oracle Solaris Cluster Objects <<<
The following Oracle Solaris Cluster objects will be created.
Select the value you are changing:
Property Name Current Setting
============= ===============
1) Resource Group Name rac-framework-rg
2) RAC Framework Resource N...rac-framework-rs
d) Done
?) Help
Option: d
>>> Review Configuration of RAC Framework Resource Group <<<
The following Oracle Solaris Cluster configuration will be created.
To view the details for an option, select the option.
Name Value
==== =====
1) Resource Group Name rac-framework-rg
2) RAC Framework Resource N...rac-framework-rs
c) Create Configuration
?) Help
Option: c
Listing 4. Executing clsetup
# clrs status -Z z11gr2A
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
rac-framework-rs vzhost1c Online Online
vzhost2c Online Online
vzhost3c Online Online
vzhost4c Online Online
z11gr2A
From each global zone cluster node (phyhost1
, phyhost2
, phyhost3
, and phyhost4
), do the following:
root
:
# /usr/sbin/zlogin z11gr2A
[Connected to zone 'z11gr2A' pts/2]
Last login: Thu Aug 25 17:30:14 on pts/2
Oracle Corporation SunOS 5.10 Generic Patch January 2005
.bash_profile
:
/u01/grid/product/11.2.0.3/bin
/usr/cluster/bin
make
is installed on each zone cluster node:
make
package on the node:# pkg list *make*
make
package by executing this command as root
:# pkg install developer/build/make
# svcs ntp
disabled Mar_28 svc:/network/ntp:default
# cat > /etc/inet/ntp.conf
slewalways yes
disable pll
^D
root
, execute the following commands from each node:
# groupadd -g 300 oinstall
# groupadd -g 301 dba
# useradd -g 300 -G 301 -u 302 -d /u01/ora_home -s /usr/bin/bash ouser
# mkdir -p /u01/ora_home
# chown ouser:oinstall /u01/ora_home
# mkdir /u01/oracle
# chown ouser:oinstall /u01/oracle
# mkdir /u01/grid
# chown ouser:oinstall /u01/grid
# mkdir /u01/oraInventory
# chown ouser:oinstall /u01/oraInventory
.bash_profile
file of the software owner, ouser
:
export ORACLE_BASE=/u01/oracle
export ORACLE_HOME=/u01/oracle/product/11.2.0.3
export AWT_TOOLKIT=XToolkit
ouser
:
# passwd ouser
New Password:
Re-enter new Password:
passwd: password successfully changed for ouser
bash-3.00#
ouser
, set up SSH from each node:
$ ssh-keygen -t rsa
Generating public/private rsa key pair.
Enter file in which to save the key (/u01/ora_home/.ssh/id_rsa):
Enter passphrase (empty for no passphrase):
Enter same passphrase again:
Your identification has been saved in /u01/ora_home/.ssh/id_rsa.
Your public key has been saved in /u01/ora_home/.ssh/id_rsa.pub.
The key fingerprint is:
e6:63:c9:71:fe:d1:8f:71:77:70:97:25:2a:ee:a9:33 local1@vzhost1c
$
$ pwd
/u01/ora_home/.ssh
vzhost1c
, do the following:
$ cd /u01/ora_home/.ssh
$ cat id_rsa.pub >> authorized_keys
$ chmod 600 authorized_keys
$ scp authorized_keys vzhost2c:/u01/ora_home/.ssh
vzhost2c
, do the following:
$ cd /u01/ora_home/.ssh
$ cat id_rsa.pub >> authorized_keys
$ scp authorized_keys vzhost3c:/u01/ora_home/.ssh
vzhost3c
, do the following:
$ cd /u01/ora_home/.ssh
$ cat id_rsa.pub >> authorized_keys
$ scp authorized_keys vzhost4c:/u01/ora_home/.ssh
vzhost4c
, do the following:
$ cd /u01/ora_home/.ssh
$ cat id_rsa.pub >> authorized_keys
$ scp authorized_keys vzhost1c:/u01/ora_home/.ssh
vzhost1c
, do the following:
$ cd /u01/ora_home/.ssh
$ scp authorized_keys vzhost2c:/u01/ora_home/.ssh
$ scp authorized_keys vzhost3c:/u01/ora_home/.ssh
$ ssh vzhost1c date
$ ssh vzhost2c date
$ ssh vzhost3c date
$ ssh vzhost4c date
root
, set up the Oracle Automatic Storage Management candidate disk:
# for i in 6 7 8 9 10 14 15
> do
> chown ouser:oinstall /dev/did/rdsk/d${i}s6
> chmod 660 /dev/did/rdsk/d${i}s6
> done
$ for i in 6 7 8 9 10 14 15
> do
> dd if=/dev/zero of=/dev/did/rdsk/d${i}s6 bs=1024k count=200
> done
$ bash
$ export DISPLAY=<hostname>:<n>
$ cd <PATH to 11.2.0.3 based software image>/grid/
$ ./runInstaller
starting Oracle Universal Installer...
Checking Temp space: must be greater than 180 MB. Actual 20766 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23056 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute /usr/bin/xdpyinfo Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n]
Listing 5. Starting Oracle Universal Installer
Figure 2. Grid Plug and Play Information Page
Public Hostname | Virtual Hostname |
---|---|
vzhost1c |
vzhost1c-vip |
vzhost2c |
vzhost2c-vip |
vzhost3c |
vzhost3c-vip |
vzhost4c |
vzhost4c-vip |
Figure 3. Cluster Node Information Page
Figure 4. Create ASM Disk Group Page
Figure 5. Specify ASM Password Page
Figure 6. Perform Prerequisite Checks Page
The Execute Configuration Scripts dialog box, shown in Figure 7, asks you to execute the /u01/oraInventory/orainstRoot.sh
and /u01/grid/product/11.2.0.3/root.sh
scripts as root
.
Figure 7. Message About Executing Configuration Scripts
root
on each zone cluster node. Listing 6 shows an example.
# /u01/oraInventory/orainstRoot.sh
Changing permissions of /u01/oraInventory.
Adding read,write permissions for group.
Removing read,write,execute permissions for world.
Changing groupname of /u01/oraInventory to oinstall.
The execution of the script is complete.
# cd /u01/grid/product/11.2.0.3
#./root.sh
Performing root user operation for Oracle 11g
The following environment variables are set as:
ORACLE_OWNER= ouser
ORACLE_HOME= /u01/grid/product/11.2.0.3
Enter the full pathname of the local bin directory: [/usr/local/bin]: /opt/local/bin
Creating /opt/local/bin directory...
Copying dbhome to /opt/local/bin ...
Copying oraenv to /opt/local/bin ...
Copying coraenv to /opt/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/grid/product/11.2.0.3/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 'vzhost1c'
CRS-2676: Start of 'ora.mdnsd' on 'vzhost1c' succeeded
CRS-2672: Attempting to start 'ora.gpnpd' on 'vzhost1c'
CRS-2676: Start of 'ora.gpnpd' on 'vzhost1c' succeeded
CRS-2672: Attempting to start 'ora.cssdmonitor' on 'vzhost1c'
CRS-2672: Attempting to start 'ora.gipcd' on 'vzhost1c'
CRS-2676: Start of 'ora.cssdmonitor' on 'vzhost1c' succeeded
CRS-2676: Start of 'ora.gipcd' on 'vzhost1c' succeeded
CRS-2672: Attempting to start 'ora.cssd' on 'vzhost1c'
CRS-2672: Attempting to start 'ora.diskmon' on 'vzhost1c'
CRS-2676: Start of 'ora.diskmon' on 'vzhost1c' succeeded
CRS-2676: Start of 'ora.cssd' on 'vzhost1c' succeeded
ASM created and started successfully.
Disk Group crsdg 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 621725b80bf24f53bfc8c56f8eaf3457.
Successful addition of voting disk 630c40e735134f2bbf78571ea35bb856.
Successful addition of voting disk 4a78fd6ce8564fdbbfceac0f0e9d7c37.
Successfully replaced voting disk group with +crsdg.
CRS-4256: Updating the profile
CRS-4266: Voting file(s) successfully replaced
## STATE File Universal Id File Name Disk group
-- ----- ----------------- --------- ---------
1. ONLINE 621725b80bf24f53bfc8c56f8eaf3457 (/dev/did/rdsk/d6s6) [CRSDG]
2. ONLINE 630c40e735134f2bbf78571ea35bb856 (/dev/did/rdsk/d7s6) [CRSDG]
3. ONLINE 4a78fd6ce8564fdbbfceac0f0e9d7c37 (/dev/did/rdsk/d8s6) [CRSDG]
Located 3 voting disk(s).
CRS-2672: Attempting to start 'ora.asm' on 'vzhost1c'
CRS-2676: Start of 'ora.asm' on 'vzhost1c' succeeded
CRS-2672: Attempting to start 'ora.CRSDG.dg' on 'vzhost1c'
CRS-2676: Start of 'ora.CRSDG.dg' on 'vzhost1c' succeeded
Configure Oracle Grid Infrastructure for a Cluster ... succeeded
Listing 6. Executing the Scripts
An error message, [INS-20802] Oracle Cluster Verification Utility failed
, appears, as shown in Figure 8. The oraInstall
log also shows errors regarding the ntp.conf
setting that are not applicable to Oracle Solaris 11.
INFO: Check for NTP daemon or service alive passed on all nodes
INFO: NTP daemon slewing option check failed on some nodes
INFO: Check failed on nodes:
INFO: vzgray2a,vzgray3a,vzgray4a,vzgray1a
INFO: PRVF-5436 : The NTP daemon running on one or more nodes lacks the slewing option "'slewalways yes' & 'disable pll'"
INFO: Clock synchronization check using Network Time Protocol(NTP) failed
INFO: PRVF-9652 : Cluster Time Synchronization Services check failed
INFO: Checking VIP configuration.
INFO: Checking VIP Subnet configuration.
INFO: Check for VIP Subnet configuration passed.
INFO: Checking VIP reachability
INFO: Check for VIP reachability passed.
INFO: Post-check for cluster services setup was unsuccessful on all the nodes.
INFO:
WARNING:
INFO: Completed Plugin named: Oracle Cluster Verification Utility
Figure 8. Error Message
Error message INS-32091 appears, as shown in Figure 9:
Figure 9. Another Error Message
The installation of Oracle Grid Infrastructure 11.2.0.3 is completed.
# /u01/grid/product/11.2.0.3/bin/crsctl status res -t
--------------------------------------------------------------------------------
NAME TARGET STATE SERVER STATE_DETAILS
--------------------------------------------------------------------------------
Local Resources
--------------------------------------------------------------------------------
ora.CRSDG.dg
ONLINE ONLINE vzhost1c
ONLINE ONLINE vzhost2c
ONLINE ONLINE vzhost3c
ONLINE ONLINE vzhost4c
ora.LISTENER.lsnr
ONLINE ONLINE vzhost1c
ONLINE ONLINE vzhost2c
ONLINE ONLINE vzhost3c
ONLINE ONLINE vzhost4c
ora.asm
ONLINE ONLINE vzhost1c Started
ONLINE ONLINE vzhost2c Started
ONLINE ONLINE vzhost3c Started
ONLINE ONLINE vzhost4c Started
ora.gsd
OFFLINE OFFLINE vzhost1c
OFFLINE OFFLINE vzhost2c
OFFLINE OFFLINE vzhost3c
OFFLINE OFFLINE vzhost4c
ora.net1.network
ONLINE ONLINE vzhost1c
ONLINE ONLINE vzhost2c
ONLINE ONLINE vzhost3c
ONLINE ONLINE vzhost4c
ora.ons
ONLINE ONLINE vzhost1c
ONLINE ONLINE vzhost2c
ONLINE ONLINE vzhost3c
ONLINE ONLINE vzhost4c
--------------------------------------------------------------------------------
Cluster Resources
--------------------------------------------------------------------------------
ora.LISTENER_SCAN1.lsnr
1 ONLINE ONLINE vzhost1c
ora.cvu
1 ONLINE ONLINE vzhost2c
ora.oc4j
1 ONLINE ONLINE vzhost3c
ora.scan1.vip
1 ONLINE ONLINE vzhost4c
ora.vzhost1c.vip
1 ONLINE ONLINE vzhost1c
ora.vzhost2c.vip
1 ONLINE ONLINE vzhost2c
ora.vzhost3c.vip
1 ONLINE ONLINE vzhost3c
ora.vzhost4c.vip
1 ONLINE ONLINE vzhost4c
Listing 7. Checking the Status of the Resources
# crsctl stop crs
# svccfg -s timezone:default listprop timezone/localtime
timezone/localtime astring US/Pacific
TZ
in $GRID_HOME/crs/install/s_crsconfig_<nodename>_env.txt
to match the system's time zone. In this example, it is TZ=US/Pacific
.# crsctl start crs
swbdg
for the database creation.
$ export DISPLAY=<hostname>:<n>
$ /u01/grid/product/11.2.0.3/bin/asmca
Figure 10. ASM Configuration Assistant
/dev/did/rdsk/d9s6
and /dev/did/rdsk/d10s6
./dev/did/rdsk/d14s6
and /dev/did/rdsk/d15s6
.
Figure 11. Create Disk Group Page
swbdg
disk group creation is completed, click Exit to close the ASM Configuration Assistant.
$ export DISPLAY=<hostname>:<n>
$ cd <PATH to 11.2.0.3 based software image>/database
$ ./runInstaller
starting Oracle Universal Installer...
Checking Temp space: must be greater than 180 MB. Actual 20766 MB Passed
Checking swap space: must be greater than 150 MB. Actual 23056 MB Passed
Checking monitor: must be configured to display at least 256 colors
>>> Could not execute /usr/bin/xdpyinfo Failed <<<<
Some requirement checks failed. You must fulfill these requirements before
continuing with the installation,
Continue? (y/n) [n]
Listing 8. Starting Oracle Universal Installer
Figure 12. Grid Installation Options Page
Figure 13. Specify Configuration Options Page
Figure 14. Select ASM Disk Group Page
Figure 15. Perform Prerequisite Checks Page
An INS-13016 message appears, as shown in Figure 16.
Figure 16. Error Message
Figure 17. Summary Page
Figure 18. Database Configuration Assistant Dialog Box
The Execute Configuration Scripts dialog box asks you to execute root.sh
on each node, as shown in Figure 19.
Figure 19. Execute Configuration Scripts Dialog Box
root.sh
script on the last node, click OK to continue.The Finish page, shown in Figure 20, shows that the installation and configuration of Oracle Database is complete.
Figure 20. Finish Page
Use the following procedure to create the Oracle Solaris Cluster resource. Alternatively, you can use the clsetup
wizard.
SUNW.crs_framework
resource type in the zone cluster: # clrt register SUNW.crs_framework
SUNW.crs_framework
resource type to the Oracle RAC framework resource group:
# clresource create -t SUNW.crs_framework \
-g rac-framework-rg \
-p resource_dependencies=rac-framework-rs \
crs-framework-rs
# clresourcetype register SUNW.scalable_asm_instance_proxy
# clresourcetype register SUNW.scalable_asm_diskgroup_proxy
asm-inst-rg
and asm-dg-rg
:
# clresourcegroup create -S asm-inst-rg asm-dg-rg
rac-fmwk-rg
by asm-inst-rg
:# clresourcegroup set -p rg_affinities=++rac-framework-rg asm-inst-rg
asm-inst-rg
by asm-dg-rg
:# clresourcegroup set -p rg_affinities=++asm-inst-rg asm-dg-rg
SUNW.scalable_asm_instance_proxy
resource and set the resource dependencies:
# clresource create asm-inst-rg \
-t SUNW.scalable_asm_instance_proxy \
-p ORACLE_HOME=/u01/grid/product/11.2.0.3 \
-p CRS_HOME=/u01/grid/product/11.2.0.3 \
-p "ORACLE_SID{vzhost1c}"=+ASM1 \
-p "ORACLE_SID{vzhost2c}"=+ASM2 \
-p "ORACLE_SID{vzhost3c}"=+ASM3 \
-p "ORACLE_SID{vzhost4c}"=+ASM4 \
-p resource_dependencies_offline_restart=crs-framework-rs \
-d asm-inst-rs
asm-dg-rg
resource group:
# clresource create -g asm-dg-rg -t SUNW.scalable_asm_diskgroup_proxy \
-p asm_diskgroups=CRSDG,SWBDG \
-p resource_dependencies_offline_restart=asm-inst-rs \
-d asm-dg-rs
asm-inst-rg
resource group in a managed state:# clresourcegroup online -eM asm-inst-rg
asm-dg-rg
resource group in a managed state:# clresourcegroup online -eM asm-dg-rg
# clresourcegroup create -S \
-p rg_affinities=++rac-framework-rg,++asm-dg-rg \
rac-swbdb-rg
SUNW.scalable_rac_server_proxy
resource type:# clresourcetype register SUNW.scalable_rac_server_proxy
# clresource create -g rac-swbdb-rg \
-t SUNW.scalable_rac_server_proxy \
-p resource_dependencies=rac-framework-rs \
-p resource_dependencies_offline_restart=crs-framework-rs,asm-dg-rs \
-p oracle_home=/u01/oracle/product/11.2.0.3 \
-p crs_home=/u01/grid/product/11.2.0.3 \
-p db_name=swb \
-p "oracle_sid{vzhost1c}"=swb1 \
-p "oracle_sid{vzhost2c}"=swb2 \
-p "oracle_sid{vzhost3c}"=swb3 \
-p "oracle_sid{vzhost4c}"=swb4 \
-d rac-swb-srvr-proxy-rs
# clresourcegroup online -emM rac-swbdb-rg
# clrs status
=== Cluster Resources ===
Resource Name Node Name State Status Message
------------- --------- ----- --------------
crs_framework-rs vzhost1c Online Online
vzhost2c Online Online
vzhost3c Online Online
vzhost4c Online Online
rac-framework-rs vzhost1c Online Online
vzhost2c Online Online
vzhost3c Online Online
vzhost4c Online Online
asm-inst-rs vzhost1c Online Online - +ASM1 is UP and ENABLED
vzhost2c Online Online - +ASM2 is UP and ENABLED
vzhost3c Online Online - +ASM3 is UP and ENABLED
vzhost4c Online Online - +ASM4 is UP and ENABLED
asm-dg-rs vzhost1c Online Online - Mounted: SWBDG
vzhost2c Online Online - Mounted: SWBDG
vzhost3c Online Online - Mounted: SWBDG
vzhost4c Online Online - Mounted: SWBDG
rac-swb-srvr-proxy-rs vzhost1c Online Online - Oracle instance UP
vzhost2c Online Online - Oracle instance UP
vzhost3c Online Online - Oracle instance UP
vzhost4c Online Online - Oracle instance UP
Listing 9. Checking the Cluster Resource Status
Here are some additional resources:
Vinh Tran is a quality engineer in the Oracle Solaris Cluster Group. His responsibilities include, but are not limited to, certification and qualification of Oracle RAC on Oracle Solaris Cluster.
Revision 2.0, 06/05/2014
Revision 1.0, 07/27/2012