📄 ch1_admin.htm
字号:
</tr>
<tr align="left" valign="top">
<td id="r15c1" headers="r13c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r13c1 r15c1 r1c2" align="left" colspan="1" rowspan="1"><code>/u01/app/oracle</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r16c1" headers="r1c1" align="left" colspan="1" rowspan="3">ORACLE_HOME<a id="sthref45" name="sthref45"></a><a id="sthref46" name="sthref46"></a><a id="sthref47" name="sthref47"></a><a id="sthref48" name="sthref48"></a>
</td>
<td headers="r16c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r16c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the directory containing the Oracle software.<a id="sthref49" name="sthref49"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r17c1" headers="r16c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r16c1 r17c1 r1c2" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r18c1" headers="r16c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r16c1 r18c1 r1c2" align="left" colspan="1" rowspan="1"><code>$ORACLE_BASE/product/</code><em><code>9.2.0.1.0</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r19c1" headers="r1c1" align="left" colspan="1" rowspan="3">ORACLE_PATH<a id="sthref50" name="sthref50"></a>
</td>
<td headers="r19c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r19c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the search path for files used by Oracle applications, such as SQL*Plus (<code>*.sql</code> ), Oracle Forms (<code>*.frm</code>), and Oracle Reports (<code>*.rpt</code>). If the full path to the file is not specified, or if the file is not in the current directory, the Oracle application uses ORACLE_PATH to locate the file.<a id="sthref51" name="sthref51"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r20c1" headers="r19c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r19c1 r20c1 r1c2" align="left" colspan="1" rowspan="1">Colon-separated list of directories:<br /><em><code>directory1:directory2:directory3</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r21c1" headers="r19c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r19c1 r21c1 r1c2" align="left" colspan="1" rowspan="1"><code>/u01/app/oracle/product/9.2.0.1.0/bin:.</code>
<p><code></code><strong>Note:</strong> The period adds the current working directory to the search path.
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r22c1" headers="r1c1" align="left" colspan="1" rowspan="3"><a id="sthref52" name="sthref52"></a><a id="sthref53" name="sthref53"></a>ORACLE_SID
</td>
<td headers="r22c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r22c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the Oracle system identifier.<a id="sthref54" name="sthref54"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r23c1" headers="r22c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r22c1 r23c1 r1c2" align="left" colspan="1" rowspan="1">A string of numbers and letters that must begin with a letter. Oracle Corporation recommends a maximum of eight characters for system identifiers. For more information on this environment variable, see the <em>Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems</em>. <a id="sthref55" name="sthref55"></a><a id="sthref56" name="sthref56"></a><a id="sthref57" name="sthref57"></a><a id="sthref58" name="sthref58"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r24c1" headers="r22c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r22c1 r24c1 r1c2" align="left" colspan="1" rowspan="1">SAL1
</td>
</tr>
<tr align="left" valign="top">
<td id="r25c1" headers="r1c1" align="left" colspan="1" rowspan="2"><a id="sthref59" name="sthref59"></a>ORACLE_TRACE
</td>
<td headers="r25c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r25c1 r1c3" align="left" colspan="1" rowspan="1">Enables the tracing of shell scripts during an installation. If this environment variable is set to T, many Oracle shell scripts use the <code>set -x</code> command, which prints commands and their arguments as they are run.<a id="sthref60" name="sthref60"></a><a id="sthref61" name="sthref61"></a><a id="sthref62" name="sthref62"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r26c1" headers="r25c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r25c1 r26c1 r1c2" align="left" colspan="1" rowspan="1">T or not T.
</td>
</tr>
<tr align="left" valign="top">
<td id="r27c1" headers="r1c1" align="left" colspan="1" rowspan="3"><a id="sthref63" name="sthref63"></a>ORAENV_ASK
</td>
<td headers="r27c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r27c1 r1c3" align="left" colspan="1" rowspan="1">Controls whether the <code>coraenv</code> or <code>oraenv</code> script prompts for the value of the ORACLE_SID or ORACLE_HOME environment variable. If the value is NO, the scripts do not prompt; otherwise they do.<a id="sthref64" name="sthref64"></a><a id="sthref65" name="sthref65"></a><a id="sthref66" name="sthref66"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r28c1" headers="r27c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r27c1 r28c1 r1c2" align="left" colspan="1" rowspan="1">A string. Specifies the directory containing the Oracle Net Services configuration file.
</td>
</tr>
<tr align="left" valign="top">
<td id="r29c1" headers="r27c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r27c1 r29c1 r1c2" align="left" colspan="1" rowspan="1">NO or not NO.
</td>
</tr>
<tr align="left" valign="top">
<td id="r30c1" headers="r1c1" align="left" colspan="1" rowspan="1"><a id="sthref67" name="sthref67"></a>SQLPATH
</td>
<td headers="r30c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r30c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the directory or list of directories that SQL*Plus searches for a <code>login.sql</code> file.<a id="sthref68" name="sthref68"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r31c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r31c1 r1c2" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r31c1 r1c3" align="left" colspan="1" rowspan="1">Colon-separated list of directories:<br /><em><code>directory1:directory2:directory3</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r32c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r32c1 r1c2" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r32c1 r1c3" align="left" colspan="1" rowspan="1"><code>/home:/home/oracle:/u01/oracle</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r33c1" headers="r1c1" align="left" colspan="1" rowspan="1"><a id="sthref69" name="sthref69"></a>TNS_ADMIN
</td>
<td headers="r33c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r33c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the directory containing the Oracle Net Services configuration file.
</td>
</tr>
<tr align="left" valign="top">
<td id="r34c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r34c1 r1c2" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r34c1 r1c3" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r35c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r35c1 r1c2" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r35c1 r1c3" align="left" colspan="1" rowspan="1">$ORACLE_HOME/network/admin
</td>
</tr>
<tr align="left" valign="top">
<td id="r36c1" headers="r1c1" align="left" colspan="1" rowspan="4"><a id="sthref70" name="sthref70"></a>TWO_TASK
</td>
<td headers="r36c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r36c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the default connect identifier to use in the connect string. The connect identifier does not need to be specified in the connect string. For example, if the TWO_TASK environment variable is set to <code>sales</code>, you can connect to a database using the <code>CONNECT</code> <em><code>username/password </code></em>command rather than the <code>CONNECT</code> <em><code>username/password</code></em><code>@sales</code> command. <a id="sthref71" name="sthref71"></a><a id="sthref72" name="sthref72"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r37c1" headers="r36c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r36c1 r37c1 r1c2" align="left" colspan="1" rowspan="1">Any connect identifier.
</td>
</tr>
<tr align="left" valign="top">
<td id="r38c1" headers="r36c1 r1c1" align="left" colspan="1" rowspan="1">Range of Values
</td>
<td headers="r36c1 r38c1 r1c2" align="left" colspan="1" rowspan="1">Any valid connect identifier that can be resolved with a naming method, such as a <code>tnsnames.ora</code> file or a directory server.
</td>
</tr>
<tr align="left" valign="top">
<td id="r39c1" headers="r36c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r36c1 r39c1 r1c2" align="left" colspan="1" rowspan="1">PRODDB_TCP
</td>
</tr></tbody>
</table>
<div align="center">
<br /><table summary="This is a layout table to format a note" title="This is a layout table to format a note" 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>Note:</strong>
</font>
</p>To prevent conflicts, do not define environment variables with names that are identical to the names of Oracle Server processes, for example: ARCH, PMON, and DBWR.
</td>
</tr></tbody>
</table><br />
</div>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref73" name="sthref73"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
UNIX Environment Variables
</font>
</h3>
<p><a href="#g95690">Table 1-2</a> provides the syntax for, and examples of, UNIX environment variables used with Oracle9<em>i</em>.
</p><a id="sthref74" name="sthref74"></a><a id="g95690" name="g95690"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table 1-2 UNIX Environment Variables Used with Oracle9<em>i</em>
</font></em></strong></p>
<table title="UNIX Environment Variables Used with Oracle9<em>i</em> " summary="Table listing UNIX environment variables used with Oracle9i." 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>Variable
</strong></font></th>
<th id="r1c2" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Detail
</strong></font></th>
<th id="r1c3" align="left" colspan="1" rowspan="1" valign="bottom">
<font face="Arial, Helvetica, sans-serif">
<strong>Definition
</strong></font></th>
</tr>
</thead><tbody>
<tr align="left" valign="top">
<td id="r2c1" headers="r1c1" align="left" colspan="1" rowspan="1">ADA_PATH <br />(Solaris 32-bit and AIX only)
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r2c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the directory containing the Ada compiler.<a id="sthref75" name="sthref75"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r3c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r3c1 r1c2" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r3c1 r1c3" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r4c1 r1c3" align="left" colspan="1" rowspan="1"><em><code>/usr/lpp/</code></em><code>powerada</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r1c1" align="left" colspan="1" rowspan="1"><a id="sthref76" name="sthref76"></a>CLASSPATH
</td>
<td headers="r5c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r5c1 r1c3" align="left" colspan="1" rowspan="1">Used with Java applications. The setting for this variable differs with each Java application. See the product documentation for your Java application for more information.<a id="sthref77" name="sthref77"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r1c1" align="left" colspan="1" rowspan="1">
<br />
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -