<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 Transitional//EN">
<HTML>
<HEAD>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

      For third-party license citations, please see the bottom of this file.
    *************************************************************************************
  -->
<meta http-equiv="Content-Type" content="text/html; charset=UTF-8">
<meta name="TEMPLATEBASE" content="vx_vxhelp_2005c">
<meta name="LASTUPDATED" content="06/15/05 07:50:25">
<meta name="PRODUCTNAME" content="VERITAS Software Documentation">
<meta name="FILENAME" content="0E_DB_create.fm">
     
<title>Creating a Starter Database on CFS Using dbca</title>

</HEAD>

<BODY bgcolor="#FFFFFF" link="#000066" vlink="#0000ff" marginheight="0" topmargin="0">
<basefont=1>

<a name="81397"></a>

<div align="left">
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
   <td height="2" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#000000">
   </td>
 </tr>
 <tr>
   <td height="15" width="50%" border="0" cellspacing="0" cellpadding="0" bgcolor="#cccccc">
    <img src="images/vxsymbol.gif" height="20" width="31" border="0" cellspacing="0" cellpadding="0" align="left">
     
     
   </td>
   <td align="right" width="50%" bgcolor="#cccccc">

<!-- Header Breadcrumbs -->
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="0E_DB_create_sf_ora_rac157_95683.html" title="Previous - Creating a Starter Database on Raw Volumes Using dbca">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="0F_linkrac_sf_ora_rac159_62674.html" title="Next - Appendix:  Linking VERITAS Libraries to Oracle">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
   </td>
 </tr>

 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_ora_rac_splashpage_docCD_sf_ora_rac1_103036.vxhd" title="Storage Foundation for Oracle RAC Guides title page ">Storage Foundation for Oracle RAC Guides</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>
 <tr>
  <td bgcolor="#CCCCCC" colspan="2" height="15" align="right">
  <font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="sfrac_icg_titlepage_docCD_sf_ora_rac2_73700.vxhd" title="Storage Foundation 4.1 for Oracle RAC Installation and Configuration title page ">Storage Foundation 4.1 for Oracle RAC Installation and Configuration</a>
  &nbsp;&nbsp;
  </font>
  </td>
 </tr>


</table>
</div>

<div align="left">
 <table border="0" width="100%" bgcolor="#FFFFFF">
  <tr>
   <td width="100%" valign="top" bgcolor="#FFFFFF">

<!-- Start Main Topic Content -->
        <a name="startcontent"></a>
	
<h1><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="+1" color="#000000"><a name="81397"></a> Creating a Starter Database on CFS Using dbca</font>
</h1>
         
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103580"></a>When creating a starter database on a cluster file system, create a disk group and volume for the tablespaces before running the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbca</font> utility.</font>
</p>




<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="79059"></a>Preparing a Cluster File System (CFS) for Tablespaces</font>
</h2>
 
<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103601"></a>Create a disk group (for example, <font face="Courier New, Courier, sansserif, sans serif" size="2">rac_dg</font>): 
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103602"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vxdg&nbsp;-s&nbsp;init&nbsp;rac_dg&nbsp;c2t3d1s2</b></font>
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103603"></a>Create a single shared volume (for example, <font face="Courier New, Courier, sansserif, sans serif" size="2">rac_vol1</font>) large enough to contain a file system for all the tablespaces. The tablespaces require about 6.8 GB:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103605"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vxassist&nbsp;-g&nbsp;rac_dg&nbsp;make&nbsp;rac_vol1&nbsp;6600M</b></font>
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103606"></a>Start the volume in the disk group:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103608"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vxvol&nbsp;-g</b></font>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>rac_dg</b></font>&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>startall</b></font>
</font>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103693"></a>Set the activation for the disk group on all cluster nodes:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103694"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>vxdg&nbsp;-g&nbsp;rac_dg&nbsp;set&nbsp;activation=sw</b></font>
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103610"></a>Create a VxFS file system in this volume. From one node, type:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103611"></a>&nbsp;&nbsp;#<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>&nbsp;mkfs&nbsp;-F&nbsp;vxfs&nbsp;/dev/vx/rdsk/rac_dg/rac_vol1</b></font>
</font>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103613"></a>Create a mount point for the shared file system:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103614"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>mkdir&nbsp;/rac_ts</b></font>
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103615"></a>From the same node, mount the file system:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103616"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>mount&nbsp;-F&nbsp;vxfs&nbsp;-o&nbsp;cluster&nbsp;/dev/vx/dsk/rac_dg/rac_vol1&nbsp;/rac_ts</b></font>
</font>
<li value="8">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103618"></a>Set &quot;oracle&quot; as the owner of the file system and &quot;755&quot; as the permissions:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103619"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chown&nbsp;oracle:dba&nbsp;/rac_ts</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103620"></a>&nbsp;&nbsp;#&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>chmod&nbsp;755&nbsp;/rac_ts</b></font>
</font>
<li value="9">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103763"></a>On the other node(s), complete <a href="0E_DB_create_sf_ora_rac158_81397.html#103613">step  6</a> through <a href="0E_DB_create_sf_ora_rac158_81397.html#103618">step  8</a>.
</font>
</ol>



<h2><font face="Arial, Helvetica, Geneva, sansserif, sans serif, Verdana" size="3" color="#000000"><a name="103764"></a>Running the dbca Utility for Cluster File System</font>
</h2>
 
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103800"></a>As <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font> user, use the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbca</font> utility on the master node to create a general purpose database on a cluster file system. This utility is a graphical user interface and requires setting the <font face="Courier New, Courier, sansserif, sans serif" size="2">DISPLAY</font> environment variable.</font>
</p>

<ol>
<li value="1">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103822"></a>Make sure an <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font> account is created on all nodes.
</font>
<li value="2">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103823"></a>Verify that <font face="Courier New, Courier, sansserif, sans serif" size="2">remsh</font> works among all the nodes under the <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font> account.
</font>
<li value="3">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103824"></a>Examine the <font face="Courier New, Courier, sansserif, sans serif" size="2">/var/opt/oracle/srvConfig.loc</font> configuration file and note the path name defined for the <font face="Courier New, Courier, sansserif, sans serif" size="2">srvconfig_loc</font> variable. For example, the path name may resemble:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103855"></a>&nbsp;&nbsp;srvconfig_loc=/orasrv/ora_srvm
</font>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103856"></a>where <font face="Courier New, Courier, sansserif, sans serif" size="2">/orasrv/ora_srvm</font> is the path name of the SRVM configuration file.</font>
</p>
<ol type=a>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103827"></a>Use the <font face="Courier New, Courier, sansserif, sans serif" size="2">ls -l </font><font face="Courier New, Courier, sansserif, sans serif" size="2"><i>pathname</i></font> command to display the long listing for the defined path. The file is initialized if the output shows a file size greater than zero bytes.</font>
</li>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103828"></a>If the variable is not initialized (size is 0), type:</font>
</li>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103829"></a>&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>srvconfig&nbsp;-init</b></font>
</font>
<li><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103830"></a>If the path is not yet defined (listing does not appear), initialize the variable after using the <font face="Courier New, Courier, sansserif, sans serif" size="2">touch</font> command to create it:</font>
</li>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103831"></a>&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>touch&nbsp;/orasrv/ora_srvm</b></font>
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103832"></a>&nbsp;&nbsp;&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>srvconfig&nbsp;-init</b></font>
</font>
</ol>
<li value="4">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103834"></a>Start the Oracle Real Application Clusters Manageability daemon on each node:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103835"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>gsdctl&nbsp;start</b></font>
</font>
<li value="5">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103836"></a>From one node, log in as <font face="Courier New, Courier, sansserif, sans serif" size="2">oracle</font> user.
</font>
<li value="6">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103838"></a>Create and start the Oracle listener using <font face="Courier New, Courier, sansserif, sans serif" size="2">NETCA</font> utility (refer to the <em>Oracle9i Installation Guide</em>):
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103839"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>netca</b></font>
</font>
<li value="7">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103840"></a>Run the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbca</font> utility. When starting the utility with a cluster file system, use the <font face="Courier New, Courier, sansserif, sans serif" size="2">-datafileDestination</font> option to specify the mount point. For example:
</font>
<br>
<font face="Courier New, Courier, sansserif, sans serif" size="2"><a name="103841"></a>&nbsp;&nbsp;$&nbsp;<font face="Courier New, Courier, sansserif, sans serif" size="2"><b>dbca&nbsp;-datafileDestination</b></font><font face="Courier New, Courier, sansserif, sans serif" size="2">&nbsp;</font><font face="Courier New, Courier, sansserif, sans serif" size="2"><b>/rac_ts</b></font>
</font>
</ol>
<p>
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="2"><a name="103810"></a>Refer to the Oracle documentation for details on the <font face="Courier New, Courier, sansserif, sans serif" size="2">dbca</font> utility.</font>
</p>


<!-- End Main Topic Content -->

   </td>
  </tr>
 </table>
</div>

<div>
<table border="0" cellspacing="0" cellpadding="0" width="100%">
 <tr>
  <td height="18" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
  </td>
 </tr>
  <td align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&nbsp;&#94;&nbsp;<a href="0E_DB_create_sf_ora_rac158_81397.html" title="Creating a Starter Database on CFS Using dbca">Return to Top</a></font>

  </td>
  <td align="right"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">&lt;&nbsp;<a href="0E_DB_create_sf_ora_rac157_95683.html" title="Previous - Creating a Starter Database on Raw Volumes Using dbca">Previous</a>&nbsp;&nbsp;|&nbsp;&nbsp;<a href="0F_linkrac_sf_ora_rac159_62674.html" title="Next - Appendix:  Linking VERITAS Libraries to Oracle">Next</a>
&nbsp;&gt;&nbsp;&nbsp;</font>
  </td>
 <tr>
   <td height="9" border="0" cellspacing="0" cellpadding="0" colspan="2" bgcolor="#FFFFFF">
   </td>
 </tr>

<!-- Footer Breadcrumbs -->
<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Product:  
<a href="sf_ora_rac_splashpage_docCD_sf_ora_rac1_103036.vxhd" title="Storage Foundation for Oracle RAC Guides title page ">Storage Foundation for Oracle RAC Guides</a>&nbsp;&nbsp;</font></td>
</tr>

<tr>
<td bgcolor="#FFFFFF" colspan="2" height="15" align="right">
<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="1">Manual:  
<a href="sfrac_icg_titlepage_docCD_sf_ora_rac2_73700.vxhd" title="Storage Foundation 4.1 for Oracle RAC Installation and Configuration title page ">Storage Foundation 4.1 for Oracle RAC Installation and Configuration</a>&nbsp;&nbsp;</font></td>
</tr>


 <tr>
  <td colspan="2" align="left"><font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" color="#000000" align="right" size="-2">
<em>VERITAS Software Corporation
</em></font><br>

<font face="Verdana, Arial, Helvetica, Geneva, sansserif, sans serif" size="-2">www.veritas.com</font><br>
  </td>
 </tr>
</table>
</div>

</BODY>
  <!--
    *************************************************************************************
    * Copyright (c) 2005 VERITAS Software Corporation. All rights reserved. *

    VERITAS, VERITAS SOFTWARE, the VERITAS Logo, and VERITAS Software Documentation 
    are trademarks or registered trademarks of VERITAS Software Corporation 
    or its affiliates in the U.S. and other countries. Other names may be 
    trademarks of their respective owners. 

    Apache Jakarta Lucene:
    Apache Software License
    Version 1.1

    Copyright (c) 2000 The Apache Software Foundation. All rights reserved.

    Redistribution and use in source and binary forms, with or without modification, 
    are permitted provided that the following conditions are met:

    1. Redistributions of source code must retain the above copyright notice, this 
    list of conditions and the following disclaimer.

    2. Redistributions in binary form must reproduce the above copyright notice, this 
    list of conditions and the following disclaimer in the documentation and/or other 
    materials provided with the distribution.

    3. The end-user documentation included with the redistribution, if any, must include 
    the following acknowledgment: "This product includes software developed by the Apache 
    Software Foundation (http://www.apache.org/)." Alternately, this acknowledgment may 
    appear in the software itself, if and wherever such third-party acknowledgments 
    normally appear.

    4. The names "Apache" and "Apache Software Foundation" must not be used to endorse or 
    promote products derived from this software without prior written permission. For 
    written permission, please contact apache@apache.org.

    5. Products derived from this software may not be called "Apache", nor may "Apache" 
    appear in their name, without prior written permission of the Apache Software Foundation.

    THIS SOFTWARE IS PROVIDED "AS IS" AND ANY EXPRESSED OR IMPLIED WARRANTIES, INCLUDING, 
    BUT NOT LIMITED TO, THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A 
    PARTICULAR PURPOSE ARE DISCLAIMED. IN NO EVENT SHALL THE APACHE SOFTWARE FOUNDATION 
    OR ITS CONTRIBUTORS BE LIABLE FOR ANY DIRECT, INDIRECT, INCIDENTAL, SPECIAL, EXEMPLARY, 
    OR CONSEQUENTIAL DAMAGES (INCLUDING, BUT NOT LIMITED TO, PROCUREMENT OF SUBSTITUTE GOODS 
    OR SERVICES; LOSS OF USE, DATA, OR PROFITS; OR BUSINESS INTERRUPTION) HOWEVER CAUSED AND 
    ON ANY THEORY OF LIABILITY, WHETHER IN CONTRACT, STRICT LIABILITY, OR TORT (INCLUDING 
    NEGLIGENCE OR OTHERWISE) ARISING IN ANY WAY OUT OF THE USE OF THIS SOFTWARE, EVEN IF 
    ADVISED OF THE POSSIBILITY OF SUCH DAMAGE.

    This software consists of voluntary contributions made by many individuals on behalf 
    of the Apache Software Foundation. For more information on the Apache Software Foundation, 
    please see <http://www.apache.org/>. Portions of this software are based upon public domain 
    software originally written at the National Center for Supercomputing Applications, University 
    of Illinois, Urbana-Champaign.
    
    This product includes WebWindow Software developed by Horst Heistermann.
    *************************************************************************************
  -->
</HTML>
