oracle 升级 32升级64 utlirp,11G从32位迁移到64的问题

11G从32位迁移到64的问题

中文社区 (MOSC)

数据库 (MOSC)

1 Replies

Last updated on November 27, 2012

This question is Not Answered.

我要把WINDOWS下32位的9.2.0.6.0升级到WINDOWS的11.2.0.1，用导入导出花的时间太长(导出就12个小时的)

于是采用了9.2.0.6.0升级到9.2.0.8，再从9.2.0.8升级到11.2.0.1(都是32位的)

以上都成功了，

而从11.2.0.1的32位迁移到64位时：

用重建控制文件的方法迁移：

1.在32位上备份控制文件到文本文件

2.32位上停ORACLE服务，把数据文件复制到64位机器上

3.在64位上用备份控制文件到文本文件重建控制文件

4.启动打开数据库

以上都成功

接下来

Shut down the database:

SHUTDOWN IMMEDIATE;

STARTUP UPGRADE

SPOOL mig32-64.log

@\rdbms\admin\utlirp.sql

出现了错误:

SQL> @?\rdbms\admin\utlirp.sql

SQL>

SQL> WHENEVER SQLERROR EXIT;

SQL>

SQL> DOC

DOC>#######################################################################

DOC>#######################################################################

DOC>   The following statement will cause an "ORA-01722: invalid number"

DOC>   error if there the database was not opened in UPGRADE mode

DOC>

DOC>   If you encounter this error, execute "SHUTDOWN", "STARTUP UPGRADE" and

DOC>   re-execute utlirp.sql

DOC>#######################################################################

DOC>#######################################################################

DOC>#

...............

................

SQL> grant execute on dbms_standard to public

2  /

授权成功。

SQL>

SQL> -- Step (III)

SQL> --

SQL> -- Invalidate views and synonyms which depend (directly or indirectly) on

SQL> -- invalid objects.

SQL> begin

2    loop

3    update obj$ o_outer set status = 6

4    where    type# in (4, 5)

5          and status not in (5, 6)

6          andTo view full details, sign in with your My Oracle Support Community account.

Don't have a My Oracle Support

Community account? Click to get started!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.

Oracle offers a comprehensive and fully integrated stack of cloud applications and platform services. For more information about Oracle (NYSE:ORCL), visit oracle.com. © Oracle | Contact and Chat | Support | Communities | Connect with us | Legal Notices | Terms of Use