升级数据库后启动时报 Ora-01092的错误信息,查询错误信息如下:
ORA-01092 ORACLE instance terminated. Disconnection forced
Cause: The instance connected to was terminated abnormally, probably due to a SHUTDOWN ABORT. The current process was forced to disconnect from the instance.
Action: Examine the alert log for more details. Contact the database administrator to determine when the instance is restarted. Attempt to reconnect after the instance is running again.
没有给出直接的解决方法,不过提示查看alert log,查看后发现如下错误:
Errors in file d:\oracle\product\10.2.0\admin\orcl\udump\orcl_ora_6312.trc:
ORA-00704:引导程序进程失败
ORA-39700:必须用UPGRADE选项打开数据库
看到这个错误就知道原因了,因为升级后的数据版本为10.2.0.4,原版本是10.2.0.1,应该是版本问题,因此进行升级数据库方式进行处理,具体处理步骤如下:
SQL>startup upgrade
SQL>@?\rdbms\admin\catupgrd.sql
SQL>@?\rdbms\admin\catalog.sql
SQL>@?\rdbms\admin\catproc.sql
SQL>@?\rdbms\admin\utlrp.sql
SQL>shutdown immediate
SQL>startup
结果命令执行完后,问题解决了。