Edit D:\rfid\database\database\doc\win.112\e10845\config.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-05T15:45:35Z" /> <meta name="doctitle" content="Oracle® Database Platform Guide 11g Release 2 (11.2) for Microsoft Windows" /> <meta name="partno" content="E10845-01" /> <meta name="docid" content="NTQRF" /> <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="create.htm" title="Previous" type="text/html" /> <link rel="Next" href="admin.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10845.pdf" title="PDF version" type="application/pdf" /> <title>Postinstallation Configuration Tasks on Windows</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 Platform Guide<br /> 11<i>g</i> Release 2 (11.2) for Microsoft Windows</b><br /> Part Number E10845-01</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="create.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="admin.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="../e10845.pdf">View PDF</a></td> </tr> </table> <a name="BEGIN" id="BEGIN"></a></div> <div class="IND"><!-- End Header --><a id="g1014529" name="g1014529"></a><a id="NTQRF060" name="NTQRF060"></a><a id="i1008781" name="i1008781"></a> <h1 class="chapter"><span class="secnum">4</span> Postinstallation Configuration Tasks on Windows</h1> <p>This chapter describes configuration tasks you can perform to increase security and other configuration tasks you must perform before using Oracle Multimedia and other Oracle options. Where appropriate, the chapter provides references to other guides for those configuration tasks.</p> <p>This chapter contains these topics:</p> <ul> <li> <p><a href="#BHCHFBIF">Windows Firewall</a></p> </li> <li> <p><a href="#BABBBCFF">Resetting Passwords for Default Accounts</a></p> </li> <li> <p><a href="#i1014905">NTFS File System and Windows Registry Permissions</a></p> </li> <li> <p><a href="#BABDAFBG">Configuring External Job Support for the Scheduler on Windows</a></p> </li> <li> <p><a href="#i1005764">Configuring Oracle Multimedia on Windows</a></p> </li> <li> <p><a href="#i1007869">Configuring Oracle Text on Windows</a></p> </li> <li> <p><a href="#i1006041">Configuring Oracle Spatial on Windows</a></p> </li> <li> <p><a href="#BABFDBDC">Configuring Advanced Replication on Windows</a></p> <div class="infoboxnote"> <p class="notep1">Note:</p> Directory path examples in this chapter follow <a href="glossary.htm#CHDEACCG"><span class="xrefglossterm">Optimal Flexible Architecture</span></a> (OFA) guidelines. If you specified non-OFA compliant directories during installation, then your directory paths will differ. See Appendix B, "Optimal Flexible Architecture", in <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.</div> </li> </ul> <a id="BHCHFBIF" name="BHCHFBIF"></a><a id="NTQRF157" name="NTQRF157"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Windows Firewall</h2> <p>By default, all newer Windows operating systems enable the Windows Firewall to block virtually all TCP network ports to incoming connections. As a result, any Oracle products that listen for incoming connections on a TCP port will not receive any of those connection requests, and the clients making those connections will report errors.</p> <p>Depending upon which Oracle products are installed and how they are used, some postinstallation configuration of the Windows Firewall might be required for the products to be functional on these operating systems.</p> <p>This section contains these topics:</p> <ul> <li> <p><a href="#BHCEJHDC">Oracle Executables Requiring Firewall Exceptions</a></p> </li> <li> <p><a href="#BHCFFHBI">Configuring the Windows Firewall</a></p> </li> <li> <p><a href="#BHCJAGBA">Troubleshooting Windows Firewall Exceptions</a></p> </li> </ul> <a id="BHCEJHDC" name="BHCEJHDC"></a><a id="NTQRF158" name="NTQRF158"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Oracle Executables Requiring Firewall Exceptions</h3> <p><a href="#CEGEEIEH">Table 4-1</a> lists the Oracle Database 10<span class="italic">g</span> Release 1 (10.1) or later executables that listen on TCP ports on Windows. If they are in use and accepting connections from a remote client computer, then Oracle recommends that you add them to the Windows Firewall exceptions list to ensure correct operation. Except as noted, they can be found in <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\bin</code>.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> If multiple Oracle homes are in use, then several firewall exceptions may be needed for the same executable: one for each home from which that executable loads.</div> <p>You must configure exceptions for the Windows Firewall if your system meets all of the following conditions:</p> <ul> <li> <p>Oracle server-side components are installed on a Windows Server 2003, Windows Server 2003 R2, Windows Server 2008, or Windows 2008 R2 system. The list of components includes the Oracle Database, Oracle grid infrastructure, network listeners, or any Web servers or services.</p> </li> <li> <p>The Windows system in question accepts connections from other machines over the network. If no other machines will be connecting to the Windows system to access the Oracle software, then no postinstallation configuration steps are required and the Oracle software will function as expected.</p> </li> <li> <p>The Windows system in question is configured to run the Windows Firewall. If the Windows Firewall is not enabled, then no postinstallation configuration steps are required.</p> </li> </ul> <p>If all of the above conditions are met, then the Windows Firewall must be configured to allow successful incoming connections to the Oracle software. To enable Oracle software to accept connection requests, Windows Firewall needs to be configured by either opening up specific static TCP ports in the firewall or by creating exceptions for specific executables so they can receive connection requests on any ports they choose. This firewall configuration can be done by one of the following methods:</p> <ul> <li> <p>From the Control Panel, select Windows Firewall. In the Windows Firewall application, select the Exceptions tab and then click either Add Program or Add Port to create exceptions for the Oracle software.</p> </li> <li> <p>From the command prompt, use the <code>netsh</code> <code>firewall add...</code> command.</p> </li> <li> <p>When Windows notifies you that a foreground application is attempting to listen on a port, and gives you the opportunity to create an exception for that executable. If you choose the create the exception in this way, the effect is the same as creating an exception for the executable either through Control Panel or from the command line.</p> </li> </ul> <p>The following sections list the Oracle Database 11<span class="italic">g</span> Release 2 executables that listen on TCP ports on Windows, along with a brief description of the executable. It is recommended that these executables (if in use and accepting connections from a remote, client computer) be added to the exceptions list for the Windows Firewall to ensure correct operation. In addition, if multiple Oracle homes are in use, firewall exceptions may need to be created for the same executable, for example, oracle.exe, multiple times, once for each Oracle home from which that executable loads.</p> <ul> <li> <p><a href="#CEGIFJDI">Firewall Exceptions for Oracle Database</a></p> </li> <li> <p><a href="#CEGEIAEJ">Firewall Exceptions for Oracle Database Examples</a></p> </li> <li> <p><a href="#CEGJBHBE">Firewall Exceptions for Oracle Gateways</a></p> </li> <li> <p><a href="#CEGFDJHJ">Firewall Exceptions for Oracle Clusterware and Oracle ASM</a></p> </li> <li> <p><a href="#CEGHCAHC">Firewall Exceptions for Other Oracle Products</a></p> </li> </ul> <a id="CEGIFJDI" name="CEGIFJDI"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Firewall Exceptions for Oracle Database</h4> <p>For basic database operation and connectivity from remote clients (SQL*Plus, OCI, ODBC, OLE DB applications, and so on), the following executables must be added to the Windows Firewall exception list:</p> <ul> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\bin\oracle.exe</code> - Oracle Database executable</p> </li> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\bin\tnslsnr.exe</code> - Oracle Listener</p> </li> </ul> <p>For remote monitoring capabilities to be available for a database running on Windows, the following executables must be added to the Windows Firewall exception list:</p> <ul> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\bin\emagent.exe</code> - Oracle Database Control</p> </li> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\jdk\bin\java.exe-</code> Java Virtual Machine</p> </li> </ul> </div> <!-- class="sect3" --> <a id="CEGEIAEJ" name="CEGEIAEJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Firewall Exceptions for Oracle Database Examples</h4> <p>After installing the Oracle Database Examples, the following executables must be added to the Windows Firewall exception list:</p> <ul> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\opmn\bin\opmn.exe</code> - Oracle Process Manager</p> </li> <li> <p><code><span class="codeinlineitalic">Oracle_home</span></code><code>\jdk\bin\java.exe</code> - Java Virtual Machine</p> </li> </ul> </div> <!-- class="sect3" --> <a id="CEGJBHBE" name="CEGJBHBE"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Firewall Exceptions for Oracle Gateways</h4> <p>If your Oracle database interacts with non-Oracle software through a gateway, then you must add the gateway executable to the Windows Firewall exception list. <a href="#CEGEEIEH">Table 4-1</a>table lists the gateway executables used to access non-Oracle software.</p> <div class="tblformal"><a id="sthref173" name="sthref173"></a><a id="CEGEEIEH" name="CEGEEIEH"></a> <p class="titleintable">Table 4-1 Oracle Executables Requiring Windows Firewall Exceptions</p> <table class="Formal" title=" Oracle Executables Requiring Windows Firewall Exceptions" summary="This table lists the Oracle executables requiring Windows Firewall exceptions. The first column is the file name, and the second column is the executable name." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="*" /> <col width="47%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t4">File Name</th> <th align="left" valign="bottom" id="r1c2-t4">Executable Name</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t4" headers="r1c1-t4"> <p><code>omtsreco.exe</code></p> </td> <td align="left" headers="r2c1-t4 r1c2-t4"> <p>Oracle Services for Microsoft Transaction Server</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t4" headers="r1c1-t4"> <p><code>dg4sybs.exe</code></p> </td> <td align="left" headers="r3c1-t4 r1c2-t4"> <p>Oracle Database Gateway for Sybase</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t4" headers="r1c1-t4"> <p><code>dg4tera.exe</code></p> </td> <td align="left" headers="r4c1-t4 r1c2-t4"> <p>Oracle Database Gateway for Teradata</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t4" headers="r1c1-t4"> <p><code>dg4msql.exe</code></p> </td> <td align="left" headers="r5c1-t4 r1c2-t4"> <p>Oracle Database Gateway for SQL Server</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t4" headers="r1c1-t4"> <p><code>dg4db2.exe</code></p> </td> <td align="left" headers="r6c1-t4 r1c2-t4"> <p>Oracle Database Gateway for DRDA</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t4" headers="r1c1-t4"> <p><code>pg4arv.exe</code></p> </td> <td align="left" headers="r7c1-t4 r1c2-t4"> <p>Oracle Database Gateway for APPC</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t4" headers="r1c1-t4"> <p><code>pg4t4ic.exe</code></p> </td> <td align="left" headers="r8c1-t4 r1c2-t4"> <p>Oracle Database Gateway for APPC</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t4" headers="r1c1-t4"> <p><code>dg4mqs.exe</code></p> </td> <td align="left" headers="r9c1-t4 r1c2-t4"> <p>Oracle Database Gateway for WebSphere MQ</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t4" headers="r1c1-t4"> <p><code>dg4mqc.exe</code></p> </td> <td align="left" headers="r10c1-t4 r1c2-t4"> <p>Oracle Database Gateway for WebSphere MQ</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t4" headers="r1c1-t4"> <p><code>dg4odbc.exe</code></p> </td> <td align="left" headers="r11c1-t4 r1c2-t4"> <p>Oracle Database Gateway for ODBC</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --> <a id="CEGFDJHJ" name="CEGFDJHJ"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Firewall Exceptions for Oracle Clusterware and Oracle ASM</h4> <p>If you installed the Oracle grid infrastructure software on the nodes in your cluster, then you can enable the Windows Firewall only after adding the following executables and ports to the Firewall exception list. The Firewall Exception list must be updated on each node.</p> <ul> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\gpnpd.exe</code> - Grid Plug and Play daemon</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\oracle.exe</code> - Oracle ASM executable (if using Oracle ASM for storage)</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\racgvip.exe</code> - Virtual Internet Protocol Configuration Assistant</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\evmd.exe</code> - OracleEVMService</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\crsd.exe</code> - OracleCRService</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\ocssd.exe</code> - OracleCSService</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\octssd.exe</code> - Cluster Time Synchronization Service daemon</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\mDNSResponder.exe</code> - multicast-DNS Responder Daemon</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\gipcd.exe</code> - Grid IPC daemon</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\gnsd.exe</code> - Grid Naming Service daemon</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\ohasd.exe</code> - OracleOHService</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\bin\TNSLSNR.EXE</code> - SCAN listener and local listener for Oracle Database and Oracle ASM</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\opmn\bin\ons.exe</code> - Oracle Notification Service</p> </li> <li> <p><code><span class="codeinlineitalic">Grid_home</span></code><code>\jdk\jre\bin\java.exe</code> - Java Virtual Machine</p> </li> </ul> </div> <!-- class="sect3" --> <a id="CEGHCAHC" name="CEGHCAHC"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">Firewall Exceptions for Other Oracle Products</h4> <p>In additional to all the previously listed exceptions, if you use any of the Oracle software listed in, then you must create an exception for Windows Firewall for the associated executable.</p> <div class="tblformal"><a id="sthref174" name="sthref174"></a><a id="sthref175" name="sthref175"></a> <p class="titleintable">Table 4-2 Other Oracle Software Products Requiring Windows Firewall Exceptions</p> <table class="Formal" title="Other Oracle Software Products Requiring Windows Firewall Exceptions" summary="Other Oracle Software Products Requiring Windows Firewall Exceptions" dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"> <col width="*" /> <col width="48%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t5">Oracle Software Product</th> <th align="left" valign="bottom" id="r1c2-t5">Executable Name</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t5" headers="r1c1-t5"> <p>Data Guard Manager</p> </td> <td align="left" headers="r2c1-t5 r1c2-t5"> <p><code>dgmgrl.exe</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t5" headers="r1c1-t5"> <p>Oracle Internet Directory LDAP Server</p> </td> <td align="left" headers="r3c1-t5 r1c2-t5"> <p><code>oidldapd.exe</code></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t5" headers="r1c1-t5"> <p>External Procedural Calls</p> </td> <td align="left" headers="r4c1-t5 r1c2-t5"> <p><code>extproc.exe</code></p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblformal" --></div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BHCFFHBI" name="BHCFFHBI"></a><a id="NTQRF161" name="NTQRF161"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Configuring the Windows Firewall</h3> <p>Postinstallation configuration for the Windows Firewall must be undertaken if <span class="italic">all</span> of the following conditions are met:</p> <ul> <li> <p>Oracle server-side components are installed.</p> <p>These components include the Oracle Database, network listeners, and any Web servers or services.</p> </li> <li> <p>The computer services connections from other computers over a network.</p> <p>If no other computers connect to the computer with the Oracle software, then no postinstallation configuration steps are required and the Oracle software will function as expected.</p> </li> <li> <p>The Windows Firewall is enabled.</p> <p>If the Windows Firewall is not enabled, then no postinstallation configuration steps are required.</p> </li> </ul> <p>You can configure Windows Firewall by opening specific static TCP ports in the firewall or by creating exceptions for specific executables so that they are able to receive connection requests on any ports they choose. To configure the firewall, from the <span class="bold">Control Panel</span>, select <span class="bold">Windows Firewall</span> and then select <span class="bold">Exceptions</span> or enter <code>netsh firewall add...</code> at the command line.</p> <p>Alternatively, Windows will inform you if a foreground application is attempting to listen on a port, and it will ask you if you want to create an exception for that executable. If you choose to do so, then the effect is the same as creating an exception for the executable either in the Control Panel or from the command line.</p> <div class="infoboxnote"> <p class="notep1">Note:</p> Windows 2008 and later operating systems do not provide any information on applications attempting to listen on a port. Instead, a security audit event is logged to signal that an application is blocked.</div> </div> <!-- class="sect2" --> <a id="BHCJAGBA" name="BHCJAGBA"></a><a id="NTQRF162" name="NTQRF162"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Troubleshooting Windows Firewall Exceptions</h3> <p>If you cannot establish certain connections even after granting exceptions to the executables listed in <a href="#CEGEEIEH">Table 4-1</a>, then follow these steps to troubleshoot the installation:</p> <ol> <li> <p>Examine Oracle configuration files (such as <code>*.conf</code> files), the Oracle key in the Windows registry, and network configuration files in <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\network\admin</code>.</p> </li> <li> <p>Pay particular attention to any executable listed in <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\network\admin\listener.ora</code> in a <code>PROGRAM=</code> clause. Each of these must be granted an exception in the Windows Firewall, because a connection can be made through the TNS Listener to that executable.</p> </li> <li> <p>Examine Oracle trace files, log files, and other sources of diagnostic information for details on failed connection attempts. Log and trace files on the database client computer may contain useful error codes or troubleshooting information for failed connection attempts. The Windows Firewall log file on the server may contain useful information as well.</p> </li> <li> <p>If the preceding troubleshooting steps do not resolve a specific configuration issue on Windows XP Service Pack 2, then provide the output from command <code>netsh firewall show state verbose=enable</code> to Oracle Support for diagnosis and problem resolution.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><code><a href="http://www.microsoft.com/downloads/details.aspx?FamilyID=a7628646-131d-4617-bf68-f0532d8db131&displaylang=en">http://www.microsoft.com/downloads/details.aspx?FamilyID=a7628646-131d-4617-bf68-f0532d8db131&displaylang=en</a></code></p> <p>for information on Windows Firewall troubleshooting</p> </li> <li> <p><code><a href="http://support.microsoft.com/kb/875357">http://support.microsoft.com/kb/875357</a></code> for more information on Windows Firewall configuration</p> </li> </ul> </div> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABBBCFF" name="BABBBCFF"></a><a id="NTQRF163" name="NTQRF163"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Resetting Passwords for Default Accounts</h2> <p>Oracle Database installs with many default accounts. Database Configuration Assistant locks and expires most default database accounts upon successful installation. Oracle recommends changing all user passwords <span class="italic">immediately</span> after installation.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink ADMIN00206" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN00206"><span class="italic">Oracle Database Administrator's Guide</span></a> for more information on default database accounts and passwords</div> </div> <!-- class="sect1" --> <a id="i1014905" name="i1014905"></a><a id="NTQRF164" name="NTQRF164"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">NTFS File System and Windows Registry Permissions<a id="sthref176" name="sthref176"></a><a id="sthref177" name="sthref177"></a></h2> <p>Oracle recommends that you configure Oracle Database files, directories, and registry settings to allow only authorized database administrators (DBAs) to have full control. If you created a database using Database Configuration Assistant or upgraded a database using Oracle Database Upgrade Assistant, then no further action is required.</p> <p>This section describes the permissions automatically set by Oracle Universal Installer, Database Configuration Assistant, and Oracle Database Upgrade Assistant and the steps to set these permissions manually.</p> <p>This section contains these topics:</p> <ul> <li> <p><a href="#i1013691">File Permissions</a></p> </li> <li> <p><a href="#BABBJDHJ">Setting NTFS File System Security</a></p> </li> <li> <p><a href="#i1005695">Setting Windows Registry Security</a></p> <div class="infoboxnotealso"> <p class="notep1"><span class="bold">See Also</span>:</p> Your operating system documentation for more information about modifying NTFS file system and Windows registry settings</div> </li> </ul> <a id="i1013691" name="i1013691"></a><a id="NTQRF165" name="NTQRF165"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">File Permissions<a id="ABC1019374" name="ABC1019374"></a><a id="ABC1019374SRI1" name="ABC1019374SRI1"></a></h3> <p>Beginning with Oracle9<span class="italic">i</span> Release 2 (9.2), Oracle Universal Installer, Database Configuration Assistant, and Database Upgrade Assistant set file permissions when Oracle Database software is installed or upgraded.</p> <p>This section contains these topics:</p> <ul> <li> <p><a href="#i1013596">File Permissions Set by Oracle Universal Installer</a></p> </li> <li> <p><a href="#i1013620">File Permissions Set by Database Configuration Assistant</a></p> </li> <li> <p><a href="#i1013646">File Permissions Set by Database Upgrade Assistant</a></p> </li> </ul> <a id="i1013596" name="i1013596"></a><a id="NTQRF166" name="NTQRF166"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">File Permissions Set by Oracle Universal Installer</h4> <p>During Oracle Database installation, by default Oracle Universal Installer installs software in <code><span class="codeinlineitalic">ORACLE_HOME</span></code>. Oracle Universal Installer sets the following permissions to this directory, and all files and directories under this directory:</p> <ul> <li> <p><code>Administrators</code> - Full control</p> </li> <li> <p><code>System</code> - Full control</p> </li> <li> <p><code>Authenticated Users</code> - Read, Execute, and List Contents</p> <div class="infoboxnote"> <p class="notep1">Important:</p> If these accounts already exist and possess more restrictive permissions, then the most restrictive permissions are retained. If accounts other than <code>Administrators</code>, <code>System</code>, and <code>Authenticated</code> <code>Users</code> already exist, then the permissions for these accounts are removed.</div> </li> </ul> </div> <!-- class="sect3" --> <a id="i1013620" name="i1013620"></a><a id="NTQRF167" name="NTQRF167"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">File Permissions Set by Database Configuration Assistant</h4> <p>During database configuration, Database Configuration Assistant installs files and directories in the following default locations, where <code><span class="codeinlineitalic">database_name</span></code> is the database name or <code><span class="codeinlineitalic">SID</span></code>:</p> <ul> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\admin\</code><code><span class="codeinlineitalic">database_name</span></code> (administration file directories)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">database_name</span></code> (database file directories)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">database_name</span></code> (redo log files and control files)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\database</code> (<code>SPFILE</code><code><span class="codeinlineitalic">SID</span></code><code>.ORA</code>)</p> </li> </ul> <p>Database Configuration Assistant sets the following permissions to these directories, and all files and directories under these directories:</p> <ul> <li> <p><code>Administrators</code> - Full Control</p> </li> <li> <p><code>System</code> - Full Control</p> <div class="infoboxnote"> <p class="notep1">Important:</p> If these accounts already exist and possess more restrictive permissions, then the most restrictive permissions are retained. If accounts other than <code>Administrators</code> and <code>System</code> already exist, then the permissions for these accounts are removed.</div> </li> </ul> </div> <!-- class="sect3" --> <a id="i1013646" name="i1013646"></a><a id="NTQRF168" name="NTQRF168"></a> <div class="sect3"><!-- infolevel="all" infotype="General" --> <h4 class="sect3">File Permissions Set by Database Upgrade Assistant</h4> <p>When an older version of the database is upgraded to Oracle Database 10<span class="italic">g</span> Release 1 (10.1) or later, Database Upgrade Assistant installs software in the following directories, where <code><span class="codeinlineitalic">database_name</span></code> is the database name or <code><span class="codeinlineitalic">SID</span></code>:</p> <ul> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\admin\</code><code><span class="codeinlineitalic">database_name</span></code> (administration files)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">database_name</span></code> (database file directories)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">database_name</span></code> (redo log files and control files)</p> </li> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\</code><code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\database</code> (<code>SPFILE</code><code><span class="codeinlineitalic">SID</span></code><code>.ORA</code>)</p> </li> </ul> <p>Database Upgrade Assistant sets the following permissions to these directories, and all files and directories under these directories:</p> <ul> <li> <p><code>Administrators</code> - Full Control</p> </li> <li> <p><code>System</code> - Full Control</p> <div class="infoboxnote"> <p class="notep1">Important:</p> If these accounts already exist and possess more restrictive permissions, then the most restrictive permissions are retained. If accounts other than <code>Administrators</code> and <code>System</code> already exist, then the permissions for these accounts are removed.</div> </li> </ul> <p>Beginning with Oracle Database 11<span class="italic">g</span> Release 2 (11.2), Database Upgrade Assistant can also configure Enterprise Manager. If the "Enable daily backup" option is selected while configuring Enterprise Manager, then Database Upgrade Assistant shows a separate screen asking for Fast Recovery Area. Database Upgrade Assistant will try to create the directory structure in whatever file system location is specified if it does not exist. It will put the same set of file permissions to this location. The default location shown by DBUA for fast recovery area is:</p> <ul> <li> <p><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\recovery_area</code></p> </li> </ul> </div> <!-- class="sect3" --></div> <!-- class="sect2" --> <a id="BABBJDHJ" name="BABBJDHJ"></a><a id="NTQRF169" name="NTQRF169"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Setting NTFS File System Security</h3> <p><span class="bold">To ensure that only authorized users have full file system permissions:</span></p> <ol> <li> <p>Go to Windows Explorer.</p> </li> <li> <p>Set the following permissions for each directory or file:</p> <div class="inftblhruleinformalwide"> <table class="HRuleInformalWide" title="Setting Directory Permissions" summary="Recommended permissions for selected Oracle directories" dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="*" /> <col width="42%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t13">Directory</th> <th align="left" valign="bottom" id="r1c2-t13">Group and Permissions</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t13" headers="r1c1-t13"><code><span class="codeinlineitalic">ORACLE_HOME</span></code></td> <td align="left" headers="r2c1-t13 r1c2-t13"> <ul> <li><code>Administrators</code> - Full Control</li> <li> <p><code>System</code> - Full Control</p> </li> <li> <p><code>Authenticated</code> <code>Users</code> - Read, Execute and List Contents</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t13" headers="r1c1-t13"><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\admin\</code><code><span class="codeinlineitalic">database_name</span></code></td> <td align="left" headers="r3c1-t13 r1c2-t13"> <ul> <li><code>Administrators</code> - Full Control</li> <li> <p><code>System</code> - Full Control</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t13" headers="r1c1-t13"><code><span class="codeinlineitalic">ORACLE_BASE</span></code><code>\oradata\</code><code><span class="codeinlineitalic">database_name</span></code></td> <td align="left" headers="r4c1-t13 r1c2-t13"> <ul> <li><code>Administrators</code> - Full Control</li> <li> <p><code>System</code> - Full Control</p> </li> </ul> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t13" headers="r1c1-t13"><code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\database\spfile</code><code><span class="codeinlineitalic">SID</span></code><code>.ora</code></td> <td align="left" headers="r5c1-t13 r1c2-t13"> <ul> <li><code>Administrators</code> - Full Control</li> <li> <p><code>System</code> - Full Control</p> </li> </ul> </td> </tr> </tbody> </table> <br /></div> <!-- class="inftblhruleinformalwide" --></li> </ol> <div class="infoboxnote"> <p class="notep1">Note:</p> Oracle Database uses the Windows LocalSystem built-in security account. Therefore, file permissions must be granted to the <code>System</code> account of the local computer running Oracle Database.</div> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> Your operating system online help for more information about how to modify NTFS file system and registry settings</div> </div> <!-- class="sect2" --> <a id="i1005695" name="i1005695"></a><a id="NTQRF171" name="NTQRF171"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2">Setting Windows Registry Security<a id="sthref178" name="sthref178"></a><a id="sthref179" name="sthref179"></a></h3> <p>Oracle recommends that you remove write permissions from users who are <span class="italic">not</span> Oracle Database DBAs or system administrators in <code>HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE</code> of the Windows registry.</p> <p><span class="bold">To remove write permissions:</span></p> <ol> <li> <p>Open the registry.</p> </li> <li> <p>Go to <code>HKEY_LOCAL_MACHINE\SOFTWARE\ORACLE</code>.</p> </li> <li> <p>Select Permissions from the Security main menu.</p> <p>The Registry Key Permissions dialog appears.</p> </li> <li> <p>Remove write permissions from any users who are not Oracle Database DBAs or system administrators. Note that the <code>SYSTEM</code> account must have Full Control, since this is the account with which Oracle Database runs.</p> </li> <li> <p>Ensure that user accounts that must run Oracle applications have read privileges.</p> </li> <li> <p>Choose OK.</p> </li> <li> <p>Exit the registry. <a id="sthref180" name="sthref180"></a><a id="sthref181" name="sthref181"></a></p> </li> </ol> </div> <!-- class="sect2" --></div> <!-- class="sect1" --> <a id="BABDAFBG" name="BABDAFBG"></a><a id="NTQRF172" name="NTQRF172"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Configuring External Job Support for the Scheduler on Windows</h2> <p>This release includes Oracle Scheduler (the Scheduler) which provides enterprise scheduling functionality. External jobs performed by the user are started using the <code>OracleJobScheduler</code><code><span class="codeinlineitalic">SID</span></code> service. This service is disabled by default. To use the external jobs functionality, the administrator must set the username and password for the user account under which this service must run and enable the service.</p> <p>Restricting execution of external jobs to a low-privileged user prevents unauthorized database users from gaining operating system level privileges, but it also places restrictions on the kinds of jobs that can be run. Jobs requiring a higher level of operating system privileges cannot be run by this mechanism.</p> <p>Enabling and starting the <code>OracleJobScheduler</code><code><span class="codeinlineitalic">SID</span></code> service is required only for compatibility with Oracle Database 10<span class="italic">g</span> Release 1 and Release 2, for local external jobs that do not use credentials. This service is not required if all local external jobs use credentials. For improved security, Oracle recommends that all local external jobs use credentials.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink ADMIN12368" href="http://www.oracle.com/pls/db112/lookup?id=ADMIN12368"><span class="italic">Oracle Database Administrator's Guide</span></a> for more information about external jobs</div> </div> <!-- class="sect1" --> <a id="i1005764" name="i1005764"></a><a id="NTQRF183" name="NTQRF183"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Configuring Oracle Multimedia on Windows</h2> <p>Oracle Multimedia (formerly <span class="italic">inter</span>Media) is a feature that enables Oracle Database to store, manage, and retrieve images, DICOM format medical images and other DICOM data, audio, video, or other heterogeneous media data in an integrated fashion with other enterprise information. Oracle Multimedia extends Oracle Database reliability, availability, and data management to multimedia content in traditional, Internet, electronic commerce, medical and media-rich applications.</p> <p>If you install Standard Edition, Standard Edition One, or Enterprise Edition, then Database Configuration Assistant starts automatically at the end of installation. If you choose any Database Configuration Assistant installation type other than Customized, then Oracle Multimedia does not require manual configuration. All tasks described in this section are performed automatically.</p> <p>If you select Customized installation, then Database Configuration Assistant will guide you through configuration of Oracle Multimedia.</p> <a id="i1005766" name="i1005766"></a> <p>If you are creating and configuring a database manually, then you can configure Oracle Multimedia as follows:</p> <ol> <li> <p>Start SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /NOLOG </pre></li> <li> <p>Connect to Oracle Database with account <code>SYSDBA</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> CONNECT /<span class="italic"> </span>AS SYSDBA </pre></li> <li> <p>Start the database (if necessary):</p> <pre xml:space="preserve" class="oac_no_warn">SQL> STARTUP </pre></li> <li> <p>Run script <code>ordinst.sql</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="italic">ORACLE_HOME</span>\ord\admin\ordinst.sql SYSAUX SYSAUX </pre></li> <li> <p>Run script <code>iminst.sql</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="italic">ORACLE_HOME</span>\ord\im\admin\catim.sql </pre></li> <li> <p>Exit SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> EXIT </pre> <div class="infoboxnote"> <p class="notep1">Note:</p> If you manually copy your Oracle8<span class="italic">i</span> <code>listener.ora</code> and <code>tnsnames.ora</code> files into your Oracle Database network directory, then you must modify network configuration files <code>tnsnames.ora</code> and <code>listener.ora</code> on your server to enable <a href="glossary.htm#i433324"><span class="xrefglossterm">external routine</span></a> calls to work and Oracle Multimedia to function properly. Follow the procedure in <a class="olink NETAG0132" href="http://www.oracle.com/pls/db112/lookup?id=NETAG0132"><span class="italic">Oracle Net Services Administrator's Guide</span></a>.</div> </li> </ol> </div> <!-- class="sect1" --> <a id="i1007869" name="i1007869"></a><a id="NTQRF184" name="NTQRF184"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref182" name="sthref182"></a><a id="sthref183" name="sthref183"></a>Configuring Oracle Text on Windows</h2> <p>Oracle Text enables text queries through SQL and <a href="glossary.htm#i432445"><span class="xrefglossterm">PL/SQL</span></a> from most Oracle interfaces. By installing Oracle Text with an Oracle Database server, client tools such as SQL*Plus and Pro*C/C++ are able to retrieve and manipulate text in Oracle Database.</p> <p>Oracle Text manages textual data in concert with traditional data types in Oracle Database. When text is inserted, updated, or deleted, Oracle Text automatically manages the change.</p> <p>If you install Oracle Text from the media and do not have a previous release of Oracle Text installed, then Oracle Database is already configured for use with Oracle Text if one of the following is true:</p> <ul> <li> <p>You created the database by using Database Configuration Assistant in standalone mode, and selected Typical database creation type.</p> </li> <li> <p>The database is a <a href="glossary.htm#CBACJBHB"><span class="xrefglossterm">starter database</span></a> that you created by performing the following sequence of steps:</p> <ol> <li> <p>Select Oracle Database 11<span class="italic">g</span> in the <span class="bold">Select a Product to Install</span> window.</p> </li> <li> <p>Select Basic Installation in the <span class="bold">Select Installation Method</span> window.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><a href="create.htm#g1023843">Chapter 3, "Postinstallation Database Creation on Windows"</a></p> </li> <li> <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 creating a starter database</p> </li> </ul> </div> </li> </ul> <p>If none of these is true, then you must configure Oracle Database for use with Oracle Text by using <a href="#BABHJCBJ">"Configuring Oracle Text Using Database Configuration Assistant"</a>.</p> <a id="NTQRF185" name="NTQRF185"></a> <p class="subhead2">Upgrading Oracle Text from a Previous Release</p> <p>If you install Oracle Text from the 11.2 media and have a previous release of Oracle Text (formerly called <span class="italic">inter</span>Media Text) already installed, then the executables for USER_FILTER are now executed from <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\ctx\bin.</code> Therefore, after the upgrade, you must issue the following sql command as database user <code>SYS, SYSTEM,</code> or <code>CTXSYS</code> to get a list of USER_FILTER executables. These executables must be copied from <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\bin</code> to <code><span class="codeinlineitalic">ORACLE_HOME</span></code><code>\ctx\bin</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> SELECT IXV_VALUE FROM CTXSYS.CTX_INDEX_VALUES WHERE IXV_CLASS='FILTER' AND IXV_OBJECT='USER_FILTER' AND IXV_ATTRIBUTE='COMMAND'; </pre> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink CCAPP" href="http://www.oracle.com/pls/db112/lookup?id=CCAPP"><span class="italic">Oracle Text Application Developer's Guide</span></a></div> <a id="BABHJCBJ" name="BABHJCBJ"></a><a id="NTQRF186" name="NTQRF186"></a> <p class="subhead1">Configuring Oracle Text Using Database Configuration Assistant</p> <p>To use Database Configuration Assistant to configure Oracle Database for use with Oracle Text at the time you create the database, simply select Oracle Text as the option to configure when prompted.</p> <p>To configure the database at a later time:</p> <ol> <li> <p>Start Database Configuration Assistant.</p> <p>From the <span class="bold">Start</span> menu, select <span class="bold">Programs</span>, then select <span class="bold">Oracle -</span> <span class="bolditalic">HOME_NAME,</span> then select <span class="bold">Configuration and Migration Tools</span> and then select <span class="bold">Database Configuration Assistant</span>.</p> </li> <li> <p>Select <span class="bold">Configure database options in a database</span>.</p> </li> <li> <p>Select the database to modify when prompted.</p> </li> <li> <p>Select <span class="bold">Oracle Text</span> as the option to configure when prompted.</p> </li> </ol> </div> <!-- class="sect1" --> <a id="i1006041" name="i1006041"></a><a id="NTQRF189" name="NTQRF189"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><a id="sthref184" name="sthref184"></a><a id="sthref185" name="sthref185"></a>Configuring Oracle Spatial on Windows</h2> <p>Oracle Spatial makes storage, retrieval, and manipulation of spatial data easier and more intuitive to users.</p> <p>One example of spatial data is a road map. A road map is a two-dimensional object that contains points, lines, and polygons representing cities, roads, and political boundaries such as states. A road map represents geographic information. Locations of cities, roads, and political boundaries are projected onto a two-dimensional display or piece of paper, preserving relative positions and relative distances of objects.</p> <p>If you install Oracle Spatial through Enterprise Edition, then no manual configuration is required. All Oracle Spatial configuration tasks are performed automatically.</p> <p>If you install both Oracle Spatial and Oracle Database together through Enterprise Edition or Standard Edition Custom installation, then Database Configuration Assistant starts automatically at the end of installation. If you choose Custom installation and select Create new database, then the assistant asks if Oracle Spatial is to be configured automatically.</p> <p>If you install Oracle Spatial during a separate installation from Enterprise Edition, then you must either start Database Configuration Assistant and select Configure database options in a database or configure Oracle Spatial manually.</p> <p>To configure Oracle Spatial manually:</p> <ol> <li> <p>Start SQL*Plus at the command prompt:</p> <pre xml:space="preserve" class="oac_no_warn">C:\> sqlplus /NOLOG </pre></li> <li> <p>Connect to Oracle Database with account <code>SYSDBA</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> CONNECT / AS SYSDBA </pre></li> <li> <p>Start the database (if necessary):</p> <pre xml:space="preserve" class="oac_no_warn">SQL> STARTUP </pre></li> <li> <p>Run script <code>ordinst.sql</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="italic">ORACLE_HOME</span>\ord\admin\ordinst.sql SYSAUX SYSAUX </pre></li> <li><a id="i1006127" name="i1006127"></a> <p>Connect to the database as user <a href="glossary.htm#i432552"><span class="xrefglossterm">SYSTEM</span></a>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> CONNECT SYSTEM Enter password: <span class="italic">system_password</span> </pre></li> <li> <p>Run script <code>mdinst.sql</code>:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> <span class="italic">ORACLE_HOME</span>\md\admin\mdinst.sql </pre></li> <li> <p>Exit SQL*Plus:</p> <pre xml:space="preserve" class="oac_no_warn">SQL> EXIT </pre> <div class="infoboxnote"> <p class="notep1">Note:</p> Script <code>mdinst.sql</code> has a variable <code>%MD_SYS_PASSWORD%</code> that Oracle Universal Installer will <a href="glossary.htm#i432900"><span class="xrefglossterm">instantiate</span></a> at installation time. Therefore, if you have changed the <code>mdsys</code> user's password, then be sure during a manual installation to remember also to update script <code>mdinst.sql</code> with that password.</div> </li> </ol> </div> <!-- class="sect1" --> <a id="BABFDBDC" name="BABFDBDC"></a><a id="NTQRF191" name="NTQRF191"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1">Configuring Advanced Replication on Windows</h2> <p>Oracle Database installs <a href="glossary.htm#i433329"><span class="xrefglossterm">replication</span></a> packages and procedures automatically rather than as a separate manual process. There are many configuration and usage possibilities with Advanced Replication.</p> <p>This section describes how to manually configure Advanced Replication in Oracle Database. Follow the instructions <span class="italic">only</span> if you add Advanced Replication to an installation of Oracle Database that was not previously configured with this feature.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <a class="olink REPLN" href="http://www.oracle.com/pls/db112/lookup?id=REPLN"><span class="italic">Oracle Database Advanced Replication</span></a> for more information about Advanced Replication and for definitions of master sites and materialized view sites</div> <a id="i1006320" name="i1006320"></a> <p>Configuring Advanced Replication consists of the following steps:</p> <ul> <li> <p><a href="#i1006359">Checking Tablespace and Rollback Segment Requirements</a></p> </li> <li> <p><a href="#i1006388">Adding and Modifying Initialization Parameters</a></p> </li> <li> <p><a href="#i1006440">Monitoring Data Dictionary Tables</a></p> </li> </ul> <a id="i1006359" name="i1006359"></a><a id="NTQRF192" name="NTQRF192"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref186" name="sthref186"></a><a id="sthref187" name="sthref187"></a>Checking Tablespace and Rollback Segment Requirements</h3> <p>Recommended tablespace and rollback segment requirements for Advanced Replication are shown in <a href="#g1010392">Table 4-3</a>.</p> <div class="tblhruleformal"><a id="NTQRF193" name="NTQRF193"></a><a id="sthref188" name="sthref188"></a><a id="g1010392" name="g1010392"></a> <p class="titleintable">Table 4-3 Advanced Replication Tablespace/Rollback Segment Requirements</p> <table class="HRuleFormal" title=" Advanced Replication Tablespace/Rollback Segment Requirements" summary="Rows are tablespaces or rollback segments. For each row, the first column is the name of the tablespace or rollback segment, and the second column is its minimum free space requirement." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="44%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t22">Tablespace/Rollback Segment</th> <th align="left" valign="bottom" id="r1c2-t22">Minimum Free Space</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t22" headers="r1c1-t22"> <p>SYSTEM<a href="#BABGBFHD"><span class="xrefglossterm">Note</span></a></p> </td> <td align="left" headers="r2c1-t22 r1c2-t22"> <p>20 MB</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t22" headers="r1c1-t22"> <p>UNDO TABLESPACE</p> </td> <td align="left" headers="r3c1-t22 r1c2-t22"> <p>10 MB</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t22" headers="r1c1-t22"> <p>RBS</p> </td> <td align="left" headers="r4c1-t22 r1c2-t22"> <p>5 MB</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t22" headers="r1c1-t22"> <p>TEMP</p> </td> <td align="left" headers="r5c1-t22 r1c2-t22"> <p>10 MB</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t22" headers="r1c1-t22"> <p>USERS</p> </td> <td align="left" headers="r6c1-t22 r1c2-t22"> <p>No specific requirement</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformal" --> <a id="BABGBFHD" name="BABGBFHD"></a><a id="NTQRF194" name="NTQRF194"></a> <p class="subhead2">Note</p> <p>Replication triggers and procedures are stored here.</p> </div> <!-- class="sect2" --> <a id="i1006388" name="i1006388"></a><a id="NTQRF195" name="NTQRF195"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref189" name="sthref189"></a><a id="sthref190" name="sthref190"></a>Adding and Modifying Initialization Parameters</h3> <p>If you use Advanced Replication, then certain parameter values must be added to the initialization parameter file, and others must be set to recommended values. Parameter names and values for the master site and materialized view sites are shown in <a href="#g1010414">Table 4-4</a>.</p> <div class="tblhruleformal"><a id="NTQRF196" name="NTQRF196"></a><a id="sthref191" name="sthref191"></a><a id="g1010414" name="g1010414"></a> <p class="titleintable">Table 4-4 Advanced Replication Initialization Parameters</p> <table class="HRuleFormal" title=" Advanced Replication Initialization Parameters" summary="Rows are parameters. For each parameter, the first column is its name, the second column is its recommended value, and the third column shows its site (master or materialized view)." dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="*" /> <col width="33%" /> <col width="24%" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t23">Parameter Name</th> <th align="left" valign="bottom" id="r1c2-t23">Recommended Value</th> <th align="left" valign="bottom" id="r1c3-t23">Site</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t23" headers="r1c1-t23"> <p><code>JAVA_POOL_SIZE</code></p> </td> <td align="left" headers="r2c1-t23 r1c2-t23"> <p>50 MB</p> </td> <td align="left" headers="r2c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t23" headers="r1c1-t23"> <p><code>DISTRIBUTED_LOCK_TIMEOUT</code></p> </td> <td align="left" headers="r3c1-t23 r1c2-t23"> <p>300 seconds</p> </td> <td align="left" headers="r3c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t23" headers="r1c1-t23"> <p><code>GLOBAL_NAMES</code></p> </td> <td align="left" headers="r4c1-t23 r1c2-t23"> <p>TRUE</p> </td> <td align="left" headers="r4c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t23" headers="r1c1-t23"> <p><code>OPEN_LINKS</code></p> </td> <td align="left" headers="r5c1-t23 r1c2-t23"> <p>4</p> </td> <td align="left" headers="r5c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t23" headers="r1c1-t23"> <p><code>PROCESSES</code></p> </td> <td align="left" headers="r6c1-t23 r1c2-t23"> <p>Add 9 to current value</p> </td> <td align="left" headers="r6c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t23" headers="r1c1-t23"> <p><code>JOB_QUEUE-PROCESSES</code></p> </td> <td align="left" headers="r7c1-t23 r1c2-t23"> <p>2 <a href="#BABIEFCD"><span class="xrefglossterm">Note</span></a></p> </td> <td align="left" headers="r7c1-t23 r1c3-t23"> <p>master</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t23" headers="r1c1-t23"> <p><code>JOB_QUEUE_PROCESSES</code></p> </td> <td align="left" headers="r8c1-t23 r1c2-t23"> <p>2</p> </td> <td align="left" headers="r8c1-t23 r1c3-t23"> <p>materialized view</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformal" --> <a id="BABIEFCD" name="BABIEFCD"></a><a id="NTQRF197" name="NTQRF197"></a> <p class="subhead2">Note</p> <p>Depends on number of n-way sites.</p> </div> <!-- class="sect2" --> <a id="i1006440" name="i1006440"></a><a id="NTQRF198" name="NTQRF198"></a> <div class="sect2"><!-- infolevel="all" infotype="General" --> <h3 class="sect2"><a id="sthref192" name="sthref192"></a><a id="sthref193" name="sthref193"></a>Monitoring <a id="sthref194" name="sthref194"></a><a id="sthref195" name="sthref195"></a>Data Dictionary Tables</h3> <p>If you use Advanced Replication and intend to set up a large number of replicated objects, then you are required to monitor the following data dictionary tables with the <code>SQL SELECT</code> command:</p> <ul> <li> <p><code>ARGUMENT$</code></p> </li> <li> <p><code>IDL_CHAR$</code></p> </li> <li> <p><code>IDL_UB1$</code></p> </li> <li> <p><code>IDL_UB2$</code></p> </li> <li> <p><code>IDL_SB4$</code></p> </li> <li> <p><code>I_ARGUMENT1</code></p> </li> <li> <p><code>I_SOURCE1I$</code></p> </li> <li> <p><code>SOURCE$</code></p> </li> <li> <p><code>TRIGGER</code></p> </li> </ul> <p>If necessary, increase storage parameters to accommodate storage requirements of large numbers of replicated objects.</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="create.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="admin.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