< Previous  | TOC | Index | Next  >

Creating Oracle9i database on raw volumes

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

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

Creating shared raw volumes for tablespaces

To create a starter database on raw VxVM volumes, prepare the shared storage for the database tablespaces.

 To create shared raw volumes for tablespaces

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

   # vxdg -s init ora_dg c2t3d1s2

3. Create a volume in the shared group for each of the required tablespaces:

   # vxassist -g ora_dg make VRT_system1 1000M

   # vxassist -g ora_dg make VRT_spfile1 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(1M) command:

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

   For example:

   # vxedit -g ora_dg set group=dba user=oracle mode=660 VRT_system1

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

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. Make sure the file configured for srvm is accessible to the oracle user.
4. Start the Oracle Real Application Clusters Manageability daemon on each node:

   $ gsdctl start

5. From one node, log in as oracle user.
6. Create and start the Oracle listener using the NETCA utility.

   Refer to the Oracle9i Installation Guide for more information.

   $ netca

7. Run the dbca utility to create the database.

   Refer to Oracle documentation for details on the dbca utility.