appg_ofa.htm

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

<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;applmgr</code>
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">Oracle applications software subtrees
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;oracle&#047;product</code>
</td>
<td headers="r6c1 r1c2" align="left" colspan="1" rowspan="1">Oracle software subtrees
</td>
</tr>
<tr align="left" valign="top">
<td id="r7c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;oracle&#047;product&#047;9.2.0.1.0</code>
</td>
<td headers="r7c1 r1c2" align="left" colspan="1" rowspan="1">Oracle Server release 9.2.0.1.0 distribution files
</td>
</tr>
<tr align="left" valign="top">
<td id="r8c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;oracle&#047;admin&#047;sab</code>
</td>
<td headers="r8c1 r1c2" align="left" colspan="1" rowspan="1">sab database administrative subtrees
</td>
</tr>
<tr align="left" valign="top">
<td id="r9c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;app&#047;oracle&#047;admin&#047;sab&#047;arch&#047;&#042;</code>
</td>
<td headers="r9c1 r1c2" align="left" colspan="1" rowspan="1">sab database archived log files
</td>
</tr>
<tr align="left" valign="top">
<td id="r10c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;oradata</code>
</td>
<td headers="r10c1 r1c2" align="left" colspan="1" rowspan="1">Oracle data directories
</td>
</tr>
<tr align="left" valign="top">
<td id="r11c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;oradata&#047;sab&#047;&#042;</code>
</td>
<td headers="r11c1 r1c2" align="left" colspan="1" rowspan="1">sab database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r12c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;&#042;&#047;oradata&#047;sab&#047;&#042;.log</code>
</td>
<td headers="r12c1 r1c2" align="left" colspan="1" rowspan="1">sab database redo log files
</td>
</tr></tbody>
</table>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref812" name="sthref812"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
<a id="sthref813" name="sthref813"></a>OFA File Mapping
</font>
</h3>
<p><a href="#g641260">Table G-7</a> shows a hierarchical file mapping of a sample OFA-compliant database, including each file mount point, application, database, and tablespace. The filenames indicate the file type (control, log, or data).
</p><a id="sthref814" name="sthref814"></a><a id="g641260" name="g641260"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table G-7 Hierarchical File Mapping for OFA Installation 
</font></em></strong></p>
<table title="Hierarchical File Mapping for OFA Installation " summary="This table shows a hierarchical file mapping of a sample OFA-compliant database, including each file mount point, application, database, and tablespace." 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>Directory
</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"><code>&#047;</code>
<br />
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">Root mount point
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;</code>
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">User data mount point 1
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;</code>
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for application software
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;</code>
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">Home for <code>oracle</code><em> </em>software user
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;admin&#047;</code>
</td>
<td headers="r6c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for database administration files
</td>
</tr>
<tr align="left" valign="top">
<td id="r7c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;admin&#047;</code><code>TAR</code>
</td>
<td headers="r7c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for support log files
</td>
</tr>
<tr align="left" valign="top">
<td id="r8c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;admin&#047;</code><em><code>db&#095;name1</code></em><code>&#047;</code>
</td>
<td headers="r8c1 r1c2" align="left" colspan="1" rowspan="1"><code>admin</code> subtree for <em>db&#095;name1</em> database
</td>
</tr>
<tr align="left" valign="top">
<td id="r9c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;admin&#047;</code><em><code>db&#095;name2</code></em><code>&#047;</code>
</td>
<td headers="r9c1 r1c2" align="left" colspan="1" rowspan="1"><code>admin</code> subtree for <em>db&#095;name2</em> database
</td>
</tr>
<tr align="left" valign="top">
<td id="r10c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;doc&#047;</code>
</td>
<td headers="r10c1 r1c2" align="left" colspan="1" rowspan="1">Online documentation
</td>
</tr>
<tr align="left" valign="top">
<td id="r11c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;product&#047;</code>
</td>
<td headers="r11c1 r1c2" align="left" colspan="1" rowspan="1">Distribution files
</td>
</tr>
<tr align="left" valign="top">
<td id="r12c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;product&#047;</code><code>8.1.6&#047;</code>
</td>
<td headers="r12c1 r1c2" align="left" colspan="1" rowspan="1">Oracle home directory for release 8.1.6 instances
</td>
</tr>
<tr align="left" valign="top">
<td id="r13c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;product&#047;8.1.7&#047;</code>
</td>
<td headers="r13c1 r1c2" align="left" colspan="1" rowspan="1">Oracle home directory for release 8.1.7 instances
</td>
</tr>
<tr align="left" valign="top">
<td id="r14c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;oracle&#047;product&#047;9.2.0.1.0</code>
</td>
<td headers="r14c1 r1c2" align="left" colspan="1" rowspan="1">Oracle home directory for release 9.2.0.1.0 instances
</td>
</tr>
<tr align="left" valign="top">
<td id="r15c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;ltb&#047;</code>
</td>
<td headers="r15c1 r1c2" align="left" colspan="1" rowspan="1">Home directory for a user
</td>
</tr>
<tr align="left" valign="top">
<td id="r16c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;app&#047;sbm&#047;</code>
</td>
<td headers="r16c1 r1c2" align="left" colspan="1" rowspan="1">Home directory for a user
</td>
</tr>
<tr align="left" valign="top">
<td id="r17c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;oradata&#047;</code>
</td>
<td headers="r17c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for Oracle data
</td>
</tr>
<tr align="left" valign="top">
<td id="r18c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;oradata&#047;</code><em><code>db&#095;name1</code></em><code>&#047;</code>
</td>
<td headers="r18c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name1</em> database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r19c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;oradata&#047;</code><em><code>db&#095;name2</code></em><code>&#047;</code>
</td>
<td headers="r19c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name2</em> database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r20c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;</code>
</td>
<td headers="r20c1 r1c2" align="left" colspan="1" rowspan="1">User data mount point 2
</td>
</tr>
<tr align="left" valign="top">
<td id="r21c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;home&#047;</code>
</td>
<td headers="r21c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for login home directories
</td>
</tr>
<tr align="left" valign="top">
<td id="r22c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;home&#047;cvm&#047;</code>
</td>
<td headers="r22c1 r1c2" align="left" colspan="1" rowspan="1">Home directory for a user
</td>
</tr>
<tr align="left" valign="top">
<td id="r23c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;home&#047;vrm&#047;</code>
</td>
<td headers="r23c1 r1c2" align="left" colspan="1" rowspan="1">Home directory for a user
</td>
</tr>
<tr align="left" valign="top">
<td id="r24c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;oradata&#047;</code>
</td>
<td headers="r24c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for Oracle data
</td>
</tr>
<tr align="left" valign="top">
<td id="r25c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;oradata&#047;</code><em><code>db&#095;name1</code></em><code>&#047;</code>
</td>
<td headers="r25c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name1</em> database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r26c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u02&#047;oradata</code><em>&#047;</em><em><code>db&#095;name2</code></em><code>&#047;</code>
</td>
<td headers="r26c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name2</em> database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r27c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u03&#047;</code>
</td>
<td headers="r27c1 r1c2" align="left" colspan="1" rowspan="1">User data mount point 3
</td>
</tr>
<tr align="left" valign="top">
<td id="r28c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u03&#047;oradata&#047;</code>
</td>
<td headers="r28c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for Oracle data
</td>
</tr>
<tr align="left" valign="top">
<td id="r29c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u03&#047;oradata&#047;</code><em><code>db&#095;name1</code></em><code>&#047;</code>
</td>
<td headers="r29c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name1</em> database files
</td>
</tr>
<tr align="left" valign="top">
<td id="r30c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u03&#047;oradata&#047;</code><em><code>db&#095;name2</code></em><code>&#047;</code>
</td>
<td headers="r30c1 r1c2" align="left" colspan="1" rowspan="1">Subtree for <em>db&#095;name2</em> database files
</td>
</tr></tbody>
</table>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref815" name="sthref815"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
File Mapping for a Multiple-Instance OFA Database
</font>
</h3>
<p>When using the Oracle9<em>i</em> Real Application Clusters, select one node to act as the Oracle administrative home for the cluster. The administrative home contains the administrative subtree. Create subdirectories for each instance accessing the database within the <code>bdump</code>, <code>cdump</code>, <code>logbook</code>, <code>pfile</code>, and <code>udump</code> directories of the <code>~&#047;admin&#047;</code><em><code>d</code></em><code>&#047;</code> directory. Mount the <code>admin</code> directory for the administrative home as the <code>admin</code> directory for every instance. <a href="#g641470">Table G-10</a> shows a sample directory structure.
</p><a id="sthref816" name="sthref816"></a><a id="sthref816" name="sthref816"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table G-8 Administrative Directory Structure for Dual-Instance Oracle9<em>i</em> Real Application Clusters 
</font></em></strong></p>
<table title="Administrative Directory Structure for Dual-Instance Oracle9<em>i</em> Real Application Clusters " summary="This table shows a sample directory structure." 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>Directory Path
</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"><code>&#047;u01&#047;app&#047;oracle&#047;admin&#047;sab&#047;</code>
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">Administrative directory for sab database
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1"><code>&#047;u01&#047;adhoc</code>&#047;
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">Directory for miscellaneous scripts