ORA-39700 oracle 10g升级后数据库实例无法启动
来源:互联网 发布:sql 2005官网 编辑:程序博客网 时间:2024/05/02 10:17
今天把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)
然后启动数据库的时候出错:
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
----------
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.
USER is "SYS"
SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
0 0
- ORA-39700 oracle 10g升级后数据库实例无法启动
- Oracle 10g数据库关闭后无法启动,ORA-12514错误。
- oracle 11.2.0.3.7升级到11.2.0.3.11后数据库无法启动案例 - ORA-00600 kfioTranslateIO03和17090
- oracle10g升级补丁后无法启动实例
- Oracle 11g参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101,ORA-00824]
- Oracle 10g数据库启动ORA-12514: TNS: 监听程序当前无法识别连接描述符中请求的服务;ora-01034:oracle not available
- Oracle 11g 参数修改错误导致数据库无法启动的处理方法.[ORA-01034,ORA-27101]
- Oracle数据库升级后报ORA-00704和ORA-39700错误
- oracle 11g---------启动、关闭数据库实例
- Oracle 10g (10.2.0.4.0) 新建数据库实例85%卡住, OracleDBConsoleorcl无法启动 EM创建问题修复
- oracle 11g 减少内存后,启动实例报错:ORA-00845: MEMORY_TARGET not supported on this system
- Oracle 10g启动后报ORA-16038错误的解决方法
- Oracle 11g启动数据库报错ora-00845
- 升级到Oracle 11g后,SAP数据库用户密码过期
- 数据库异常关闭后无法启动问题处理(ORA-01102)
- Ubuntu 升级后Oracle VirtualBox 无法启动问题
- oracle非法关机数据库无法启动ORA-00600: [kcratr1_lostwrt],解决办法
- oracle 10g tnslistener 无法启动?
- jQuery创建新元素
- Android进程简介
- chrome调试
- c库函数 strring.h字符串操作(部分常用实现)
- HTML CSS Javascript
- ORA-39700 oracle 10g升级后数据库实例无法启动
- 获取元素的方法
- cc、gcc、g++、CC的区别概括[转载]
- CSS3的transition和transform
- 关于JacORB编程过程中的一些问题
- POJ 1470 Closest Common Ancestors【最近公共祖先LCA】
- ORA-02287: 此处不允许序号
- leetcode twosums
- 多关键词排序问题