Edit D:\rfid\database\database\doc\install.112\e10818\dbcacrea.htm
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> <html lang="en" xml:lang="en" xmlns="http://www.w3.org/1999/xhtml"> <head> <meta http-equiv="Content-Type" content="text/html; charset=us-ascii" /> <meta http-equiv="Content-Language" content="en" /> <meta http-equiv="Content-Style-Type" content="text/css" /> <meta http-equiv="Content-Script-Type" content="text/javascript" /> <meta name="robots" content="all" scheme="http://www.robotstxt.org/" /> <meta name="generator" content="Oracle DARB XHTML Converter (Mode = document) - Version 5.1" /> <meta name="Date" content="2010-03-15T18:13:37Z" /> <meta name="doctitle" content="Oracle® Real Application Clusters Installation Guide 11g Release 2 (11.2) for Microsoft Windows" /> <meta name="partno" content="E10818-02" /> <meta name="docid" content="RIWIN" /> <link rel="Start" href="../../index.htm" title="Home" type="text/html" /> <link rel="Copyright" href="../../dcommon/html/cpyr.htm" title="Copyright" type="text/html" /> <link rel="Stylesheet" href="../../dcommon/css/blafdoc.css" title="Default" type="text/css" /> <script type="text/javascript" src="../../dcommon/js/doccd.js"> </script> <link rel="Contents" href="toc.htm" title="Contents" type="text/html" /> <link rel="Index" href="index.htm" title="Index" type="text/html" /> <link rel="Prev" href="racinstl.htm" title="Previous" type="text/html" /> <link rel="Next" href="postinst.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10818.pdf" title="PDF version" type="application/pdf" /> <title>Creating Oracle Real Application Clusters Databases with Database Configuration Assistant</title> </head> <body> <div class="header"> <div class="zz-skip-header"><a name="top" id="top" href="#BEGIN">Skip Headers</a></div> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"><b>Oracle® Real Application Clusters Installation Guide<br /> 11<i>g</i> Release 2 (11.2) for Microsoft Windows</b><br /> Part Number E10818-02</td> <td valign="bottom" align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <tr> <td align="left" valign="top"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="racinstl.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="postinst.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td align="right" valign="top" style="font-size: 90%"><a href="../e10818.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="BGBIJGDA" name="BGBIJGDA"></a><a id="RIWIN004" name="RIWIN004"></a> <h1 class="chapter"><span class="secnum">3</span> Creating Oracle Real Application Clusters Databases with Database Configuration Assistant</h1> <p>This chapter describes how to use Database Configuration Assistant (DBCA) in standalone mode to create and delete Oracle Real Application Clusters (Oracle RAC) databases. The topics in this chapter include the following:</p> <ul> <li> <p><a href="#BABJEAFA">Using Database Configuration Assistant with Oracle RAC</a></p> </li> <li> <p><a href="#BABFJGHF">Benefits of Using Database Configuration Assistant</a></p> </li> <li> <p><a href="#BABIDGEG">Automatic Listener Migration from Earlier Releases</a></p> </li> <li> <p><a href="#BABFFBBC">Verifying Requirements for DBCA</a></p> </li> <li> <p><a href="#BABCHEIC">Creating an Oracle RAC Database with DBCA</a></p> </li> <li> <p><a href="#BABIGJAH">Deleting an Oracle RAC Database with DBCA</a></p> </li> <li> <p><a href="#CACJFIDD">Configuring Database Control During Installation</a></p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink RACAD" href="http://www.oracle.com/pls/db112/lookup?id=RACAD"><span class="italic">Oracle Real Application Clusters Administration and Deployment Guide</span></a> for procedures on using DBCA to add and delete instances</div> </li> </ul> <a id="BABJEAFA" name="BABJEAFA"></a><a id="RIWIN401" name="RIWIN401"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">3.1</span> Using Database Configuration Assistant with Oracle RAC</h2> <p><a id="sthref184" name="sthref184"></a><a id="sthref185" name="sthref185"></a><a id="sthref186" name="sthref186"></a>DBCA has the following primary database functions:</p> <ul> <li> <p>Create and delete the database</p> </li> <li> <p>Add and delete database instances</p> </li> <li> <p>Set up network configuration for the database and its instances</p> </li> <li> <p>Register the database in Oracle Enterprise Manager Grid Control or configure Database Control</p> </li> <li> <p>Configure options for the database, such as Oracle Database Vault</p> </li> <li> <p>Start up the database and its instances</p> <div class="infoboxnote"> <p class="notep1">Note:</p> Cluster Managed Services are no longer managed through DBCA. Instead, use the cluster managed services page in Oracle Enterprise Manager DB Control (accessible from the Cluster Database Availability Page). For more information, refer to <span class="italic">Oracle Real Application Clusters Administration and Deployment Guide</span>.</div> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="#BABCHEIC">"Creating an Oracle RAC Database with DBCA"</a> for more information about using DBCA in standalone mode</p> </li> <li> <p><a class="olink NETAG" href="http://www.oracle.com/pls/db112/lookup?id=NETAG"><span class="italic">Oracle Database Net Services Administrator's Guide</span></a> to resolve problems—for example, with the listener configuration—and for further information about Lightweight Directory Access Protocol (LDAP)-compliant directory support</p> </li> <li> <p><a class="olink TDPRC" href="http://www.oracle.com/pls/db112/lookup?id=TDPRC"><span class="italic">Oracle Database 2 Day + Real Application Clusters Guide</span></a> for more information about using Oracle Enterprise Manager</p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BABFJGHF" name="BABFJGHF"></a><a id="RIWIN402" name="RIWIN402"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">3.2</span> Benefits of Using Database Configuration Assistant</h2> <p>Oracle recommends that you use DBCA to create your Oracle RAC database, because the preconfigured databases created by DBCA optimize your environment for features such as password security, the server parameter file (SPFILE), and automatic undo management. If you use Oracle ASM or cluster file system storage, then DBCA also configures automated backup, which uses the Fast Recovery Area.</p> <p>DBCA enables you to create both policy-managed and administrator-managed databases. At the end of database creation, DBCA starts any database instances required to support your defined configuration.</p> <p>With DBCA, you can create site-specific tablespaces as part of database creation. If you have data file requirements that differ from those offered by DBCA templates, then create your database with DBCA and modify the data files later. You can also run user-specified scripts as part of your database creation process.</p> </div> <!-- class="sect1" --> <a id="BABIDGEG" name="BABIDGEG"></a><a id="RIWIN1024" name="RIWIN1024"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">3.3</span> Automatic Listener Migration from Earlier Releases<a id="sthref187" name="sthref187"></a><a id="sthref188" name="sthref188"></a><a id="sthref189" name="sthref189"></a></h2> <p><a id="sthref190" name="sthref190"></a>If your system has an Oracle Database 10<span class="italic">g</span> or 11<span class="italic">g</span> installation, and you install Oracle Database 11<span class="italic">g</span> release 2 (11.2) either to coexist with or to upgrade the Oracle Database 10.1, 10.2, or 11.1 installation, then most installation types automatically migrate the existing Oracle Database listener to the 11<span class="italic">g</span> release 2 (11.2) Oracle home. During migration, they configure and start a default Oracle Net listener using the same TCP/IP port as the existing listener, with the IPC key value.</p> <p>During the Oracle Clusterware upgrade to 11<span class="italic">g</span> release 2 (11.2) the default listener (<span class="italic">LISTENER_NODENAME</span> was migrated to the Oracle grid infrastructure home (Grid home). DBCA always uses the default listener.</p> <p>The listener migration process stops the listener in the existing Oracle home, and restarts it in the new Oracle home. If the database was using the default listener (LISTENER_<span class="italic">NODENAME</span>), then it was migrated automatically to the Oracle Clusterware home by NETCA as part of the Oracle Clusterware upgrade. If the database was using a nondefault listener, then DBUA migrates the nondefault listener to the Oracle Database home.</p> <p>During migration, client applications may not be able to connect to any databases that are registered to the listener that is being migrated.</p> </div> <!-- class="sect1" --> <a id="BABFFBBC" name="BABFFBBC"></a><a id="RIWIN1026" name="RIWIN1026"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">3.4</span> Verifying Requirements for DBCA<a id="sthref191" name="sthref191"></a></h2> <p>If you want to use DBCA to change database configuration, then use Cluster Verification Utility (CVU) to verify that your system is prepared for configuration changes using the following command syntax:</p> <pre xml:space="preserve" class="oac_no_warn"><span class="italic">Grid_home</span>\bin\cluvfy stage -pre dbcfg -n <span class="italic">node_list</span> -d <span class="italic">Oracle_home</span> [-verbose] </pre> <p>In the preceding syntax example, the variable <code><span class="codeinlineitalic">Grid_home</span></code> is the Oracle grid infrastructure home, the variable <code><span class="codeinlineitalic">node_list</span></code> is the list of nodes in your cluster, separated by commas, and the variable <code><span class="codeinlineitalic">Oracle_home</span></code> is the path for the Oracle home directory where OUI creates or modifies the database.</p> <p>For example, to perform a check to determine if your system is prepared for an Oracle Database with Oracle RAC installation on a two-node cluster with nodes node1 and node2, with the Oracle grid infrastructure home path<code>C:\app\grid</code>, and with the Oracle home path <code>C:\app\oracle\product\11.2.0\dbhome1</code>, then enter the following command:</p> <pre xml:space="preserve" class="oac_no_warn">C:\app\grid\bin> cluvfy stage -pre dbcfg -n node1,node2 \ -d C:\app\oracle\product\11.2.0\dbhome1 </pre> <p>You can select the option <code>-verbose</code> to receive progress updates as the CVU performs its system checks, and detailed reporting of the test results.</p> <p>If the CVU summary indicates that the cluster verification check fails, then review and correct the relevant system configuration steps, and run the test again.</p> <p>The command <code>cluvfy stage -pre dbcfg</code> verifies the following:</p> <ul> <li> <p>Node Reachability: All the specified nodes are reachable from the local node.</p> </li> <li> <p>User Equivalence: User equivalence exists on all the specified nodes.</p> </li> <li> <p>Node Connectivity: Connectivity exists between all the specified nodes through the available public and private network interfaces.</p> </li> <li> <p>Administrative Privileges: The installation user (typically <code>oracle</code>) has proper administrative privileges on the specified nodes for creating an Oracle RAC database.</p> </li> <li> <p>Oracle Clusterware Integrity: All the components of the Oracle Clusterware stack are fully operational.</p> </li> </ul> </div> <!-- class="sect1" --> <a id="BABCHEIC" name="BABCHEIC"></a><a id="RIWIN404" name="RIWIN404"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">3.5</span> Creating an Oracle RAC Database with DBCA</h2> <p>To create an Oracle RAC database with DBCA without Oracle ASM or a cluster file system, you must have configured shared storage devices. In addition, you must have run the Oracle Net Configuration Assistant (NETCA) to configure your Oracle Net <code>listener.ora</code> file.</p> <p>On Windows-based systems, if you plan to use Oracle ASM storage, then before you use DBCA to create a database, you must first create logical partitions without primary partitions on the same drive and delete the drive letters for these partitions on all nodes, or stamp these partitions with <code>asmtool</code>. Refer to the <a class="olink CWWIN" href="../../install.112/e10817/toc.htm"><span class="italic">Oracle Grid Infrastructure Installation Guide for Microsoft Windows</span></a> for more information on configuring disk devices for use with Oracle ASM.</p> <p>To s<a id="sthref192" name="sthref192"></a><a id="sthref193" name="sthref193"></a>tart DBCA, connect as the installation owner account (for example, <code>oracle</code>)to one of your nodes where Oracle RAC is installed, and enter the command <code>dbca</code> command from the <code><span class="codeinlineitalic">Oracle_home</span></code><code>\bin</code> directory. On Windows-based platforms, you can also click <span class="bold">Start</span>, and select <span class="bold">Programs</span>, <span class="bold">Oracle -</span> <span class="bolditalic">Oracle_home name</span>, <span class="bold">Configuration and Migration Tools</span>, and then <span class="bold">Database Configuration Assistant</span>.</p> <p>When you start DBCA, the first page it displays is the Welcome page for Oracle RAC, which includes the option to select an Oracle RAC database. DBCA displays this Oracle RAC Welcome page only if the Oracle home from which it is started was installed on a cluster.<a id="sthref194" name="sthref194"></a><a id="sthref195" name="sthref195"></a> Enter information as prompted by DBCA. Click <span class="bold">Help</span> if you need assistance.</p> <a id="i1037229" name="i1037229"></a> <p>If DBCA does not display the Welcome page for Oracle RAC, then DBCA was unable to detect if the Oracle home is installed on a cluster. In this case, check that the OUI inventory is correctly located in the directory <code>C:\Program Files\Oracle\Inventory\oraInst.loc</code>, and that the inventory files are not corrupted. Also, perform clusterware diagnostics by using the following CVU command syntax:</p> <pre xml:space="preserve" class="oac_no_warn">cluvfy stage -post crsinst -n <span class="codeinlineitalic">nodelist</span>. </pre> <p>For example, on a cluster with nodes <code>node1</code> and <code>node2</code>, run the following command:</p> <pre xml:space="preserve" class="oac_no_warn">C:\app\grid\bin\cluvfy stage -post crsinst -n node1,node2 </pre> <p>Note the following important information when using DBCA:</p> <ul> <li> <p>If nodes that are part of your cluster installation do not appear on the Node Selection page, then execute the <code>opatch -lsinventory</code> command to perform inventory diagnostics and CVU to perform clusterware diagnostics.</p> </li> <li> <p>The global database name is of the form <code><span class="codeinlineitalic">database_name.domain</span></code>. The global database name can be up to 30 characters in length, and must begin with an alphabetic character. The domain portion of the global database name can be no more than 128 characters and can contain only alphabetic and numeric characters, as well as the period (.) character.</p> </li> <li> <p><a id="sthref196" name="sthref196"></a>A system identifier (SID) is used as an identifier unique to each Oracle instance. The system identifier (SID) prefix, or first 8 characters, must begin with an alphabetic character. For Oracle RAC database, the SID prefix is limited to 8 characters, and only letters and numeric digits are permitted. On some platforms, the SID is case-sensitive.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> It is common practice to set the SID to be equal to the database name. The maximum number of characters for the database name is 8. For more information, see the discussion of the <code>DB_NAME</code> initialization parameter in <a class="olink REFRN10041" href="http://www.oracle.com/pls/db112/lookup?id=REFRN10041"><span class="italic">Oracle Database Reference</span></a>.</div> </li> <li> <p>On the Management Options page, you are provided with selections for Oracle Enterprise Manager monitoring and management interfaces.</p> <p>Database Control is always an option. If DBCA discovers Grid Control agents on the cluster, then it also provides you with the option Enterprise Manager with the Grid Control. Choose between Database Control and Grid Control interfaces.</p> <p>You can set up e-mail notification and enable daily backup operations. For e-mail notifications, you provide the outgoing mail server and e-mail address. For daily backups, you enter the backup time and operating system credentials for the user that performs backup operations.</p> </li> <li> <p><span class="bold"><a id="sthref197" name="sthref197"></a><a id="sthref198" name="sthref198"></a></span>To use a fast recovery area, Oracle recommends that you create at least two separate Oracle ASM disk groups: one for the database data files and one for the fast recovery area. Oracle recommends that you place the database data files and the fast recovery area in separate failure groups using shared storage.</p> <p><a id="sthref199" name="sthref199"></a><a id="sthref200" name="sthref200"></a>A failure group is defined by shared hardware, such as a controller shared between two storage devices, or two disks that are on the same spindle. If two storage devices share hardware that could fail, making both storage devices unavailable, then these storage devices are said to be in the same failure group.</p> <p>If you do not use Oracle ASM, then Oracle recommends that you store the data files and the fast recovery area on shared storage outside of the Oracle home and in separate locations, similar to using separate Oracle ASM failure groups, so that a hardware failure does not affect availability.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a class="olink CNCPT" href="http://www.oracle.com/pls/db112/lookup?id=CNCPT"><span class="italic">Oracle Database Concepts</span></a> for more information about using a fast recovery area</p> </li> <li> <p><a class="olink OSTMG" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG"><span class="italic">Oracle Database Storage Administrator's Guide</span></a> for information about failure groups and best practices for high availability and recovery</p> </li> </ul> </div> </li> <li> <p><a id="sthref201" name="sthref201"></a><a id="sthref202" name="sthref202"></a><a id="sthref203" name="sthref203"></a><a id="sthref204" name="sthref204"></a> On the<a id="sthref205" name="sthref205"></a> Oracle ASM Disk Groups page, if you do not see the storage devices that you want to add, then click <span class="bold">Change Disk Discovery Path</span> to alter the search path used by DBCA to find available storage devices, or click <span class="bold">Stamp</span> <span class="bold">Disks</span> to start the <code>asmtoolg</code> GUI tool. You can select storage devices with a status of <code>Candidate</code> or <code>Former</code> (never used in an Oracle ASM disk group or no longer in a group). If you want to add storage devices that still have Oracle ASM disk headers, but the disk group is no longer in use (a case that can occur if you are selecting storage devices after an aborted installation attempt, you attempted deinstallation without dropping the disk group, or other configuration problems), then use the <code>Force</code> command.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink NTDBI" href="../../install.112/e10843/toc.htm"><span class="italic">Oracle Database Installation Guide for Microsoft Windows</span></a> for more information about <code>asmtoolg</code></div> </li> <li> <p>On the <a id="sthref206" name="sthref206"></a>Recovery Configuration page, if you are using Oracle ASM or cluster file system storage, then you can also select the fast recovery area and size on the Recovery Configuration page. If you are using Oracle ASM, then the fast recovery area defaults to an Oracle ASM disk group. <a id="sthref207" name="sthref207"></a>If you are using Oracle CFS, then the fast recovery area defaults to <code><span class="codeinlineitalic">Oracle_home</span></code><code>\fast_recovery_area</code>.</p> </li> <li> <p>For all platforms, if you intend to add more nodes in your cluster than you have during the current DBCA session, then click <span class="bold">All Initialization Parameters</span>, and change the parameter <code><a id="sthref208" name="sthref208"></a><a id="sthref209" name="sthref209"></a>CLUSTER_DATABASE_INSTANCES</code> to the total number of nodes that you plan to add to the cluster.</p> <p>In addition, if you click <span class="bold">All Initialization Parameters</span>, note that if your global database name is longer than 8 characters, then the database name value (in the <code><a id="sthref210" name="sthref210"></a><a id="sthref211" name="sthref211"></a>DB_NAME</code> parameter) is truncated to the first 8 characters, and the <code><a id="sthref212" name="sthref212"></a><a id="sthref213" name="sthref213"></a>DB_UNIQUE_NAME</code> parameter value is set to the global name.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN"><span class="italic">Oracle Database Administrator's Guide</span></a> for information about initialization parameters</div> </li> </ul> <p>After you respond to DBCA prompts, review the Summary dialog information and then click <span class="bold">OK</span>. DBCA does the following:</p> <ul> <li> <p>Starts the Oracle services if you are on a Windows-based platform</p> </li> <li> <p>Configures the network for the cluster database</p> </li> <li> <p>Migrates previous release Oracle Database listeners and related files to the Oracle Database 11<span class="italic">g</span> Oracle home</p> </li> <li> <p>Creates an Oracle RAC database and its instances</p> </li> <li> <p>Creates the Oracle RAC data dictionary views</p> </li> <li> <p>Configures Oracle Enterprise Manager Database Control or Grid Control</p> </li> <li> <p>Starts the listeners and database instances, and then starts the high availability services</p> </li> </ul> <div class="infoboxnote"> <p class="notep1">Caution:</p> <a id="sthref214" name="sthref214"></a>After you have created the database, if you decide that you want to install additional Oracle Database products in the database you have created, then you must stop <span class="italic">all</span> processes running in the Oracle home before you attempt to install the additional products. Refer to <a href="procstop.htm#BABEHGJG">Appendix E, "How to Stop Processes in an Existing Oracle Real Application Clusters Database"</a> for additional information.</div> </div> <!-- class="sect1" --> <a id="BABIGJAH" name="BABIGJAH"></a><a id="RIWIN405" name="RIWIN405"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">3.6</span> Deleting an Oracle RAC Database with DBCA<a id="sthref215" name="sthref215"></a><a id="sthref216" name="sthref216"></a></h2> <p><a id="sthref217" name="sthref217"></a>This section explains how to delete an Oracle RAC database with DBCA. This process deletes a database and removes a database's initialization parameter files, instances, OFA structure, and Oracle network configuration. However, this process does not remove data files if you placed the files on raw devices or on raw partitions.</p> <p>To <a id="sthref218" name="sthref218"></a><a id="sthref219" name="sthref219"></a>delete a database with DBCA:</p> <ol> <li> <p>Start DBCA on one of the nodes:.</p> <p>On Windows-based platforms, click <span class="bold">Start</span>, and select <span class="bold">Programs</span>, <span class="bold">Oracle -</span> <span class="bolditalic">Oracle_home name</span>. In the <span class="bold">Configuration and Migration Tools</span> folder select <span class="bold">Database Configuration Assistant</span></p> <p>The DBCA Welcome page appears.</p> </li> <li> <p>Select <span class="bold">Oracle Real Application Clusters database,</span> then click <span class="bold">Next</span>.</p> <p>After you click Next, DBCA displays the <a id="sthref220" name="sthref220"></a>Operations page.</p> </li> <li> <p>Select <span class="bold">Delete a database</span>, and then click <span class="bold">Next</span>.</p> <p>DBCA displays the <a id="sthref221" name="sthref221"></a><a id="sthref222" name="sthref222"></a>List of Cluster Databases page.</p> </li> <li> <p>If your user ID and password are not operating-system authenticated, then the List of Cluster Databases page displays the user name and password fields. If these fields appear, then enter a user ID and password for a user account that has <code>SYSDBA</code> privileges.</p> </li> <li> <p>Select the database to delete, and click <span class="bold">Finish</span>.</p> <p>After you click Finish, DBCA displays a <a id="sthref223" name="sthref223"></a><a id="sthref224" name="sthref224"></a>dialog box to confirm the database and instances that DBCA is going to delete.</p> </li> <li> <p>Click <span class="bold">OK</span> to begin the deletion of the database and its associated files, services, and environment settings, or click <span class="bold">Cancel</span> to stop the operation.</p> </li> </ol> <p>If you clicked OK, then DBCA continues the operation and deletes all the associated instances for this database. DBCA also removes the parameter files and password files.</p> <p>At this point, you have accomplished the following:</p> <ul> <li> <p>Deleted the selected database from the cluster</p> </li> <li> <p>Deleted the Oracle services for the database on Windows-based platforms</p> </li> <li> <p>Deleted high availability services that were assigned to the database</p> </li> <li> <p>Deleted the Oracle Net configuration for the database</p> </li> <li> <p>Deconfigured Database Control for that database</p> </li> <li> <p>Deleted the OFA directory structure for that database from the cluster</p> </li> <li><a id="i1031801" name="i1031801"></a> <p>Deleted the data files if the data files were not on raw devices</p> </li> </ul> </div> <!-- class="sect1" --> <a id="CACJFIDD" name="CACJFIDD"></a><a id="RIWIN1027" name="RIWIN1027"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">3.7</span> Configuring <a id="sthref225" name="sthref225"></a>Database Control During Installation</h2> <p>If you create a database while installing Oracle RAC 11<span class="italic">g</span> release 2 (11.2), then you have the option of configuring your database so it can be managed by Oracle Enterprise Manager Grid Control Console, or by Oracle Enterprise Manager 11<span class="italic">g</span> Database Control Console.</p> <p>When you configure Database Control for your Oracle RAC database, for each Oracle RAC instance on a node, the following subdirectory is created, where <code><span class="codeinlineitalic">Oracle_home</span></code> is the directory where the Oracle RAC software is installed, <code><span class="codeinlineitalic">nodename</span></code> is the name of the node in the cluster and <code><span class="codeinlineitalic">DBUniqueName</span></code> is the database unique name:</p> <pre xml:space="preserve" class="oac_no_warn"><span class="codeinlineitalic">Oracle_home</span>\<span class="codeinlineitalic">nodename_DBUniqueName</span> </pre> <p>To select Grid Control Console as your management option, the Oracle Management Service must be installed on a network host. In addition, the Oracle Management Agent must be installed on the host where you are installing the database. Otherwise, the Grid Control Console option is unavailable, and you must instead choose to manage your database with Database Control.</p> <p>For most Oracle RAC 11<span class="italic">g</span> release 2 (11.2) installation types, you must choose either Database Control or Grid Control as your management option when you create a database during the installation. However, if you create a database using one of the following methods, then you can choose not to configure Database Control:</p> <ul> <li> <p>Choosing the Advanced database configuration option during an Enterprise or Standard Edition installation</p> </li> <li> <p>Running Database Configuration Assistant (DBCA) after the installation</p> </li> </ul> <p>If you do not configure Database Control during the Oracle RAC 11<span class="italic">g</span> release 2 (11.2) installation, then no <span class="italic">hostname_dbuniquename</span> directory is created in the resulting Oracle home directory.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="srvpool.htm#CACIAIFG">"Understanding EMCA with Oracle RAC"</a></p> </li> <li> <p><a href="srvpool.htm#BHBGJGBI">"Configuring Enterprise Manager Database Control"</a></p> </li> </ul> </div> </div> <!-- class="sect1" --></div> <!-- class="ind" --> <div class="footer"> <hr /> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="100%"> <col width="33%" /> <col width="*" /> <col width="33%" /> <tr> <td align="left"> <table class="simple oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="98"> <tr> <td align="center" valign="top"><a href="racinstl.htm"><img width="24" height="24" src="../../dcommon/gifs/leftnav.gif" alt="Go to previous page" /><br /> <span class="icon">Previous</span></a></td> <td align="center" valign="top"><a href="postinst.htm"><img width="24" height="24" src="../../dcommon/gifs/rightnav.gif" alt="Go to next page" /><br /> <span class="icon">Next</span></a></td> </tr> </table> </td> <td style="font-size: 90%" align="center" class="copyrightlogo"><img width="144" height="18" src="../../dcommon/gifs/oracle.gif" alt="Oracle" /><br /> Copyright © 2007, 2010, Oracle and/or its affiliates. All rights reserved.<br /> <a href="../../dcommon/html/cpyr.htm">Legal Notices</a></td> <td align="right"> <table class="icons oac_no_warn" summary="" cellspacing="0" cellpadding="0" width="245"> <tr> <td align="center" valign="top"><a href="../../index.htm"><img width="24" height="24" src="../../dcommon/gifs/doclib.gif" alt="Go to Documentation Home" /><br /> <span class="icon">Home</span></a></td> <td align="center" valign="top"><a href="../../nav/portal_booklist.htm"><img width="24" height="24" src="../../dcommon/gifs/booklist.gif" alt="Go to Book List" /><br /> <span class="icon">Book List</span></a></td> <td align="center" valign="top"><a href="toc.htm"><img width="24" height="24" src="../../dcommon/gifs/toc.gif" alt="Go to Table of Contents" /><br /> <span class="icon">Contents</span></a></td> <td align="center" valign="top"><a href="index.htm"><img width="24" height="24" src="../../dcommon/gifs/index.gif" alt="Go to Index" /><br /> <span class="icon">Index</span></a></td> <td align="center" valign="top"><a href="../../dcommon/html/feedback.htm"><img width="24" height="24" src="../../dcommon/gifs/feedbck2.gif" alt="Go to Feedback page" /><br /> <span class="icon">Contact Us</span></a></td> </tr> </table> </td> </tr> </table> </div> <noscript> <p>Scripting on this page enhances content navigation, but does not change the content in any way.</p> </noscript> </body> </html>
Ms-Dos/Windows
Unix
Write backup
jsp File Browser version 1.2 by
www.vonloesch.de