Storage Foundation for Oracle® RAC 8.0.2 Configuration and Upgrade Guide - Linux
- Section I. Configuring SF Oracle RAC
- Preparing to configure SF Oracle RAC
- Configuring SF Oracle RAC using the script-based installer
- Configuring the SF Oracle RAC components using the script-based installer
- Configuring the SF Oracle RAC cluster
- Configuring the cluster name
- Configuring private heartbeat links
- Configuring the virtual IP of the cluster
- Configuring SF Oracle RAC in secure mode
- Configuring a secure cluster node by node
- Adding VCS users
- Configuring SMTP email notification
- Configuring SNMP trap notification
- Configuring global clusters
- Creation of SF Oracle RAC configuration files
- Stopping and starting SF Oracle RAC processes
- Configuring the SF Oracle RAC cluster
- Setting up disk-based I/O fencing using installer
- Setting up server-based I/O fencing using installer
- Configuring SFDB
- Configuring the SF Oracle RAC components using the script-based installer
- Performing an automated SF Oracle RAC configuration
- Configuring SF Oracle RAC using response files
- Response file variables to configure SF Oracle RAC
- Sample response file for configuring SF Oracle RAC
- Configuring I/O fencing using response files
- Response file variables to configure disk-based I/O fencing
- Sample response file for configuring disk-based I/O fencing
- Configuring CP server using response files
- Response file variables to configure CP server
- Sample response file for configuring the CP server on SFHA cluster
- Response file variables to configure server-based I/O fencing
- Sample response file for configuring server-based I/O fencing
- Section II. Post-installation and configuration tasks
- Verifying the installation
- Performing additional post-installation and configuration tasks
- Section III. Upgrade of SF Oracle RAC
- Planning to upgrade SF Oracle RAC
- Performing a full upgrade of SF Oracle RAC using the product installer
- Performing an automated full upgrade of SF Oracle RAC using response files
- Performing a phased upgrade of SF Oracle RAC
- About phased upgrade
- Performing a phased upgrade of SF Oracle RAC from version 7.3.1 and later release
- Step 1: Performing pre-upgrade tasks on the first half of the cluster
- Step 2: Upgrading the first half of the cluster
- Step 3: Performing pre-upgrade tasks on the second half of the cluster
- Step 4: Performing post-upgrade tasks on the first half of the cluster
- Step 5: Upgrading the second half of the cluster
- Step 6: Performing post-upgrade tasks on the second half of the cluster
- Performing a rolling upgrade of SF Oracle RAC
- Upgrading Volume Replicator
- Performing post-upgrade tasks
- Relinking Oracle RAC libraries with the SF Oracle RAC libraries
- Re-joining the backup boot disk group into the current disk group
- Reverting to the backup boot disk group after an unsuccessful upgrade
- Setting or changing the product license level
- Resetting DAS disk names to include host name in FSS environments
- Upgrading disk layout versions
- CVM master node needs to assume the logowner role for VCS managed VVR resources
- Switching on Quotas
- Upgrading the disk group version
- Section IV. Installation of Oracle RAC
- Before installing Oracle RAC
- Important preinstallation information for Oracle RAC
- About preparing to install Oracle RAC
- Preparing to install Oracle RAC using the SF Oracle RAC installer or manually
- Identifying the public virtual IP addresses for use by Oracle
- Setting the kernel parameters
- Verifying that RPMs and patches required by Oracle are installed
- Verifying the user nobody exists
- Launching the SF Oracle RAC installer
- Creating users and groups for Oracle RAC
- Creating storage for OCR and voting disk
- Configuring private IP addresses for Oracle RAC
- Verifying that multicast is functional on all private network interfaces
- Creating Oracle Clusterware/Grid Infrastructure and Oracle database home directories manually
- Setting up user equivalence
- Installing Oracle RAC
- Performing an automated Oracle RAC installation
- Performing Oracle RAC post-installation tasks
- Adding Oracle RAC patches or patchsets
- Configuring the CSSD resource
- Preventing automatic startup of Oracle Clusterware/Grid Infrastructure
- Relinking the SF Oracle RAC libraries with Oracle RAC
- Updating the CSS misscount setting
- Creating the Oracle RAC database
- Configuring VCS service groups for Oracle RAC
- Preventing automatic database startup
- Removing existing PrivNIC or MultiPrivNIC resources
- Removing permissions for communication
- Upgrading Oracle RAC
- Before installing Oracle RAC
- Section V. Adding and removing nodes
- Adding a node to SF Oracle RAC clusters
- About adding a node to a cluster
- Before adding a node to a cluster
- Adding a node to a cluster using the Veritas InfoScale installer
- Adding the node to a cluster manually
- Starting Veritas Volume Manager (VxVM) on the new node
- Configuring cluster processes on the new node
- Setting up the node to run in secure mode
- Starting fencing on the new node
- After adding the new node
- Configuring server-based fencing on the new node
- Configuring Cluster Volume Manager (CVM) and Cluster File System (CFS) on the new node
- Configuring the ClusterService group for the new node
- Preparing the new node manually for installing Oracle RAC
- Adding a node to the cluster using the SF Oracle RAC response file
- Configuring private IP addresses for Oracle RAC on the new node
- Adding the new node to Oracle RAC
- Adding nodes to a cluster that is using authentication for SFDB tools
- Updating the Storage Foundation for Databases (SFDB) repository after adding a node
- Sample configuration file for adding a node to the cluster
- Removing a node from SF Oracle RAC clusters
- About removing a node from a cluster
- Removing a node from a cluster
- Modifying the VCS configuration files on existing nodes
- Modifying the Cluster Volume Manager (CVM) configuration on the existing nodes to remove references to the deleted node
- Removing the node configuration from the CP server
- Removing security credentials from the leaving node
- Updating the Storage Foundation for Databases (SFDB) repository after removing a node
- Sample configuration file for removing a node from the cluster
- Adding a node to SF Oracle RAC clusters
- Section VI. Configuration of disaster recovery environments
- Configuring disaster recovery environments
- Disaster recovery options for SF Oracle RAC
- Hardware requirements for campus cluster
- Supported replication technologies for global clusters
- About setting up a campus cluster for disaster recovery
- About setting up a global cluster environment for SF Oracle RAC
- About configuring a parallel global cluster using Volume Replicator (VVR) for replication
- Configuring disaster recovery environments
- Section VII. Installation reference
- Appendix A. Installation scripts
- Appendix B. Tunable files for installation
- About setting tunable parameters using the installer or a response file
- Setting tunables for an installation, configuration, or upgrade
- Setting tunables with no other installer-related operations
- Setting tunables with an un-integrated response file
- Preparing the tunables file
- Setting parameters for the tunables file
- Tunables value parameter definitions
- Appendix C. Sample installation and configuration values
- About the installation and configuration worksheets
- SF Oracle RAC worksheet
- Oracle RAC worksheet
- Replicated cluster using VVR worksheet
- Replicated cluster using SRDF worksheet
- Required installation information for Oracle Clusterware/Grid Infrastructure
- Required installation information for Oracle database
- Appendix D. Configuration files
- About VCS configuration file
- About the LLT and GAB configuration files
- About I/O fencing configuration files
- Sample configuration files
- sfrac02_main.cf file
- sfrac03_main.cf file
- sfrac04_main.cf file
- sfrac05_main.cf file
- sfrac06_main.cf file
- sfrac07_main.cf and sfrac08_main.cf files
- sfrac09_main.cf and sfrac10_main.cf files
- sfrac11_main.cf file
- sfrac12_main.cf and sfrac13_main.cf files
- sfrac14_main.cf file
- sfrac15_main.cf and sfrac16_main.cf files
- sfrac17_main.cf file
- Sample configuration files for CP server
- Appendix E. Configuring the secure shell or the remote shell for communications
- About configuring secure shell or remote shell communication modes before installing products
- Manually configuring passwordless ssh
- Setting up ssh and rsh connection using the installer -comsetup command
- Setting up ssh and rsh connection using the pwdutil.pl utility
- Restarting the ssh session
- Enabling rsh for Linux
- Appendix F. Automatic Storage Management
- Appendix G. Creating a test database
- Appendix H. High availability agent information
- About agents
- CVMCluster agent
- CVMVxconfigd agent
- CVMVolDg agent
- CFSMount agent
- CFSfsckd agent
- CSSD agent
- VCS agents for Oracle
- Oracle agent functions
- Startup and shutdown options for the pluggable database (PDB)
- Recommended startup modes for pluggable database (PDB) based on container database (CDB) startup modes
- Monitor options for the Oracle agent in traditional database and container database
- Monitor for the pluggable database
- Info entry point for Cluster Server agent for Oracle
- Action entry point for Cluster Server agent for Oracle
- Resource type definition for the Oracle agent
- Netlsnr agent functions
- Resource type definition for the Netlsnr agent
- ASMDG agent functions
- Resource type definition for the ASMDG agent
- Oracle agent functions
- CRSResource agent
- Appendix I. SF Oracle RAC deployment scenarios
- Appendix J. Configuring LLT over UDP
- Using the UDP layer for LLT
- Manually configuring LLT over UDP using IPv4
- Broadcast address in the /etc/llttab file
- The link command in the /etc/llttab file
- The set-addr command in the /etc/llttab file
- Selecting UDP ports
- Configuring the netmask for LLT
- Configuring the broadcast address for LLT
- Sample configuration: direct-attached links
- Sample configuration: links crossing IP routers
- Using the UDP layer of IPv6 for LLT
- Manually configuring LLT over UDP using IPv6
- About configuring LLT over UDP multiport
- Appendix K. Using LLT over RDMA
- Using LLT over RDMA
- About RDMA over RoCE or InfiniBand networks in a clustering environment
- How LLT supports RDMA capability for faster interconnects between applications
- Using LLT over RDMA: supported use cases
- Configuring LLT over RDMA
- Choosing supported hardware for LLT over RDMA
- Installing RDMA, InfiniBand or Ethernet drivers and utilities
- Configuring RDMA over an Ethernet network
- Configuring RDMA over an InfiniBand network
- Tuning system performance
- Manually configuring LLT over RDMA
- LLT over RDMA sample /etc/llttab
- Verifying LLT configuration
- Troubleshooting LLT over RDMA
- IP addresses associated to the RDMA NICs do not automatically plumb on node restart
- Ping test fails for the IP addresses configured over InfiniBand interfaces
- After a node restart, by default the Mellanox card with Virtual Protocol Interconnect (VPI) gets configured in InfiniBand mode
- The LLT module fails to start
Oracle RAC worksheet
This section provides a worksheet with sample values for installing and configuring Oracle RAC.
Note:
Italicized text in parenthesis indicates the corresponding variable that is used in procedures. When you perform the steps in the procedures, ensure that you replace the variables with the values that are assigned to them in this worksheet.
Table: Required information for Oracle RAC displays the sample worksheets that may be used as reference when you perform the corresponding tasks.
Table: Required information for Oracle RAC
Sample value sheet | Go to |
|---|---|
Oracle user and group | |
Public IP addresses and host names | See Table: Sample value sheet - Public IP addresses and host names. |
PrivNIC and MultiPrivNIC | |
Oracle High Availability IP (HAIP) | |
Oracle RAC home directories | See Table: Sample value sheet - Oracle RAC home directories. |
OCR and voting disk | |
CSSD and Oracle database configuration | See Table: Sample value sheet - CSSD and Oracle database configuration. |
Table: Sample value sheet - Oracle user and group displays sample values that may be used when you create Oracle users and groups.
Table: Sample value sheet - Oracle user and group
Information | Sample value | Assigned value |
|---|---|---|
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 |
Table: Sample value sheet - Public IP addresses and host names displays sample values for public IP addresses and host names.
Table: Sample value sheet - Public IP addresses and host names
Information | Sample value | Assigned value |
|---|---|---|
Name of a node in the cluster (node_name1) (node_name2) | For a two-node cluster:
| |
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 | A minimum of three addresses is recommended. 10.10.10.20 10.10.10.21 10.10.10.22 | |
SCAN name | clus1_scan |
The following table displays sample values that may be used when you use Oracle HAIP for Oracle RAC.
Table: Sample value sheet - Oracle HAIP
Information | Sample value | Assigned value |
|---|---|---|
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 |
Table: Sample value sheet - Oracle RAC home directories displays sample values that may be used when you create the Oracle RAC home directories.
Table: Sample value sheet - Oracle RAC home directories
Information | Sample value | Assigned value |
|---|---|---|
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 |
Table: Sample value sheet - OCR and voting disk displays sample values that may be used when you create the storage for OCR and voting disk.
Table: Sample value sheet - OCR and voting disk
Information | Sample value | Assigned value |
|---|---|---|
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 |
Table: Sample value sheet - CSSD and Oracle database configuration displays sample values that may be used when you configure the CSSD agent and the Oracle database.
Table: Sample value sheet - CSSD and Oracle database configuration
Information | Sample value | Assigned value |
|---|---|---|
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 |