📄 ch1_admin.htm
字号:
<!DOCTYPE html
PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//en"
"http://www.w3c.org/TR/1999/PR-xhtml1-19991210/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" sml:lang="en" lang="en">
<head>
<!-- Run date = May 1, 2002 19:19:0 -->
<meta name="XHTML Generator" content="Oracle SGML to XHTML converter - Version 3.1.2">
<title> Administering Oracle9i </title>
<link rel="next" href="ch2_tun.htm" title="Next">
</head>
<body bgcolor="#ffffff">
<a id="top" name="top"></a>
<a href="#BEGIN">Skip Headers</a><br><br>
<table cellspacing="0" cellpadding="0" width="100%">
<tr>
<td align="left" valign="top"><font face="helvetica, arial, sans-serif">
<b>Oracle9<em>i</em> Administrator's Reference </b>
<br />
<b>Release 2 (9.2.0.1.0) for UNIX Systems: AIX-Based Systems, Compaq Tru64 UNIX, HP 9000 Series HP-UX, Linux Intel, and Sun Solaris</b>
<br />
Part No. A97297-01
</font>
</td>
<td valign="bottom" align="right" width="144">
<table cellspacing="0" cellpadding="0" width="100%">
</tr>
<td align="center" valign="top" width="25%"><a href="toc.htm"><img src="../Support/gifs/conticon.gif" alt="Go To Table Of Contents" border="0" height="30" width="30"><br /><font size="-2">Contents</font></a></td>
<td align="center" valign="top" width="25%"><a href="index.htm"><img src="../Support/gifs/indxicon.gif" alt="Go To Index" border="0" height="30" width="30"><br /><font size="-2">Index</font></a></td>
</tr>
</table>
</td>
</tr>
</table>
<hr />
<p>
<a href="preface.htm">
<img src="../Support/gifs/larrow.gif" alt="Previous" border="0" height="30" width="30"></a>
<a href="ch2_tun.htm">
<img src="../Support/gifs/rarrow.gif" alt="Next" border="0" height="30" width="30"></a>
</p>
<a name="BEGIN"></a>
<div class="IND">
<!-- End Header --><a id="i46634" name="i46634"></a>
<h1>
<font face="arial, helvetica, sans-serif" color="#330099">
1
<br />
Administering Oracle9<em>i</em>
</font>
</h1>
<p>This chapter provides information on administering Oracle9<em>i</em> on AIX, HP, Linux, Solaris, and Tru64. It contains the following sections:
</p>
<ul>
<li type="disc">
<p><a href="#i46647">Overview</a>
</p>
</li>
<li type="disc">
<p><a href="#i46652">Environment Variables</a>
</p>
</li>
<li type="disc">
<p><a href="#CHDBGDDE">LD_PRELOAD Environment Variable for Loading Shared Libraries (HP Only)</a>
</p>
</li>
<li type="disc">
<p><a href="#i80314">Relinking Executables</a>
</p>
</li>
<li type="disc">
<p><a href="#i85390">System Global Area</a>
</p>
</li>
<li type="disc">
<p><a href="#CHDHDEID">Oracle9<em>i</em> Memory Requirements</a>
</p>
</li>
<li type="disc">
<p><a href="#i92495">Database Limits</a>
</p>
</li>
<li type="disc">
<p><a href="#i92421">Operating System Accounts and Groups</a>
</p>
</li>
<li type="disc">
<p><a href="#i94540">Customizing the Initialization File</a>
</p>
</li>
<li type="disc">
<p><a href="#g104282">Oracle HTTP Server</a>
</p>
</li>
<li type="disc">
<p><a href="#i86673">Demonstration Files</a>
</p>
</li>
</ul><a id="i46647" name="i46647"></a>
<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="sthref24" name="sthref24"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Overview
</font>
</h2>
<p>You must set Oracle9<em>i</em> environment variables, parameters, and user settings for Oracle9<em>i</em> to work. This chapter describes the various settings for Oracle9<em>i</em> on AIX, HP, Linux, Solaris, and Tru64.
</p>
<p>In Oracle9<em>i</em> files and programs, a question mark (?) represents the value of the ORACLE_HOME environment variable. For example, Oracle9<em>i</em> expands the question mark in the following SQL statement to the full pathname of the Oracle home directory:
</p>
<pre><code>SQL> ALTER TABLESPACE TEMP ADD DATAFILE '?/dbs/temp02.dbf' SIZE 2M</code>
</pre>
<p>Similarly, the @ sign represents the ORACLE_SID environment variable. For example, to indicate a file belonging to the current instance, enter:<a id="sthref25" name="sthref25"></a><a id="sthref26" name="sthref26"></a>
</p>
<pre>SQL> ALTER TABLESPACE <em>tablespace_name</em> ADD DATAFILE tempfile@.dbf
</pre>
</div class="sect1"><a id="i46652" name="i46652"></a>
<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="sthref27" name="sthref27"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Environment Variables
</font>
</h2>
<p>This section describes the most commonly-used Oracle9<em>i</em> and UNIX environment variables. You must define some environment variables before installing Oracle9<em>i</em>. These environment variables are listed in the Oracle9i Installation Guide Release 2 (9.2.0.1.0) for UNIX Systems.
</p>
<p>To display the current value of an environment variable, use the <code>env</code> command. For example, to display the value of the ORACLE_SID environment variable, enter:
</p>
<pre>$ env | grep ORACLE_SID
</pre>
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref28" name="sthref28"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Oracle9<em>i</em> Environment Variables<a id="sthref29" name="sthref29"></a>
</font>
</h3>
<p><a href="#g95138">Table 1-1</a> provides the syntax for, and examples of, environment variables used by Oracle9<em>i</em>.
</p><a id="sthref30" name="sthref30"></a><a id="g95138" name="g95138"></a>
<p><strong><em><font face="arial, helvetica, sans-serif">Table 1-1 Oracle9<em>i</em> Environment Variables on UNIX
</font></em></strong></p>
<table title="Oracle9<em>i</em> Environment Variables on UNIX " summary="Table listing the Oracle9i environment variables." 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"><a id="sthref31" name="sthref31"></a>EPC_DISABLED
</td>
<td headers="r2c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r2c1 r1c3" align="left" colspan="1" rowspan="1">Disables Oracle Trace.<a id="sthref32" name="sthref32"></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">TRUE |FALSE
</td>
</tr>
<tr align="left" valign="top">
<td id="r4c1" headers="r1c1" align="left" colspan="1" rowspan="3"><a id="sthref33" name="sthref33"></a>NLS_LANG
</td>
<td headers="r4c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r4c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the language, territory, and character set of the client environment. The character set specified by NLS_LANG must match the character set of the terminal or terminal emulator. The character set specified by NLS_LANG can be different from the database character set, in which case Oracle automatically converts the character set.
<p>See the <em>Oracle9i Globalization Support Guide</em> for a list of values for this variable. <a id="sthref34" name="sthref34"></a><a id="sthref35" name="sthref35"></a><a id="sthref36" name="sthref36"></a>
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r5c1" headers="r4c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r4c1 r5c1 r1c2" align="left" colspan="1" rowspan="1"><em><code>language_territory.characterse</code></em>t
</td>
</tr>
<tr align="left" valign="top">
<td id="r6c1" headers="r4c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r4c1 r6c1 r1c2" align="left" colspan="1" rowspan="1"><code>french_france.we8dec</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r7c1" headers="r1c1" align="left" colspan="1" rowspan="3"><a id="sthref37" name="sthref37"></a>ORA_NLS33
</td>
<td headers="r7c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r7c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the directory where language, territory, character set, and linguistic definition files are stored.<a id="sthref38" name="sthref38"></a><a id="sthref39" name="sthref39"></a><a id="sthref40" name="sthref40"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r8c1" headers="r7c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r7c1 r8c1 r1c2" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r9c1" headers="r7c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r7c1 r9c1 r1c2" align="left" colspan="1" rowspan="1"><code>$ORACLE_HOME/ocommon/nls/admin/data</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r10c1" headers="r1c1" align="left" colspan="1" rowspan="3"><a id="sthref41" name="sthref41"></a>ORA_TZFILE
</td>
<td headers="r10c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r10c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the full pathname to the time zone file. You must set this environment variable if you want to use a time zone from the large time zone file (<code>$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat</code>) for data in the database. The large time zone file contains information on more time zones than the default time zone file (<code>$ORACLE_HOME/oracore/zoneinfo/timezone.dat</code>).
<p>All databases that share information must use the same time zone file. You must stop and restart the database when you change the value of this environment variable.<a id="sthref42" name="sthref42"></a>
</p>
</td>
</tr>
<tr align="left" valign="top">
<td id="r11c1" headers="r10c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r10c1 r11c1 r1c2" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
</tr>
<tr align="left" valign="top">
<td id="r12c1" headers="r10c1 r1c1" align="left" colspan="1" rowspan="1">Example
</td>
<td headers="r10c1 r12c1 r1c2" align="left" colspan="1" rowspan="1"><code>$ORACLE_HOME/oracore/zoneinfo/timezlrg.dat</code>
</td>
</tr>
<tr align="left" valign="top">
<td id="r13c1" headers="r1c1" align="left" colspan="1" rowspan="3">ORACLE_BASE<a id="sthref43" name="sthref43"></a>
</td>
<td headers="r13c1 r1c2" align="left" colspan="1" rowspan="1">Function
</td>
<td headers="r13c1 r1c3" align="left" colspan="1" rowspan="1">Specifies the base of the Oracle directory structure for Optimal Flexible Architecture (OFA) compliant databases. <a id="sthref44" name="sthref44"></a>
</td>
</tr>
<tr align="left" valign="top">
<td id="r14c1" headers="r13c1 r1c1" align="left" colspan="1" rowspan="1">Syntax
</td>
<td headers="r13c1 r14c1 r1c2" align="left" colspan="1" rowspan="1"><em><code>directory_path</code></em>
</td>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -