Oracle 10.2.0.x升级到11.2.0.3

联系：手机/微信(+86 17813235971) QQ(107644445)

标题：Oracle 10.2.0.x升级到11.2.0.3

一、环境描述
[oracle@node1 ~]$ export ORACLE_SID=chf

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Fri Nov 4 08:59:58 2011

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter name;

NAME TYPE VALUE

———————————— ———– ——————————

db_file_name_convert string

db_name string chf

db_unique_name string chf

global_names boolean FALSE

instance_name string chf

lock_name_space string

log_file_name_convert string

service_names string chf

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@node1 ~]$ source .bash_profile

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.5.0 – Production on Fri Nov 4 09:01:25 2011

Connected to:

Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

SQL> show parameter name;

NAME TYPE VALUE

———————————— ———– ——————————

db_file_name_convert string

db_name string ecp

db_unique_name string ecp

global_names boolean FALSE

instance_name string ecp

lock_name_space string

log_file_name_convert string

service_names string ecp

SQL> exit

Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 – 64bit Production

With the Partitioning, OLAP, Data Mining and Real Application Testing options

[oracle@node1 ~]$ source ora11g.sh

[oracle@node1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.3.0 Production on Fri Nov 4 09:00:42 2011

Connected to:

Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

SQL> show parameter name;

NAME TYPE VALUE

———————————— ———– ——————————

db_file_name_convert string

db_name string ora11g

db_unique_name string ora11g

global_names boolean FALSE

instance_name string ora11g

lock_name_space string

log_file_name_convert string

processor_group_name string

service_names string ora11g

SQL> exit

Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 – 64bit Production

With the Partitioning, Oracle Label Security, OLAP, Data Mining,

Oracle Database Vault and Real Application Testing options

通过上面的资料可以看出，Oracle 10g中有两个实例分别是chf和ecp，Oracle 11g中有一个实例为ora11g，现在需要做的操作是升级Oracle 10g中的chf为11g

二、升级过程
1、执行11g中的dbua

[oracle@node1 ~]$ export DISPLAY=192.168.9.215:0.0

[oracle@node1 ~]$ dbua

选择需要升级数据库，这里选择chf

升级前可能存在问题，需要处理

Oracle Database Vault没有关闭(关闭后重新运行dbua），具体操作见:Disable/Enable Oracle Database Vault

相关选项

因为em配置需要监听，因为我不用em，所以忽略这些

提示升级间关闭归档

选择升级过程中是否移动数据文件和存储类型

dbua升级汇总

开始升级

提示em没有关闭，因为不用，不管它，最好是升级前关闭这些

升级完成