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