6 Configuring Storage for Oracle Grid Infrastructure and Oracle RAC

6.1.1 Supported Storage Options for Oracle Grid Infrastructure and Oracle RAC

Both Oracle Clusterware and the Oracle RAC database use files that must be available to all the nodes in the cluster. The following table shows the storage options supported for storing Oracle Clusterware and Oracle RAC files.

6.1.2 General Storage Considerations for Oracle Grid Infrastructure

Oracle Clusterware uses voting files to monitor cluster node status, and the Oracle Cluster Registry (OCR) is a file that contains the configuration information and status of the cluster. The installer automatically initializes the OCR during the Oracle Clusterware installation. Oracle Database Configuration Assistant (DBCA) uses the OCR for storing the configurations for the cluster databases that it creates.

Use the following guidelines when choosing storage options for the Oracle Clusterware files:

• The Oracle Grid Infrastructure home (Grid home) cannot be stored on a shared file system; it must be installed on a local disk.

• You can choose any combination of the supported storage options for each file type if you satisfy all requirements listed for the chosen storage options.

• You can store Oracle Cluster Registry (OCR) and voting files in Oracle ASM disk groups. You can also store a backup of the OCR file in a disk group.

  See Also:

  Oracle Database Upgrade Guide for information about how to prepare for upgrading an existing database

• For a storage option to meet high availability requirements, the files stored on the disk must be protected by data redundancy, so that if one or more disks fail, then the data stored on the failed disks can be recovered. This redundancy can be provided externally using Redundant Array of Independent Disks (RAID) devices, or logical volumes on multiple physical devices and implement the stripe-and-mirror- everything methodology, also known as SAME.

• If you do not have a RAID devices or logical volumes to provide redundancy, then you can create additional copies, or mirrors, of the files on different file systems. If you choose to mirror the files, then you must provide disk space for additional OCR files and at least two additional voting files.

• Each OCR location should be placed on a different disk.

• For voting files, ensure that each file does not share any hardware device or disk, or other single point of failure with the other voting files. Any node that does not have available to it an absolute majority of voting files (more than half, or a quorum) configured will be restarted.

• If you do not have a storage option that provides external file redundancy, then you must use Oracle ASM, or configure at least three voting file locations to provide redundancy.

• Except when using external redundancy, Oracle ASM mirrors all Oracle Clusterware files in separate failure groups within a disk group. A quorum failure group, a special type of failure group, contains mirror copies of voting files when voting files are stored in normal or high redundancy disk groups.

6.1.3 General Storage Considerations for Oracle RAC

For all Oracle RAC installations, you must choose the shared storage options to use for Oracle Database files. Oracle Database files include data files, control files, redo log files, the server parameter file, and the password file.

If you plan to configure automated backups, then you must also choose a shared storage option to use for recovery files (the fast recovery area). Oracle recommends that you choose Oracle ASM as the shared storage option for the database data files and recovery files. The shared storage option that you choose for recovery files can be the same as or different from the shared storage option that you choose for the data files.

If you do not use Oracle ASM, then Oracle recommends that you place the data files and the Fast Recovery Area in shared storage located outside of the Oracle home, in separate locations, so that a hardware failure does not affect availability.

Use the following guidelines when choosing storage options for the Oracle RAC files:

• You can choose any combination of the supported storage options for each file type if you satisfy all requirements listed for the chosen storage options.

• Oracle recommends that you choose Oracle ASM as the storage option for database and recovery files.

• If you intend to use Oracle ASM with Oracle RAC, and you are configuring a new Oracle ASM instance, then your system must meet the following conditions:

  • All the nodes in the cluster must have Oracle Clusterware and Oracle ASM 12c Release 1 (12.1) installed as part of an Oracle Grid Infrastructure for a cluster installation.

  • Any existing Oracle ASM instance on any node in the cluster is shut down before installing Oracle RAC or creating the Oracle RAC database.

• For Standard Edition and Standard Edition 2 (SE2) Oracle RAC installations, Oracle ASM is the only supported shared storage option for database or recovery files. You must use Oracle ASM for the storage of Oracle RAC data files, online redo logs, archived redo logs, control files, server parameter file (SPFILE), and the fast recovery area.

6.1.4 About Oracle ACFS and Oracle ADVM

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) and Oracle ASM Dynamic Volume Manager (Oracle ADVM) are the main components of Oracle Cloud File System (Oracle CloudFS).

Oracle ACFS extends Oracle ASM technology to support of all of your application data in both single instance and cluster configurations. Oracle ADVM provides volume management services and a standard disk device driver interface to clients. Oracle Automatic Storage Management Cluster File System communicates with Oracle ASM through the Oracle Automatic Storage Management Dynamic Volume Manager interface.

6.2.1 Guidelines for Using Oracle ASM Disk Groups for Storage

During Oracle Grid Infrastructure installation, you can create one disk group. After the Oracle Grid Infrastructure installation, you can create additional disk groups using Oracle Automatic Storage Management Configuration Assistant (ASMCA), SQL*Plus, or Automatic Storage Management Command-Line Utility (ASMCMD). Note that with Oracle Database 11g Release 2 (11.2) and later releases, Oracle Database Configuration Assistant (DBCA) does not have the functionality to create disk groups for Oracle ASM.

If you install Oracle Database or Oracle RAC after you install Oracle Grid Infrastructure, then you can either use the same disk group for database files, OCR, and voting files, or you can use different disk groups. If you create multiple disk groups before installing Oracle RAC or before creating a database, then you can decide whether you want to:

• Place the data files in the same disk group as the Oracle Clusterware files.

• Use the same Oracle ASM disk group for data files and recovery files.

• Use different disk groups for each file type.

If you create only one disk group for storage, then the OCR and voting files, database files, and recovery files are contained in the one disk group. If you create multiple disk groups for storage, then you can choose to place files in different disk groups.

6.2.2 Guidelines for Using Direct Network File System (NFS) with Oracle RAC

Network attached storage (NAS) systems use a network file system (NFS) to access data. You can store Oracle RAC data files and recovery files on a supported NAS server using Direct NFS Client.

NFS file systems must be mounted and available over NFS mounts before you start the Oracle RAC installation. See your vendor documentation for NFS configuration and mounting information.

Note that the performance of Oracle Database software and the databases that use NFS storage depend on the performance of the network connection between the database server and the NAS device. For this reason, Oracle recommends that you connect the database server (or cluster node) to the NAS device using a private, dedicated, network connection, which should be Gigabit Ethernet or better.

6.2.3 Guidelines for Using Oracle ACFS with Oracle RAC

Oracle Automatic Storage Management Cluster File System (Oracle ACFS) provides a general purpose file system. Oracle ACFS extends Oracle ASM technology to support of all of your application data in both single instance and cluster configurations. Oracle ADVM provides volume management services and a standard disk device driver interface to clients. Oracle Automatic Storage Management Cluster File System communicates with Oracle ASM through the Oracle Automatic Storage Management Dynamic Volume Manager interface.

You can place the Oracle home for Oracle Database 12c Release 1 (12.1) software on Oracle ACFS, but you cannot place Oracle Clusterware files on Oracle ACFS.

Note the following about Oracle ACFS:

• You cannot put Oracle Clusterware executable files or shared files on Oracle ACFS.

• You must use a domain user when installing Oracle Grid Infrastructure if you plan to use Oracle ACFS.

• Starting with Oracle Grid Infrastructure 12c Release 1 (12.1) for a cluster, creating Oracle data files on an Oracle ACFS file system is supported.

• You can put Oracle Database binaries and administrative files (for example, trace files) on Oracle ACFS.

• When creating Oracle ACFS file systems on Windows, log on as a Windows domain user. Also, when creating files in an Oracle ACFS file system on Windows, you should be logged in as a Windows domain user to ensure that the files are accessible by all nodes.

  When using a file system across cluster nodes, the best practice is to mount the file system using a domain user, to ensure that the security identifier is the same across cluster nodes. Windows security identifiers, which are used in defining access rights to files and directories, use information which identifies the user. Local users are only known in the context of the local node. Oracle ACFS uses this information during the first file system mount to set the default access rights to the file system.

6.2.4 Guidelines for Placing Recovery Files on a File System

If you choose to place the recovery files on a cluster file system, then use the following guidelines when deciding where to place them:

• To prevent disk failure from making the database files and the recovery files unavailable, place the recovery files on a cluster file system that is on a different physical disk from the database files.

  Note:

  Alternatively use an Oracle ASM disk group with a normal or high redundancy level for data files, recovery files, or both file types, or use external redundancy.

• The cluster file system that you choose should have at least 3 GB of free disk space.

  The disk space requirement is the default disk quota configured for the fast recovery area (specified by the DB_RECOVERY_FILE_DEST_SIZE initialization parameter).

  If you choose the Advanced database configuration option, then you can specify a different disk quota value. After you create the database, you can also use Oracle Enterprise Manager to specify a different value.

  See Also:

  Oracle Database Backup and Recovery User's Guide for more information about sizing the fast recovery area.

6.3.1 Requirements for Using a Cluster File System for Oracle Database Files

If you choose to place your Oracle Database software or data files on a clustered file system, then one of the following should be true:

• The disks used for the file system are on a highly available storage device, (for example, a RAID device).

• You use at least two independent file systems, with the database files on one file system, and the recovery files on a different file system.

The user account with which you perform the installation must be able to create the files in the path that you specify.

6.3.2 Identifying Storage Requirements for Using Oracle ASM for Shared Storage

Before installing Oracle Grid Infrastructure, you must identify and determine how many devices are available for use by Oracle ASM, the amount of free disk space available on each disk, and the redundancy level to use with Oracle ASM. When Oracle ASM provides redundancy, you must have sufficient capacity in each disk group to manage a re-creation of data that is lost after a failure of one or two failure groups.

1. Determine whether you want to use Oracle ASM for Oracle Clusterware files (OCR and voting files), Oracle Database data files, recovery files, or all file types.

   Note:

   • You do not have to use the same storage mechanism for data files and recovery files. You can store one type of file in a cluster file system while storing the other file type within Oracle ASM. If you plan to use Oracle ASM for both data files and recovery files, then you should create separate Oracle ASM disk groups for the data files and the recovery files.

   • There are two types of Oracle Clusterware files: OCR files and voting files. Each type of file can be stored on either Oracle ASM or a cluster file system. All the OCR files or all the voting files must use the same type of storage. You cannot have some OCR files stored in Oracle ASM and other OCR files in a cluster file system. However, you can use one type of storage for the OCR files and a different type of storage for the voting files if all files of each type use the same type of storage.

2. Choose the Oracle ASM redundancy level to use for the Oracle ASM disk group.

   The redundancy level that you choose for the Oracle ASM disk group determines how Oracle ASM mirrors files in the disk group, and determines the number of disks and amount of disk space that you require. If the voting files are in a disk group, then the disk groups that contain Oracle Clusterware files (OCR and voting files) have a higher minimum number of failure groups than other disk groups because the voting files are stored in quorum failure groups.

   A quorum failure group is a special type of failure group that stores the Oracle Clusterware voting files. The quorum failure group ensures that a quorum of the specified failure groups are available. When Oracle ASM mounts a disk group that contains Oracle Clusterware files, the quorum failure group determines if the disk group can be mounted in the event of the loss of one or more failure groups. Disks in the quorum failure group do not contain user data, therefore a quorum failure group is not considered when determining redundancy requirements in respect to storing user data.

   The redundancy levels are as follows:

   • External redundancy

     An external redundancy disk group requires a minimum of one disk device. The effective disk space in an external redundancy disk group is the sum of the disk space in all of its devices.

     Because Oracle ASM does not mirror data in an external redundancy disk group, Oracle recommends that you use external redundancy with storage devices such as RAID, or other similar devices that provide their own data protection mechanisms.

   • Normal redundancy

     A normal redundancy disk group requires a minimum of two disk devices (or two failure groups). The effective disk space in a normal redundancy disk group is half the sum of the disk space in all of its devices.

     For Oracle Clusterware files, a normal redundancy disk group requires a minimum of three disk devices (failure groups use two of the three disks and the quorum failure group uses all three disks) and provides three voting files and one OCR and mirror of the OCR. When using a normal redundancy disk group, the cluster can survive the loss of one failure group.

     For most installations, Oracle recommends that you select normal redundancy disk groups.

   • High redundancy

     In a high redundancy disk group, Oracle ASM uses three-way mirroring to increase performance and provide the highest level of reliability. A high redundancy disk group requires a minimum of three disk devices (or three failure groups). The effective disk space in a high redundancy disk group is one-third the sum of the disk space in all of its devices.

     For Oracle Clusterware files, a high redundancy disk group requires a minimum of five disk devices (failure groups use three of the five disks and the quorum failure group uses all five disks) and provides five voting files and one OCR and two mirrors of the OCR. With high redundancy, the cluster can survive the loss of two failure groups.

     While high redundancy disk groups provide a high level of data protection, you should consider the greater cost of additional storage devices before deciding to use this redundancy level.

   Note:

   After a disk group is created, you cannot alter the redundancy level of the disk group.

3. Determine the total amount of disk space that you require for the Oracle Clusterware files using Oracle ASM for shared storage.

   Use Table 6-2, "Oracle Clusterware Storage Required by Redundancy Type" to determine the minimum number of disks and the minimum disk space requirements for installing Oracle Clusterware using Oracle ASM for shared storage:

   Table 6-2 Oracle Clusterware Storage Required by Redundancy Type

   Redundancy Level	Minimum Number of Disks	Oracle Cluster Registry (OCR) Files	Voting Files	Both File Types	Total
   External	1	400 MB	300 MB	700 MB	At least 5.9 GB for a cluster with 4 nodes or less (5.2 GBFoot 1  + 400 MB + 300 MB). Additional space required for clusters with 5 or more nodes. For example, a six-node cluster allocation should be at least 6.9 GB: (5.2 GB + 2*(500 MB) + 400 MB + 300 MB).
   Normal	3	At least 400 MB for each failure group, or 800 MB	At least 300 MB for each voting file, or 900MB	1.7 GB	At least 12.1 GB for a cluster with 4 nodes or less (10.4 GB + 2*400 MB + 3*300 MB). Additional space required for clusters with 5 or more nodes. For example, for a six-node cluster allocation should be at least 14.1 GB: (2 * (5.2 GB + 2*(500 MB)) + (2 * 400 MB) + (3 * 300 MB)).
   High	5	At least 400 MB for each failure group, or 1.2 GB	At least 300 MB for each voting file, or 1.5 GB	2.7 GB	At least 18.3 GB for a cluster with 4 nodes or less (3* 5.2 GB + 3*400 MB + 5*300 MB). Additional space required for clusters with 5 or more nodes. For example, for a six-node cluster allocation should be at least 21.3 GB: (3* (5.2 GB + 2*(500 MB))+ (3 * 400 MB) + (5 * 300 MB)).

   
   

   ^Footnote 1 The size of the Grid Infrastructure Management Repository for Oracle Clusterware 12.1.0.2 is 5.2 GB. For Oracle Clusterware 12.1.0.1, the size is 4.5 GB.

   Note:

   If the voting files are in a disk group, then the disk groups that contain Oracle Clusterware files (OCR and voting files) have a higher minimum number of failure groups than other disk groups.

   If you create a disk group for the OCR and voting files as part of the installation, then the installer requires that you create these files on a disk group with at least 2 GB of available space.

   To ensure high availability of Oracle Clusterware files on Oracle ASM, you must have at least 2 GB of disk space for Oracle Clusterware files in three separate failure groups, with at least three physical disks. Each disk must have at least 1 GB of capacity to ensure that there is sufficient space to create Oracle Clusterware files.

4. Determine an allocation unit size. Every Oracle ASM disk is divided into allocation units (AU). An allocation unit is the fundamental unit of allocation within a disk group. You can select the AU Size value from 1, 2, 4, 8, 16, 32 or 64 MB, depending on the specific disk group compatibility level. The default value is set to 1 MB.

5. For Oracle Clusterware installations, you must also add additional disk space for the Oracle ASM metadata. You can use the following formula to calculate the disk space requirements (in MB) for OCR and voting files, and the Oracle ASM metadata:

   total = [2 * ausize * disks] + [redundancy * (ausize * (nodes * (clients + 1) + 30) + (64 * nodes) + 533)]

   Where:

   • redundancy = Number of mirrors: external = 1, normal = 2, high = 3

   • ausize = Metadata AU size in megabytes (default is 1 MB)

   • nodes = Number of nodes in cluster

   • clients = Number of database instances for each node

   • disks = Number of disks in disk group

   For example, for a four-node Oracle RAC installation, using three disks in a normal redundancy disk group, and a default AU size of 1 MB, you require an additional 1684 MB of space:

   [2 * 1 * 3] + [2 * (1 * (4 * (4 + 1)+ 30)+ (64* 4)+ 533)] = 1684 MB

   To ensure high availability of Oracle Clusterware files on Oracle ASM, for a normal redundancy disk group, you must have at least 2 GB of disk space for Oracle Clusterware files in three separate failure groups, with at least three physical disks. Each disk must have at least 2.1 GB of capacity, with total capacity of at least 6.3 GB for three disks, to ensure that the effective disk space to create Oracle Clusterware files is 2 GB.

6. Determine the total amount of disk space that you require for the Oracle database files and recovery files.

   Use the following table to determine the minimum number of disks and the minimum disk space requirements for installing the starter database:

   Table 6-3 Total Oracle Database Storage Space Required by Redundancy Type

   Redundancy Level	Minimum Number of Disks	Database Files	Recovery Files	Both File Types
   External	1	1.5 GB	3 GB	4.5 GB
   Normal	2	3 GB	6 GB	9 GB
   High	3	4.5 GB	9 GB	13.5 GB

   
   

   Note:

   The file sizes listed in the previous table are estimates of minimum requirements for a new installation (or a database without any user data). The file sizes for your database will be larger.

7. Determine if you can use an existing disk group.

   If an Oracle ASM instance currently exists on the system, then you can use an existing disk group to meet these storage requirements. If necessary, you can add disks to an existing disk group during the installation. See Section 6.3.3.1, "Identifying Existing Oracle ASM Disk Groups to Use" for more information about using an existing disk group.

8. If there is no existing Oracle ASM disk group to use, then create one or more Oracle ASM disk groups, as needed, before installing Oracle RAC. See Section 6.3.3.2, "Selecting Disks to use with Oracle ASM Disk Groups" for more information about selecting disks to use in a disk group.

9. Optionally, identify failure groups for the Oracle ASM disk group devices.

   Note:

   You only have to complete this step if you plan to use an installation method that includes configuring Oracle ASM disk groups before installing Oracle RAC, or creating an Oracle RAC database.

   If you intend to use a normal or high redundancy disk group, then you can further protect your database against hardware failure by associating a set of disk devices in a custom failure group. Failure groups define Oracle ASM disks that share a common potential failure mechanism. By default, each device comprises its own failure group. If you choose to define custom failure groups, then note the following:

   • You must specify a minimum of two failure groups for normal redundancy disk groups and three failure groups for high redundancy disk groups.

   • If the disk group contains data files and Oracle Clusterware files, including the voting files, then you must specify a minimum of three failure groups for normal redundancy disk groups and five failure groups for high redundancy disk groups.

   • Disk groups containing voting files must have at least three failure groups for normal redundancy or at least five failure groups for high redundancy. If the disk group does not contain the voting files, then the minimum number of required failure groups is two for normal redundancy and three for high redundancy. The minimum number of failure groups applies whether or not they are custom failure groups.

   If two disk devices in a normal redundancy disk group are attached to the same small computer system interface (SCSI) controller, then the disk group becomes unavailable if the controller fails. The SCSI controller in this example is a single point of failure. To protect against failures of this type, you could use two SCSI controllers, each with two disks, and define a failure group for the disks attached to each controller. This configuration enables the disk group to tolerate the failure of one SCSI controller.

   Note:

   You can define custom failure groups after installation of Oracle Grid Infrastructure using the GUI tool ASMCA, the command-line tool asmcmd, or SQL*Plus commands.

   See Also:

   Oracle Automatic Storage Management Administrator's Guide for more information about Oracle ASM failure groups

6.3.3 Preparing Your System to Use Oracle ASM for Shared Storage

To use Oracle ASM as the shared storage solution for Oracle Clusterware or Oracle RAC files, you must perform certain tasks before you begin the software installation.

• Identifying Existing Oracle ASM Disk Groups to Use

• Selecting Disks to use with Oracle ASM Disk Groups

• Restrictions for Disk Partitions Used By Oracle ASM

• Specifying the Oracle ASM Disk Discovery String

6.3.4 Restrictions for Disk Partitions Used By Oracle ASM

Be aware of the following restrictions when configuring disk partitions for use with Oracle ASM:

• You cannot use primary partitions for storing Oracle Clusterware files while running OUI to install Oracle Clusterware as described in Chapter 7, "Installing Oracle Grid Infrastructure for a Cluster". You must create logical drives inside extended partitions for the disks to be used by Oracle Clusterware files and Oracle ASM.

• With x64 Windows, you can create up to 128 primary partitions for each disk.

• You can create shared directories only on primary partitions and logical drives.

• Oracle recommends that you limit the number of partitions you create on a single disk to prevent disk contention. Therefore, you may prefer to use extended partitions rather than primary partitions.

For these reasons, you might prefer to use extended partitions for storing Oracle software files and not primary partitions.

6.3.5 Requirements for Using a Shared File System

To use a shared file system for Oracle RAC, the file system must comply with the following requirements:

• To use NFS, it must be on a certified network attached storage (NAS) device. Access the My Oracle Support website as described in Section 3.4, "Checking Hardware and Software Certification on My Oracle Support" to find a list of certified NAS devices.

• If placing the Oracle RAC data files on a shared file system, then one of the following should be true:

  • The disks used for the file system are on a highly available storage device, (for example, a RAID device).

  • The file systems consist of at least two independent file systems, with the data files on one file system, and the recovery files on a different file system.

• The user account with which you perform the installation must be able to create the files in the path that you specify for the shared storage.

Use the following table to determine the minimum size for shared file systems:

The total required volume size is cumulative. For example, if you use one volume for data files and one volume for recovery files, then you should have at least 3.5 GB of available storage over two volumes.

6.3.6 Requirements for Files Managed by Oracle

If you use Oracle ASM for your database files, then Oracle creates the database with Oracle Managed files by default. When using the Oracle Managed files feature, you need specify only the database object name instead of file names when creating or deleting database files.

6.5.1 Disabling Write Caching

You must disable write caching on all disks that will be used to share data between the nodes in your cluster.

1. Click Start, then select Control Panel, then Administrative Tools, then Computer Management, then Device Manager, and then Disk drives

2. Expand the Disk drives and double-click the first drive listed.

3. Under the Policies tab for the selected drive, uncheck the option that enables write caching.

4. Double-click each of the other drives that will be used by Oracle Clusterware and Oracle RAC and disable write caching as described in the previous step.

6.5.2 Enabling Automounting for Windows

Even though the automount feature is enabled by default, you should verify that automount is enabled.

You must enable automounting when using:

• Raw partitions for Oracle ASM

• Oracle Clusterware

• Logical drives for Oracle ASM

To determine if automatic mounting of new volumes is enabled, use the following commands:

C:\> diskpart
DISKPART> automount
Automatic mounting of new volumes disabled.

To enable automounting:

1. Enter the following commands at a command prompt:

   C:\> diskpart
   DISKPART> automount enable
   Automatic mounting of new volumes enabled.
   

2. Type exit to end the diskpart session

3. Repeat steps 1 and 2 for each node in the cluster.

4. You must restart each node after enabling disk automounting. After it is enabled and the node is restarted, automatic mounting remains active until it is disabled.

6.6.1 Create Disk Partitions for Use With Oracle ASM

The following steps outline the procedure for creating disk partitions for use with Oracle ASM:

1. Use Microsoft Computer Management utility or the command line tool diskpart to create an extended partition. Use a basic disk; dynamic disks are not supported.

2. Create at least one logical partition for the Oracle Clusterware files. You do not have to create separate partitions for the OCR and voting file; Oracle Clusterware creates individual files for the OCR and voting file in the specified location.

3. If your file system does not use a redundant array of inexpensive disks (RAID), then create an additional extended partition and logical partition for each partition that will be used by Oracle Clusterware files, to provide redundancy.

To create the required partitions, use the Disk Management utilities available with Microsoft Windows. Use a basic disk with a Master Boot Record (MBR) partition style as an extended partition for creating partitions.

1. From an existing node in the cluster, run the Windows disk administration tool as follows:

   See Section 6.7, "Configuring Disk Partitions on Shared Storage" for instructions on creating disk partitions using the DISKPART utility.

2. On each node in the cluster, ensure that the partitions are visible and that none of the disk partitions created for shared storage have drive letters assigned. If any partitions have drive letters assigned, then remove them by performing these steps:

   • Right-click the partition in the Windows disk administration tool

   • Select "Change Drive Letters and Paths" from the menu

   • Click Remove in the "Change Drive Letter and Paths" window

6.6.2 Marking Disk Partitions for Oracle ASM Before Installation

The only partitions that OUI displays for Windows systems are logical drives that are on disks that do not contain a primary partition, and have been marked (or stamped) with asmtool. Configure the disks before installation either by using asmtoolg (graphical user interface (GUI) version) or using asmtool (command line version). You also have the option of using the asmtoolg utility during Oracle Grid Infrastructure for a cluster installation.

The asmtoolg and asmtool utilities only work on partitioned disks; you cannot use Oracle ASM on unpartitioned disks. You can also use these tools to reconfigure the disks after installation. These utilities are installed automatically as part of Oracle Grid Infrastructure.

asmtool -add [-force]
\Device\Harddisk1\Partition1 ORCLDISKASM0
\Device\Harddisk2\Partition1 ORCLDISKASM2
...

asmtool -addprefix ORCLDISKASM [-force]
\Device\Harddisk1\Partition1
\Device\Harddisk2\Partition1
...

asmtool -create \\server\share\file 1000

asmtool -create D:\asm\asmfile02.asm 240

asmtool -list

asmtool -delete ORCLDISKASM0 ORCLDISKASM1...

6.7.1 Creating Disk Partitions Using the Disk Management Interface

Use the graphical user interface Disk Management snap-in to manage disks.

1. To access the Disk Management snap-in, do one of the following:

   1. Type diskmgmt.msc at the command prompt

   2. From the Start menu, select All Programs, then Administrative Tools, then Computer Management. Then select the Disk Management node in the Storage tree.

2. Create primary partitions and logical drives in extended partitions by selecting the New Simple Volume option. You must select Do not format this partition to specify raw partition. Do not use spanned volumes or striped volumes. These options convert the volume to a dynamic disk. Oracle Automatic Storage Management does not support dynamic disks.

   For other Windows, create primary partitions by selecting the New Partition option. Create the logical drives by selecting the New Logical Drive option.

3. To create a raw device, after the partition is created, you must remove the drive letter that was assigned to the partition.

6.7.2 Creating Disk Partitions using the DiskPart Utility

To create the required partitions, perform the following steps:

1. From an existing node in the cluster, run the DiskPart utility as follows:

   C:\> diskpart
   DISKPART>
   

2. List the available disks. By specifying its disk number (n), select the disk on which you want to create a partition.

   DISKPART> list disk
   DISKPART> select disk n
   

3. Create an extended partition:

   DISKPART> create part ext
   

4. Create a logical drive of the desired size after the extended partition is created using the following syntax:

   DISKPART> create part log [size=n] [offset=n] [noerr]
   

5. Repeat steps 2 through 4 for the second and any additional partitions. An optimal configuration is one partition for the Oracle home and one partition for Oracle Database files.

6. List the available volumes, and remove any drive letters from the logical drives you plan to use.

   DISKPART> list volume
   DISKPART> select volume n
   DISKPART> remove
   

7. Check all nodes in the cluster to ensure that the partitions are visible on all the nodes and to ensure that none of the Oracle partitions have drive letters assigned. If any partitions have drive letters assigned, then remove them by performing these steps:

   • Right-click the partition in the Windows Disk Management utility

   • Select "Change Drive Letters and Paths" from the menu

   • Click Remove in the "Change Drive Letter and Paths" window

6.8.1 About Direct NFS Client Storage

With Oracle Database, instead of using the operating system NFS client or third-party NFS client, you can configure Oracle Database to use Direct NFS Client NFS to access NFS servers directly. Direct NFS Client supports NFSv3, NFSv4 and NFSv4.1 protocols (excluding the Parallel NFS extension) to access the NFS server. Direct NFS Client tunes itself to make optimal use of available resources and enables the storage of data files on supported NFS servers.

To enable Oracle Database to use Direct NFS Client, the NFS file systems must be mounted and available over regular NFS mounts before you start installation. Direct NFS Client manages settings after installation. If Oracle Database cannot open an NFS server using Direct NFS Client, then an informational message is logged into the Oracle alert log. A trace file is also created, indicating that Direct NFS Client could not connect to an NFS server.

The Oracle files resident on the NFS server that are accessed by Direct NFS Client can also be accessed through a third party NFS client. Management of Oracle data files created with Direct NFS Client should be done according to the guidelines specified in the "Managing Datafiles and Tempfiles" chapter of Oracle Database Administrator's Guide.

Volumes mounted through Common Internet File System (CIFS) can not be used for storing Oracle database files without configuring Direct NFS Client. The atomic write requirements needed for database writes are not guaranteed through the CIFS protocol, consequently CIFS can only be used for OS level access, for example, for commands such as copy.

Some NFS file servers require NFS clients to connect using reserved ports. If your filer is running with reserved port checking, then you must disable it for Direct NFS to operate. To disable reserved port checking, consult your NFS file server documentation.

For NFS servers that restrict port range, you can use the insecure option to enable clients other than an Administrator user to connect to the NFS server. Alternatively, you can disable Direct NFS Client as described in Section 6.8.9, "Disabling Oracle Disk Management Control of NFS for Direct NFS Client."

6.8.2 About the Oranfstab File for Direct NFS Client

If you use Direct NFS Client, then you must create a configuration file, oranfstab, to specify the options, attributes, and parameters that enable Oracle Database to use Direct NFS Client. Direct NFS Client looks for the mount point entries in oranfstab. It uses the first matched entry as the mount point. You must create the oranfstab file in the Oracle_home\dbs directory.

When the oranfstab file is placed in Oracle_home\dbs, the entries in the file are specific to a single database. For Oracle RAC installations in a shared Oracle home, the oranfstab file is globally available to all database instances. All instances that use the shared Oracle home use the same Oracle_home\dbs\oranfstab file. For a nonshared Oracle home, because all the Oracle RAC instances use the same oranfstab file, you must replicate the oranfstab file on all of the nodes. Also, you must keep the oranfstab file synchronized on all the nodes.

6.8.3 Configurable Attributes for the oranfstab File

6.8.4 Mounting NFS Storage Devices with Direct NFS Client

Direct NFS Client determines mount point settings for NFS storage devices based on the configuration information in oranfstab. Direct NFS Client uses the first matching entry as the mount point. If Oracle Database cannot open an NFS server using Direct NFS Client, then an error message is written into the Oracle alert and trace files indicating that Direct NFS Client could not be established.

Direct NFS Client requires an NFS server supporting NFS read/write buffers of at least 16384 bytes.

Direct NFS Client issues writes at wtmax granularity to the NFS server. Direct NFS Client does not serve an NFS server with a wtmax less than 16384. Oracle recommends that you use the value 32768.

6.8.5 Specifying Network Paths for a NFS Server

Direct NFS Client can use up to four network paths defined in the oranfstab file for an NFS server. Direct NFS Client performs load balancing across all specified paths. If a specified path fails, then Direct NFS Client re-issues all outstanding requests over any remaining paths.

Example 6-1 and Example 6-2 provide examples of configuring network paths for Direct NFS Client attributes in an oranfstab file.

6.8.6 Enabling Direct NFS Client

To enable Direct NFS Client, you must add an oranfstab file to Oracle_home\dbs. When oranfstab is placed in this directory, the entries in this file are specific to one particular database. Direct NFS Client searches for the mount point entries as they appear in oranfstab. Direct NFS Client uses the first matched entry as the mount point.

1. Create an oranfstab file and specify the attributes listed in Section 6.8.3, "Configurable Attributes for the oranfstab File" for each NFS server that Direct NFS Client accesses:

   See Also:

   "Limiting Asynchronous I/O in NFS Server Environments" in Oracle Database Performance Tuning Guide

   The mount point specified in the oranfstab file represents the local path where the database files would reside normally, as if Direct NFS Client was not used. For example, if the location for the data files would be C:\app\oracle\oradata\orcl directory if the database did not use Direct NFS Client, then you specify C:\app\oracle\oradata\orcl for the NFS virtual mount point in the corresponding oranfstab file.

   Example 6-1 and Example 6-2 provide examples of how Direct NFS Client attributes can be used in an oranfstab file.

   Note:

   • Direct NFS Client ignores a uid or gid value of 0.

   • The exported path from the NFS server must be accessible for read/write/execute by the user with the uid, gid specified in oranfstab. If neither uid nor gid is listed, then the exported path must be accessible by the user with uid:65534 and gid:65534.

2. Replace the standard ODM library, oraodm12.dll, with the ODM NFS library.

   Oracle Database uses the ODM library, oranfsodm12.dll, to enable Direct NFS Client. To replace the ODM library, complete the following steps:

   1. Change directory to Oracle_home\bin.

   2. Shut down the Oracle Database instance on a node using the Server Control Utility (SRVCTL).

   3. Enter the following commands:

      copy oraodm12.dll oraodm12.dll.orig
      copy /Y oranfsodm12.dll oraodm12.dll 
      

   4. Restart the Oracle Database instance using SRVCTL.

   5. Repeat Step a to Step d for each node in the cluster.

server: MyDataServer1
local: 192.0.2.0
path: 192.0.2.1
local: 192.0.100.0
path: 192.0.100.1
nfs_version: nfsv3
export: /vol/oradata1 mount: C:\APP\ORACLE\ORADATA\ORCL
 

server: MyDataServer2
local: LocalInterface1
path: NfsPath1
local: LocalInterface2
path: NfsPath2
local: LocalInterface3
path: NfsPath3
local: LocalInterface4
path: NfsPath4
nfs_version: nfsv4
export: /vol/oradata2 mount: C:\APP\ORACLE\ORADATA\ORCL2
export: /vol/oradata3 mount: C:\APP\ORACLE\ORADATA\ORCL3
management: MgmtPath1
community: private

6.8.7 Performing Basic File Operations Using the ORADNFS Utility

ORADNFS is a utility which enables the database administrators to perform basic file operations over Direct NFS Client on Microsoft Windows platforms.

ORADNFS is a multi-call binary, which is a single binary that acts like many utilities.

You must be a member of the local ORA_DBA group to use ORADNFS. A valid copy of the oranfstab configuration file must be present in Oracle_home\dbs for ORADNFS to operate.

• To execute commands using ORADNFS you issue the command as an argument on the command line.

  The following command prints a list of commands available with ORADNFS:

  C:\> oradnfs help
  

  To display the list of files in the NFS directory mounted as C:\ORACLE\ORADATA, use the following command:

  C:\> oradnfs ls C:\ORACLE\ORADATA\ORCL
  

6.8.8 Monitoring Direct NFS Client Usage

Use the following global dynamic performance views for managing Direct NFS Client usage with your Oracle RAC database:

• GV$DNFS_SERVERS: Lists the servers that are accessed using Direct NFS Client.

• GV$DNFS_FILES: Lists the files that are currently open using Direct NFS Client.

• GV$DNFS_CHANNELS: Lists the open network paths, or channels, to servers for which Direct NFS Client is providing files.

• GV$DNFS_STATS: Lists performance statistics for Direct NFS Client.

6.8.9 Disabling Oracle Disk Management Control of NFS for Direct NFS Client

If you no longer want to use the Direct NFS client, you can disable it.

1. Log in as the Oracle Grid Infrastructure software owner.

2. Restore the original oraodm12.dll file by reversing the process you completed in Section 6.8.6, "Enabling Direct NFS Client."

3. Remove the oranfstab file.