oracle 10.2.0.4升级到11.2.0.4(单实例)

1、1：DBUA 图形界面2：GUI 手动升级1、Backup the database.2、In UNIX/Linux environments, set the $ORACLE_HOME and $PATH variables to point to the new 11g Oracle home.3、Analyze the existing instance using the "$ORACLE_HOME/rdbms/admin/utlu111i.sql" script, explained below.4、Start the original database using theSTARTUP UPGRADEcommand and proceed with the upgrade by running the "$ORACLE_HOME/rdbms/admin/catupgrd.sql" script.5、Recompile invalid objects.Restart the database.6、Run the "$ORACLE_HOME/rdbms/admin/utlu111s.sql" script and check the result of the upgrade.7、Troubleshoot any issues or abort the upgrade.3：expdp/impdp 最简单，风险性最小，时间较长如果要减少时间可以考虑 2个库都关闭归档，开启并行