📄 migng.htm
字号:
<!DOCTYPE html public "-//w3c//dtd html 3.2 transitional//en.us"><HTML lang="en.us"><HEAD><META NAME="Generator" CONTENT="Quadralay WebWorks Publisher 5.0.4"><META NAME="Page" CONTENT="DefaultSingle"><META NAME="Title" CONTENT=" Oracle9i Database Migration"><TITLE> Oracle9i Database Migration</TITLE> <LINK REL="home" HREF="../../products.htm" TITLE="Library"><LINK REL="toc" HREF="toc.htm" TITLE="Contents"><LINK REL="index" HREF="index.htm" TITLE="Index"><LINK REL="copyright" HREF="../dcommon/html/cpyr.htm" TITLE="Copyright"><LINK REL="up" HREF="toc.htm" TITLE="Up"><LINK REL="next" HREF="refrn.htm" TITLE="Next"><LINK REL="previous" HREF="nlspg.htm" TITLE="Previous"></HEAD> <BODY BGCOLOR="#ffffff"><A NAME="top"></A><TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%"><TR> <TD ALIGN="LEFT" VALIGN="TOP"><FONT COLOR="#330099" FACE="Helvetica, Arial, sans-serif"><B>Oracle9<i>i</i> Database Generic Documentation Addendum<BR>Release 2 (9.2)</B><BR>Part Number A97283-01</FONT></B></TD><td valign="BOTTOM" align="RIGHT" width="144"><table cellspacing="0" cellpadding="0" width="50%"><TR><TD ALIGN="CENTER" VALIGN="TOP" WIDTH="25%"><A HREF="toc.htm"><IMG SRC="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="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="nlspg.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A><A HREF="refrn.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A> <DIV CLASS="IND"><!-- End Header --><A NAME="1004903"></A><!--TOC=Title-"1004903"--><H1 CLASS="Title"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099">7<BR> Oracle9<EM CLASS="Italic">i</EM> Database Migration</FONT></H1><!--/TOC=Title--><A NAME="1002341"></A><P CLASS="BP">This chapter lists additions and corrections to <EM CLASS="Italic">Oracle9i Database Migration</EM>, Release 2 (9.2).</P><A NAME="1010007"></A><P CLASS="BP">This chapter contains the following topics:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="153398"></A><A HREF="migng.htm#153408">Upgrading a Database to the New Oracle9i Release</a><P><LI CLASS="LB1" TYPE="DISC"><A NAME="153404"></A><A HREF="migng.htm#153552">Downgrading a Database Back to the Previous Oracle Release</a><P></UL><A NAME="153408"></A><!--TOC=h1-"153408"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Upgrading a Database to the New Oracle9<EM CLASS="Italic">i</EM> Release</FONT></H2><!--/TOC=h1--><A NAME="153414"></A><P CLASS="BP">The following sections outline changes and corrections to the upgrade procedures discussed in Chapter 3 of <EM CLASS="Italic">Oracle9i Database Migration</EM>.</P><A NAME="153416"></A><!--TOC=h2-"153416"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Installing the New Oracle Software</FONT></H3><!--/TOC=h2--><A NAME="153422"></A><P CLASS="BP">On pages 3-2 and 3-3 of <EM CLASS="Italic">Oracle9i Database Migration</EM>, disregard Step 8, and replace Step 6 with the following:</P><A NAME="153424"></A><P CLASS="BP">6. At the Installation Types screen, select Enterprise, Standard, or Custom Installation. Then, click Next.</P> <A NAME="1010020"><DIV ALIGN="CENTER"><P><TABLE CLASS="Note" BORDER="0" WIDTH="80%" CELLPADDING="0" CELLSPACING="0" dir="ltr"><TR CLASS="Note"><TD CLASS="Note"><HR><A NAME="1010018"></A><FONT FACE="Arial, Helvetica, sans-serif"><STRONG CLASS="NH"><STRONG CLASS="Bold">Note</STRONG>:</STRONG></FONT><A NAME="1010019"></A><P CLASS="NB">Normally, you should not install a starter database if you are upgrading an existing database. <HR></TD></TR></TABLE><TABLE CLASS="TableNote" CELLPADDING="3" dir="ltr"><TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote"></TD></TR></TABLE></DIV></A> <A NAME="1010021"></A><P CLASS="BP">If you chose Enterprise or Standard, then the Database Configuration screen appears. Complete the following steps:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="153431"></A>Select Software Only.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="355958"></A>Click Next.<P></UL><A NAME="355960"></A><P CLASS="BP">If you chose Custom Installation, then the Available Product Components screen appears. Complete the following steps:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="355962"></A>Choose the product components you want to install. Then, click Next.<P><A NAME="355968"></A><P CLASS="BP1">Make sure you install Oracle Utilities to install the Database Upgrade Assistant, and if you are upgrading from Oracle7, the MIG utility.</P><A NAME="256020"></A><P CLASS="BP1">Make sure you install all of the options you installed with the previous database, assuming you do not want to discontinue use of a particular option. For example, if you installed Oracle Text in the previous database, then you should install Oracle Text in the new Oracle9<EM CLASS="Italic">i</EM> database.</P><LI CLASS="LB1" TYPE="DISC"><A NAME="256026"></A>If you are installing Oracle9<EM CLASS="Italic">i</EM> Real Application Clusters, then, at the Cluster Node Selection screen, select the nodes onto which you want the software installed. Then, click Next.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="153439"></A>Respond to the remaining screens that enable you to specify your custom installation settings, until you reach the Upgrading an Existing Database screen.<P><LI CLASS="LB1" TYPE="DISC"><A NAME="153441"></A>If the Create Database screen appears, then select the No option, indicating that you do not want to create a database because you are upgrading an existing database. Then, click Next.<P></UL><A NAME="153443"></A><!--TOC=h2-"153443"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Rollback Segments</FONT></H3><!--/TOC=h2--><A NAME="153445"></A><P CLASS="BP">A large <CODE>PUBLIC</CODE> rollback segment is necessary to upgrade databases with a large number of database objects (packages, tables, types, and so on). A rollback segment of at least 70 MB is recommended when the total number of database objects exceeds 5000.</P><A NAME="153447"></A><P CLASS="BP">To determine the total number of database objects, issue the following SQL statement:</P> <PRE CLASS="CE"><A NAME="153449"></A>SQL> SELECT COUNT(*) FROM dba_objects;<A NAME="153451"></A></PRE> <A NAME="153457"></A><P CLASS="BP">In addition, the example of adding space to a rollback segment in Step 6 on page 3-13 of <EM CLASS="Italic">Oracle9i Database Migration</EM> is incorrect. The example illustrates adding space to the <CODE>SYSTEM</CODE> rollback segment. You should not add space to the <CODE>SYSTEM</CODE> rollback segment, but should in fact add space to a different rollback segment.</P><A NAME="153459"></A><!--TOC=h2-"153459"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Setting the COMPATIBLE Initialization Parameter Before Upgrading</FONT></H3><!--/TOC=h2--><A NAME="153465"></A><P CLASS="BP">Replace Part b of Step 4 on pages 3-18 and 3-19 of <EM CLASS="Italic">Oracle9i Database Migration</EM> with the following:</P><A NAME="153467"></A><P CLASS="BP">Make sure the <CODE>COMPATIBLE</CODE> initialization parameter is properly set for Oracle9<EM CLASS="Italic">i</EM>. If <CODE>COMPATIBLE</CODE> is set below 8.1.0, then you will encounter the following error when you attempt to start up your release 9.2 database later in step 10:</P> <PRE CLASS="CE"><A NAME="153469"></A>ORA-00401: the value for parameter compatible is not supported by this release<A NAME="153471"></A></PRE> <A NAME="1009658"></A><P CLASS="BP">If you are upgrading from release 8.1.7 or earlier, then either leave <CODE>COMPATIBLE</CODE> unset in your initialization parameter file or set <CODE>COMPATIBLE</CODE> to <CODE>8.1.</CODE><EM><CODE>x</CODE></EM>.</P><A NAME="153474"></A><P CLASS="BP">If you are upgrading from release 9.0.1, then set <CODE>COMPATIBLE</CODE> to <CODE>9.0.1.3.0</CODE>.</P><A NAME="153476"></A><!--TOC=h2-"153476"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Troubleshooting Manual Upgrades</FONT></H3><!--/TOC=h2--><A NAME="153478"></A><P CLASS="BP">There are three resources that generally require increases for a new Oracle release:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="153480"></A><CODE>SYSTEM</CODE> tablespace<P><LI CLASS="LB1" TYPE="DISC"><A NAME="153482"></A>Shared memory<P><LI CLASS="LB1" TYPE="DISC"><A NAME="153484"></A>Rollback segments<P></UL><A NAME="153486"></A><P CLASS="BP">If you run out of one of these resources during the upgrade, then increase the resource allocation and re-run the appropriate upgrade scripts.</P><A NAME="153488"></A><!--TOC=h3-"153488"--><H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> SYSTEM Tablespace</FONT></H4><!--/TOC=h3--><A NAME="153490"></A><P CLASS="BP">Typically you will receive one of the following messages during the upgrade if your <CODE>SYSTEM</CODE> tablespace size is insufficient:</P> <PRE CLASS="CE"><A NAME="153492"></A>ORA-01650: unable to extend rollback segment <EM CLASS="Italic">string</EM> by <EM CLASS="Italic">string</EM> in tablespace <EM CLASS="Italic">string</EM><A NAME="153494"></A>ORA-01651: unable to extend save undo segment by <EM CLASS="Italic">string</EM> for tablespace <EM CLASS="Italic">string</EM><A NAME="153496"></A>ORA-01652: unable to extend temp segment by <EM CLASS="Italic">string</EM> in tablespace <EM CLASS="Italic">string</EM><A NAME="153498"></A>ORA-01653: unable to extend table <EM CLASS="Italic">string</EM>.<EM CLASS="Italic">string</EM> by <EM CLASS="Italic">string</EM> in tablespace <EM CLASS="Italic">string</EM><A NAME="153500"></A>ORA-01654: unable to extend index <EM CLASS="Italic">string</EM>.<EM CLASS="Italic">string</EM> by <EM CLASS="Italic">string</EM> in tablespace <EM CLASS="Italic">string</EM><A NAME="153502"></A>ORA-01655: unable to extend cluster <EM CLASS="Italic">string</EM>.<EM CLASS="Italic">string</EM> by <EM CLASS="Italic">string</EM> in tablespace <EM CLASS="Italic">string</EM><A NAME="153504"></A></PRE> <A NAME="153506"></A><!--TOC=h3-"153506"--><H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Shared Memory</FONT></H4><!--/TOC=h3--><A NAME="153508"></A><P CLASS="BP">You will require larger shared memory pool sizes, particularly if you have JServer in the database. The error message will indicate which shared memory initialization parameter needs to be increased.</P> <PRE CLASS="CE"><A NAME="153510"></A>ORA-04031: unable to allocate <EM CLASS="Italic">string</EM> bytes of shared memory ("<EM CLASS="Italic">string</EM>","<EM CLASS="Italic">string</EM>","<EM CLASS="Italic">string</EM>","<EM CLASS="Italic">string</EM>")<A NAME="153512"></A></PRE> <A NAME="153518"></A><P CLASS="BP">Refer to <EM CLASS="Italic">Oracle9i Database Reference</EM> for information about shared memory initialization parameters.</P><A NAME="153520"></A><!--TOC=h3-"153520"--><H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Public Rollback Segment</FONT></H4><!--/TOC=h3--><A NAME="153522"></A><P CLASS="BP">If you are using rollback segments, then you need to have a single large (70 MB) <CODE>PUBLIC</CODE> rollback segment online while the upgrade scripts are being run. Smaller public rollback segments should be taken offline during the upgrade. Typically you will get the following error if your rollback segment size is insufficient:</P> <PRE CLASS="CE"><A NAME="153524"></A>ORA-01562: failed to extend rollback segment number <EM CLASS="Italic">string</EM><A NAME="153526"></A></PRE> <A NAME="153528"></A><!--TOC=h2-"153528"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Upgrading from the Standard Edition to the Enterprise Edition</FONT></H3><!--/TOC=h2--><A NAME="153530"></A><P CLASS="BP">If you are using the Standard Edition of Oracle and want to upgrade to the Enterprise Edition, then complete the following steps:</P><OL CLASS="LN1" TYPE="1"><LI CLASS="LN1" TYPE="1" VALUE="1"><A NAME="153532"></A>Ensure that the release number of your Standard Edition server software is the same release as the Enterprise Edition server software.<P><A NAME="153534"></A><P CLASS="BP1">For example, if your Standard Edition server software is release 9.2.0.1.0, then you should upgrade to release 9.2.0.1.0 of the Enterprise Edition.</P><LI CLASS="LN1" TYPE="1" VALUE="2"><A NAME="153536"></A>Shut down your database.<P><LI CLASS="LN1" TYPE="1" VALUE="3"><A NAME="153538"></A>If your operating system is Windows, then stop all Oracle services, including the <CODE>OracleService</CODE><EM><CODE>SID</CODE></EM> Oracle service, where <EM><CODE>SID</CODE></EM> is the instance name.<P><LI CLASS="LN1" TYPE="1" VALUE="4"><A NAME="153540"></A>Deinstall the Standard Edition server software.<P><LI CLASS="LN1" TYPE="1" VALUE="5"><A NAME="153542"></A>Install the Enterprise Edition server software using the Oracle Universal Installer.<P> <A NAME="153544"></A><P CLASS="BP1">Select the same Oracle home that was used for the de-installed Standard Edition. During the installation, be sure to select the Enterprise Edition. When prompted, choose Software Only from the Database Configuration screen.</P><LI CLASS="LN1" TYPE="1" VALUE="6"><A NAME="153546"></A>Start up your database.<P> </OL><A NAME="153548"></A><P CLASS="BP">Your database is now upgraded to the Enterprise Edition.</P><A NAME="153552"></A><!--TOC=h1-"153552"--><H2 CLASS="H1"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading a Database Back to the Previous Oracle Release</FONT></H2><!--/TOC=h1--><A NAME="153558"></A><P CLASS="BP">The following sections outline changes and corrections to the downgrade procedures discussed in Chapter 7 of <EM CLASS="Italic">Oracle9i Database Migration</EM>.</P><A NAME="153560"></A><!--TOC=h2-"153560"--><H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Supported Releases for Downgrading</FONT></H3><!--/TOC=h2--><A NAME="153562"></A><P CLASS="BP">In Oracle9<EM CLASS="Italic">i</EM> release 9.2, only the following releases are supported for downgrading:</P><UL CLASS="LB1"><LI CLASS="LB1" TYPE="DISC"><A NAME="153564"></A>Release 9.0.1.3.0<P><LI CLASS="LB1" TYPE="DISC"><A NAME="153566"></A>Release 8.1.7.3.0<P></UL><A NAME="153568"></A><P CLASS="BP">If the release number of your previous database is an 8.1.7 release earleir than release 8.1.7.3.0, then install the 8.1.7.3.0 patch release software before you downgrade.</P><A NAME="153570"></A><P CLASS="BP">Similarly, if the release number of your database is a 9.0.1 release earleir than release 9.0.1.3.0, then install the 9.0.1.3.0 patch release software before you downgrade.</P><A NAME="153572"></A><P CLASS="BP">You do not need to first upgrade your previous database to the 8.1.7.3.0 or 9.0.1.3.0 patch releases, but the patch release software must be installed before the downgrade from release 9.2.</P>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -