Edit D:\rfid\database\database\doc\install.112\e10843\faq.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:36Z" /> <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="ts.htm" title="Previous" type="text/html" /> <link rel="Next" href="glossary.htm" title="Next" type="text/html" /> <link rel="alternate" href="../e10843.pdf" title="PDF version" type="application/pdf" /> <title>Frequently Asked Questions About 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="ts.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="glossary.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="CBAGIJDJ" name="CBAGIJDJ"></a> <h1 class="appendix"><span class="secnum">G</span> <a name="NTDBI013" id="NTDBI013"></a> Frequently Asked Questions About Installation</h1> <p><a id="ABC4369360" name="ABC4369360"></a><a id="ABC4369360SRI1" name="ABC4369360SRI1"></a>Use<a id="ABC4368595" name="ABC4368595"></a><a id="ABC4368595SRI1" name="ABC4368595SRI1"></a><a id="ABC4368595SRI12" name="ABC4368595SRI12"></a><a id="ABC4368595SRI123" name="ABC4368595SRI123"></a> the following guidelines to decide how to install Oracle Database components:</p> <ul> <li> <p><a href="#BEHHJBEE">Installing Oracle Database or Oracle Database Client</a></p> </li> <li> <p><a href="#BEHGABCI">Installing Oracle Database Tools</a></p> </li> <li> <p><a href="#BEHIGEIH">Installing Oracle Database with Oracle Applications</a></p> </li> <li> <p><a href="#BEHGBDFI">Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)</a></p> </li> </ul> <a id="BEHHJBEE" name="BEHHJBEE"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">G.1</span> Installing Oracle Database or Oracle Database Client</h2> <p>The following are frequently asked questions about installing Oracle database:</p> <ul> <li> <p><a href="#CBAGECHE">I only need one instance of Oracle Database or I just want to install a test database to get familiar with the product. How do I install Oracle Database for these situations?</a></p> </li> <li> <p><a href="#CBACIDJC">How can I create an Oracle database that can handle transaction-heavy or data warehousing applications?</a></p> </li> <li> <p><a href="#CBAGEGEB">What's the best way to install multiple Oracle databases?</a></p> </li> <li> <p><a href="#CBAHFCBB">How do I configure client connections to an Oracle database?</a></p> </li> <li> <p><a href="#CBAGJHAJ">What is the best way to install Oracle Database Client if my client nodes have limited disk space?</a></p> </li> <li> <p><a href="#CBAGCEDA">How do I upgrade Oracle Database?</a></p> </li> <li> <p><a href="#CBAHGEFE">The computers at my site have been configured to run as a cluster. How should I install Oracle Database?</a></p> </li> <li> <p><a href="#CBAICICG">How do I migrate my non-Oracle databases to Oracle Database?</a></p> </li> </ul> <a id="CBAGECHE" name="CBAGECHE"></a> <p class="subhead2"><a id="ABC4356982" name="ABC4356982"></a>I only need one instance of Oracle Database or I just want to install a test database to get familiar with the product. How do I install Oracle Database for these situations?</p> <ul> <li> <p>If you want a quick installation using the default installation settings, then see the platform-specific <span class="italic">Oracle Database Quick Installation Guide</span>.</p> </li> <li> <p>If your site has special requirements, then see this guide for more information.</p> </li> </ul> <a id="CBACIDJC" name="CBACIDJC"></a> <p class="subhead2">How can I create an Oracle database that can handle transaction-heavy or data warehousing applications?</p> <p>If you want to create a starter database designed for transaction-heavy or data warehousing applications, then see this guide for more details. Select the <span class="bold">Advanced Installation</span> method, and then select the database type you want on the Select Database Configuration screen.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink DWHSG" href="http://www.oracle.com/pls/db112/lookup?id=DWHSG">Oracle Database Data Warehousing Guide</a></span> after installation</div> <p>Alternatively, you can install Oracle OLAP during the Oracle Database installation. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements. To do so, in the Select Database Edition screen, select <span class="bold">Enterprise Edition</span>. Click the Select Options button, and from the Choose Components screen, select <span class="bold">Oracle OLAP</span>.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink OLAUG" href="http://www.oracle.com/pls/db112/lookup?id=OLAUG">Oracle OLAP User's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink OLADM" href="http://www.oracle.com/pls/db112/lookup?id=OLADM">Oracle OLAP DML Reference</a></span></p> </li> <li> <p><span class="italic"><a class="olink OLAPI" href="http://www.oracle.com/pls/db112/lookup?id=OLAPI">Oracle OLAP Java API Reference</a></span></p> </li> </ul> </div> <a id="CBAGEGEB" name="CBAGEGEB"></a> <p class="subhead2">What's the best way to install multiple Oracle databases?</p> <p>Use this guide to install Oracle Database using either of the following methods:</p> <ul> <li> <p><span class="bold">Installing with response files</span>: This method lets you run Oracle Universal Installer at a command line using a response file that contains settings specific to each computer.</p> </li> <li> <p><span class="bold">Cloning a database</span>: Install Oracle Database on one computer using interactive mode. You can also clone databases. The instructions for cloning databases are described in <span class="italic">Oracle Database Administrator's Guide</span>.</p> </li> </ul> <a id="CBAHFCBB" name="CBAHFCBB"></a> <p class="subhead2">How do I configure client connections to an Oracle database?</p> <ol> <li> <p>Install Oracle Database on a server by using this guide for more information.</p> </li> <li> <p>Use platform-specific <span class="italic">Oracle Database Client Installation Guide</span> to install <a id="sthref825" name="sthref825"></a>Oracle Database Client on each client node, and select the Instant Client installation type.</p> <p>If you have many client nodes, consider staging the software centrally, mapping the drive, and running Oracle Universal Installer in the silent or response file mode.</p> <p>If the client nodes only require a default installation into a new Oracle home directory, consider using this guide for more information.</p> </li> </ol> <a id="CBAGJHAJ" name="CBAGJHAJ"></a> <p class="subhead2">What is the best way to install Oracle Database Client if my client nodes have limited disk space?</p> <ol> <li> <p>Install Oracle Database onto a server by using this guide for more details.</p> </li> <li> <p>Use platform-specific <span class="italic">Oracle Database Client Installation Guide</span> to install Oracle Database Client on each client node, and select the Instant Client installation type.</p> <p>If you have many client nodes, then consider running Oracle Universal Installer in silent or response file mode.</p> </li> </ol> <a id="CBAGCEDA" name="CBAGCEDA"></a> <p class="subhead2">How do I upgrade Oracle Database?<a id="sthref826" name="sthref826"></a><a id="sthref827" name="sthref827"></a></p> <p>See <span class="italic">Oracle Database Upgrade Guide</span>.</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 using software cloning to upgrade Oracle Database</div> <a id="CBAHGEFE" name="CBAHGEFE"></a> <p class="subhead2">The computers at my site have been configured to run as a cluster. How should I install Oracle Database?</p> <p>Use any of the following installation scenarios:</p> <ul> <li> <p>If you want to run a single-instance Oracle Database in a clustered environment, then install Oracle Clusterware either before or after you install Oracle Database.</p> </li> <li> <p>If you want a consolidated pool of storage for all databases in a cluster, then install Oracle Clusterware first and use Automatic Storage Management to manage this storage. Afterward, install Oracle Database (which can be either single instance or Real Application Clusters).</p> </li> <li> <p>If you plan to use Oracle Real Application Clusters, first install Oracle Clusterware, and then install Oracle Real Application Clusters.</p> </li> </ul> <p>See platform-specific <span class="italic">Oracle Clusterware Installation Guide</span>and<span class="italic">Oracle Real Application Clusters Installation Guide for Microsoft Windows</span> for the platform to install Oracle Clusterware or Oracle Real Application Clusters. Oracle Clusterware is available on the Oracle Clusterware installation media. See this guide which explains how to install Automatic Storage Management and Oracle Database.</p> <p><a id="sthref828" name="sthref828"></a><a id="sthref829" name="sthref829"></a><a id="sthref830" name="sthref830"></a>Oracle Clusterware is a key component required by Oracle Real Application Clusters installations. Oracle Clusterware is an integrated cluster management solution that can bind multiple servers to act as a single system. This is referred to as a cluster. It performs workload management and component restart. For example, when an instance supporting a particular service fails, Oracle Clusterware restarts the service on the next available instance that you have configured for that service. Oracle Clusterware can monitor non-Oracle programs, if they are defined within the Oracle Clusterware environment using the High Availability API.</p> <a id="CBAICICG" name="CBAICICG"></a> <p class="subhead2">How do I migrate my non-Oracle databases to Oracle Database?</p> <p><a id="sthref831" name="sthref831"></a><a id="sthref832" name="sthref832"></a>Use Oracle Migration Workbench to migrate your non-Oracle databases and applications to Oracle. Oracle Migration Workbench software and documentation are available at</p> <p><code><a href="http://www.oracle.com/technology/tech/migration/index.html">http://www.oracle.com/technology/tech/migration/index.html</a></code><a id="sthref833" name="sthref833"></a></p> </div> <!-- class="sect1" --> <a id="BEHGABCI" name="BEHGABCI"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">G.2</span> Installing Oracle Database Tools</h2> <p>The following are frequently asked questions about installing Oracle database tools:</p> <ul> <li> <p><a href="#CBACJDCE">How do I install Oracle Application Server?</a></p> </li> <li> <p><a href="#CBAHJCAE">How can I administer and monitor my Oracle Database products?</a></p> </li> <li> <p><a href="#CBAJADIE">How do I manage security for my Oracle Database products?</a></p> </li> <li> <p><a href="#CBACAJHI">How do I use Oracle Database to manage my XML data?</a></p> </li> <li> <p><a href="#CBAJEAGA">Does Oracle Database provide OLAP tools so that I can analyze data such as trends and time series in my database?</a></p> </li> <li> <p><a href="#CBADEGAB">Does Oracle Database provide data mining tools that I can use to discover hidden meaning in my data and predict likely outcomes based on my data?</a></p> </li> <li> <p><a href="#CBADEDAG">How do I perform backup and recovery operations for Oracle Database?</a></p> </li> <li> <p><a href="#CHDJABEG">Is Oracle Workflow included with Oracle Database 11<span class="italic">g</span>?</a></p> </li> <li> <p><a href="#CHDJHHJB">Is there a migration plan for customers that have built solutions using Oracle Workflow?</a></p> </li> </ul> <a id="CBACJDCE" name="CBACJDCE"></a> <p class="subhead2"><a id="sthref834" name="sthref834"></a>How do I install Oracle Application Server?</p> <p><a id="sthref835" name="sthref835"></a>See <span class="italic">Oracle Application Server Installation Guide</span>. How you install Application Server depends on whether you already have Oracle Database installed:</p> <ul> <li> <p>If you do not have Oracle Database installed or you do not want Oracle Application Server to use any of your existing Oracle Databases, then Oracle Universal Installer lets you install Oracle Application Server with its own Oracle Database. This database is populated with the metadata that Oracle Application Server must run.</p> </li> <li> <p>If you want Oracle Application Server to use an existing Oracle Database, then do the following:</p> <ol> <li> <p>From the Oracle Application Server installation media, run Oracle Application Server Repository Creation Assistant to populate your database with the metadata that Application Server needs.</p> </li> <li> <p>Install the remaining Oracle Application Server components by following the instructions in the <span class="italic">Oracle Application Server Installation Guide</span>.</p> </li> </ol> </li> </ul> <a id="CBAHJCAE" name="CBAHJCAE"></a> <p class="subhead2">How can I administer and monitor my Oracle Database products?</p> <p><a id="sthref836" name="sthref836"></a><a id="sthref837" name="sthref837"></a>To perform regular administrative functions such as creating, configuring, or deleting databases, or managing database templates, use one of the following methods:</p> <p>To manage only the single database and listener that you are installing:</p> <ol> <li> <p>Use this guide to install Oracle Database.</p> </li> <li> <p>From Oracle Database, use Database Configuration Assistant to manage your databases.</p> <p>You can also administer and monitor the database with Oracle Enterprise Manager Grid Control, which is installed by default with Oracle Database. Oracle Enterprise Manager Grid Control requires an agent which is not installed by default.</p> <p>Oracle Enterprise Manager Grid Control includes the Oracle Management Agent, Oracle Management Service, and Oracle Management Repository, as well as Grid Control, a browser-based central console through which administrators can perform all monitoring, administration, and configuration tasks for the enterprise.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <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> available on the Enterprise Manager Grid Control installation media</div> </li> </ol> <p>To perform advanced administration tasks, such as monitoring Oracle Database and managing multiple hosts, application servers, and databases including the one that you are installing, install Oracle Enterprise Manager as follows:</p> <ol> <li> <p>Use this guide to install Oracle Database.</p> <p>If you plan to use <a id="sthref838" name="sthref838"></a>Oracle Real Application Clusters, then install Oracle Database by using platform-specific <span class="italic">Oracle Clusterware Installation Guide</span> and <span class="italic"><a class="olink RIGEN" href="http://www.oracle.com/pls/db112/lookup?id=RIGEN">Oracle Real Application Clusters Installation Guide</a></span> .</p> </li> <li> <p>Use <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> to install and configure Oracle Enterprise Manager. For postconfiguration tasks, use <span class="italic"><a class="olink OEMCG" href="http://www.oracle.com/pls/db112/lookup?id=OEMCG">Oracle Enterprise Manager Advanced Configuration</a></span>.</p> </li> </ol> <a id="CBAJADIE" name="CBAJADIE"></a> <p class="subhead2">How do I manage security for my Oracle Database products?</p> <p><a id="sthref839" name="sthref839"></a><a id="sthref840" name="sthref840"></a><a id="sthref841" name="sthref841"></a>Oracle provides a wide range of security solutions for your enterprise environment, including centralized administration and security features integrated with Oracle Internet Directory. The set of Oracle security services called Oracle Platform Security integrates the security features built into Oracle Database, Oracle Application Server, and the Oracle Identity Management infrastructure. Combined, these features enable the development and deployment of secure e-business applications.</p> <p>Oracle Identity Management includes Oracle Internet Directory, a centralized repository that simplifies administration of users and applications in the Oracle environment with the following components:</p> <ul> <li> <p>Oracle Internet Directory client tools, including LDAP command-line tools, the Oracle Internet Directory SDK, and Oracle Directory Manager.</p> </li> <li> <p>Oracle Internet Directory server components, including the directory server, the directory replication server, the directory integration server, and various tools for starting and stopping them.</p> </li> </ul> <p>Oracle Database includes the <a id="sthref842" name="sthref842"></a>Oracle Internet Directory client tools, but not the Oracle Internet Directory server components. To install the Oracle Internet Directory server components, run Oracle Universal Installer from an Oracle 10<span class="italic">g</span> Application Server installation.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic">Oracle Application Server Installation Guide</span> (to install Oracle Identity Management)</p> </li> <li> <p><span class="italic"><a class="olink DBSEG" href="http://www.oracle.com/pls/db112/lookup?id=DBSEG">Oracle Database Security Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink ASOAG" href="http://www.oracle.com/pls/db112/lookup?id=ASOAG">Oracle Database Advanced Security Administrator's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink DBIMI" href="http://www.oracle.com/pls/db112/lookup?id=DBIMI">Oracle Database Enterprise User Security Administrator's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink OLSAG" href="http://www.oracle.com/pls/db112/lookup?id=OLSAG">Oracle Label Security Administrator's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink ASSEC" href="http://www.oracle.com/pls/db112/lookup?id=ASSEC">Oracle Application Server Security Guide</a></span></p> </li> <li> <p>Oracle Technology Network topics on database security: <code><a href="http://www.oracle.com/technology/deploy/security/index.html">http://www.oracle.com/technology/deploy/security/index.html</a></code></p> </li> </ul> </div> <a id="CBACAJHI" name="CBACAJHI"></a> <p class="subhead2">How do I use Oracle Database to manage my XML data?</p> <p>Use <a id="sthref843" name="sthref843"></a><a id="sthref844" name="sthref844"></a>Oracle XML DB, which is installed as part of Oracle Database. Oracle XML DB enables you to efficiently store, generate, retrieve, query, and manage XML data on your site. Oracle XML DB provides all the advantages of a relational database, for example, allowing you to control the referential integrity of XML data with constraints and triggers. It works well with large amounts of XML data by storing it in a parsed, relational form, which improves access performance.</p> <p>Oracle XML DB supports XML Type, which is a native data type for XML data, for which you can choose various storage options depending on your needs. In addition, Oracle XML DB supports XML Schema processing, structured and unstructured storage, a content repository that you can access by using common protocols (FTP, HTTP(S), and WebDAV), and SQL/XML, which is a standard for SQL with XML. For Oracle Database 11<span class="italic">g</span> Release 1 (11.1), Oracle XML DB introduced support for the XQuery language for querying, transforming, and constructing XML; the ability for users to define their own metadata for schema-based XML; a set of new SQL functions for DML operations on XML data; and more.</p> <p>You can use Oracle XML DB with Oracle XML Developer's Kit (XDK) to build applications that run on either Oracle Database or Oracle Application Server.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink ADXDB" href="http://www.oracle.com/pls/db112/lookup?id=ADXDB">Oracle XML DB Developer's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink ADXDK" href="http://www.oracle.com/pls/db112/lookup?id=ADXDK">Oracle XML Developer's Kit Programmer's Guide</a></span></p> </li> </ul> </div> <a id="CBAJEAGA" name="CBAJEAGA"></a> <p class="subhead2">Does Oracle Database provide <a id="sthref845" name="sthref845"></a><a id="sthref846" name="sthref846"></a>OLAP tools so that I can analyze data such as trends and time series in my <a id="sthref847" name="sthref847"></a><a id="sthref848" name="sthref848"></a>database?</p> <p><a id="sthref849" name="sthref849"></a>Yes, install Oracle OLAP, which is provided in the Oracle Database installation. Oracle OLAP provides optimal support for database environments that must meet OLAP requirements.</p> <p>Use either of the following methods in <span class="italic">Oracle Database Installation Guide</span> to install Oracle OLAP:</p> <ul> <li> <p>When you run Oracle Universal Installer, in the Select Database Edition screen, select <span class="bold">Enterprise Edition</span>. Click the <span class="bold">Select Options</span> button, and from the Choose Components screen, select <span class="bold">Oracle OLAP</span>.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <li> <p><span class="italic"><a class="olink OLAUG" href="http://www.oracle.com/pls/db112/lookup?id=OLAUG">Oracle OLAP User's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink OLADM" href="http://www.oracle.com/pls/db112/lookup?id=OLADM">Oracle OLAP DML Reference</a></span></p> </li> <li> <p><span class="italic"><a class="olink OLAPI" href="http://www.oracle.com/pls/db112/lookup?id=OLAPI">Oracle OLAP Java API Reference</a></span></p> </li> </ul> </div> </li> <li> <p>Select the <span class="bold">Enterprise Edition</span> installation type, and then on the Select Database Configuration screen, select the <span class="bold">Data Warehouse</span> configuration.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink DWHSG" href="http://www.oracle.com/pls/db112/lookup?id=DWHSG">Oracle Database Data Warehousing Guide</a></span> after installation</div> </li> </ul> <a id="CBADEGAB" name="CBADEGAB"></a> <p class="subhead2">Does Oracle Database provide data mining tools that I can use to discover hidden meaning in my data and predict likely outcomes based on my data?</p> <p>Yes, you must have an Oracle Enterprise Edition license to use Oracle Data Mining tools. <a id="sthref850" name="sthref850"></a><a id="sthref851" name="sthref851"></a><a id="sthref852" name="sthref852"></a>Oracle Data Mining is an option of the Enterprise Edition, as described in <a href="install.htm#CIHFJICE">Table 4-1, "Oracle Universal Installer Windows"</a>, in the Select Database Edition row.</p> <p>With the Oracle Data Mining option, you can create and execute predictive and descriptive data mining models that use a variety of algorithms.</p> <p>Use the following method in this guide to install Oracle Data Mining:</p> <ol> <li> <p>When you run Oracle Universal Installer, select the <span class="bold">Enterprise Edition</span> installation type.</p> </li> <li> <p>In the Select Database Configuration screen, select the <span class="bold">General Purpose/Transaction Processing</span> configuration.</p> </li> </ol> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> The following manuals for information about Oracle Data Mining: <ul> <li> <p><span class="italic"><a class="olink DMCON" href="http://www.oracle.com/pls/db112/lookup?id=DMCON">Oracle Data Mining Concepts</a></span></p> </li> <li> <p><span class="italic"><a class="olink DMADM" href="http://www.oracle.com/pls/db112/lookup?id=DMADM">Oracle Data Mining Administrator's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink DMPRG" href="http://www.oracle.com/pls/db112/lookup?id=DMPRG">Oracle Data Mining Application Developer's Guide</a></span></p> </li> <li> <p><span class="italic"><a class="olink DMJAV" href="http://www.oracle.com/pls/db112/lookup?id=DMJAV">Oracle Data Mining Java API Reference</a></span></p> </li> <li> <p><span class="italic"><a class="olink ARPLS" href="http://www.oracle.com/pls/db112/lookup?id=ARPLS">Oracle Database PL/SQL Packages and Types Reference</a></span> (search for Data Mining)</p> </li> <li> <p><span class="italic"><a class="olink SQLRF" href="http://www.oracle.com/pls/db112/lookup?id=SQLRF">Oracle Database SQL Language Reference</a></span> (search for Data Mining)</p> </li> </ul> </div> <a id="CBADEDAG" name="CBADEDAG"></a> <p class="subhead2">How do I perform backup and recovery operations for Oracle Database?</p> <p>Use <a id="sthref853" name="sthref853"></a><a id="sthref854" name="sthref854"></a>Oracle Database Recovery Manager (RMAN), <a id="sthref855" name="sthref855"></a><a id="sthref856" name="sthref856"></a>which is a backup and recovery tool integrated into Oracle Database. This tool satisfies the pressing demands of high-performance, manageable backup, and recovery. Recovery Manager is native to the database server, automatically tracks database structure changes, and optimizes operations accordingly. In addition, Recovery Manager is integrated with leading tape media management products, so that Oracle database backups can be integrated with your existing networked data protection infrastructure.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <ul> <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></p> </li> <li> <p><span class="italic"><a class="olink RCMRF" href="http://www.oracle.com/pls/db112/lookup?id=RCMRF">Oracle Database Backup and Recovery Reference</a></span></p> </li> </ul> </div> <a id="CHDJABEG" name="CHDJABEG"></a> <p class="subhead2">Is Oracle Workflow included with Oracle Database 11<span class="italic">g</span>?</p> <p>Starting with Oracle Database 11<span class="italic">g</span>, Oracle Workflow is no longer released with the database. Oracle Workflow is available with the Oracle E-Business Suite releases.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> Oracle Workflow statement of direction (<code><a href="http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html">http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html</a></code>)</div> <a id="CHDJHHJB" name="CHDJHHJB"></a> <p class="subhead2">Is there a migration plan for customers that have built solutions using Oracle Workflow?</p> <p>Starting January 2006, customers are encouraged to re-create and implement workflows using Oracle BPEL Process Manager. Oracle is in the process of creating a technical migration guide to provide detailed recommendations for migrating Oracle Workflow processes to Oracle BPEL Process Manager.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> Oracle Workflow statement of direction <code><a href="http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html">http://www.oracle.com/technology/products/ias/workflow/workflow_sod.html</a></code></div> </div> <!-- class="sect1" --> <a id="BEHIGEIH" name="BEHIGEIH"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">G.3</span> Installing Oracle Database with Oracle Applications</h2> <p>The following are frequently asked questions about installing Oracle database with Oracle applications:</p> <ul> <li> <p><a href="#CBAJAAEG">How do I install my Oracle applications with Oracle Database?</a></p> </li> <li> <p><a href="#CBABGGEE">How can I create Web applications that communicate with Oracle Database?</a></p> </li> <li> <p><a href="#CHDHEGHB">Which Web server can my Oracle applications use?</a></p> </li> <li> <p><a href="#CBAEABEA">How can I migrate my non-Oracle applications to Oracle?</a></p> </li> </ul> <a id="CBAJAAEG" name="CBAJAAEG"></a> <p class="subhead2"><a id="sthref857" name="sthref857"></a>How do I install my Oracle applications with Oracle Database?</p> <p><a id="sthref858" name="sthref858"></a><a id="sthref859" name="sthref859"></a>In most cases, install Oracle Database itself, then install the Oracle application. The Oracle Universal Installer for that application prompts you for the connection information. Check the application documentation requirements.</p> <p>If you must implement your applications with Oracle Real Applications Clusters databases, see <span class="italic"><a class="olink RIGEN" href="http://www.oracle.com/pls/db112/lookup?id=RIGEN">Oracle Real Application Clusters Installation Guide</a></span>, and platform-specific <span class="italic"><a class="olink CWGEN" href="http://www.oracle.com/pls/db112/lookup?id=CWGEN">Oracle Grid Infrastructure Installation Guide</a></span> .</p> <a id="CBABGGEE" name="CBABGGEE"></a> <p class="subhead2">How can I create Web applications that communicate with Oracle Database?</p> <p>Install Oracle Application Express and a Web server. Use this guide to install Oracle Database. Oracle Application Express is automatically installed, when you install Oracle database.</p> <div class="infoboxnotealso"> <p class="notep1">See Also:</p> <span class="italic"><a class="olink HTMIG" href="../../install.112/e13366/toc.htm">Oracle Application Express Installation Guide</a></span></div> <a id="CHDHEGHB" name="CHDHEGHB"></a> <p class="subhead2">Which Web server can my Oracle applications use?</p> <p><a id="sthref860" name="sthref860"></a><a id="sthref861" name="sthref861"></a>Install Oracle HTTP Server:</p> <p>Use this guide to install Oracle Database.</p> <a id="CBAEABEA" name="CBAEABEA"></a> <p class="subhead2">How can I migrate my non-Oracle applications to Oracle?</p> <p><a id="sthref862" name="sthref862"></a><a id="sthref863" name="sthref863"></a><a id="sthref864" name="sthref864"></a>Use Oracle Migration Workbench to migrate your non-Oracle applications to Oracle. Oracle Migration Workbench software and documentation are available at</p> <p><code><a href="http://www.oracle.com/technology/tech/migration/index.html">http://www.oracle.com/technology/tech/migration/index.html</a></code></p> </div> <!-- class="sect1" --> <a id="BEHGBDFI" name="BEHGBDFI"></a> <div class="sect1"><!-- infolevel="all" infotype="General" --> <h2 class="sect1"><span class="secnum">G.4</span> Installing Oracle Database Heterogeneous Connectivity Tools (Gateways)</h2> <p>The following section discusses the Gateway products:</p> <p><a href="#CBAHEIEH">How can my Oracle applications access data in a non-Oracle database system?</a></p> <a id="CBAHEIEH" name="CBAHEIEH"></a> <p class="subhead2"><a id="sthref865" name="sthref865"></a><a id="sthref866" name="sthref866"></a>How can my Oracle applications access data in a non-Oracle database system?</p> <p>You can use Oracle Database Gateway as the connectivity tool to enable Oracle applications to access data in non-Oracle databases. The following are the functions of Oracle Database Gateway:</p> <ul> <li> <p>Integrates a non-Oracle database into your Oracle Database environment.</p> </li> <li> <p>Enables Oracle PL/SQL applications to integrate with APPC-enabled transactions, or access messages in IBM Websphere MQ.</p> </li> </ul> <p>You can install the Gateway product on a computer independent of the Oracle application, Oracle database, and non-Oracle database.</p> <p>For example, suppose you have the following scenario:</p> <ul> <li> <p>Oracle Database is installed on a Linux computer.</p> </li> <li> <p>The Oracle application is installed on a Microsoft Windows computer and accesses data from the Oracle database on the Linux computer.</p> </li> <li> <p>The Oracle application needs to join data in a DB2 database on Solaris Operating System and an Oracle Database on Linux.</p> </li> </ul> <p>You have the option of installing the Database Gateway for DRDA on the Solaris computer where DB2 is running, on Linux where Oracle is running, or on a third computer.</p> <p><a href="#CHDHCBJA">Table G-1</a> lists the non-Oracle database systems that you can access from Oracle applications, and the Gateways products that are available for those systems. <a id="sthref867" name="sthref867"></a></p> <div class="tblhruleformalwide"><a id="sthref868" name="sthref868"></a><a id="CHDHCBJA" name="CHDHCBJA"></a> <p class="titleintable">Table G-1 Oracle Gateway Products</p> <table class="HRuleFormalWide" title="Oracle Gateway Products" summary="Gateway products" dir="ltr" border="1" width="100%" frame="hsides" rules="rows" cellpadding="3" cellspacing="0"> <col width="25%" /> <col width="*" /> <thead> <tr align="left" valign="top"> <th align="left" valign="bottom" id="r1c1-t15">Non-Oracle Database</th> <th align="left" valign="bottom" id="r1c2-t15">Oracle Gateway Products and Documentation</th> </tr> </thead> <tbody> <tr align="left" valign="top"> <td align="left" id="r2c1-t15" headers="r1c1-t15"> <p>IBM DB2 Universal Database<a id="sthref869" name="sthref869"></a><a id="sthref870" name="sthref870"></a> (UDB)<a id="sthref871" name="sthref871"></a><a id="sthref872" name="sthref872"></a></p> </td> <td align="left" headers="r2c1-t15 r1c2-t15"> <p>Oracle Database Gateway for DRDA.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink DRDAG" href="http://www.oracle.com/pls/db112/lookup?id=DRDAG">Oracle Database Gateway for DRDA User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r3c1-t15" headers="r1c1-t15"> <p>IBM DB2 z/OS<a id="sthref873" name="sthref873"></a><a id="sthref874" name="sthref874"></a></p> </td> <td align="left" headers="r3c1-t15 r1c2-t15"> <p>Oracle Database Gateway for DRDA.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink DRDAG" href="http://www.oracle.com/pls/db112/lookup?id=DRDAG">Oracle Database Gateway for DRDA User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r4c1-t15" headers="r1c1-t15"> <p>IBM DB2/400<a id="sthref875" name="sthref875"></a><a id="sthref876" name="sthref876"></a></p> </td> <td align="left" headers="r4c1-t15 r1c2-t15"> <p>Oracle Database Gateway for DRDA.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink DRDAG" href="http://www.oracle.com/pls/db112/lookup?id=DRDAG">Oracle Database Gateway for DRDA User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r5c1-t15" headers="r1c1-t15"> <p>WebSphere MQ<a id="sthref877" name="sthref877"></a><a id="sthref878" name="sthref878"></a></p> </td> <td align="left" headers="r5c1-t15 r1c2-t15"> <p>Oracle Database Gateway for WebSphere MQ.</p> <p><span class="italic"><a class="olink WSMQG" href="http://www.oracle.com/pls/db112/lookup?id=WSMQG">Oracle Database Gateway for WebSphere MQ Installation and User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r6c1-t15" headers="r1c1-t15"> <p>CICS/TS</p> <p>IMSTM</p> </td> <td align="left" headers="r6c1-t15 r1c2-t15"> <p>Oracle Database Gateway for<a id="sthref879" name="sthref879"></a><a id="sthref880" name="sthref880"></a> APPC.</p> <p>Use <span class="italic"><a class="olink APPCW" href="http://www.oracle.com/pls/db112/lookup?id=APPCW">Oracle Database Gateway for APPC Installation and Configuration Guide for Microsoft Windows</a></span></p> <p>Use <a href="OLINK:appug"><span class="italic">Oracle Database Gateway for APPC User's Guide</span></a></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r7c1-t15" headers="r1c1-t15"> <p>SQL Server <a id="sthref881" name="sthref881"></a></p> </td> <td align="left" headers="r7c1-t15 r1c2-t15"> <p>Oracle Database Gateway for SQL Server.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink GMSWN" href="http://www.oracle.com/pls/db112/lookup?id=GMSWN">Oracle Database Gateway for SQL Server User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r8c1-t15" headers="r1c1-t15"> <p>Sybase Adaptive Server<a id="sthref882" name="sthref882"></a></p> </td> <td align="left" headers="r8c1-t15 r1c2-t15"> <p>Oracle Database Gateway for Sybase.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink TGSYU" href="http://www.oracle.com/pls/db112/lookup?id=TGSYU">Oracle Database Gateway for Sybase User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r9c1-t15" headers="r1c1-t15"> <p>Teradata<a id="sthref883" name="sthref883"></a></p> </td> <td align="left" headers="r9c1-t15 r1c2-t15"> <p>Oracle Database Gateway for Teradata.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink TGTEU" href="http://www.oracle.com/pls/db112/lookup?id=TGTEU">Oracle Database Gateway for Teradata User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r10c1-t15" headers="r1c1-t15"> <p>Informix Server<a id="sthref884" name="sthref884"></a></p> </td> <td align="left" headers="r10c1-t15 r1c2-t15"> <p>Oracle Database Gateway for Informix.</p> <p>Use <span class="italic"><a class="olink OTGIW" href="http://www.oracle.com/pls/db112/lookup?id=OTGIW">Oracle Database Gateway Installation and Configuration Guide for Microsoft Windows</a></span> and <span class="italic"><a class="olink TGINU" href="http://www.oracle.com/pls/db112/lookup?id=TGINU">Oracle Database Gateway for Informix User's Guide</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r11c1-t15" headers="r1c1-t15"> <p>IMS</p> </td> <td align="left" headers="r11c1-t15 r1c2-t15"> <p>Oracle Database Gateway for IMS.</p> <p>Use <span class="italic"><a class="olink IVACW" href="http://www.oracle.com/pls/db112/lookup?id=IVACW">Oracle Database Gateway for IMS, VSAM, and Adabas Installation and Configuration Guide for Microsoft Windows</a></span>, <span class="italic"><a class="olink IMSUG" href="http://www.oracle.com/pls/db112/lookup?id=IMSUG">Oracle Database Gateway for IMS User's Guide</a></span>, and <span class="italic"><a class="olink OCZOS" href="http://www.oracle.com/pls/db112/lookup?id=OCZOS">Oracle Connect for IMS, VSAM, and Adabas Gateways Installation and Configuration Guide for IBM z/OS</a></span></p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r12c1-t15" headers="r1c1-t15"> <p>VSAM</p> </td> <td align="left" headers="r12c1-t15 r1c2-t15"> <p>Oracle Database Gateway for VSAM.</p> <p>Use <span class="italic"><a class="olink IVACW" href="http://www.oracle.com/pls/db112/lookup?id=IVACW">Oracle Database Gateway for IMS, VSAM, and Adabas Installation and Configuration Guide for Microsoft Windows</a></span>, <span class="italic"><a class="olink VSMUG" href="http://www.oracle.com/pls/db112/lookup?id=VSMUG">Oracle Database Gateway for VSAM User's Guide</a></span>, and <span class="italic"><a class="olink OCZOS" href="http://www.oracle.com/pls/db112/lookup?id=OCZOS">Oracle Connect for IMS, VSAM, and Adabas Gateways Installation and Configuration Guide for IBM z/OS</a></span>.</p> </td> </tr> <tr align="left" valign="top"> <td align="left" id="r13c1-t15" headers="r1c1-t15"> <p>Adabas</p> </td> <td align="left" headers="r13c1-t15 r1c2-t15"> <p>Oracle Database Gateway for Adabas.</p> <p>Use <span class="italic"><a class="olink IVACW" href="http://www.oracle.com/pls/db112/lookup?id=IVACW">Oracle Database Gateway for IMS, VSAM, and Adabas Installation and Configuration Guide for Microsoft Windows</a></span>, <span class="italic"><a class="olink ADAUG" href="http://www.oracle.com/pls/db112/lookup?id=ADAUG">Oracle Database Gateway for Adabas User's Guide</a></span>, and <span class="italic"><a class="olink OCZOS" href="http://www.oracle.com/pls/db112/lookup?id=OCZOS">Oracle Connect for IMS, VSAM, and Adabas Gateways Installation and Configuration Guide for IBM z/OS</a></span>.</p> </td> </tr> </tbody> </table> <br /></div> <!-- class="tblhruleformalwide" --></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="ts.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="glossary.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