toc.htm

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

<p>Upgrading from 8.1.7 (32-bit) on AIX5L to 9.2.0.1.0 is supported during installation using the Oracle Universal Installer.
</p>
<p>Upgrading from 8.0.6 (32-bit and 64-bit), 8.1.7 (32-bit and 64-bit) and 9.0.1 (64-bit) on AIX 4.3.3 directly to 9.2.0.1.0 on AIX5L is not supported. You must first upgrade to 9.2.0.1.0 on AIX 4.3.3. Use the 4.3.3 documentation to complete this upgrade. When you have completed this task, then use the following procedure to upgrade to 9.2.0.1.0 on AIX5L:
</p>
<ol type="1" start="1">
<li>
<p>Perform complete backups of the existing 9.2.0.<em>x</em>.<em>x</em> database on AIX 4.3.3 to protect against any failures in the upgrade.
</p>
</li>
<li>
<p>To assist with creating the control file after the upgrade, enter the following SQL command:
</p>
<pre>SQL&gt; ALTER DATABASE BACKUP CONTROLFILE TO TRACE;

</pre>
<p>Entering the preceding command saves control file information to a trace file under the UDUMP directory, which should appear similar to the following syntax example. Database names, paths, and parameter values will vary, depending on your system values:
</p>
<pre>CREATE CONTROLFILE REUSE DATABASE "<em>SAMPLE</em>" NORESETLOGS
NOARCHIVELOG
  MAXLOGFILES <em>32</em>
  MAXLOGMEMBERS <em>2</em>
  MAXDATAFILES <em>32</em>
  MAXINSTANCES <em>1</em>
  MAXLOGHISTORY  <em>112</em>
LOGFILE
  GROUP1 &#039;&#047;<em>aix433&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;log1.f SIZE<em> 25</em>M,
  GROUP2 &#039;&#047;<em>aix433&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;log2.f&#039; SIZE<em> 25</em>M
DATAFILE
  &#039;&#047;<em>aix433&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;DB1.F&#039;
CHARACTER SET <em>WE8DEC</em>;

</pre>
</li>
<li>
<p>Perform a clean Oracle database shutdown.
</p>
</li>
<li>
<p>Upgrade the AIX 4.3.3 operating system to AIX 5L, using the instructions in <em>AIX 5L Version 5.1 Installation Guide</em>.
</p>
<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 align="left" valign="top">
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>Do not attempt to use Oracle9<em>i</em> for AIX 4.3.3 after booting the system with AIX 5.1. Database files created with Oracle9<em>i</em> release 2 (9.2.0.1.0) on AIX 4.3.3 are compatible with Oracle9<em>i</em> release 2 (9.2.0.1.0) databases on AIX 5L.
<p>If you need to transfer data from raw devices on 4.3.3 to 5L, then refer to the section following this one, "Moving Database Files on Raw Devices from AIX 4.3.3 to AIX 5L Systems with the Offset Utility."
</p>
</td>
</tr></tbody>
</table><br />
</div>
</li>
<li>
<p>Install in a new ORACLE&#095;HOME the Oracle9<em>i</em> release 2 (9.2.0.1.0) software for AIX 5L.
</p>
</li>
<li>
<p>Copy your existing <code>init.ora</code> file to the new ORACLE&#095;HOME. Change any AIX 4.3.3 ORACLE&#095;HOME path references to use the new AIX 5L ORACLE&#095;HOME path.
</p>
</li>
<li>
<p>Start up the database, using SQL commands similar to the following syntax example. Database names, paths, and parameter values will vary, depending on your system values:
</p>
<pre>STARTUP NOMOUNT;
CREATE CONTROLFILE REUSE DATABASE "<em>SAMPLE</em>" NORESETLOGS
  MAXLOGFILES <em>32</em>
  MAXLOGMEMBERS <em>2</em>
  MAXDATAFILES <em>32</em>
  MAXINSTANCES <em>1</em>
  MAXLOGHISTORY <em>112</em>
LOGFILE
  GROUP 1 &#039;&#047;<em>aix51&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;log1.f&#039; size <em>25M</em>
  GROUP 2 &#039;&#047;<em>aix51&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;log2.f&#039; size <em>25M</em>
DATAFILE
  &#039;<em>aix5l&#095;path</em>&#047;oracle&#047;dbs&#047;t&#095;dbl.f
CHARACTER SET <em>WE8DEC</em>;
ALTAR DATABASE OPEN

</pre>
<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 align="left" valign="top">
<td align="left" colspan="1" rowspan="1">
<p>
<font face="arial, helvetica, sans-serif">
<strong>Note:</strong>
</font>
</p>At this point, the NComp objects in the migrated database are invalid. Refer to the section "Steps to Update NComp Java Objects in the Database" for the procedure to revalidate these objects.
</td>
</tr></tbody>
</table><br />
</div>
</li>
<li>
<p>Perform a clean shutdown of the database.
</p>
</li>
<li>
<p>Perform complete backups of the Oracle9<em>i</em> release 2 (9.2.0.1.0) for AIX 5L database.
</p>
</li>
</ol>
</div class="sect3">
<div class="sect3"><a id="sthref7" name="sthref7"></a>
<h4>
<font face="arial, helvetica, sans-serif" color="#330099">
Moving Database Files on Raw Devices from AIX 4.3.3 to AIX 5L Systems with the Offset Utility
</font>
</h4>
<p>To move database files from an AIX 4.3.3 raw device, you must find the control block size of the device, and you must locate "offset" bytes, which indicate where Oracle data is located on the device. Oracle Corporation ships the offset utility with Oracle9<em>i</em> release 2 (9.2.0.1.0) to assist in this task.
</p>
<p>Using offset, complete the following steps:
</p>
<ol type="1" start="1">
<li>
<p>Run <code>&#036;ORACLE&#095;HOME&#047;bin&#047;offset</code> on the AIX 4.3.3 database file (the "source" file).
</p>
</li>
<li>
<p>Copy the database data on the source file to a temporary location, such as an NFS filesystem, which is accessible to the AIX 5L systems or cluster nodes, using the following command syntax:.
</p>
<pre>dd if&#061;<em>source&#095;file</em> of&#061;<em>temp&#095;path</em> bs&#061;<em>value</em> skip&#061;<em>offset&#095;value&#095;source</em>

</pre>
<p>where:
</p>
<ul>
<li type="disc">
<p><em><code>source&#095;file</code></em> represents the full path of the database source file
</p>
</li>
<li type="disc">
<p><em><code>temp&#095;path</code></em> represents the full path to the temporary location where the source file is placed
</p>
</li>
<li type="disc">
<p><em><code>value</code></em> is the block size value
</p>
</li>
<li type="disc">
<p><em><code>offset&#095;value&#095;source</code></em> represents the value returned by the offset program for the database source file, divided by the bs value. 
</p>
</li>
</ul>
</li>
<li>
<p>Run <code>&#036;ORACLE&#095;HOME&#047;bin&#047;offset</code> on the destination database file, using the following command syntax:
</p>
<pre>offset <em>dest&#095;file</em>

</pre>
<p>where <em><code>dest&#095;file</code></em> represents the full path of the destination file on the AIX 5L node (the "target" file)
</p>
</li>
<li>
<p>Copy the database data from the source file on the temporary location to the target file, using the following command syntax:
</p>
<pre>dd if&#061;<em>temp&#095;path</em> of&#061;<em>dest&#095;file</em> bs&#061;<em>value</em> seek&#061;<em>offset&#095;value&#095;target</em>

</pre>
<p>where:
</p>
<ul>
<li type="disc">
<p><em><code>temp&#095;path</code></em> represents the full path to the temporary location where the source file is placed
</p>
</li>
<li type="disc">
<p><em><code>dest&#095;file</code></em> represents the full path to the target file
</p>
</li>
<li type="disc">
<p><em><code>value</code></em> is the block size value
</p>
</li>
<li type="disc">
<p><em><code>offset&#095;value&#095;target</code></em> represents the value returned by the offset program for the database target file.
</p>
</li>
</ul>
</li>
</ol>
</div class="sect3">
<div class="sect3"><a id="sthref8" name="sthref8"></a>
<h4>
<font face="arial, helvetica, sans-serif" color="#330099">
Steps to Update NComp Java Objects in the Database
</font>
</h4>
<p>To be able to use natively compiled Java objects for AIX5L, use the following procedure to update NComp Java objects in the database:
</p>
<ol type="1" start="1">
<li>
<p>Connect to the database as the user SYSTEM
</p>
</li>
<li>
<p>Run the following command
</p>
<pre>SQL&gt; create or replace java system;
</pre>
</li>
</ol>
</div class="sect3">
<div class="sect3">
<!--
infolevel=all
infotype=general
--><a id="sthref9" name="sthref9"></a>
<h4>
<font face="arial, helvetica, sans-serif" color="#330099">
Migrating Agent Repository Files from AIX 4.3.3 to AIX 5L
</font>
</h4>
<p>Migrating agent files from AIX 4.3.3 (32-bit) to AIX 5L (64-bit) is not supported using the nmumigr8 utility. Oracle Corporation has assigned Oracle Bug identification number 2237433 to track this problem.
</p>
</div class="sect3">
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="i772564" name="i772564"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Installing with Response Files
</font>
</h3>
<p>For installation with a response file, the path to the response file must be the full path on the system. The Oracle Universal Installer does not handle relative paths properly.
</p>
</div class="sect2"><a id="CACFAIII" name="CACFAIII"></a>
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="CHDBGIBI" name="CHDBGIBI"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Unzip Utility for Downloading and Installing Oracle Patches 
</font>
</h3>
<p>An unzip utility is provided with Oracle9<em>i</em> release 2 (9.2.0.1.0) for uncompressing Oracle patches downloaded from Oracle<em>MetaLink</em>. The utility is located in the following directory:
</p>
<pre>&#036;ORACLE&#095;HOME&#047;bin&#047;
</pre>
</div class="sect2">
<div class="sect2">
<!--
infolevel=all
infotype=general
--><a id="sthref10" name="sthref10"></a>
<h3>
<font face="arial, helvetica, sans-serif" color="#330099">
Platform-Specific Product Information
</font>
</h3>
<p>The following product information in this section supersedes the information in the installation guide or the administrator&#039;s reference for Oracle9<em>i</em> release 2 (9.2.0.1.0) on AIX 5L.
</p>
<ul>
<li type="disc">
<p>Oracle Advanced Security:
</p>
<ul>
<li type="disc">
<p>Radius challenge response authentication is not supported.
</p>
</li>
<li type="disc">
<p>CyberSafe is not supported.
</p>
</li>
<li type="disc">
<p>Entrust is not supported.
</p>
</li>
<li type="disc">
<p>DCE integration is not supported.
</p>
</li>
</ul>
</li>
<li type="disc">
<p>JDBC&#047;OCI Interfaces:
</p>
<ul>
<li type="disc">
<p>Oracle JDBC Thin Driver for JDK 1.4 is not supported.
</p>
</li>
<li type="disc">
<p>Oracle JDBC&#047;OCI Driver for JDK 1.4 is not supported.
</p>
</li>
</ul>
</li>
<li type="disc">
<p>File Systems
</p>
<ul>
<li type="disc">
<p>Veritas File System (VxFS) is not supported.
</p>
</li>
</ul>
<ul>
<li type="disc">
<p>Legato NetWorker Single Server is not supported.
</p>
</li>
</ul>
</li>
</ul>
</div class="sect2">
</div class="sect1">
<div class="sect1">
<!--
infolevel=all
infotype=general
--><a id="i774665" name="i774665"></a>
<h2>
<font face="arial, helvetica, sans-serif" color="#330099">Product-Related Issues
</font>
</h2><a id="i772575" name="i772575"></a>
<p>This section provides information on the following topics:
</p>
<ul>
<li type="disc">
<p><a href="#CHDHGJJE">Character Sets</a>
</p>
</li>
<li type="disc">
<p><a href="#CHDCGCHD">Demo Schema</a>
</p>
</li>
<li type="disc">
<p><a href="#BABHECGC">Oracle Advanced Security</a>
</p>
</li>
<li type="disc">
<p><a href="#CACBIIJI">Oracle Internet Directory (OID)</a>
</p>
</li>
<li type="disc">
<p><a href="#CACEDFFI">Oracle Real Application Clusters</a>
</p>
</li>
</ul><a id="CHDHGJJE" name="CHDHGJJE"></a>