Creating database tablespace on shared raw VxVM volumes (option 1)

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. Log in as root.

  2. Find out the CVM master, enter the following command on any node:

    # vxdctl -c mode
    mode: enabled: cluster active - MASTER
    master: system01

    The above sample output indicates that system01 is the CVM master.

  3. On the CVM master, 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
    hdisk1 auto:none     -      -         online invalid
    hdisk2 auto:none     -      -         online invalid
    hdisk3 auto:cdsdisk  -      tempdg    online shared
    hdisk4 auto:none     -      ocrvotedg online shared
    hdisk5 auto:cdsdisk  -      -         online shared
    hdisk6 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.

  4. On the CVM master node, create a shared disk group:

    # vxdg -s init oradatadg hdisk5 hdisk6
  5. 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
    .
    .
    .
    
  6. 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.

  7. Create the database.

    See the Oracle documentation.