| Oracle9i Database Installation Guide Release 2 (9.2.0.2.1) for 64-Bit Windows Part Number B10546-01 |
|
This appendix describes the required preinstallation tasks for Oracle9i cluster software on Windows Server 2003. Windows-specific information is described in this section.
This appendix contains these topics:
In addition to the system requirements listed in Chapter 2, "Preinstallation Requirements", you must meet these requirements:
Each node in a cluster requires the following hardware:
Have the following hardware and network configuration information available:
Each node in a cluster requires one of the following software types:
512 MB for each instance
Oracle Corporation recommends that you:
Table B-1 Recommended Allocation Unit Sizes
| File Type | Recommended Allocation Unit Size |
|---|---|
|
Cluster File System for Oracle Home Only |
4 KB to 8KB |
|
Cluster File System for Oracle datafiles |
1024 KB minimum |
Do not use a public interconnect for your cluster database. Public interconnects experience busy network traffic. Do not use DHCP to dynamically assign IP addresses to the nodes on which you run cluster databases. DHCP produces increased network traffic through leasing and revoking IP addresses.
Each node should have at least two network interface cards (NIC) to provide a private interconnect for the internode cache fusion traffic and to safeguard against the possibility of network card failure. The private interconnect takes advantage of the performance gains provided by cache fusion. The NICs should have dedicated IP addresses for optimal bandwidth. Alternatively, configure multiple physical NICs as one logical NIC and assign multiple IP addresses to the single logical NIC. Using multiple NICs safeguards against the possibility of network card failure.
Perform the preinstallation steps described in this section before starting the Cluster Setup Wizard. Windows refers to raw partitions as logical drives.
Oracle Cluster File System is a shared file system designed specifically for Oracle9i. OCFS eliminates the requirement of linking Oracle datafiles to logical drives and enables all nodes to share a single Oracle home instead of requiring each node to have its own local copy.
The number of partitions used for OCFS affects performance. Therefore, you should create the minimum number of partitions needed for the OCFS option you choose.
Minimum size recommendations:
If the datafiles are stored on raw partitions, the voting disk must exist as a logical partition on the shared disk and is required by the Cluster Setup Wizard.
The voting disk stores configuration data for Server Management (SRVM) and is used by Oracle operating system dependent clusterware.
|
See Also:
"Creating Partitions" for detailed steps on how to create a logical drive for the voting disk. The voting disk must be at least 100 MB in size |
Symbolic link names are required in order to use Database Configuration Assistant to install a predefined starter database on logical drives if you are not using Cluster File System for the Oracle Datafiles.
Use one of the following methods to assign symbolic link names:
The Oracle Cluster Setup Wizard assists with cluster creation and the addition of nodes to an existing cluster. It also enables you to assign symbolic link names to logical drives.
The ImportSYMLinks utility is a command line tool that assigns symbolic link names or renames existing symbolic link names.
|
See Also:
"Installing the Raw Devices Management Utilities Manually" if you did not run Cluster Setup Wizard. |
TBL file.
| To... | Do this... |
|---|---|
|
Modify an existing symbolic link name |
Note: Duplicate links are indented in the |
|
Create a |
A sample ASCII file is located in the following directory on the first component CD:Foot 1
|
|
1
This sample file contains symbolic link names associated with raw partitions for a two-node cluster database. |
ImportSYMLinks.exe [/f:filename]
For example, ImportSYMLinks.exe /f:c:\temp\mysymlinks.tbl
where temp is the temporary directory defined in step 1 and filename is the full path and filename of the valid TBL file.
Object Link Manager is a GUI tool that assigns symbolic link names or renames existing symbolic link names.
|
See Also:
"Installing the Raw Devices Management Utilities Manually" to install Oracle Object Link Manager |
c:\temp\GUIOracleOBJManager.exe where temp is the temporary directory defined in step 1.
The Oracle Object Manager window appears.
An edit window, with an active blinking cursor, opens in the New Link Name column.
Do not proceed to step 5 if the edit window is active. Changes will not apply.
Note:
Before running the Cluster Setup Wizard, you must decide how the shared disk is to be configured. The choice you make, will guide your shared disk preinstall steps. If you are using OCFS for both the Oracle Home and the Oracle Datafiles see "Real Application Clusters Preinstallation"
If you are using OCFS for the Oracle Home or Raw Partitions for Oracle datafiles see "Real Application Clusters Preinstallation" and "Voting Disk Preinstallation".
If you are using OCFS for the Oracle Datafile only, see "Real Application Clusters Preinstallation".
If your are not using OCFS, please read the "Voting Disk Preinstallation".
The Cluster Setup Wizard is used to install Oracle Operating system dependent clusterware layer on Windows Server 2003. The Cluster Setup Wizard can create a new cluster or add a node to an existing cluster. The Cluster Setup Wizard can also configure the shared disks. Table B-2 shows the shared disk configuration options. See "Cluster File System Installed Components and Services" for more information.
Each shared disk used by Real Application Clusters must be configured as a basic disk with a master boot record (MBR) partition style. Real Application Clusters does not support dynamic disks or GUID partition table (GPT) partition style.
Do not use Windows disk administration tools to assign drive letters to partitions in this procedure. Cluster Setup Wizard assigns drive letters to OCFS partitions when you create a cluster.
The Computer Management window displays disks and volumes in a graphical view and in a list view. View the status of a disk of volume in the Status column of the list view.
The Computer Management Window appears.
The Disk Management window appears.
Before creating the logical partitions on a disk verify that the disk has the following properties:
To view the disk properties:
If the properties are not correct, use Windows Disk Management to reconfigure the disk.
Before creating the logical drives, first create extended partitions that point to the raw space on the disk. The number of partitions needed depends on the how you configure the shared disk. If more information is needed about creating partitions, refer to the Windows online help from within the Disk Administration tools.
Before creating the logical drives on a disk verify that the disk is a basic disk and has a Master Boot Record (MBR) partition style:
For each datafile needed in Table B-3, you must complete steps 2 through 11:
This section describes using the Cluster Setup Wizard.
\preinstall_rac\clustersetup\ directory and double-click clustersetup.exe. The Welcome page for the Oracle Cluster Setup Wizard appears. Click Next.
The following options are available on the Cluster File System Options page:
If you selected any of the first three options, you must perform the steps in "Real Application Clusters Preinstallation" first.
Selecting one of the first three options will cause the Cluster Setup wizard to install the Cluster File System driver and supporting applications on to all nodes selected.
For example the voting disk is created in the following format:
Oracle_datafile_drive_letter:\voting_filename
| To... | Do this... |
|---|---|
|
Rename a symbolic link |
|
|
Create a symbolic link |
SYSTEM_DRIVE\system32\osd9i. Choose Browse to navigate to a different location.
The voting disk stores configuration data for Server Management (SRVM) and for the Oracle operating system dependent clusterware. Vendor operating system dependent clusterware also requires this disk for Real Application Clusters configuration information.
Real Application Clusters uses logical drives within an unformatted extended partition to store the control, data, and redo log files. Only one extended partition is created for each disk. Oracle Corporation recommends creating the extended partition on an unpartitioned disk and using the entire disk for the extended partition.
Each instance shares a set of unformatted devices on a shared disk subsystem for datafiles. The number and type of raw devices required depends on several factors.
If you plan to use one of the General Purpose, Transaction Processing, or Data Warehouse database configuration types, then you must create a specific number of logical partitions and assign symbolic names to them. The Cluster Setup Wizard does not require these partitions for its installation task, but it can be used to create and assign symbolic links names to partitions. If you decide to use one of the predefined database configuration types refer to "Raw Partitions for Datafiles" and "Using Oracle Cluster Setup Wizard"for more information.
You must also create specific tablespaces using the minimum sizes as listed in Table B-3. When considering size requirements of your disks, remember to account for the initial signature of 1 MB or 2 MBs on each disk that cannot be used for extended partitions. These requirements are the same for both the vendor supplied clusterware layer and Oracle supplied clusterware layer.
The datafiles, control files, and redo log files must reside on unformatted raw devices on logical drives that reside within extended partitions. The extended partitions point to raw space on the disks. To configure the logical drives, create multiple logical partitions using Windows Disk Management. See the online help for Windows Disk Management for more information.
By default, Database Configuration Assistant uses automatic undo management. You should create one Undo tablespace for each instance. Logical drives for Undo tablespaces for all preconfigured database templates should be at least 320 MB. If you use manual undo management, make the RBS logical drive at least 625 MB in size.
Database Configuration Assistant uses a logical partition to store the server parameters by default. If you keep this option, you must create one logical partition to hold the server parameters with a file minimum file size 5 MB and symbolic link format db_name_SPFILE. If you do not use this option each instance will have a local copy of the parameters file, and you do NOT need to create the server parameter partition.
Database Configuration Assistant uses automatic undo management by default. Create one Undo tablespace for each instance. Logical drives for Undo tablespaces for all preconfigured database templates should be at least 320 MB with symbolic link format db_name_UNDOTBSinstance_number. If you use manual undo management, make the RBS logical drive at least 640 MB in size with symbolic link format db_name_RBS.
Database Configuration Assistant will require two logs files for each instance by default. Each redo log files for each instance has a file size of 120 MB and a symbolic link format db_name_REDOinstance_number_thread_number.
|
See Also:
|
There are two sets of utilities. Utilities for raw devices and utilities for Cluster File System Additional disk management utilities are installed by the Oracle Cluster Setup Wizard on all nodes. These tools are not installed if you do not run Oracle Cluster Setup Wizard. Table B-4 describes the disk management utilities.
If you did not install Oracle9i operating system dependent clusterware using the Oracle Cluster Setup Wizard, then manually install the raw device management utilities.
To manually install the disk management utilities, perform the following tasks on each node of the cluster:
C:\temp> OracleOBJService /INSTALL
If you do not create the database with Database Configuration Assistant, then the number of logical drives you create depends on the number of datafiles, redo log files, and control files you plan to create. However, you must still create a logical drive of 100 MB for the voting disk.
| Component | Function |
|---|---|
|
|
File system driver for Windows Server 2003 |
|
|
OCFS service that ensures consistent mount points across the cluster and provides configuration support for the file system driver. After installation, it appears in the Windows Services panel. |
|
|
Utility that prepares volumes for use with the cluster file system. In order to enable a volume for use with OCFS, it needs to be formatted by running this utility from one of the nodes in the cluster. See "Formatting a Partition to Add to OCFS" |
|
|
Utility that is used for changing the cluster name for a given volume, managing the list of nodes configured on a volume, and creating node-specific files and directories. See "OcfsUtil Command Summary" |
|
|
Batch file that automatically runs from Oracle Universal Installer during the installation of an Oracle home on OCFS. It is called by |
OcfsUtil is a command line utility that is used for:
Table B-6 lists the operations performed by OcfsUtil.
To add a new partition to an existing OCFS, use OcfsFormat to format the partition.
OcfsFormat /l <driver letter:> /c <Allocation Unit Size>
For example, if the volume is to be given the drive letter O: and an allocation unit size of 4 KB, the command is:
OcfsFormat /l O: /c 4
The Allocation Unit Size reflects the minimum allocation the file system will give to a file. For example, for a 4 KB file, the file system (as shown in the example) will allocate 4 KB of disk space to the file. Once the file grows beyond 4 KB, the file system will give the file another 4 KB from the disk. This small size is optimal for the Oracle home, parameter files, and log files. For the OCFS drive that you select for datafiles, the Allocation Unit Size should be set to 1024 KB minimum.
Use the Oracle utility OCOPY to copy data to or from a raw partition for both physical partitions and logical drives.
The physical partition and logical drive conventions are not compatible with one another due to the extra block that is skipped for physical raw conventions. This also means you cannot simply do an OCOPY command from a physical disk to a logical drive, as the contents of these partitions are incompatible.
If your database installation uses physical disk conventions with logical drives, Oracle Corporation recommends converting to the logical drive conventions using these steps:
If you want to deinstall previous versions of Oracle operating system dependent clusterware, use the following steps to manually remove them:
OracleCMService9i.
C:\> regedit
The Registry Editor window appears.
HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE\OSD9i.
OSD subkey.
HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services.
OracleCMService9i.
osd9i directory under C:\.
This section contains these topics:
Real Application Clusters Management Tools Error Messages are located in Appendix C of Oracle9i Real Application Clusters Administration.
If Oracle Universal Installer does not display the Node Selection page, perform clusterware diagnostics by executing the lsnodes -v command and analyzing its output.
From the \preinstall_rac directory, execute the following:
lsnodes -v
Refer to your clusterware documentation if the detailed output indicates that your clusterware is not running.
Do not use Terminal Services Client with any of the disk management tools. Changes may not be applied.
You may get the following warning message while using the Cluster Setup Wizard if you have OracleGSDService or OracleServiceSID running on any of the nodes in the cluster you are creating:
The nodes that we are trying to install the software on could not be cleaned completely
Stop these services on all the nodes and then start Oracle Cluster Setup Wizard again.
If mappings do not appear in the Object Link Manager, make sure the Oracle Object Service is started on all nodes in the cluster.
Make sure OracleServiceSID and OracleHOME_NAMETNSListener run under the same Windows account with the same user ID.
Most likely, an extended partition was not created. Create the extended partition and the multiple logical drives within the extended partition.
An Oracle database handles the datafile using the physical disk convention, even though it really is a logical drive. This will not cause any data corruption or loss, as long as the physical disk naming conventions continues to be used. Oracle Corporation recommends that you convert to the logical drive at your earliest convenience.
This poses severe problems, because the Disk Administrator typically writes a signature into the first block of every disk, and consequently the Oracle database may overwrite a portion of the signature with a datafile header.
|
|
![]() Copyright © 2003 Oracle Corporation. All Rights Reserved. |
|