ORA-39700Oracle10g升级后数据库实例无法启动
内容导读
互联网集市收集整理的这篇技术教程文章主要介绍了ORA-39700Oracle10g升级后数据库实例无法启动,小编现在分享给大家,供广大互联网技能从业者学习和参考。文章包含2490字,纯文字阅读大概需要4分钟。
内容图文
![ORA-39700Oracle10g升级后数据库实例无法启动](/upload/InfoBanner/zyjiaocheng/555/6eda106ed8cf4d2ca4399385cc23ad11.jpg)
今天把Oracle数据库 10.2.0.1升级到10.2.0.5,然后启动数据库的时候出错:ORA-01092: ORACLE instance terminated. Disconnectio
今天把Oracle数据库 10.2.0.1升级到10.2.0.5
然后启动数据库的时候出错:
ORA-01092: ORACLE instance terminated. Disconnection forced 实例终止并强制断开。
遂查看数据库警报日志, 默认地址 $ORACLE_BASE/admin/$ORACLE_SID/bdump/ 目录下的aler_SID.log
[oracle@RedHat4 bdump]$ cd $ORACLE_BASE/admin/$ORACLE_SID/bdump/
[oracle@redhat4 bdump]$ pwd
/u01/app/oracle/admin/crab/bdump
[oracle@redhat4 bdump]$ vim alert_crab.log
日志最近错误信息:
Mon Jun 09 13:54:51 CST 2014
ARC0: Becoming the heartbeat ARCH
Mon Jun 09 13:54:51 CST 2014
Thread 1 opened at log sequence 14
Current log# 1 seq# 14 mem# 0: /u01/app/oracle/oradata/crab/redo01.log
Successful open of redo thread 1
Mon Jun 09 13:54:51 CST 2014
MTTR advisory is disabled because FAST_START_MTTR_TARGET is not set
Mon Jun 09 13:54:51 CST 2014
SMON: enabling cache recovery
Mon Jun 09 13:54:57 CST 2014
Errors in file /u01/app/oracle/admin/crab/udump/crab_ora_2768.trc:
ORA-00704: bootstrap process failure
ORA-39700: database must be opened with UPGRADE option
Mon Jun 09 13:54:57 CST 2014
Error 704 happened during db open, shutting down database
USER: terminating instance due to error 704
Instance terminated by USER, pid = 2768
ORA-1092 signalled during: ALTER DATABASE OPEN...
找到问题关键
oracle 10g官方文档显示 :
ORA-39700: database must be opened with UPGRADE option
Cause: A normal database open was attempted, but the database has not been upgraded to the current server version.
Action: Use the UPGRADE option when opening the database to run catupgrd.sql (for database upgrade), or to run catalog.sql and catproc.sql (after initial database creation)
我只安装了升级包,没有执行升级数据库的过程
进入数据库,启动到upgrade
sqlplus / as sysdba
startup upgrade
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catalog.sql
@/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/catproc.sql
这俩个脚本比较慢 我执行了半小时
或者亦可以 @/u01/app/oracle/product/10.2.0/db_1/rdbms/admin/ catupgrd.sql
然后关闭数据库,再启动
SQL> select open_mode from v$database;
OPEN_MODE
----------
READ WRITE
1 row selected.
SQL> show user
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
在CentOS 6.4下安装Oracle 11gR2(x64)
Oracle 11gR2 在VMWare虚拟机中安装步骤
Debian 下 安装 Oracle 11g XE R2
本文永久更新链接地址:
内容总结
以上是互联网集市为您收集整理的ORA-39700Oracle10g升级后数据库实例无法启动全部内容,希望文章能够帮你解决ORA-39700Oracle10g升级后数据库实例无法启动所遇到的程序开发问题。 如果觉得互联网集市技术教程内容还不错,欢迎将互联网集市网站推荐给程序员好友。
内容备注
版权声明:本文内容由互联网用户自发贡献,该文观点与技术仅代表作者本人。本站仅提供信息存储空间服务,不拥有所有权,不承担相关法律责任。如发现本站有涉嫌侵权/违法违规的内容, 请发送邮件至 gblab@vip.qq.com 举报,一经查实,本站将立刻删除。
内容手机端
扫描二维码推送至手机访问。