Oracle 10g R2升级到Oracle 11g R2

SQL>ALTER SYSTEM SET COMPATIBLE = ’11.2.0’ SCOPE=SPFILE;

参考文档：CompleteChecklist for Manual Upgrades to 11gR2 [ID 837570.1]

@至此，数据库升级工作完成！

升级遇到的问题：

[oracle@rh55 admin]$ cd /u01/app/oracle/product/10.2.0/db_1/sqlplus/admin/

[oracle@rh55 admin]$ cat glogin.sql

set linesize 120

set pagesize 20

set time on

set timing on

set sqlprompt ‘_user@ _connect_identifier>‘

 在升级过程遇到以上问题，原因是在glogin.sql增加了以上的内容，删除后问题解决！

以下为相似案例：

问题：

10.2.0.4 -> 11.2 - dbua - fatal - db using asm as storage,... but it isn‘t

This question is Not Answered.

stuartu Jan 27, 2010 10:27 PM Currently Being Moderated

I‘m upgrading my 10.2.0.4 to 11.2.0.1 on RHEL5.4.

I start up the 11.2 dbua, and select the database to upgrade, then dbua pops up a box that says:

"The database is using ASM as storage. Before you upgrade the database, you need to upgrade ASM using Automatic Storage Configuration Assistant (ASMCA) from grid infrastructure home. Starting 11gR2, ASM should be running from grid infrastructure home"

The problem is.... I am not running ASM.

Any reasons why dbua is complaining about this, and how I can get past it?

Thanks in advance.

Stuart.

解决方法：

Problem has been resolved, with help from Oracle Support:

In my 10gR2 environment, the glogin.sql had the following custom entry:

set heading on

set pages 49999

set feedback on

set linesize 180

define _editor=vi

The problem is with ‘set feedback on‘. Once this is removed, I am able to get past the ASM instance popup error.

I had earlier removed a custom ‘sqlprompt‘ entry from glogin.sql, as I knew that caused problems when I upgraded from 9.2.0.8 -> 10.2.0.4 early last year, but left the other ones there.

Really,... this problem is quite logical when you think about it. It is just the cryptic error that was thrown when it was encountered... :-/

Stuart.

Edited by: stuartu on Feb 3, 2010 9:51 AM

以上，文档参考了一些网友的著作，在这里一并标示感谢，谢谢你们的辛勤劳动！

本文出自 “” 博客，请务必保留此出处

Oracle 10g R2升级到Oracle 11g R2,布布扣,bubuko.com