ORA-39700 是一个 Oracle 数据库在使用 Data Pump 工具(如 expdp 和impdp)进行数据导入导出时可能遇到的错误。下面是对该错误的详细解答: 1. ORA-39700错误的含义 ORA-39700 错误通常表示在 Data Pump 作业执行过程中遇到了一个与数据验证或约束相关的问题。具体来说,它指示在导入过程中,由于某些数据违反了数据...
Database mounted. ORA-01092: ORACLE instance terminated. Disconnection forced 2. 查看alert.log ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option 3. 查看数据库版本为:10.2.0.4.0,应该是做过数据库的升级而没有执行这个脚本造成的 $ORACLE_HOME\rdbms\admin\ca...
ORA-00704: bootstrap process failure ORA-39700:databasemust be openedwithUPGRADEoptionProcess ID:15638Session ID:191Serialnumber:1 以STARTUP UPGRADE启动实例 执行catupgrd.sql脚本修改数据字典即可,执行时间较长请耐心等待。 SQL>startup upgrade; SQL>@?/rdbms/admin/catupgrd.sql; SQL>@?/rdbms/admin/cata...
ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option 进程ID: 292 会话ID: 191 序列号: 1 SQL> !oerr ora 39700 39700, 00000, "database must be opened with UPGRADE option" // *Cause: A normal database open was attempted, but the database has not ...
ORA-39700: database must be opened with UPGRADE option 3. 查看数据库版本为:10.2.0.5.0,应该是他们做过数据库的升级而没有执行这个脚本造成的 $ORACLE_HOME\rdbms\admin\catupgrd.sql; 4.linux下处理过程很简单 startup upgrade; @$ORACLE_HOME\rdbms\admin\catupgrd.sql; ...
ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option 进程ID: 292 会话ID: 191 序列号: 1 SQL> !oerr ora 39700 39700, 00000, "database must be opened with UPGRADE option" // *Cause: A normal database open was attempted, but the database has not...
ORA-00704: bootstrap process failure ORA-39700: database must be opened with UPGRADE option 进程ID: 3650 会话ID: 292 序列号: 5 问题原因:进行数据库报错的时候才突然想起犯了一个错误原数据库的版本是11.2.0.1,但是目标数据库的版本是11.2.0.3,所以在打开的时候就提示了0RA-39700。
ORA-00704: 引导程序进程失败 ORA-39700: 必须用 UPGRADE 选项打开数据库 Tue Dec 10 09:33:57 2013 Error 704 happened during db open, shutting down database USER: terminating instance due to error 704 Tue Dec 10 09:33:57 2013 Errors in file d:\oracle\product\10.2.0\admin\orcl...
ORA-00704: bootstrap process failureORA-39700: database must be opened with UPGRADE option The following is observed in the sqlplus session Changes The database was recently upgraded from 11.2.0.1 to 11.2.0.2 Cause Sign In To view full details, sign in with your My Oracle Support account....
ORA-39700: database must be opened with UPGRADE option 进程ID: 292 会话ID: 191 序列号: 1 错误概述:说明需要运行这些数据字典脚本,主要原因是升级以后数据字典的一些基表的内容修改了 C:\>sqlplus / as sysdba SQL*Plus: Release 11.2.0.3.0 Production on 星期四 11月 28 16:06:03 2013 ...