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
-
Start the database in the
UPGRADE
mode:SQL> STARTUP UPGRADE
-
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
重启后恢复正常