oracle10.2.0.1.0到10.2.0.4.0的过程---p6810189_10204_Linux-x86-64.zip

SuSE10上安装Oracle10g后升级

 

1) 停掉所有oracle相关服务：

$ emctl stop dbconsole
$ isqlplusctl stop
$ lsnrctl stop

 

升级后，发现无法正常启动，启动报错：ORA-01092: ORACLE instance terminated. Disconnection forced

 

查看Readme.html，需要执行两个SQL脚本，在

9.3.2.1 Run the Pre-Upgrade Information Tool

1. Start the database in the UPGRADE mode:

   SQL> STARTUP UPGRADE

2. Run the Pre-Upgrade Information Tool:

   SQL> @?/rdbms/admin/utlu102i.sql

9.3.2.2 Upgrading a Release 10.2 Database

SQL> @?/rdbms/admin/catupgrd.sql

重启后恢复正常