Skip Headers
Oracle® Database Installation Guide
11g Release 2 (11.2) for Linux

Part Number E10840-02
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

C Using NAS Devices

This appendix provides guidelines for using a network attached storage (NAS) storage device for Oracle software and database files. It includes information about the following:

See Also:

"Configuring and Using Direct NFS Client"

C.1 General Configuration Guidelines for NAS Devices

Refer to the documentation provided with the NAS device for specific information about how to configure it. In addition, use the following guidelines to ensure that the performance of the Oracle software meets the requirements:

C.2 NFS Feature Description

The following are the features of NFS:

C.3 Choosing Mount Points

This section provides guidelines on how to choose the mount points for the file systems that you want to use for the Oracle software and database files. The guidelines contained in the following sections comply with the Optimal Flexible Architecture recommendations:

C.3.1 Choosing Mount Points for Oracle Software Files

Oracle software files are stored in three different directories:

  • Oracle base directory

  • Oracle Inventory directory

  • Oracle home directory

For the first installation of Oracle software on a system, the Oracle base directory, identified by the ORACLE_BASE environment variable, is normally the parent directory for both the Oracle Inventory and Oracle home directories. For example, for a first installation, the Oracle base, Oracle Inventory, and Oracle home directories might have paths similar to the following:

Directory Path
Oracle base ($ORACLE_BASE) /u01/app/oracle
Oracle Inventory $ORACLE_BASE/oraInventory
Oracle home $ORACLE_BASE/product/11.2.0/dbhome_1

For subsequent installations, you can choose to use either the same Oracle base directory or a different one, but every subsequent installation uses the original Oracle Inventory directory. For example, if you use the /u02/app/oracle directory as the Oracle base directory for a new installation, then the Oracle Inventory directory continues to be /u01/app/oracle/oraInventory.

To enable you to effectively maintain the Oracle software on a particular system, Oracle recommends that you locate the Oracle Inventory directory only on a local file system, if possible. If you must place the Oracle Inventory directory on a NAS device, create a specific directory for each system, then to prevent more than one system from writing to the same Inventory.

Directory-Specific Guidelines

You can use any of the following directories as mount points for NFS file systems used to store Oracle software:

Note:

In the following examples, the paths shown are the defaults if the ORACLE_BASE environment variable is set before you start Oracle Universal Installer.
  • Oracle base directory or its parents (/u01/app/oracle for example)

    If you use the Oracle base directory of one of its parents as a mount point, then the default location for all Oracle software and database files will be on that file system. During the installation, you might consider changing the default location of the following directories:

    • The Oracle Inventory directory (oracle_base/oraInventory)

      Specify a local file system or a host-specific directory on the NFS file system, for example:

      oracle_base/hostname/oraInventory
      
    • The Oracle database file directory (oracle_base/oradata)

      You might want to use a different file system for database files, for example, to enable you to specify different mount options or to distribute I/O.

    • The Oracle database recovery file directory (oracle_base/recovery_area)

      Oracle recommends that you use different file systems for database and recovery files.

    If you use this mount point, then all Oracle installations that use this Oracle base directory will use the NFS file system.

  • The product directory (oracle_base/product)

    By default, only software files will be located on the NFS file system. You can also use this mount point to install software from different releases, for example:

    /u01/app/oracle/product/9.2.0
    /u01/app/oracle/product/10.2.0/dbhome_1
    /u01/app/oracle/product/11.2.0/dbhome_1
    
  • The release directory (oracle_base/product/11.2.0)

    By default, only software files will be located on the NFS file system. You can also use this mount point to install different products from the same release, for example:

    /u01/app/oracle/product/11.2.0/dbhome_1
    /u01/app/oracle/product/11.2.0/client_1
    
  • The Oracle home directory (oracle_base/product/11.2.0/dbhome_1)

    By default, only software files will be located on the NFS file system. This is the most restrictive mount point. You can use it only to install a single release of one product:

    /u01/app/oracle/product/11.2.0/dbhome_1
    

C.3.2 Choosing Mount Points for Oracle Database and Recovery Files

To store Oracle database or recovery files on a NAS device, you can use different paths depending on whether you want to store files from only one database or from more than one database:

  • Use the NFS file system for files from more than one database

    If you want to store the database files or recovery files from more than one database on the same NFS file systems, then use paths or mount points similar to the following:

    File Type Path or Mount Point
    Database files /u02/oradata
    Recovery files /u03/recovery_area

    When Oracle Universal Installer prompts you for the data file and the recovery file directories, specify these paths. The Database Configuration Assistant and Enterprise Manager create subdirectories in these directories using the value you specify for the database name (DB_NAME) as the directory name, for example:

    /u02/oradata/db_name1
    /u03/recovery_area/db_name1
    
  • Use the NFS file system for files from only one database

    If you want to store the database files or recovery files for only one database in the NFS file system, then you can create mount points similar to the following, where orcl is the name that you want to use for the database:

    /u02/oradata/orcl
    /u03/recovery_area/orcl
    

    Specify the directory /u02/oradata when Oracle Universal Installer prompts you for the data file directory and specify the directory /u03/recovery_area when Oracle Universal Installer prompts you for the recovery file location. The orcl directory will be used automatically either by Database Configuration Assistant or by Enterprise Manager.

C.4 Creating Files on a NAS Device for Use with Automatic Storage Management

If you have a certified NAS storage device, then you can create zero-padded files in an NFS mounted directory and use those files as disk devices in an Automatic Storage Management disk group. To create these files, follow these steps:

Note:

To use files as disk devices in an Automatic Storage Management disk group, the files must be on an NFS mounted file system. You cannot use files on local file systems.
  1. If necessary, create an exported directory for the disk group files on the NAS device.

    Refer to the NAS device documentation for more information about completing this step.

  2. Switch user to root:

    $ sudo sh
    password:
    
  3. Create a mount point directory on the local system:

    # mkdir -p /mnt/oracleasm
    
  4. To ensure that the NFS file system is mounted when the system restarts, add an entry for the file system in the /etc/mtab mount file.

    For more information about editing the mount file for the operating system, refer to the man pages. For more information about recommended mount options, refer to the "NFS Mount Options" section.

  5. Enter a command similar to the following to mount the NFS file system on the local system:

    # mount /mnt/oracleasm
    
  6. Choose a name for the disk group that you want to create, for example, nfsdg.

  7. Create a directory for the files on the NFS file system, using the disk group name as the directory name:

    # mkdir /mnt/oracleasm/nfsdg
    
  8. Use commands similar to the following to create the required number of zero-padded files in this directory:

    # dd if=/dev/zero of=/mnt/oracleasm/nfsdg/disk1 bs=1024k count=1000
    

    This example creates 1 GB files on the NFS file system. You must create one, two, or three files respectively to create an external, normal, or high redundancy disk group.

    Note:

    Creating multiple zero-padded files on the same NAS box does not guard against NAS box failure. Instead, create one file for each NAS box and mirror them using the Automatic Storage Management technology.
  9. Enter the following commands to change the owner, group, and permissions on the directory and files that you created:

    # chown -R oracle:dba /mnt/oracleasm
    # chmod -R 660 /mnt/oracleasm
    
  10. When you are creating the database, edit the Automatic Storage Management disk discovery string to specify a regular expression that matches the file names you created. For example, you might specify a disk discovery string similar to the following:

    /mnt/oracleasm/nfsdg/*
    

C.5 NFS Mount Options

You must mount NFS volumes used for storing database files with special mount options on the host where the database server is running. When mounting an NFS file system, Oracle recommends that you use the same mount point options that the NAS vendor used when certifying the device. Refer to the device documentation or contact the vendor for information about recommended mount-point options.

Option Requirement Description
hard Mandatory Generate a hard mount of the NFS file system. If the connection to the server fails or is temporarily lost, then connection attempts are made until the NAS device responds.
bg Optional Try to connect in the background if connection fails.
tcp Optional Use the TCP protocol rather than UDP. TCP is more reliable than UDP.
nfsvers=3 Optional Use NFS version 3. Oracle recommends that you use NFS version 3 where available, unless the performance of version 2 is later.
suid Optional Allow clients to run executables with SUID enabled. This option is required for Oracle software mount points.
rsize Mandatory The number of bytes used when reading from the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
wsize Mandatory The number of bytes used when writing to the NAS device. This value should be set to the maximum database block size supported by this platform. A value of 8192 is often recommended for NFS version 2 and 32768 is often recommended for NFS version 3.
nointr (or intr) Optional Do not allow (or allow) keyboard interrupts to end a process that is hung while waiting for a response on a hard-mounted file system.

Note: Different vendors have different recommendations about this option. Contact the vendor for advice.

actime=0 or noac Mandatory Disable attribute caching.

Note: You must specify this option for NFS file systems where you want to install the software. If you do not use this option, then Oracle Universal Installer will not install the software in the directory that you specify.

timeo Mandatory Represents number of seconds to timeout. Better overall performance may be achieved by increasing the timeout when mounting on a busy network, to a slow server, or through several routers or gateways. Oracle recommends that you set the timeout value to the maximum timeout for TCP, which is 600 seconds.
rw Mandatory Represents read and write access.