oracle 10.2.0.4 升级到11.1.0.7之前需要哪些pre步骤？

[hej027]

我安装了10.2.0.1然后patch到10.2.0.4
在另一个文件夹里面安装了11.1.0.6然后patch到11.1.0.7
我正要把10g的数据库用dbua升级到11g
请问还需要做什么pre步骤吗？直接dbua就可以了吗？

我直接用dbua的话
会弹出一个框框说

==========================================
oracle corporation强烈建议您先解决数据库“abc”中的以下问题，然后再开始升级数据库：

upgrade assistant识别出数据库中存在一些无效对象。请记下这些对象，以便在升级过程结束时将他们与无效对象列表进行比较。

数据库包含其对象从属于网络包的方案。有关配置网络ACL的说明，请参阅11g升级指南。

数据库包含过时的优化程序统计信息。在升级数据库之前，请参阅upgrade guide以了解更新统计信息的说明。

数据库中存在enterprise manager database control资料档案库。不支持直接降级enterprise manager database control。有关在升级前保存enterprise manager数据的说明，请参阅11g升级指南。

是否要继续升级？
===========================================

另外，@utlu111i.sql的结果如下，我不知道哪些是可以忽视的，哪些是必须修复的问题。。好多warning。。。。

=============================================

Oracle Database 11.1 Pre-Upgrade Information Tool 03-22-2010 21:47:34
.
**********************************************************************
Database:
**********************************************************************
--> name: ABC
--> version: 10.2.0.4.0
--> compatible: 10.1.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: 860 MB
.... AUTOEXTEND additional space required: 180 MB
--> UNDOTBS1 tablespace is adequate for the upgrade.
.... minimum required size: 195 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: 107 MB
.... AUTOEXTEND additional space required: 59 MB
--> ST2096B4 tablespace is adequate for the upgrade.
.... minimum required size: 27 MB
--> SYSAUX tablespace is adequate for the upgrade.
.... minimum required size: 266 MB
--> ST2096B6 tablespace is adequate for the upgrade.
.... minimum required size: 27 MB
.
**********************************************************************
Update Parameters: [Update Oracle Database 11.1 init.ora or spfile]
**********************************************************************
-- No update parameter changes are required.
.
**********************************************************************
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
.... SYSMAN
.... XDB
WARNING: --> Database contains INVALID objects prior to upgrade.
.... The list of invalid SYS/SYSTEM objects was written to
.... registry$sys_inv_objs.
.... The list of non-SYS/SYSTEM objects was written to
.... registry$nonsys_inv_objs.
.... Use utluiobj.sql after the upgrade to identify any new invalid
.... objects due to the upgrade.
.... USER WKSYS has 4 INVALID objects.
.... USER MDSYS has 17 INVALID objects.
.... USER DMSYS has 8 INVALID objects.
.... USER PUBLIC has 36 INVALID objects.
.... USER CTXSYS has 8 INVALID objects.
.... USER ORDSYS has 18 INVALID objects.
.... USER XDB has 15 INVALID objects.
.... USER ODM has 1 INVALID objects.
.... USER SYS has 126 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 过程已成功完成。

[hej027]

自己顶一下~

[suiziguo]

这个要看看ORACLE的升级文档，按照步骤来.

[rexyudl]

没事升级干什么啊？以稳定为优先啊！

[孤独剑_LPZ]

一般分几步吧:
1.分用户导出dmp数据文件(10.2.0.4);
2.参照老库建表空间,用户,要一模一样;
3.导入dmp数据文件;
4.将所有的过程,函数编译通过;
5.测试功能

[hej027]

[Quote=引用 5 楼 asftrhgjhkjlkttttttt 的回复:]

一般分几步吧:
1.分用户导出dmp数据文件(10.2.0.4);
2.参照老库建表空间,用户,要一模一样;
3.导入dmp数据文件;
4.将所有的过程,函数编译通过;
5.测试功能
[/Quote]


谢谢～
不过由于某些需求，我必须用dbua做升级。。。

[dawugui]

同问,帮顶.