Oracle 10.2.0.1 升级 10.2.0.4失败后处理

今天将由Oracle 10.2.0.1.0升级为10.2.0.4.0的过程中,由于数据库期间不能完成正常的重启,因此升级失败.. 不过数据库软件是已升级成功了.

ORA-00704: bootstrap process failure
ORA-1092 signalled during: alter database open...
--- 进行如下操作后OK.
SQL>startup upgrade
SQL>@$ORACLE_HOME/rdbms/admin/catupgrd.sql       
SQL> @$ORACLE_HOME/rdbms/admin/catalog.sql
--- 编译无效对象：
SQL> @ $ORACLE_HOME/rdbms/admin/utlrp.sql
--- 最后再查看是否还有无效对象
SQL> SELECT count(*) FROM dba_objects WHERE status='INVALID';
--- 重新启动
SQL>shutdown immediate
SQL>startup
--- 数据库启动成功

再一次提醒自己,无论做什么操作,无论有多大把握,做之前请务必进行备份!!!

--- 解锁sysman用户
SQL> alter user sysman IDENTIFIED by on_finish_change;
SQL> alter user sysman account unlock;

---重新配置enterprise manager
emctl config emkey -repos -sysman_pwd
emctl secure dbconsole -sysman_pwd