Creating database tablespace on shared raw VxVM volumes

This section describes how to create database tablespace on shared raw VxVM volumes (option 1).

To create database tablespace on shared raw VxVM volumes (option 1)

  1. On any cluster node, log in as root. Find out the spare disks that can be used for creating shared disk group for Oracle database tablespaces, enter:
    # vxdisk -o alldgs list
    DEVICE TYPE          DISK   GROUP     STATUS
    sda    auto:none     -      -         online invalid
    sdb    auto:none     -      -         online invalid
    sdc    auto:cdsdisk  -      tempdg    online shared
    sdd    auto:cfsdisk  -      ocrvotedg online shared
    sde    auto:cdsdisk  -      -         online shared
    sdf    auto:cdsdisk  -      -         online shared

    The above sample output indicates that shared disks sde and sdf are free and can be used for Oracle database tablespaces.

  2. Create a shared disk group:
    # vxdg -s init oradatadg sde sdf
  3. Create a volume in the shared group for each of the required tablespaces.

    See the Oracle documentation specific to the Oracle database release to determine the tablespace requirements.

    For example, enter:

    # vxassist -g oradatadg make VRT_system01 1000M
    # vxassist -g oradatadg make VRT_system02 10M
    .
    .
    .
    
  4. Define the access mode and permissions for the volumes storing the Oracle data. For each volume listed in $ORACLE_HOME/raw_config, use the vxedit command:
    # vxedit -g disk_group set group=group user=user mode=660
    					volume

    See the vxedit(1M) manual page.

    For example, enter:

    # vxedit -g oradatadg set group=oinstall user=oracle mode=660 \
    VRT_system01

    In this example, VRT_system01 is the name of one of the volumes. Repeat the command to define access mode and permissions for each volume in the oradatadg.

  5. Create the database.

    See the Oracle documentation.