< Previous  | TOC | Index | Next  >

Creating Oracle 10g database on raw volumes

Creating a starter database on raw VxVM volumes involves the following tasks:

• Creating shared raw volume for database tablespaces
• Running the dbca utility for raw VxVM volumes

Creating shared raw volume for database tablespaces

You can create the database tablespaces on shared raw volume.

 To create shared raw volume for database tablespaces

1. Log in as superuser.
2. On the master node, create a shared disk group:

   # vxdg -s init oradatadg c4t1d2

3. Create a volume in the shared group for each of the required tablespaces. (Refer to the Oracle documentation to determine the tablespace requirements.) For example:

   # vxassist -g oradatadg make oradata_system1 1000M

   # vxassist -g oradatadg make oradata_spfile1 10M

   .

4. Deport and import the shared disk group to enable write access to it and to enable I/O fencing. On the CVM master node, enter:

   # vxdg deport oradatadg

   # vxdg -s import oradatadg

   # vxvol -g oradatadg startall

   # vxdg -g oradatadg set activation=sw

5. On each other node, enter:

   # vxdg -g oradatadg set activation=sw

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(1M) command:

   vxedit -g disk_group set group=group user=user mode=660 volume

   For example:

   # vxedit -g oradatadg set group=dba user=oracle mode=660 oradata_system1

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

7. You can now create the database using Oracle documentation.

Running the dbca utility for raw VxVM volumes

Use the dbca utility on the master node to create a general-purpose database on raw VxVM volumes. The utility is a graphical user interface and requires setting the DISPLAY environment variable.

 To create a database on raw VxVM volumes

1. Make sure an oracle account is created on all nodes.
2. Verify that remsh works among all nodes under the oracle account.
3. From one node, log in as oracle user.
4. Create and start the Oracle listener using the NETCA utility.

   Refer to the Oracle10g Installation Guide for more information.

   $ netca

5. Run the dbca utility to create the database.

   Refer to Oracle documentation for details on the dbca utility.