Storage Foundation for Oracle® RAC 7.4.1 Configuration and Upgrade Guide - Solaris

Oracle user and group

See Table: Sample value sheet - Oracle user and group.

Public IP addresses and host names

See Table: Sample value sheet - Public IP addresses and host names.

PrivNIC and MultiPrivNIC

See Table: Sample value sheet - PrivNIC and MultiPrivNIC.

Oracle High Availability IP (HAIP)

[For Oracle RAC 11.2.0.2 and later versions]

See Table: Sample value sheet - Oracle HAIP [Oracle RAC 11.2.0.2 and later versions].

Oracle RAC home directories

See Table: Sample value sheet - Oracle RAC home directories.

OCR and voting disk

See Table: Sample value sheet - OCR and voting disk.

CSSD and Oracle database configuration

See Table: Sample value sheet - CSSD and Oracle database configuration.

Oracle user name

(user_name)

Oracle user ID

(user_id)

1000

Oracle group name - Primary group

(grp_name)

oinstall (for inventory group as primary group)

Oracle group name - Secondary group

(grp_name_sec)

dba (for dba group as secondary group)

Oracle group ID - Primary group ID

(grp_id)

1000 (for inventory group as primary group)

Oracle group ID - Secondary group ID

(grp_id_sec)

1001 (for dba group as secondary group)

Oracle user home directory

(usr_home_ora)

/home/oracle

Grid user home directory

(usr_home_grid)

/home/grid

Name of a node in the cluster

(node_name1)

(node_name2)

Name of a new node added to the cluster

(nodenew_name)

sys5

Virtual IP address

10.10.10.10

Virtual IP alias

sys1-vip

SCAN IP addresses (only for Oracle RAC 11g Release 2)

A minimum of three addresses is recommended.

10.10.10.20

10.10.10.21

10.10.10.22

SCAN name (only for Oracle RAC 11g Release 2)

clus1_scan

Private IP address for first node in the cluster - PrivNIC

(privnic_ip_node1)

192.168.12.1 (on sys1)

Private IP address for second node in the cluster - PrivNIC

(privnic_ip_node2)

192.168.12.2 (on sys2)

Private IP address when you add a node in the cluster - PrivNIC

(privnic_ip_newnode)

192.168.12.5 (on sys2)

NIC address for network on first node in the cluster

(nic1_node1)

(nic2_node1)

You have to choose an LLT device as a device for the Oracle Clusterware heartbeat. The interfaces specified should be exactly the same in name and total number as those which have been used for LLT configuration.

For example, if the LLT devices on sys1 are net1, net2:

net1, net2

Then the PrivNIC or MultiPrivNIC device names will be as follows:

Device@sys1= { net1 = 0, net2 = 1 }

If aggregated device names are configured under LLT, then the aggregated names must be used in PrivNIC or MultiPrivNIC agent.

For example, if LLT device name on sys1 is:

aggr1

Then the Device Attribute for the MultiPrivNIC agent would be as follows:

Device@sys1 = { aggr1 = 0 }

NIC address for network on second node in the cluster

(nic1_node2)

(nic2_node2)

You have to choose an LLT device as a device for the Oracle Clusterware heartbeat. The interfaces specified should be exactly the same in name and total number as those which have been used for LLT configuration.

For example, if the LLT devices on sys2 are net1, net2:

net1, net2 (on sys2)

Then the PrivNIC or MultiPrivNIC device names will be as follows:

Device@sys2= { net1 = 0, net2 = 1 }

If aggregated device names are configured under LLT, then the aggregated names must be used in PrivNIC or MultiPrivNIC agent.

For example, if LLT device name on sys2 is:

aggr1 (on sys2)

Then the Device Attribute for the MultiPrivNIC agent would be as follows:

Device@sys2 = { aggr1 = 0 }

VCS resource name for PrivNIC

(priv_resname)

ora_priv

VCS resource name for MultiPrivNIC

(multipriv_resname)

multi_priv

Private IP addresses for first node in the cluster - MultiPrivNIC

(multipriv_ip1_node1)

(multipriv_ip2_node1)

(multipriv_ip3_node1)

Veritas recommends that all Oracle Clusterware and UDP cache-fusion links be LLT links.

Private IP addresses for second node in the cluster - MultiPrivNIC

(multipriv_ip1_node2)

(multipriv_ip2_node2)

(multipriv_ip3_node2)

Veritas recommends that all Oracle Clusterware and UDP cache-fusion links be LLT links.

Private IP addresses when you add a new node in the cluster - MultiPrivNIC

(multipriv_ip1_newnode)

(multipriv_ip2_newnode)

Veritas recommends that all Oracle Clusterware and UDP cache-fusion links be LLT links.

Private hostnames (set in /etc/hosts) for first node in the cluster

(ip_node1)

Private hostnames (set in /etc/hosts) for second node in the cluster

(ip_node2)

Netmask for cluster

(netmask_ip)

255.255.255.0

Private IP address for first node in the cluster (sys1)

192.168.12.2

Hostname alias for first node in the cluster (sys1)

sys1-haip1

Private IP address for second node in the cluster (sys2)

192.168.12.2

Hostname alias for second node in the cluster (sys2)

sys2-haip1

Netmask

255.255.255.0

Disk for each node that contains the Oracle Clusterware and database binaries

disk_name

Disk_1

VxVM local disk group name

dg_name

CVM disk group name

cvm_dg

bindg

Volume name for Oracle Clusterware binaries

clus_volname

For Oracle Grid Infrastructure

gridbinvol

Oracle Clusterware home directory

clus_home

For Oracle Grid Infrastructure, path to grid_home

/u01/app/grid/product/11.2.0/gridhome

Volume name for Oracle Database binaries

ora_volname

orabinvol

VCS resource name for disk groups containing the Oracle Clusterware/Grid Infrastructure and Oracle Database home directories

dg_resname

bin_dg

Oracle Clusterware binary mount point resource name

clusbin_mnt_resname

For Oracle Grid Infrastructure

gridbin_mnt

Oracle Database binary mount point resource name

orabin_mnt_resname

orabin_mnt

Oracle base directory for Oracle Clusterware

oracle_base

/u01/app/oracle

Oracle base directory for Oracle Grid Infrastructure

grid_base

/u01/app/grid

Oracle base directory for Database

oracle_base

/u01/app/oracle

Oracle Database home directory

db_home

/u02/app/oracle/product/11.2.0/dbhome_1

Oracle Grid Infrastructure home directory

grid_home

/u01/app/11.2.0/grid

Disks for creating a shared disk group for OCR and voting disk

disk_name2

disk_name3

Disk_2

Disk_3

Shared disk group for OCR and voting disk

ocrvote_dgname

ocrvotedg

OCR volume on CVM raw volumes

ocr_volname

ocrvol

Voting disk volume on CVM raw volumes

vote_volname

votevol

OCR and voting disk volume on CFS

ocrvote_volname

ocrvotevol

Volume options for OCR and voting disk

nmirror=2

File system on shared volume (CFS)

/dev/vx/rdsk/ocrvotedg/ocrvotevol

Mount point for shared file system

ocrvote_mnt

/ocrvote

CVMVolDg resource name for OCR and voting disk

ocrvotevol_resname

ocrvote_voldg_ocrvotedg

CFSMount resource name for OCR and voting disk

ocrvotemnt_resname

ocrvote_mnt_ocrvotedg

Mount point for archive logs

/oradata

CVM group name

cvm_grpname

cvm

CVM group name

cvm_grpname

cvm

CSSD group name

cssd_grpname

cssd

VCS service group for Oracle Database

oradb_grpname

oradb_grp

VCS resource name for Oracle

db_resname

oradb

Oracle database name

db_name

db

Global Database Name

db.example.com (database name.domain)

Disk group name for Oracle Database

oradb_dgname

oradatadg (Shared)

Volume name for Oracle Database

oradb_volname

oradatavol

Mount point for Oracle Database

oradb_mnt

/oradata (Shared)

CVMVolDg resource for Oracle Database

oradbdg_resname

oradata_voldg

CFSMount resource for Oracle Database

oradbmnt_resname

oradata_mnt

SID prefix for policy-managed databases

oradb_sid_prefix

db

SID on first node in the cluster

oradb_sid_node1

db1

SID on second node in the cluster

oradb_sid_node2

db2