migng.htm

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

<A NAME="153574"></A>
<!--TOC=h2-"153574"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Removing OLAP Incompatibilities Before Downgrading to Release 8.1.7</FONT></H3>
<!--/TOC=h2-->
<A NAME="153580"></A>
<P CLASS="BP">
Before completing the downgrade procedure discussed on page 7-21 of <EM CLASS="Italic">Oracle9i Database Migration</EM>, run the following script to remove OLAP incompatibilities:
</P>
    
<PRE CLASS="CE">
<A NAME="153582"></A><EM CLASS="Italic">ORACLE_HOME</EM>/olap/admin/olapidrp.sql
<A NAME="153584"></A>
</PRE>    
<A NAME="153586"></A>
<!--TOC=h2-"153586"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading Specific Components</FONT></H3>
<!--/TOC=h2-->
<A NAME="153596"></A>
<P CLASS="BP">
Some components of the Oracle database server require a downgrade separate from the general downgrade procedure discussed on page 7-21 of <EM CLASS="Italic">Oracle9i Database Migration</EM>. <A HREF="migng.htm#362421">Table&nbsp;7-1</a> lists components and their downgrade status:
</P>
   
<A NAME="153599">
<H5 CLASS="TT"><FONT FACE="Helvetica,Arial,sans-serif"><EM>
<A NAME="362421"></A>
<STRONG><FONT FACE="Arial, Helvetica, sans-serif"><EM>Table 7-1 &#32;&nbsp;Component Downgrade Status</EM></FONT></STRONG>
 </EM></FONT></H5>

<TABLE CLASS="Formal" BORDER="1" FRAME="HSIDES" RULES="GROUPS" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" dir="ltr">
<THEAD>
<TR CLASS="Formal"><TH CLASS="Formal" align="left" valign="bottom" scope="col">
<A NAME="362427"></A>
<FONT FACE="Arial, Helvetica, sans-serif"><STRONG>Installed Component</STRONG></FONT>&nbsp;</TH>
<TH CLASS="Formal" align="left" valign="bottom" scope="col">
<A NAME="362429"></A>
<FONT FACE="Arial, Helvetica, sans-serif"><STRONG>Automatically Downgraded</STRONG></FONT>&nbsp;</TH>
</TR>
<TBODY>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362438"></A>
<P CLASS="TB">
Oracle9<EM CLASS="Italic">i</EM> Catalog Views&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362440"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362449"></A>
<P CLASS="TB">
Oracle9<EM CLASS="Italic">i</EM> Packages and Types&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362451"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362457"></A>
<P CLASS="TB">
JServer JAVA Virtual Machine&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362459"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362468"></A>
<P CLASS="TB">
Oracle9<EM CLASS="Italic">i</EM> Java Packages&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362470"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362476"></A>
<P CLASS="TB">
Oracle XDK for Java&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362478"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362484"></A>
<P CLASS="TB">
Messaging Gateway&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362486"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362492"></A>
<P CLASS="TB">
Oracle Text&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362494"></A>
<P CLASS="TB">
No&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362503"></A>
<P CLASS="TB">
Oracle9<EM CLASS="Italic">i</EM> Real Application Clusters&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362505"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362511"></A>
<P CLASS="TB">
Oracle Workspace Manager&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362513"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362519"></A>
<P CLASS="TB">
Oracle Data Mining&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362521"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362527"></A>
<P CLASS="TB">
Oracle Ultra Search&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362529"></A>
<P CLASS="TB">
No&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362535"></A>
<P CLASS="TB">
OLAP Catalog&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362537"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362535"></A>
<P CLASS="TB">
OLAP Analytic Workspace&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362537"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362543"></A>
<P CLASS="TB">
Oracle Spatial&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362545"></A>
<P CLASS="TB">
No&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362551"></A>
<P CLASS="TB">
Oracle <EM CLASS="Italic">inter</EM>Media&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362553"></A>
<P CLASS="TB">
No&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362559"></A>
<P CLASS="TB">
Oracle Visual Information Retrieval&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362561"></A>
<P CLASS="TB">
No&nbsp;</TD>
</TR>
<TR CLASS="Formal" ALIGN="LEFT" VALIGN="TOP"><TD CLASS="Formal">
<A NAME="362567"></A>
<P CLASS="TB">
Oracle Label Security&nbsp;</TD>
<TD CLASS="Formal">
<A NAME="362569"></A>
<P CLASS="TB">
Yes&nbsp;</TD>
</TR>

</TABLE>

<TABLE CLASS="TableNote" WIDTH="100%" CELLPADDING="3" CELLSPACING="0" dir="ltr">
<TR CLASS="TableNote" ALIGN=LEFT VALIGN=TOP><TD CLASS="TableNote">

</TD></TR>
</TABLE>

</A>
   <A NAME="153601"></A>
<P CLASS="BP">
Complete the actions in the following sections to downgrade components that are not automatically downgraded.
</P>

<A NAME="1009947"></A>
<!--TOC=h3-"1009947"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading Oracle Spatial</FONT></H4>
<!--/TOC=h3-->
<A NAME="1009951"></A>
<P CLASS="BP">
If the Oracle system has Oracle Spatial installed, then see the <EM CLASS="Italic">Oracle Spatial User's Guide and Reference</EM> for instructions about downgrading Oracle Spatial.
</P>

<A NAME="153608"></A>
<!--TOC=h3-"153608"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading Oracle <EM CLASS="Italic">inter</EM>Media</FONT></H4>
<!--/TOC=h3-->
<A NAME="1009957"></A>
<P CLASS="BP">
Downgrade instructions for Oracle <EM CLASS="Italic">inter</EM>Media can be found in <EM><CODE>ORACLE_HOME</CODE></EM><CODE>/ord/im/admin/README.txt</CODE> on UNIX platforms and in <EM><CODE>ORACLE_HOME</CODE></EM><CODE>\ord\im\admin\README.txt</CODE> on Windows platforms.
</P>

<A NAME="1009960"></A>
<!--TOC=h3-"1009960"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading Oracle Visual Information Retrieval</FONT></H4>
<!--/TOC=h3-->
<A NAME="1009961"></A>
<P CLASS="BP">
Downgrade instructions for Oracle Visual Information Retrieval can be found in <EM><CODE>ORACLE_HOME</CODE></EM><CODE>/ord/vir/admin/README.txt</CODE> on UNIX platforms and in <EM><CODE>ORACLE_HOME</CODE></EM><CODE>\ord\vir\admin\README.txt</CODE> on Windows platforms.
</P>

<A NAME="153613"></A>
<!--TOC=h3-"153613"-->
<H4 CLASS="H3"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Downgrading Oracle Text</FONT></H4>
<!--/TOC=h3-->
<A NAME="153615"></A>
<P CLASS="BP">
If the Oracle system has Oracle Text installed, then complete the following steps:
</P>

<OL CLASS="LN1" TYPE="1">

<LI CLASS="LN1" TYPE="1" VALUE="1"><A NAME="153617"></A>Log in to the system as the owner of the release 9.2 Oracle home directory.
<P>


<LI CLASS="LN1" TYPE="1" VALUE="2"><A NAME="153619"></A>At a system prompt, change to the <EM><CODE>ORACLE_HOME</CODE></EM><CODE>/ctx/admin</CODE> directory.
<P>

<LI CLASS="LN1" TYPE="1" VALUE="3"><A NAME="153621"></A>Start SQL*Plus.
<P>

<LI CLASS="LN1" TYPE="1" VALUE="4"><A NAME="153623"></A>Connect to the database instance as user <CODE>CTXSYS</CODE>.
<P>

<LI CLASS="LN1" TYPE="1" VALUE="5"><A NAME="153625"></A>If the instance is running, then shut it down using <CODE>SHUTDOWN IMMEDIATE</CODE>:
<P>
   
<PRE CLASS="CE1">
<A NAME="153627"></A>SQL&gt; SHUTDOWN IMMEDIATE
<A NAME="153629"></A>
</PRE>
   
<LI CLASS="LN1" TYPE="1" VALUE="6"><A NAME="153631"></A>Start up the instance in <CODE>RESTRICT</CODE> mode:
<P>
   
<PRE CLASS="CE1">
<A NAME="153633"></A>SQL&gt; STARTUP RESTRICT
<A NAME="153635"></A>
</PRE>
    

<A NAME="153637"></A>
<P CLASS="BP1">
You may need to use the <CODE>PFILE</CODE> option to specify the location of your initialization parameter file.
</P>


<LI CLASS="LN1" TYPE="1" VALUE="7"><A NAME="153639"></A>Run the appropriate downgrade script to downgrade Oracle Text.
<P>
 

<A NAME="153641"></A>
<P CLASS="BP1">
If you are downgrading to release 8.1.7, then run the following script:
</P>
   
<PRE CLASS="CE1">
<A NAME="153643"></A>SQL&gt; @d0801070.sql
<A NAME="153645"></A>
</PRE>
   
<A NAME="153647"></A>
<P CLASS="BP1">
If you are downgrading to release 9.0.1, then run the following script:
</P>
   
<PRE CLASS="CE1">
<A NAME="153649"></A>SQL&gt; @d0900010.sql
<A NAME="153651"></A>
</PRE>
   

<LI CLASS="LN1" TYPE="1" VALUE="8"><A NAME="153653"></A>Shut down the instance:
<P>
   
<PRE CLASS="CE1">
<A NAME="153655"></A>SQL&gt; SHUTDOWN IMMEDIATE
<A NAME="153657"></A>
</PRE>
   
<LI CLASS="LN1" TYPE="1" VALUE="9"><A NAME="153659"></A>Exit SQL*Plus.
<P>
 
</OL>

<A NAME="153661"></A>
<!--TOC=h2-"153661"-->
<H3 CLASS="H2"><FONT FACE="Arial, Helvetica, sans-serif" COLOR="#330099"> Reload Oracle Label Security in the Downgraded Database</FONT></H3>
<!--/TOC=h2-->
<A NAME="153667"></A>
<P CLASS="BP">
Before Step 32 on page 7-29 of <EM CLASS="Italic">Oracle9i Database Migration</EM>, insert the following step. This step must be performed if the downgraded database has Oracle Label Security installed:
</P>
<A NAME="153669"></A>
<P CLASS="BP">
If the database being downgraded has Oracle Label Security installed, then run the appropriate downgrade script to complete the Oracle Label Security downgrade. When you run the script, replace <EM><CODE>ORACLE_HOME</CODE></EM> with the full path of the previous Oracle home directory.
</P>
<A NAME="153671"></A>
<P CLASS="BP">
If you are downgrading to release 9.0.1, then run the following script:
</P>
    
<PRE CLASS="CE">
<A NAME="153673"></A>@<EM CLASS="Italic">ORACLE_HOME</EM>/rdbms/admin/catols.sql
<A NAME="153675"></A>
</PRE>    <A NAME="153677"></A>
<P CLASS="BP">
If you are downgrading to release 8.1.7, then run the following script:
</P>
    
<PRE CLASS="CE">
<A NAME="153679"></A>@<EM CLASS="Italic">ORACLE_HOME</EM>/rdbms/admin/olsd817.sql
<A NAME="153681"></A>
</PRE>    





<!-- Start Footer -->
</DIV>

<DIV CLASS="OUTD">
<HR>
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="100%">
<TR>
<TD VALIGN="BOTTOM" WIDTH="33%">
<TABLE CELLSPACING="0" CELLPADDING="0">
<TR>
<TD ALIGN="CENTER"><A HREF="nlspg.htm"><IMG SRC="larrow.gif" ALT="Go to previous page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD>

<TD ALIGN="CENTER"><A HREF="refrn.htm"><IMG SRC="rarrow.gif" ALT="Go to next page" BORDER="0" HEIGHT="30" WIDTH="40"></A></TD>
    
</TR>
</TABLE>
</TD>
<TD ALIGN="CENTER" WIDTH="34%">
<font size="-2">Copyright &copy; 2002 Oracle Corporation.</font>
<BR>
<FONT SIZE="-2">All Rights Reserved.</FONT>
</TD>
<TD VALIGN="BOTTOM" ALIGN="RIGHT" WIDTH="33%"> 
<TABLE CELLSPACING="0" CELLPADDING="0" WIDTH="144">
<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>
  
</DIV>

</BODY>
</HTML>