Edit D:\rfid\database\database\doc\install.112\e10843\intro.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.1 Build 026" /> <meta name="Date" content="2010-03-23T20:31:35Z" /> <meta name="doctitle" content="Oracle® Database Installation Guide 11g Release 2 (11.2) for Microsoft Windows" /> <meta name="partno" content="E10843-03" /> <meta name="docid" content="NTDBI" /> <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="Glossary" href="glossary.htm" title="Glossary" type="text/html" /> <link rel="Prev" href="whatsnew.htm" title="Previous" type="text/html" /> <link rel="Next" href="reqs.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10843.pdf" title="PDF version" type="application/pdf" /> <title>Overview of Oracle Database Installation</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® Database Installation Guide<br /> 11<i>g</i> Release 2 (11.2) for Microsoft Windows</b><br /> Part Number E10843-03</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="whatsnew.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="reqs.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="../e10843.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="BABHDHHA" name="BABHDHHA"></a><a id="i1006491" name="i1006491"></a> <h1 class="chapter"><span class="secnum">1</span> <a name="NTDBI001" id="NTDBI001"></a> Overview of Oracle Database Installation</h1> <p><a id="ABC4336899" name="ABC4336899"></a>This chapter describes the different installation types of Oracle Database and issues to consider before you install Oracle Database:</p> <ul> <li> <p><a href="#CHDDFIIB">New Oracle Products and Features Installed with This Release</a></p> </li> <li> <p><a href="#BABIDCGG">Planning Your Installation</a></p> </li> <li> <p><a href="#i1005728">Installation Considerations</a></p> </li> <li> <p><a href="#BABEGIJD">Migration Considerations</a></p> </li> <li> <p><a href="#CEGDACJD">Oracle Database Installation Methods</a></p> </li> <li> <p><a href="#i1005984">Oracle Database Editions</a></p> </li> <li> <p><a href="#BABGDEHD">Database Configuration Options</a></p> </li> <li> <p><a href="#CEGBGDFE">Database Storage Options</a></p> </li> <li> <p><a href="#BGEDFBEA">Database Management Options</a></p> </li> <li> <p><a href="#BGEGHEIC">Database Backup and Recovery Options</a></p> </li> <li> <p><a href="#BGEGDGGE">E-mail Notification Options</a></p> </li> <li> <p><a href="#CIHHGABI">Upgrade Considerations</a></p> </li> </ul> <a id="CHDDFIIB" name="CHDDFIIB"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.1</span> New Oracle Products and Features Installed with This Release</h2> <p>There are many new features and products installed with this release. See the <a href="whatsnew.htm#BGGJDGAA">What's New in Oracle Database 11<span class="italic">g</span> Release 2 (11.2)</a> chapter.</p> </div> <!-- class="sect1" --> <a id="BABIDCGG" name="BABIDCGG"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.2</span> Planning Your Installation</h2> <p><a id="sthref11" name="sthref11"></a>The Oracle Database installation process consists of six steps:</p> <ol> <li> <p><span class="bold">Read the release notes</span>: Read the Oracle Database <a id="sthref12" name="sthref12"></a>release notes before you begin the installation. The release notes are available with the platform-specific documentation. The latest version of the release notes is available on Oracle Technology Network at</p> <p><code><a href="http://www.oracle.com/technology/documentation">http://www.oracle.com/technology/documentation</a></code></p> </li> <li> <p><span class="bold">Review the licensing information:</span> Although the installation media in your media pack contain many Oracle components, you are permitted to use only those components for which you have purchased licenses.</p> <p>Oracle Support Services does not provide support for components for which licenses have not been purchased.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink DBLIC" href="http://www.oracle.com/pls/db112/lookup?id=DBLIC">Oracle Database Licensing Information</a></span></div> </li> <li> <p><span class="bold">Plan the installation</span>: This overview chapter describes the Oracle products that you can install and issues that you must consider before starting the installation.</p> <p>You also may want to see <a href="faq.htm#CBAGIJDJ">Appendix G</a>, which covers frequently asked questions about installing Oracle Database components, such as how to install Oracle Database if your site uses Oracle applications or if you need multiple Oracle Database client connections.</p> <p>If you plan to perform multiple installations, see <a href="advance.htm#CHDICDJA">Appendix C</a> for information about silent or response file installations, and cloning the Oracle home.</p> <p>Oracle Database Client is installed separately. You cannot install Oracle Database Client during an Oracle Database installation.</p> </li> <li> <p><span class="bold">Complete preinstallation tasks</span>: <a href="reqs.htm#BCFHFECH">Chapter 2</a> describes tasks that you must complete before installing Oracle Database.</p> </li> <li> <p><span class="bold">Install the software</span>: Use the following sections to install Oracle Database:</p> <ul> <li> <p><a href="install.htm#CIHIFHCB">Chapter 4</a> describes how to use Oracle Universal Installer to install Oracle Database and how to clone an Oracle home.</p> </li> <li> <p><a href="oraclerestart.htm#CIHCBGCC">Chapter 3</a> describes how to use Oracle Universal Installer to install grid infrastructure for a standalone server and Oracle Automatic Storage Management from the grid infrastructure media.</p> </li> <li> <p><a href="deinstall.htm#CIHDGGJJ">Chapter 7</a> describes how to remove Oracle Database software.</p> </li> <li> <p><a href="advance.htm#CHDICDJA">Appendix C</a> describes how to perform silent or response file installations, which you may want to use to perform multiple installations of Oracle Database.</p> </li> <li> <p><a href="gblsupp.htm#CEGEAADF">Appendix D</a> describes how to install and use Oracle components in different languages.</p> </li> <li> <p><a href="ts.htm#BABFDJDB">Appendix F</a> provides troubleshooting advice in case you encounter problems with the installation.</p> </li> </ul> </li> <li> <p><span class="bold">Complete postinstallation tasks</span>: <a href="postcfg.htm#CEGGCJGH">Chapter 5</a> describes postinstallation tasks.</p> </li> <li> <p><span class="bold">Get started using Oracle Database</span>: Use the following sections to get started using Oracle Database:</p> <ul> <li> <p><a href="startrdb.htm#BDCCGFFA">Chapter 6</a> describes how to check the contents of the installed Oracle Database, how to start the database and various other Oracle tools, and how to locate various files.</p> </li> <li> <p><a href="install.htm#BBAIFCGB">"Cloning an Oracle Home"</a> describes how you can clone an existing Oracle Database home.</p> </li> <li> <p><a href="ofa.htm#CBBEDHEB">Appendix B</a> on the Optimal Flexible Architecture, which is a set of guidelines that ensure reliable Oracle installations that require little maintenance.</p> </li> <li> <p><a href="gblsupp.htm#CEGEAADF">Appendix D</a> describes globalization support information.</p> </li> <li> <p><a href="ports.htm#BABECFJF">Appendix E</a> explains how to manage Oracle Database port numbers.</p> </li> </ul> </li> </ol> </div> <!-- class="sect1" --> <a id="i1005728" name="i1005728"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">1.3</span> Installation Considerations</h2> <p>This section contains information that you should consider before deciding how to install this product. It contains the following sections:</p> <ul> <li> <p><a href="#i1005689">Installation Differences Between Windows and UNIX Systems</a></p> </li> <li> <p><a href="#BHCIIDDD">Recommended File System</a></p> </li> <li> <p><a href="#CHDBJCJA">Managing User Accounts with User Account Control</a></p> </li> <li> <p><a href="#CHDCDIJI">Hardware and Software Certification</a></p> </li> <li> <p><a href="#BABHHAJC">Multiple Oracle Homes Support</a></p> </li> <li> <p><a href="#CHDBDGID">Grid Infrastructure for a Standalone Server</a></p> </li> <li> <p><a href="#BABBIEGB">Oracle Cluster Synchronization Services</a></p> </li> <li> <p><a href="#i1005848">Oracle Universal Installer Overview</a></p> </li> <li> <p><a href="#CCHFHHFI">Oracle Base Directory</a></p> </li> <li> <p><a href="#BABFHEHD">Oracle Home Directory</a></p> </li> <li> <p><a href="#CHDCHJDH">Installing Oracle Database Vault in an Oracle Data Guard Environment</a></p> </li> <li> <p><a href="#CEGDFJBF">Oracle Database Vault Default Audit Policy and Initialization Parameters</a></p> </li> </ul> <a id="i1005689" name="i1005689"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">1.3.1</span> Installation Differences Between Windows and UNIX Systems<a id="sthref13" name="sthref13"></a><a id="sthref14" name="sthref14"></a><a id="sthref15" name="sthref15"></a></h3> <p><a id="sthref16" name="sthref16"></a>If you are experienced with installing Oracle components in UNIX environments, note that many manual setup tasks required on UNIX are not required on Windows. The key differences between UNIX and Windows installations are:</p> <ul> <li> <p>Startup and shutdown services</p> <p>With Windows, Oracle Universal Installer creates services at installation time that can be configured to automatically start the Oracle software components when the host computer starts. On Linux and UNIX systems, database or system administrators must manually configure the <code>oratab</code> file.</p> </li> <li> <p>Environment variables</p> <p><a id="sthref17" name="sthref17"></a>With Windows, Oracle Universal Installer sets environment variables such as <a id="sthref18" name="sthref18"></a><a id="sthref19" name="sthref19"></a><code><span class="codeinlineitalic">PATH</span></code>, <code><span class="codeinlineitalic"><a id="sthref20" name="sthref20"></a><a id="sthref21" name="sthref21"></a>ORACLE_BASE</span></code>, <code><span class="codeinlineitalic"><a id="sthref22" name="sthref22"></a><a id="sthref23" name="sthref23"></a>ORACLE_HOME</span></code>, and <code><span class="codeinlineitalic"><a id="sthref24" name="sthref24"></a><a id="sthref25" name="sthref25"></a>ORACLE_SID</span></code> in the registry. In UNIX systems, you must manually set these environment variables.</p> <p>If you have multiple Oracle homes installed, then only the SID of the last Oracle home is set in the registry. See <span class="italic"><a class="olink OUICG" href="../../em.112/e12255/toc.htm">Oracle Universal Installer and OPatch User's Guide for Windows and UNIX</a></span> for more information about managing Oracle homes.</p> </li> <li> <p>Operating System Groups</p> <p>On Windows systems, Oracle Universal Installer creates the <code>ORA_DBA</code>, <code>ORA_OPER</code>, <code>ORA_</code><code><span class="codeinlineitalic">SID</span></code><code>_DBA</code> and <code>ORA_</code><code><span class="codeinlineitalic">SID</span></code><code>_OPER</code> groups, which are used for operating system authentication for Oracle instances. On Linux and UNIX systems, you must create these operating system groups manually, and they are used for granting permission to access various Oracle software resources and for operating system authentication. Windows does not use an Oracle Inventory group.</p> </li> <li> <p>Account for running Oracle Universal Installer</p> <p>With Windows, you log in with Administrator privileges. You do not need a separate account. On Linux and UNIX systems, you must create and use a software owner user account, and this user must belong to the Oracle Inventory group.</p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> "Oracle Database Windows/UNIX Differences" appendix in <span class="italic"><a class="olink NTQRF060" href="../../win.112/e10845/config.htm#NTQRF060">Oracle Database Platform Guide for Microsoft Windows</a></span></div> </div> <!-- class="sect2" --> <a id="BHCIIDDD" name="BHCIIDDD"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.2</span> Recommended File System</h3> <p>Oracle strongly recommends that you install the Oracle database home (Oracle database binaries, trace files, and so on) on Oracle ACFS or NTFS; the database files themselves must be placed on Oracle ASM if using Oracle ACFS; otherwise they can be placed on NTFS. Usage of Oracle ACFS and Oracle ASM or NTFS instead of FAT32 is recommended to ensure security of these files.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> "File Permissions" in <span class="italic"><a class="olink NTQRF13117" href="http://www.oracle.com/pls/db112/lookup?id=NTQRF13117">Oracle Database Platform Guide for Microsoft Windows</a></span> for information about the default permissions when using Oracle Universal Installer and Database Configuration Assistant to install the Oracle Database software</div> </div> <!-- class="sect2" --> <a id="CHDBJCJA" name="CHDBJCJA"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.3</span> Managing User Accounts with User Account Control<a id="sthref26" name="sthref26"></a><a id="sthref27" name="sthref27"></a><a id="sthref28" name="sthref28"></a><a id="sthref29" name="sthref29"></a><a id="sthref30" name="sthref30"></a><a id="sthref31" name="sthref31"></a><a id="sthref32" name="sthref32"></a></h3> <p>To ensure that only trusted applications run on your computer, Windows Vista, Windows Server 2008, Windows Server 2008 R2, and Windows 7 provide User Account Control. If you have enabled this security feature, then, depending on how you have configured it, Oracle Universal Installer prompts you for either your consent or your credentials when installing Oracle Database. Provide either the consent or your Windows Administrator credentials as appropriate.</p> <p>You must have Administrator privileges to run some Oracle tools, such as Database Configuration Assistant, Net Configuration Assistant, and OPatch, or to run any tool or application that writes to any directory within the Oracle home. If User Account Control is enabled, and you are logged in as the local Administrator, then you can successfully run each of these commands in the usual way. However, if you are logged in as "a member of the Administrator group," then you must explicitly invoke these tasks with Windows Administrator privileges. All the Oracle shortcuts that require Administrator privileges start as "Administrator" automatically when you click the shortcuts. However, if you run the above tools from a Windows command prompt, you must run them from an Administrator command prompt. OPatch does not have a shortcut and has to be run from an Administrator command prompt.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> "Running Tools with Windows User Account Control" in <span class="italic"><a class="olink NTQRF99960" href="../../win.112/e10845/tools.htm#NTQRF99960">Oracle Database Platform Guide for Microsoft Windows</a></span> for more information.</div> <a id="sthref33" name="sthref33"></a> <p class="subhead2">To start a command prompt window with Windows Administrator privileges:</p> <ol> <li> <p>On your desktop, create a shortcut for the command prompt window. An icon for that shortcut appears on the desktop.</p> </li> <li> <p>Right-click the icon for the newly created shortcut, and specify "Run as administrator."</p> </li> </ol> <p>When you open this window, the title bar reads Administrator: Command Prompt. Commands run from within this window are run with Administrator privileges.</p> </div> <!-- class="sect2" --> <a id="CHDCDIJI" name="CHDCDIJI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.4</span> Hardware and Software Certification<a id="sthref34" name="sthref34"></a><a id="sthref35" name="sthref35"></a><a id="sthref36" name="sthref36"></a></h3> <p><a id="sthref37" name="sthref37"></a><a id="sthref38" name="sthref38"></a>The platform-specific hardware and software requirements included in this installation guide were current at the time this guide was published. However, because new platforms and operating system software versions might be certified after this guide is published, review the certification matrix on the My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>) Web site for the most up-to-date list of certified hardware platforms and operating system versions. This Web site also provides compatible client and database versions, patches, and workaround information for bugs. The My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>) Web site is available at</p> <pre xml:space="preserve" class="oac_no_warn"><a href="https://support.oracle.com/">https://support.oracle.com/</a> </pre> <p>You must register online before using My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>). After logging in, click <span class="bold">More</span> and then select <span class="bold">Certifications</span> from the list. On the Certification Information page, the Certification Options list appears. Other options include <span class="bold">Product Roadmap, Product Availability</span>, and <span class="bold">Lifetime Support Policy</span>.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="reqs.htm#BGBEEREE">"Windows Certification and Web Browser Support"</a></div> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref39" name="sthref39"></a> <h4 class="sect3"><span class="secnum">1.3.4.1</span> Third-Party Database Certification for SQL Developer</h4> <p>SQL Developer can be used to view metadata and data of several non-Oracle databases. The following table lists the third-party database certifications.</p> <div class="inftblinformal"> <table class="Informal" title="Third-party Database Certification" summary="Third-party Database Certification" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="22%" /> <col width="24%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t7">Database</th> <th align="left" valign="bottom" id="r1c2-t7">Releases</th> <th align="left" valign="bottom" id="r1c3-t7">Notes</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t7" headers="r1c1-t7">Microsoft Access</td> <td align="left" headers="r2c1-t7 r1c2-t7">Access 97 <p>Access 2000</p> <p>Access 2003</p> </td> <td align="left" headers="r2c1-t7 r1c3-t7">For any Access release: no JDBC driver needed, but you must ensure read access to the system tables in the<code>.mdb</code> file.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t7" headers="r1c1-t7">Microsoft SQL Server</td> <td align="left" headers="r3c1-t7 r1c2-t7">SQL Server 7 <p>SQL Server 2000</p> <p>SQL Server 2005</p> </td> <td align="left" headers="r3c1-t7 r1c3-t7">For any Microsoft SQL Server release: JDBC driver <code>jtds-1.2.2.jar</code> required. This is included in the <code>jtds-1.2-dist.zip</code> available from <code>sourceforge.net</code>.</td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t7" headers="r1c1-t7">MySQL</td> <td align="left" headers="r4c1-t7 r1c2-t7">MySQL 3.x <p>MySQL 4.x</p> <p>MySQL 5.x</p> </td> <td align="left" headers="r4c1-t7 r1c3-t7">For any MySQL release: JDBC driver required. <p>For MySQL 5.x: <code>mysql-connector-java-5.0.4-bin.jar</code> is required, which is included in <code>mysql-connector-java-5.0.4.zip.</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblinformal" --></div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABHHAJC" name="BABHHAJC"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.5</span> Multiple Oracle Homes Support</h3> <p>Oracle Database supports multiple Oracle homes. You can install this release or previous releases of the software more than once on the same system, in different Oracle home directories. This allows flexibility in deployment and maintenance of the database software. For example, it enables you to run different versions of the database simultaneously on the same system, or it enables you to upgrade specific database instances on a system without affecting other running databases. However, when you have installed multiple Oracle Homes on a single system, there is also some added complexity introduced that you must consider allowing these Oracle Homes to coexist.</p> <p>You must install this product into a new Oracle home directory. You cannot install products from one release of Oracle Database into an Oracle home directory of a different release. For example, you cannot install Oracle Database 11g Release 2 (11.2) software into an existing Oracle9<span class="italic">i</span> Oracle home directory. If you attempt to install this release into an Oracle home directory that contains software from an earlier Oracle release, the installation fails.</p> <p>You can install this release more than once on the same system if each installation is installed in a separate Oracle home directory.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>) Note 460054.1 for more details about multiple Oracle home environment issues</div> </div> <!-- class="sect2" --> <a id="CHDBDGID" name="CHDBDGID"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.6</span> Grid Infrastructure for a Standalone Server</h3> <p>The grid infrastructure for a standalone server provides the infrastructure to include your single instance database in an enterprise grid architecture. Oracle Database 11<span class="italic">g</span> Release 2 (11.2) combines these infrastructure products into one software installation called the grid infrastructure home. On a single instance database, the grid infrastructure home includes Oracle Restart and Automatic Storage Management (Oracle ASM) software.</p> <p>If you want to use Automatic Storage Management or Oracle Restart, then you should first install Oracle grid infrastructure for a standalone server, and then install Oracle Database 11<span class="italic">g</span> Release 2 (11.2).</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="oraclerestart.htm#CIHCBGCC">Chapter 3, "Oracle Grid Infrastructure"</a> for more information about installing Oracle grid infrastructure for a standalone server</div> </div> <!-- class="sect2" --> <a id="BABBIEGB" name="BABBIEGB"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.7</span> Oracle Cluster Synchronization Services</h3> <p>When you install the grid infrastructure for a standalone server, it configures the single-node version of the Oracle Cluster Synchronization Services (CSS). The CSS service is required to enable synchronization between an Automatic Storage Management instance and the database instances that rely on it for database file storage. Because the service must be running before any Automatic Storage Management instance or database instance starts, it is configured to start automatically by Oracle Restart before the Automatic Storage Management instance is started.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="#CEGBDDFD">"Automatic Storage Management"</a></div> </div> <!-- class="sect2" --> <a id="i1005848" name="i1005848"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">1.3.8</span> Oracle Universal Installer Overview</h3> <p><a id="sthref40" name="sthref40"></a><a id="sthref41" name="sthref41"></a>Oracle Universal Installer is a Java-based graphical user interface (GUI) tool that enables you to install Oracle software. Oracle Universal Installer provides the following capabilities:</p> <ul> <li> <p>Component and suite installations</p> </li> <li> <p>Globalization support</p> </li> <li> <p>Distributed installation support</p> </li> <li> <p>Unattended silent installations using response files</p> </li> <li> <p>Removal of installed components</p> </li> <li> <p>Multiple Oracle homes support</p> </li> </ul> <p>Oracle Universal Installer can run a silent or response file installation of Oracle software using response files. See <a href="advance.htm#CHDICDJA">Appendix C, "Installing and Configuring Oracle Database Using Response Files"</a> for more information.</p> <p>You must use the Oracle Universal Installer 11<span class="italic">g</span> to install components into an Oracle Database 11g Release 2 (11.2) Oracle home directory. <a id="sthref42" name="sthref42"></a><a id="sthref43" name="sthref43"></a><a id="sthref44" name="sthref44"></a></p> <p>Oracle Universal Installer automatically installs the Oracle version of the Java Runtime Environment (JRE). This version is required to run Oracle Universal Installer and several Oracle assistants. Do <span class="italic">not</span> modify the JRE, unless doing so with a patch provided by My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>). <a id="sthref45" name="sthref45"></a><a id="sthref46" name="sthref46"></a>Visit the following site to find Oracle patches to download:</p> <pre xml:space="preserve" class="oac_no_warn"><a href="https://support.oracle.com/">https://support.oracle.com/</a> </pre> <p>When Oracle Universal Installer runs, it creates an <code><span class="codeinlineitalic">dbhome_n</span></code> directory, which keeps track of the components you are installing. Do not modify the contents of this directory. By default, this directory is located at the same directory level as <code><span class="codeinlineitalic">ORACLE_HOME</span></code>.</p> </div> <!-- class="sect2" --> <a id="CCHFHHFI" name="CCHFHHFI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.9</span> Oracle Base Directory</h3> <p><a id="sthref47" name="sthref47"></a><a id="sthref48" name="sthref48"></a>If you install Oracle Database 11<span class="italic">g</span> Release 2 (11.2) on a computer with no other Oracle software installed, Oracle Universal Installer creates an Oracle base directory for you. If Oracle software is already installed, then one or more Oracle base directories already exist. In the latter case, Oracle Universal Installer offers you a choice of Oracle base directories to install Oracle Database.</p> <p>In a default Windows installation, the Oracle base directory appears as follows:</p> <pre xml:space="preserve" class="oac_no_warn"><span class="italic">DRIVE_LETTER</span>:\app\<span class="italic">username</span> </pre> <div class="infoboxnote"> <p class="notep1">Note:</p> You can choose to create an Oracle base directory, even if other Oracle base directories exist on the system.</div> </div> <!-- class="sect2" --> <a id="BABFHEHD" name="BABFHEHD"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.10</span> Oracle Home Directory</h3> <p>This section covers the following topics:<a id="sthref49" name="sthref49"></a></p> <ul> <li> <p><a href="#CEGFIHHD">Contents of the Oracle Home Environment</a></p> </li> <li> <p><a href="#i1005660">Multiple Oracle Home Components</a></p> </li> </ul> <a id="CEGFIHHD" name="CEGFIHHD"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3"><span class="secnum">1.3.10.1</span> Contents of the Oracle Home Environment</h4> <p>The Oracle home directory is located under the Oracle base directory. For example, in a default Windows installation, if you name the Oracle home directory <code>dbhome_1</code>, it appears in the Oracle base directory as follows:</p> <pre xml:space="preserve" class="oac_no_warn"><span class="italic">DRIVE_LETTER</span>:\app\<span class="italic">username</span>\product\11.2.0\dbhome_1 </pre> <p>An Oracle home corresponds to the environment in which Oracle components run. This environment includes the following:</p> <ul> <li> <p>Location of installed component files</p> </li> <li> <p><code>PATH</code> variable pointing to binary files of installed components</p> </li> <li> <p>Registry entries</p> </li> <li> <p>Service names</p> </li> <li> <p>Program groups</p> </li> </ul> <p>Oracle homes also have a name associated with them, which is automatically assigned by the installer.</p> </div> <!-- class="sect3" --> <a id="i1005660" name="i1005660"></a> <div class="sect3"> <h4 class="sect3"><span class="secnum">1.3.10.2</span> Multiple Oracle Home Components<a id="sthref50" name="sthref50"></a><a id="sthref51" name="sthref51"></a><a id="sthref52" name="sthref52"></a><a id="sthref53" name="sthref53"></a><a id="sthref54" name="sthref54"></a></h4> <p><a id="sthref55" name="sthref55"></a>You can install all Oracle components in multiple Oracle homes on the same computer. However, some components can only support one active instance at a time. The current (latest) installation renders the previous one inactive. These components are:</p> <ul> <li> <p>Oracle Administration Assistant for Windows<a id="sthref56" name="sthref56"></a></p> </li> <li> <p>Oracle Counters for Windows Performance Monitor<a id="sthref57" name="sthref57"></a></p> </li> <li> <p>Oracle Objects for OLE<a id="sthref58" name="sthref58"></a></p> </li> <li> <p>Oracle Provider for OLE DB<a id="sthref59" name="sthref59"></a></p> </li> </ul> <div class="infoboxnote"> <p class="notep1">Note:</p> Oracle Objects for OLE is not supported on Windows x64.</div> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="CHDCHJDH" name="CHDCHJDH"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.11</span> Installing Oracle Database Vault in an Oracle Data Guard Environment</h3> <p>If you plan to use Oracle Data Guard with Oracle Database Vault, then refer to Note 754065.1 on the My Oracle Support (formerly Oracle<span class="italic">MetaLink</span>) Web site at the following URL:</p> <pre xml:space="preserve" class="oac_no_warn"><a href="https://support.oracle.com/">https://support.oracle.com/</a> </pre></div> <!-- class="sect2" --> <a id="CEGDFJBF" name="CEGDFJBF"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.3.12</span> Oracle Database Vault Default Audit Policy and Initialization Parameters</h3> <p>Oracle Database Vault installs a baseline database auditing policy. This policy covers the access control configuration information stored in Database Vault database tables, information stored in Oracle Catalog (rollback segments, tablespaces, and so on), the use of system privileges, and Oracle Label Security configuration. When you install Oracle Database Vault, the security specific database initialization parameters are initialized with default values.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink DVADM" href="http://www.oracle.com/pls/db112/lookup?id=DVADM">Oracle Database Vault Administrator's Guide</a></span> for more information about the database audit policy</div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABEGIJD" name="BABEGIJD"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.4</span> Migration Considerations</h2> <p>Oracle Database 11<span class="italic">g</span> Release 2 (11.2) database for 32-bit Windows can be migrated to an Oracle Database 11<span class="italic">g</span> Release 2 (11.2) database for 64-bit Windows. See the "Migrating an Oracle Database 11g Release 2 (11.2) Database" section in the <span class="italic"><a class="olink NTQRF001" href="../../win.112/e10845/create.htm#NTQRF001">Oracle Database Platform Guide for Microsoft Windows</a></span> for migration information.</p> </div> <!-- class="sect1" --> <a id="CEGDACJD" name="CEGDACJD"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.5</span> Oracle Database Installation Methods</h2> <p>You can choose different installation methods to install Oracle Database, which are as follows:</p> <ul> <li> <p><a href="#CHDGDAFG">Interactive Installation Types</a></p> </li> <li> <p><a href="#CHDECFBB">Automated Installation Methods Using Response Files</a></p> </li> </ul> <a id="CHDGDAFG" name="CHDGDAFG"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.5.1</span> Interactive Installation Types</h3> <p>When you use the interactive method to install Oracle Database, Oracle Universal Installer displays a series of screens that enable you to specify all of the required information to install the Oracle Database software and optionally create a database. There are two options that you can use to install Oracle Database:</p> <ul> <li> <p><a id="sthref60" name="sthref60"></a>Desktop Class: Select this option if you are installing on a laptop or desktop class system. This option includes a starter database and allows minimal configuration. This option is designed for those who want to get up and running with the database quickly.</p> </li> <li> <p><a id="sthref61" name="sthref61"></a>Server Class: Select this option if you are installing on a server class system, such as what you would use when deploying Oracle in a production data center. This option allows for more advanced configuration options. Advanced configuration options available using this option include Oracle RAC, Automatic Storage Management, backup and recovery configuration, integration with Enterprise Manager Grid Control, and more fine-grained memory tuning, among others.</p> <p>Furthermore, the Server Class option provides you with the following installation types:</p> <ul> <li> <p>Typical: Select this installation method to quickly install Oracle Database. This installation type requires minimal user input. It installs the software and optionally creates a general-purpose database using the information that you specify on the screen. It is the default installation type.</p> </li> <li> <p>Advanced: Select this installation type to complete any of the following tasks:</p> <ul> <li> <p>Select a database character set or different product languages</p> </li> <li> <p>Create the EXAMPLE tablespace during the installation</p> </li> <li> <p>Create a database on a different file system from the software</p> </li> <li> <p>Specify different passwords for administrative schemas</p> </li> <li> <p>Configure automated backups or Oracle Enterprise Manager notifications</p> </li> <li> <p>Configure Oracle Configuration Manager</p> </li> <li> <p>In the Select Database Edition screen, if you select <span class="bold">Enterprise Edition</span>, then Oracle Universal Installer automatically selects the components most customers need for their Oracle Database installation. You can also click <span class="bold">Select Options</span> to customize components from the components list.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="install.htm#BABFDDEA">"Reviewing Component-Specific Installation Guidelines"</a></div> </li> </ul> </li> </ul> </li> </ul> </div> <!-- class="sect2" --> <a id="CHDECFBB" name="CHDECFBB"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.5.2</span> Automated Installation Methods Using Response Files</h3> <p>By creating a response file and specifying this file when you start Oracle Universal Installer, you can automate some or all of the Oracle Database installation. These automated installation methods are useful if you must perform multiple installations on similarly configured systems.</p> <p>When you use a response file, you can run Oracle Universal Installer in the following modes, depending on whether you specify all of the required information or not:</p> <ul> <li> <p><span class="bold">Silent Mode:</span> Oracle Universal Installer runs in silent mode if you use a response file that specifies all required information, and specify the <code>-silent</code> option when starting Oracle Universal Installer. None of the Oracle Universal Installer screens are displayed.</p> </li> <li> <p><span class="bold">Response File Mode:</span> Oracle Universal Installer runs in response file mode if you do not specify all required information in the response file.</p> </li> </ul> <p>For more information about these modes and about how to complete an installation using response files, see <a href="advance.htm#CHDICDJA">Appendix C</a>.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="i1005984" name="i1005984"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">1.6</span> Oracle Database Edition<a id="sthref62" name="sthref62"></a><a id="sthref63" name="sthref63"></a><a id="sthref64" name="sthref64"></a>s</h2> <p>You can choose one of the following installation types when installing Oracle Database 11<span class="italic">g</span>:</p> <ul> <li> <p><span class="bold"><a id="sthref65" name="sthref65"></a>Enterprise Edition:</span> Installs licensable Oracle Database options, and database configuration and management tools in addition to all of the products that are installed during a Standard Edition installation. It also installs products most commonly used for <a id="sthref66" name="sthref66"></a>data warehousing and <a id="sthref67" name="sthref67"></a>transaction processing. This option also permits you to enable or disable individual components from a components list.</p> </li> <li> <p><span class="bold"><a id="sthref68" name="sthref68"></a>Standard Edition:</span> This installation type is designed for department or workgroup-level applications and for small and medium-sized enterprises (SMEs). It is engineered to provide core relational database management services and options. It installs an integrated set of management tools, full distribution, replication, Web features, and facilities for building business-critical applications.</p> </li> <li> <p><span class="bold"><a id="sthref69" name="sthref69"></a>Standard Edition One:</span> This installation type is designed for department, workgroup-level, or web applications. From single instance environments for small business to highly distributed branch environments, Oracle Database Standard Edition One includes all the facilities necessary to build business-critical applications.</p> </li> <li> <p><span class="bold"><a id="sthref70" name="sthref70"></a>Personal Edition:</span> Installs the same software as the Enterprise Edition installation type, but supports only a single user development and deployment environment that requires full compatibility with Enterprise Edition and Standard Edition. Oracle RAC is not installed with Personal Edition.</p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p>You must install Oracle Database Client separately. You cannot install it during an Oracle Database installation. See <span class="italic"><a class="olink NTCLI" href="http://www.oracle.com/pls/db112/lookup?id=NTCLI">Oracle Database Client Installation Guide for Microsoft Windows</a></span> for installation instructions</p> </li> <li> <p><span class="italic"><a class="olink DBLIC" href="http://www.oracle.com/pls/db112/lookup?id=DBLIC">Oracle Database Licensing Information</a></span> for more information about the features available with each Oracle Database edition and for information about licensing</p> </li> </ul> </div> <div class="infoboxnote"> <p class="notep1">Note:</p> <ul> <li> <p>The installation process is the same for all the database editions.</p> </li> <li> <p>Ensure that you install only those products for which you have a valid license.</p> </li> </ul> </div> </div> <!-- class="sect1" --> <a id="BABGDEHD" name="BABGDEHD"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.7</span> Database Configuration Options</h2> <p><a id="sthref71" name="sthref71"></a><a id="sthref72" name="sthref72"></a>You can create an Oracle database during the installation process. If you choose to create an Oracle database, Oracle Universal Installer uses Oracle Database Configuration Assistant to create it. You can create one of the preconfigured database types, which are designed for a variety of different applications, modify one of the preconfigured database types, or create a customized database to suit your own requirements.</p> <p>This section describes the following database configuration options:</p> <ul> <li> <p><a href="#CHDDEEFI">Preconfigured Database Types</a></p> </li> <li> <p><a href="#CHDJJGCJ">Installation Choices that Affect Database Creation</a></p> </li> <li> <p><a href="#CHDFIFBD">Creating a Database After Installation</a></p> </li> </ul> <a id="CHDDEEFI" name="CHDDEEFI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.7.1</span> Preconfigured Database Types</h3> <p><a id="sthref73" name="sthref73"></a>Oracle provides the following preconfigured database types that you can create or customize during the installation:</p> <ul> <li> <p><a id="sthref74" name="sthref74"></a>General Purpose/Transaction Processing</p> </li> <li> <p><a id="sthref75" name="sthref75"></a>Data Warehouse</p> </li> </ul> <p>See the online help provided by either Oracle Universal Installer or Oracle Database Configuration Assistant for a description of these preconfigured database types.</p> </div> <!-- class="sect2" --> <a id="CHDJJGCJ" name="CHDJJGCJ"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.7.2</span> Installation Choices that Affect Database Creation</h3> <p>Oracle Universal Installer runs <a id="sthref76" name="sthref76"></a>Oracle Database Configuration Assistant in one of two modes, depending on the choices that you make during the installation:</p> <ul> <li> <p>Silent or response file mode</p> <p>If you choose the Enterprise Edition, Standard Edition, or Personal Edition as the database edition, then choose to create a preconfigured database type. Oracle Universal Installer prompts you for the minimum amount of information required to create a database of the type you choose. It then runs Oracle Database Configuration Assistant in silent or response file mode to create the database after it installs the software.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> Oracle recommends that you use this method to create a database if you have not previously created one.</div> </li> <li> <p>Interactive mode</p> <p>Install the database using Oracle Universal Installer and start Oracle Database Configuration Assistant from Oracle home. Oracle Database Configuration Assistant runs in interactive mode. Using the screens in Oracle Database Configuration Assistant, you can either modify one of the preconfigured database types or customize the database.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> If you choose this method to create a database, click the <span class="bold">Help</span> button on any of the Oracle Database Configuration Assistant screens for a description of the information that you must specify on that screen.</div> </li> </ul> </div> <!-- class="sect2" --> <a id="CHDFIFBD" name="CHDFIFBD"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.7.3</span> Creating a Database After Installation</h3> <p>If you decide not to create a database during the installation, you can use Oracle Database Configuration Assistant to create one after you have installed the software.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink ADMQS" href="../../server.112/e10897/toc.htm">Oracle Database 2 Day DBA</a></span> for more information about using Oracle Database Configuration Assistant to create a database after installation</div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="CEGBGDFE" name="CEGBGDFE"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.8</span> Database Storage Options</h2> <p><a id="sthref77" name="sthref77"></a>If you choose to create a database during the installation, you can specify the following storage options for database files:</p> <ul> <li> <p><a href="#CEGFGHJF">File System</a></p> </li> <li> <p><a href="#CEGBDDFD">Automatic Storage Management</a></p> </li> </ul> <div class="infoboxnote"> <p class="notep1">Note:</p> Installing files on raw devices is no longer an option during installation. You must use a file system, or use Automatic Storage Management.</div> <a id="CEGFGHJF" name="CEGFGHJF"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.8.1</span> File System</h3> <p>If you choose the file system option, then Oracle Database Configuration Assistant creates the database files in a directory on a file system on your computer. Oracle recommends that the file system you choose be separate from the file systems used by the operating system or the Oracle software. The file system that you choose can be any of the following:</p> <ul> <li> <p>A file system on a disk that is physically attached to the system</p> <p>If you are creating a database on basic disks that are not logical volumes or RAID devices, then follow the Optimal Flexible Architecture (OFA) recommendations and distribute the database files over multiple disks.</p> </li> <li> <p>A file system on a logical volume manager <a id="sthref78" name="sthref78"></a>(LVM) or a RAID device</p> <p>If you are using <a id="sthref79" name="sthref79"></a>multiple disks in an LVM or <a id="sthref80" name="sthref80"></a>RAID configuration, then Oracle recommends that you use the stripe-and-mirror-everything (SAME) methodology to increase performance and reliability. Using this methodology, you must not specify multiple file system mounting points for database storage.</p> </li> <li> <p>A network file system (NFS) mounted from a certified network attached storage (NAS) device. You also have the option to use the Direct NFS feature, which simplifies the administration of NFS configurations and also offers performance improvements.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a href="postcfg.htm#BABBADDE">"Direct NFS Client"</a> for more information about the Direct NFS feature</div> <p>If the NAS device is certified by Oracle, then you can store the database files on them.</p> </li> </ul> <p>If you choose the Advanced database creation option, then you can also choose to use the Oracle-managed files feature with the new database. If you use this feature, then you must specify only the database object name instead of file names when creating or deleting database files.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink ADMIN" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN">Oracle Database Administrator's Guide</a></span> for more information about Oracle-managed files</div> </div> <!-- class="sect2" --> <a id="CEGBDDFD" name="CEGBDDFD"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.8.2</span> Automatic Storage Management<a id="sthref81" name="sthref81"></a><a id="sthref82" name="sthref82"></a></h3> <p>Automatic Storage Management is a high-performance storage management solution. For Oracle Database files, it simplifies the management of a dynamic database environment, such as creating and laying out databases and managing disk space.</p> <p>Automatic Storage Management can be used with single database installations, multiple database installations, and in Oracle <a id="sthref83" name="sthref83"></a>RAC environments. It can be used with databases created in Oracle Database 10<span class="italic">g</span> Release 1 (10.1.0.3 or later). However, Oracle Database 11<span class="italic">g</span> Release 2 (11.2) databases must use Automatic Storage Management from Oracle Database 11<span class="italic">g</span> Release 2 (11.2) or later. Automatic Storage Management is installed as part of the grid infrastructure installation. If you plan to use Automatic Storage Management, then you must install the grid infrastructure before installing your database.</p> <p>Automatic Storage Management manages the storage of all database files, such as redo logs, control files, and data pump export files. Automatic Storage <a id="sthref84" name="sthref84"></a><a id="sthref85" name="sthref85"></a><a id="sthref86" name="sthref86"></a>Management can manage the Oracle Database executable binary files and any other non-database file by creating a file system with Oracle Automatic Storage Management Cluster File System. Though Oracle Automatic Storage Management Cluster File System is cluster aware, it works as a file system on a single instance database also.</p> <p>To use Automatic Storage Management, you allocate partitioned disks to Oracle with preferences for striping and mirroring. Automatic Storage Management manages the disk space for you, thus eliminating the need for traditional disk management tools such as logical volume managers (LVM), file systems, and the numerous commands necessary to manage both. The synchronization between Automatic Storage Management and the database instance is handled by <a id="sthref87" name="sthref87"></a>Oracle Cluster Synchronization Services (CSS).</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="oraclerestart.htm#CIHCBGCC">Chapter 3, "Oracle Grid Infrastructure"</a> for more information about installing the Oracle grid infrastructure software</p> </li> <li> <p><span class="italic"><a class="olink OSTMG" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG">Oracle Database Storage Administrator's Guide</a></span> for more information about Oracle Automatic Storage Management Cluster File System</p> </li> </ul> </div> <div class="sect3"><!-- infolevel="all" infotype="General" --><a id="sthref88" name="sthref88"></a> <h4 class="sect3"><span class="secnum">1.8.2.1</span> Automatic Storage Management Components</h4> <p>Automatic Storage Management uses the following components:</p> <ul> <li> <p><a href="#CEGIABDI">Automatic Storage Management Disk Groups</a></p> </li> <li> <p><a href="#CEGEFFFC">Automatic Storage Management Instance</a></p> </li> </ul> <a id="CEGIABDI" name="CEGIABDI"></a> <p class="subhead2">Automatic Storage Management Disk Groups</p> <p><a id="sthref89" name="sthref89"></a>A disk group is a set of disk devices that Automatic Storage Management manages as a unit. <a id="sthref90" name="sthref90"></a><a id="sthref91" name="sthref91"></a>Each disk device can be an individual physical disk, a multiple disk device such as a RAID storage array or a logical volume, or a partition on a physical disk. However, mostly, disk groups consist of one or more individual physical disks. To enable Automatic Storage Management to balance I/O and storage appropriately within the disk group, ensure that all devices in the disk group have similar, if not identical, storage capacity and performance.</p> <p><a id="sthref92" name="sthref92"></a><a id="sthref93" name="sthref93"></a>You can set the redundancy and striping attributes of individual file types within a disk group by using Automatic Storage Management disk group templates. When you create a disk group, Automatic Storage Management creates a set of default templates for that disk group. Default template settings depend on the disk group type. For example, the default template for control files for a normal redundancy disk group sets three-way mirroring. All other file templates are two-way mirrored. For a high redundancy disk group, the default mirroring cannot be changed; that is, all files are always three-way mirrored in a high redundancy disk group. You can modify the default templates to suit the unique needs of your site. See <span class="italic"><a class="olink OSTMG" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG">Oracle Database Storage Administrator's Guide</a></span> for more information.</p> <p>Automatic Storage Management spreads data evenly across all of the devices in the disk group to optimize performance and utilization. You can add or remove disk devices from a disk group without shutting down the database. When you add or remove disks, Automatic Storage Management rebalances the data files across the disk group. You can create multiple disk groups to handle specific tasks, such as backup and recovery operations, in addition to routine file storage activities.</p> <p><a id="sthref94" name="sthref94"></a>When you add a device to a disk group, you can specify a failure group for that device. Failure groups identify disk devices that have common failure characteristics, for example, devices that are attached to the same controller. If the controller fails, then all devices attached to it become unavailable. By default, each device also belongs to its own failure group. By using the failure groups you specify, Automatic Storage Management can distribute data among the devices in the disk group to help minimize the risk of data loss caused by component failures.</p> <a id="CEGEFFFC" name="CEGEFFFC"></a> <p class="subhead2">Automatic Storage Management Instance</p> <p>The <a id="sthref95" name="sthref95"></a>Automatic Storage Management instance is a special Oracle instance that manages Automatic Storage Management disk groups. The Automatic Storage Management instance and the ASMSNMP account are created as part of the grid infrastructure home. Oracle Enterprise Manager uses this account to monitor Oracle ASM instances to retrieve data from Oracle ASM-related data dictionary views. The ASMSNMP account status is set to OPEN upon creation, and it is granted the SYSDBA privilege.</p> <p>There is only one Oracle ASM instance per host regardless of the number of database instances running on that host.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="oraclerestart.htm#CHDHFFGH">"Step 4: Manually Configuring Disks for Automatic Storage Management"</a></p> </li> <li> <p>"Managing Oracle ASM Users with Oracle Enterprise Manager" in <span class="italic"><a class="olink OSTMG22700" href="http://www.oracle.com/pls/db112/lookup?id=OSTMG22700">Oracle Database Storage Administrator's Guide</a></span> for more information about ASMSNMP user</p> </li> </ul> </div> </div> <!-- class="sect3" --></div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BGEDFBEA" name="BGEDFBEA"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.9</span> Database Management Options</h2> <p><a id="sthref96" name="sthref96"></a>To <a id="sthref97" name="sthref97"></a><a id="sthref98" name="sthref98"></a>simplify database administration, Oracle provides a Web-based management tool called Oracle Enterprise Manager.</p> <p>There are two ways that you can deploy Oracle Enterprise Manager:</p> <ul> <li> <p>Deploy Oracle Enterprise Manager centrally in your environment.</p> <p>To deploy Oracle Enterprise Manager centrally, you must install at least one Oracle Management Repository and one Oracle Management Service within your environment, then install an <a id="sthref99" name="sthref99"></a>Oracle Enterprise Management Agent on every computer. You then can use a single HTML interface to manage and monitor software and hardware targets on all of those systems. Targets can include Oracle databases, application servers, Net listeners, and third-party software. This single interface is called <a id="sthref100" name="sthref100"></a><a id="sthref101" name="sthref101"></a>Oracle Enterprise Manager 11<span class="italic">g</span> Grid Control (or simply Grid Control).</p> <div class="infoboxnote"> <p class="notep1">Note:</p> Oracle Enterprise Manager 11<span class="italic">g</span> is available separately on the Oracle Enterprise Manager Grid Control installation media.</div> </li> <li> <p>Deploy Oracle Enterprise Manager Database Control locally on the database system.</p> <p>Oracle Enterprise Manager Database Control software is installed by default with every Oracle Database installation. This local installation provides a Web-based interface called Oracle Enterprise Manager Database Control. The Database Control is similar in function to the Grid Control, but it can manage only a single database. If you want to administer multiple databases on this system, you must either configure a separate Database Control for each database, or install Oracle Enterprise Manager 11<span class="italic">g</span> Grid Control.</p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink OEMCN" href="http://www.oracle.com/pls/db112/lookup?id=OEMCN">Oracle Enterprise Manager Concepts</a></span> and <span class="italic"><a class="olink OEMIG" href="http://www.oracle.com/pls/db112/lookup?id=OEMIG">Oracle Enterprise Manager Grid Control Installation and Basic Configuration</a></span> for more information about Oracle Enterprise Manager 11<span class="italic">g</span></div> <p>This section contains the following topics:</p> <ul> <li> <p><a href="#CEGGIACC">Management Options for Preconfigured Databases</a></p> </li> <li> <p><a href="#CEGJFHBI">Management Options for Custom Databases</a></p> </li> <li> <p><a href="#CHDHGEBI">Features Provided by Oracle Enterprise Manager Database Control</a></p> </li> </ul> <a id="CEGGIACC" name="CEGGIACC"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.9.1</span> Management Options for Preconfigured Databases</h3> <p><a id="sthref102" name="sthref102"></a><a id="sthref103" name="sthref103"></a>When you create a preconfigured database during the installation, you must select the Oracle Enterprise Manager interface to manage the database. The following options are available:</p> <ul> <li> <p>Use Grid Control for central database management.</p> <p>This option is available only if an Oracle Management Agent is installed on the system. When Oracle Universal Installer detects Oracle Management Agent on the system, you can choose this option and specify the Oracle Management Service to manage the database.</p> <p>If an Oracle Management Agent is not installed, you must use Database Control to manage the database. However, if you install Oracle Management Agent after you install Oracle Database, you can use Grid Control to manage this database.</p> </li> <li> <p>Use Database Control for local database management.</p> <p>This option is selected by default if an Oracle Management Agent is not installed on the system. However, even if a Management Agent is installed, you can still configure Database Control to manage the database.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CEGJFHBI" name="CEGJFHBI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.9.2</span> Management Options for Custom Databases</h3> <p>Install the database using Oracle Universal Installer<a id="sthref104" name="sthref104"></a> and start Oracle Database Configuration Assistant from Oracle home. Oracle Database Configuration Assistant runs in interactive mode. Using a screen in Oracle Database Configuration Assistant, you can specify the Oracle Enterprise Manager interface to manage the database. Alternatively, you can choose not to configure the database with Enterprise Manager.</p> <p>Oracle recommends that you configure the database to use Enterprise Manager during installation. However, if you choose not to configure the database to use Enterprise Manager during the installation, you can use Oracle Database Configuration Assistant after the installation to configure the database to use it.</p> </div> <!-- class="sect2" --> <a id="CHDHGEBI" name="CHDHGEBI"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.9.3</span> Features Provided by Oracle Enterprise Manager Database Control</h3> <p><a id="sthref105" name="sthref105"></a>Oracle Enterprise Manager Database Control, which is installed by default with Oracle Database, provides a Web-based user interface that you can use to monitor, administer, and maintain an Oracle database. You can use it to perform all of your database administration tasks. You can also use it to determine information about the database, such as:</p> <ul> <li> <p>Instance name, database version, Oracle home location, media recovery options, and other instance data</p> </li> <li> <p>Current instance availability</p> </li> <li> <p>Database alert information</p> </li> <li> <p>Automatic notification of security alerts</p> </li> <li> <p>Ability to apply patches</p> </li> <li> <p>Session and SQL-related performance information</p> </li> <li> <p>Space usage metrics</p> </li> </ul> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BGEGHEIC" name="BGEGHEIC"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.10</span> Database Backup and Recovery Options</h2> <p><a id="sthref106" name="sthref106"></a><a id="sthref107" name="sthref107"></a><a id="sthref108" name="sthref108"></a><a id="sthref109" name="sthref109"></a>If you use Oracle Enterprise Manager Database Control during the installation, you can optionally enable automated database backups that use the Oracle-suggested default backup strategy.</p> <p><a id="sthref110" name="sthref110"></a><a id="sthref111" name="sthref111"></a><a id="sthref112" name="sthref112"></a><a id="sthref113" name="sthref113"></a>You do not have to enable automated backups during the installation. If you prefer, you can use Oracle Enterprise Manager Database Control or Grid Control to configure automated backups after you install the software and create a database.</p> <p>This section covers the following topics:</p> <ul> <li> <p><a href="#CEGGCIHC">Enabling Automated Backups</a></p> </li> <li> <p><a href="#CEGEDJDD">Backup Job Default Settings</a></p> </li> </ul> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink ADMQS" href="../../server.112/e10897/toc.htm">Oracle Database 2 Day DBA</a></span> for information about using Oracle Enterprise Manager Database Control to configure or customize automated backups or to recover a backed up database</p> </li> <li> <p><span class="italic"><a class="olink BRADV" href="http://www.oracle.com/pls/db112/lookup?id=BRADV">Oracle Database Backup and Recovery User's Guide</a></span> for more detailed information about defining a backup strategy and backing up and recovering Oracle databases</p> </li> </ul> </div> <a id="CEGGCIHC" name="CEGGCIHC"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.10.1</span> Enabling Automated Backups</h3> <p>If you enable automated backups, Oracle Enterprise Manager schedules a daily backup job that uses Oracle Database Recovery Manager (RMAN) to back up all of the database files to an on-disk storage area called the fast recovery area. The size of the fast recovery area is determined by the size of the database you must back up. The first time the backup job runs, it creates a full backup of the database. Subsequent backup jobs perform incremental backups, which enable you to recover the database to its state at any point during the preceding 24 hours. If you want to create an online backup, you must run the backup job in ARCHIVELOG mode.</p> <p>To enable automated backup jobs during installation, you must specify the following information:</p> <ul> <li> <p>The location of the fast recovery area</p> <p>You can use either a file system directory or an Automatic Storage Management disk group for the fast recovery area. The default disk quota configured for the fast recovery area is 2 GB. For Automatic Storage Management disk groups, the required disk space depends on the redundancy level of the disk group that you choose. <a href="reqs.htm#BCFHFECH">Chapter 2</a> describes how to choose the location of the fast recovery area and identifies its disk space requirements.</p> </li> <li> <p>An operating system user name and password for the backup job</p> <p>Oracle Enterprise Manager uses the operating system credentials that you specify when running the backup job. The user name that you specify must belong to the Windows group that identifies database administrators (the <code>ORA_DBA</code> group). This user also must have <code>Logon As A Batch Job</code> privilege.</p> </li> </ul> </div> <!-- class="sect2" --> <a id="CEGEDJDD" name="CEGEDJDD"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.10.2</span> Backup Job Default Settings</h3> <p>If you enable automated backups after choosing one of the preconfigured databases during the installation, automated backup is configured with the following default settings:</p> <ul> <li> <p>The backup job is scheduled to run nightly at 2 a.m.</p> </li> <li> <p>The disk quota for the fast recovery area is 2 GB.</p> </li> </ul> <p>If you enable automated backups by using Oracle Database Configuration Assistant, either during or after the installation, you can specify a different start time for the backup job and a different disk quota for the fast recovery area.</p> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BGEGDGGE" name="BGEGDGGE"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">1.11</span> E-mail Notification Options</h2> <p><a id="sthref114" name="sthref114"></a><a id="sthref115" name="sthref115"></a>If you choose to use Oracle Enterprise Manager Database Control during the installation, you can configure Enterprise Manager to send e-mail when specific events occur. These events can include occurrences such as disk space reaching a critical limit (a threshold), or a database shutting down unexpectedly.</p> <p>If you enable e-mail notifications, you must specify the following information:</p> <ul> <li> <p>The host name of a simple mail transport protocol (SMTP) server.</p> </li> <li> <p>The e-mail address that should receive the alerts.</p> <p>The e-mail address that you specify can belong to an individual, or can be a shared e-mail account, or can be a distribution list.</p> </li> </ul> <p>You can use Enterprise Manager Database Control to setup, change, or customize e-mail notifications after you have created the database.</p> </div> <!-- class="sect1" --> <a id="CIHHGABI" name="CIHHGABI"></a> <div class="sect1"> <h2 class="sect1"><span class="secnum">1.12</span> Upgrade Considerations<a id="sthref116" name="sthref116"></a><a id="sthref117" name="sthref117"></a><a id="sthref118" name="sthref118"></a></h2> <p><a id="sthref119" name="sthref119"></a>Oracle recommends installing Oracle Database 11<span class="italic">g</span> Release 2 (11.2) into a new Oracle home directory. If you must install Oracle Database 11<span class="italic">g</span> Release 2 (11.2) into an Oracle home directory that contains previously installed Oracle8<span class="italic">i</span> or Oracle9<span class="italic">i</span> components, then use Oracle Universal Installer to remove these components before beginning a new installation.</p> <p>See <span class="italic"><a class="olink UPGRD002" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD002">Oracle Database Upgrade Guide</a></span> before deciding to upgrade an existing database. Supported upgrade paths and upgrade procedures are covered in <span class="italic"><a class="olink UPGRD002" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD002">Oracle Database Upgrade Guide</a></span>. However, this section describes several Windows-specific issues to understand before following the instructions in <span class="italic"><a class="olink UPGRD002" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD002">Oracle Database Upgrade Guide</a></span>.</p> <p>This section contains these topics:</p> <ul> <li> <p><a href="#CHDEGEGC">Automatic Storage Management Is Installed with Oracle Grid Infrastructure</a></p> </li> <li> <p><a href="#CHDBIEGE">Daylight Savings Time Upgrade</a></p> </li> <li> <p><a href="#i1007026">Policies for Client and Application Software Installations</a></p> </li> <li> <p><a href="#BABECEIJ">Downgrading a Database</a></p> </li> </ul> <a id="CHDEGEGC" name="CHDEGEGC"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.12.1</span> Automatic Storage <a id="sthref120" name="sthref120"></a>Management Is Installed with Oracle Grid Infrastructure</h3> <p>In previous releases, Oracle Automatic Storage Management (Oracle ASM) was installed as part of the Oracle Database installation. With Oracle Database 11<span class="italic">g</span> Release 2 (11.2), Automatic Storage Management is part of an Oracle grid infrastructure installation, either for a cluster, or for a standalone server.</p> <p>If you want to upgrade an existing Automatic Storage Management installation, then you must upgrade Automatic Storage Management by running an Oracle grid infrastructure upgrade. If you do not have Automatic Storage Management installed and you want to use Automatic Storage Management as your storage option, then you must complete an Oracle grid infrastructure installation before you start your Oracle Database installation.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink UPGRD" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD"><span class="italic">Oracle Database Upgrade Guide</span></a></div> </div> <!-- class="sect2" --> <a id="CHDBIEGE" name="CHDBIEGE"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><span class="secnum">1.12.2</span> Daylight<a id="sthref121" name="sthref121"></a><a id="sthref122" name="sthref122"></a> Savings Time Upgrade</h3> <p>See <a href="whatsnew.htm#BGGJDJCH">"Daylight Savings Time Upgrade of Timestamp with Timezone Data Type"</a> for information about Daylight Savings Time Upgrade.</p> </div> <!-- class="sect2" --> <a id="i1007026" name="i1007026"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">1.12.3</span> Policies for Client and Application Software Installations</h3> <p>If you upgrade your Oracle Database to 11<span class="italic">g</span> Release 2 (11.2), then Oracle recommends that you upgrade the client software to Oracle Database 11<span class="italic">g</span> Release 2 (11.2) as well. Keeping the server and client software at the same release number ensures maximum stability for your applications. In addition, the latest Oracle client software may provide added functionality and performance enhancements that were not available with previous releases.</p> </div> <!-- class="sect2" --> <a id="BABECEIJ" name="BABECEIJ"></a> <div class="sect2"> <h3 class="sect2"><span class="secnum">1.12.4</span> Downgrading a Database</h3> <p><a id="sthref123" name="sthref123"></a><a id="sthref124" name="sthref124"></a><a id="sthref125" name="sthref125"></a>Steps to downgrade a database, including steps to change the <a id="sthref126" name="sthref126"></a>word size, are covered in <span class="italic"><a class="olink UPGRD" href="http://www.oracle.com/pls/db112/lookup?id=UPGRD">Oracle Database Upgrade Guide</a></span>.<a id="sthref127" name="sthref127"></a></p> </div> <!-- class="sect2" --></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="whatsnew.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="reqs.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 © 1996, 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