oracle 10.2.0.4升级到11g r1失败【待解决】

来源：互联网发布：攻壳机动队看不懂知乎编辑：程序博客网时间：2024/06/09 06:41

整个oracle的安装历史是：9.2.0.1，patch到9.2.0.8，装iPE加了一些数据，然后用dbua升级到10.2.0.1，然后用dbua升级到10.2.0.4，到这个时候，oracle一切正常。接下来，安装11g r1，开始用dbua升级。

SQL> @utlu111i.sql
Oracle Database 11.1 Pre-Upgrade Information Tool 03-19-2010 20:34:58
.
**********************************************************************
Database:
**********************************************************************
--> name: BPM2096
--> version: 10.2.0.4.0
--> compatible: 9.2.0.0.0
--> blocksize: 8192
--> platform: Microsoft Windows IA (32-bit)
--> timezone file: V4
.
**********************************************************************
Tablespaces: [make adjustments in the current environment]
**********************************************************************
--> SYSTEM tablespace is adequate for the upgrade.
.... minimum required size: 819 MB
.... AUTOEXTEND additional space required: 159 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 380 MB
--> TEMP tablespace is adequate for the upgrade.
.... minimum required size: 61 MB
.... AUTOEXTEND additional space required: 21 MB
--> CWMLITE tablespace is adequate for the upgrade.
.... minimum required size: 16 MB
--> DRSYS tablespace is adequate for the upgrade.
.... minimum required size: 11 MB
--> EXAMPLE tablespace is adequate for the upgrade.
.... minimum required size: 153 MB
.... AUTOEXTEND additional space required: 3 MB
--> ODM tablespace is adequate for the upgrade.
.... minimum required size: 10 MB
--> XDB tablespace is adequate for the upgrade.
.... minimum required size: 90 MB
.... AUTOEXTEND additional space required: 42 MB
--> ST2096B4 tablespace is adequate for the upgrade.
.... minimum required size: 27 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 242 MB
--> ST2096B6 tablespace is adequate for the upgrade.
.... minimum required size: 27 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
WARNING: --> "compatible" must be set to at least 10.1.0
.
**********************************************************************
Renamed Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No renamed parameters found. No changes are required.
.
**********************************************************************
Obsolete/Deprecated Parameters: [Update Oracle Database 11.1 init.ora or spfile]

**********************************************************************
--> "background_dump_dest" replaced by "diagnostic_dest"
--> "user_dump_dest" replaced by "diagnostic_dest"
--> "core_dump_dest" replaced by "diagnostic_dest"
.
**********************************************************************
Components: [The following database components will be upgraded or installed]
**********************************************************************
--> Oracle Catalog Views [upgrade] VALID
--> Oracle Packages and Types [upgrade] VALID
--> JServer JAVA Virtual Machine [upgrade] VALID
--> Oracle XDK for Java [upgrade] VALID
--> Oracle Workspace Manager [upgrade] VALID
--> OLAP Analytic Workspace [upgrade] VALID
--> OLAP Catalog [upgrade] VALID
--> EM Repository [upgrade] VALID
--> Oracle Text [upgrade] VALID
--> Oracle XML Database [upgrade] VALID
--> Oracle Java Packages [upgrade] VALID
--> Oracle interMedia [upgrade] VALID
--> Spatial [upgrade] VALID
--> Data Mining [upgrade] VALID
--> Oracle Ultra Search [upgrade] INVALID
--> Oracle OLAP API [upgrade] VALID
.
**********************************************************************
Miscellaneous Warnings
**********************************************************************
WARNING: --> Database contains stale optimizer statistics.
.... Refer to the 11g Upgrade Guide for instructions to update
.... statistics prior to upgrading the database.
.... Component Schemas with stale statistics:
.... SYS
.... WMSYS
.... OLAPSYS
.... SYSMAN
.... CTXSYS
.... XDB
.... MDSYS
WARNING: --> Database contains INVALID objects prior to upgrade.
.... USER WKSYS has 4 INVALID objects.
.... USER PUBLIC has 4 INVALID objects.
.... USER SYS has 4 INVALID objects.
WARNING: --> Database contains schemas with objects dependent on network
packages.
.... Refer to the 11g Upgrade Guide for instructions to configure Network ACLs.
WARNING: --> EM Database Control Repository exists in the database.
.... Direct downgrade of EM Database Control is not supported. Refer to the
.... 11g Upgrade Guide for instructions to save the EM data prior to upgrade.
.

PL/SQL 过程已成功完成。

SQL> show parameter compatible;

NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
compatible string 9.2.0.0.0

以上黑体部分是我认为需要解决的地方。

之前出现过一个time zone的问题，打上patch就行了。

我直接无视以上问题，直接dbua，安装到55%, EM repository的时候有ora-06500的错误，到71%的时候有ora-00001 ora-06512的错误，到80% xml database的时候有ora-06575 02315的错误。这些可以忽略掉并继续。紧接着80%处有ora-00600的错误，说内部错误代码，参数[kokeeilx3],[3],[],[],[],[],[],[]。点击确定之后出现同样的错误，只是多了一行字：由于执行步骤“正在升级oracle server”而无法升级，再确定之后就只能选择恢复数据库。

解决方案正在查。