plan.htm

Debian中文参考手册,系统介绍了Debian系统

<table title="Oracle9<em>i</em> Database Configurations " summary="This table lists the Oracle9i database configurations." dir="ltr" border="1" width="100%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0">
<thead>
<tr align="left" valign="top">
<th id="r1c1" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Environment
</strong></font></th>
<th id="r1c2" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Description
</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1">General Purpose<a id="sthref38" name="sthref38"></a><a id="sthref39" name="sthref39"></a>
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">Users perform a variety of database tasks, ranging from simple transactions to complex queries. Select this database environment for general purpose usage.
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1">Online Transaction Processing 
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">Users perform large numbers of concurrent transactions, where each transaction is a relatively simple operation processing a small amount of data. Transactions consist of reading, writing and deleting data in database tables. <a id="i1106548" name="i1106548"></a>
<p>Billing databases, such as those commonly found on internet commerce sites, are the most common example of this database configuration. These are also known as Online Transaction Processing (OLTP) databases.
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1">Data Warehouse<a id="sthref40" name="sthref40"></a><a id="sthref41" name="sthref41"></a><a id="sthref42" name="sthref42"></a> 
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">Users perform Online Analytical Processing (OLAP) where very complex queries access and process large volumes of data.
<p>OLAP queries are typically read-only and range from a simple query of a few records to complex queries that sort thousands of records from many different tables. Historical databases are the most common example of this database configuration. Data warehousing databases are also known as Decision Support Systems (DSS).
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1">Customized
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">Allows you to create a customized database configuration of Oracle products that meets specialized requirements.
<p>Select this option only if you are prepared to provide detailed product and database environment choices. Choosing this option requires a longer installation session than choosing a preconfigured database.
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1">Software Only
</td>
<td headers="r6c1 r1c2" align="left" colspan="1" rowspan="1">Allows you to install Oracle products. It does not configure the listeners or network infrastructure and does not create a database.
<p>Oracle Corporation recommends that you install at least one preconfigured database to serve as a template for database configuration.
</p>
</td>
</tr></tbody>
</table>
<div align="center">
<br /><table summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>See Also:</strong>
</font>
</p><em>Oracle9<em>i</em> Concepts</em>, <em>Oracle9<em>i</em> Database Performance Tuning Guide and Reference</em> and <em>Oracle9<em>i</em> Real Application Clusters Setup and Configuration</em> for more information on database environment issues. 
<p><a href="#i1101509">"Database Configuration Assistant"</a> for more information on how to choose a database.
</p>
<p>Many of the Oracle documents included in the Oracle9<em>i</em> Generic Documentation CD-ROM provide information about database environments, the effect database environment settings have on performance, and how your database can be tuned to maximize performance.
</p>
</td>
</tr></tbody>
</table><br />
</div>
</div class="sect1"><a id="i1106491" name="i1106491"></a>
<div class="sect1"><a id="sthref43" name="sthref43"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Oracle Configuration Assistants
</font>
</h2>
<p>Oracle Configuration Assistants are Graphical User Interface (GUI) tools included with the Oracle9<em>i</em> software to assist you with configuring and fine-tuning your environment and system for optimal performance. Many of them start automatically when the installation is completed, depending on the selections you make when you run the Installer. You can also manually start the configuration assistants as standalone tools.
</p>
<ul>
<li type="disc">
<p><a href="#i1103647">Database Upgrade Assistant</a> starts automatically when you select the Upgrade an Existing Database option. You can also choose not to select the option and run Database Upgrade Assistant independently after completing installation.
</p>
</li>
<li type="disc">
<p><a href="#i1101509">Database Configuration Assistant</a> starts automatically when you create an Oracle9<em>i</em> database during installation. 
</p>
</li>
<li type="disc">
<p><a href="#i1103712">Oracle HTTP Server Configuration Assistant</a> starts automatically when you install Oracle HTTP Server.
</p>
<div align="center">
<br /><table summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr align="left" valign="top">
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>Oracle HTTP Server includes software developed by the Apache Software Foundation (<code>http:&#047;&#047;www.apache.org&#047;</code>).
</td>
</tr></tbody>
</table><br />
</div>
</li>
<li type="disc">
<p><a href="#i1104256">Oracle Enterprise Manager Configuration Assistant</a> starts automatically when you select the Oracle Management Server type from the Oracle Management and Integration product installation types window, or when you explicitly select the Oracle Management Server type from an Oracle Management and Integration Custom install or a Custom Database install. The Enterprise Manager Configuration Assistant will not launch automatically with any other installation process. You must manually launch it after exiting from the Installer. 
</p>
</li>
<li type="disc">
<p><a href="#i1104012">Oracle Internet Directory Configuration Assistant</a> starts automatically when you select Oracle Internet Directory from Oracle Management and Integration product installation types window, or when you explicitly select Oracle Internet Directory during an Oracle Management and Integration Custom installation.
</p>
</li>
<li type="disc">
<p><a id="sthref44" name="sthref44"></a><a href="#i1101502">Oracle Net Configuration Assistant</a> starts automatically for all Database installation types. The Oracle Net Configuration Assistant creates and modifies network configuration files located in the <code>&#036;ORACLE&#095;HOME&#047;network&#047;admin</code> directory. Depending on the installation type selected, Oracle Net Configuration Assistant configures the network for standard database connection methods or a customized network. 
</p>
</li>
<li type="disc">
<p><a href="#i1104333">Oracle Workflow Configuration Assistant</a> starts automatically only when you select Workflow from Oracle Management and Integration custom installation type. It installs and configures the Oracle Workflow Schema in the Oracle9<em>i</em> database.
</p>
</li>
<li type="disc">
<p>Agent Configuration Assistant starts the intelligent agent service automatically. This is invoked when the Agent is installed.
</p>
</li>
</ul><a id="i1103712" name="i1103712"></a>
<div class="sect2"><a id="sthref45" name="sthref45"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Oracle HTTP Server Configuration Assistant
</font>
</h3>
<p>The Oracle HTTP Server Configuration Assistant starts the HTTP listener in non-SSL (Secure Sockets Layer) on port 7777. If port 7777 is not available, the Oracle HTTP Server Configuration Assistant defaults to port 7778.
</p>
<div align="center">
<br /><table summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>See Also:</strong>
</font>
</p><code></a><a href="http:&#047;&#047;www.apache.org">http:&#047;&#047;www.apache.org</a></code> for more information on configuring Oracle HTTP Server to use the HTTPS (HTTP over SSL) protocol.
</td>
</tr></tbody>
</table><br />
</div>
</div class="sect2"><a id="i1101509" name="i1101509"></a>
<div class="sect2"><a id="sthref46" name="sthref46"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Database Configuration Assistant
</font>
</h3>
<p><a id="sthref47" name="sthref47"></a><a id="sthref48" name="sthref48"></a><a id="sthref49" name="sthref49"></a>Database Configuration Assistant enables you to copy an Oracle9<em>i</em> preconfigured database, or create a fully customized database to match your selected environment and database configuration. It starts automatically after Oracle9<em>i</em> software has been installed during Oracle9<em>i</em> installation. 
</p>
<p>When installing Oracle9<em>i</em> software using any database configuration option other than the Custom and Software Only, the Oracle Universal Installer prompts for a global database name and System Identifier (SID). After Oracle9<em>i</em> installation is completed, the Database Configuration Assistant uses this information to create the <a id="sthref50" name="sthref50"></a><a id="sthref51" name="sthref51"></a>database. In addition, <a id="sthref52" name="sthref52"></a>the Database Configuration Assistant automatically configures the static service information for the Oracle9<em>i</em> database in the <a id="i1101518" name="i1101518"></a><code>listener.ora</code> file.
</p>
<p>The following list provides descriptions of database configurations:
</p>
<ul>
<li type="square">
<p><a id="sthref53" name="sthref53"></a><a id="sthref54" name="sthref54"></a>General Purpose configuration: If you select this option with an Enterprise Edition or Standard Edition installation, the Database Configuration Assistant creates a preconfigured, ready-to-use, multipurpose database with the following:
</p>
<ul>
<li type="disc">
<p>Default initialization parameters using server parameter file and Automatic Undo Management
</p>
</li>
<li type="disc">
<p><a id="sthref55" name="sthref55"></a>Automatic installation and configuration of Oracle Options and <em>inter</em>Media
</p>
</li>
<li type="disc">
<p>Advanced Replication capabilities
</p>
</li>
<li type="disc">
<p>Database configuration of dedicated server mode
</p>
</li>
<li type="disc">
<p>Archiving mode of NOARCHIVELOG
</p>
</li>
</ul>
</li>
<li type="square">
<p>Transaction Processing option: If you select this, the Database Configuration Assistant creates a preconfigured, ready-to-use OLTP database.
</p>
</li>
<li type="square">
<p>Data Warehouse option: If you select this, the Database Configuration Assistant creates a database that is fully enabled for data warehousing applications. The OLAP option, consisting of support for analytic workspaces and the OLAP catalog metadata repository (<code>CWMLite</code>), is included in the database.
</p>
</li>
<li type="square">
<p>Customized installation option: If you select this, the Database Configuration Assistant guides you in creating a fully customized database. You can choose to configure options, Oracle Text components and advanced replication either automatically or manually. 
</p>
<p>Select this option only if you are experienced with advanced database creation procedures. You will need to customize some or all of the following settings or parameters:
</p>
<ul>
<li type="disc">
<p>Data, control, and redo log file settings
</p>
</li>
<li type="disc">
<p>Tablespace and extent sizes
</p>
</li>
<li type="disc">
<p>Database memory parameters
</p>
</li>
<li type="disc">
<p>Archiving modes, formats and destinations
</p>
</li>
<li type="disc">
<p>Trace file destinations
</p>
</li>
<li type="disc">
<p>Character set values
</p>
</li>
</ul>
</li>
<li type="square">
<p>Software Only option: If you select this, the Oracle Universal Installer installs only Oracle9<em>i</em> software. Database Configuration Assistant does not start after installation, and no preconfigured database is installed.
</p>
<br /><table summary="This is a layout table to format a tip" title="This is a layout table to format a tip" dir="ltr" border="1" width="80%" frame="hsides" rules="groups" cellpadding="3" cellspacing="0"><tbody>
<tr>
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>See Also:</strong>
</font>
</p><a href="post-inst.htm#i1027045">"Using Database Configuration Assistant"</a> for more information on running Database Configuration Assistant in a standalone mode.
<p><em>Oracle9<em>i</em> Globalization and National Language Guide for more information on database character sets</em>. 
</p>
</td>
</tr></tbody>
</table><br />
</li>
</ul>
</div class="sect2"><a id="i1103647" name="i1103647"></a>
<div class="sect2"><a id="sthref56" name="sthref56"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Database Upgrade Assistant
</font>
</h3>