ORA-01092: ORACLE instance terminated. Disconnection forced问
升级数据字典,解决ORA-01092: ORACLE instance terminated. Disconnection forced问题。
升级数据字典,,解决ORA-01092: Oracle instance terminated. Disconnection forced问题。
在Oracle 实例关闭的情况下,Oracle 软件从10.2.0.1 升级到 10.2.0.5 之后,存在的数据库也要升级。
此时启动实例会报错 ORA-01092: ORACLE instance terminated. Disconnection forced
SQL> alter database open;
ERROR at line 1:
ORA-01092: ORACLE instance terminated. Disconnection forced
第一步,通过startup upgrade启动实例
SQL> startup upgrade;
ORACLE instance started.
Total System Global Area 322961408 bytes
Fixed Size 2095992 bytes
Variable Size 100664456 bytes
Database Buffers 213909504 bytes
Redo Buffers 6291456 bytes
Database mounted.
Database opened.
第二步,升级数据字典和实例等。
SQL>@ORACLE_HOME\rdbms\admin\catupgrd.sql
推荐阅读
-
ORA-01092 oracle instance terminated disconnection forced问题解决办法
-
ORA-01092: ORACLE instance terminated. Disconnection forced问
-
Oracle 10g升级后启动失败(Oracle instance terminated. Disconnection
-
ORA-01092 oracle instance terminated disconnection forced问题解决办法
-
Oracle 10g升级后启动失败(Oracle instance terminated. Disconnection