Oracle: ORA-01092: ORACLE instance terminated. Disconnection forced

После обновления Oracle Database с версии 10.2.0.1 до версии 10.2.0.4 возникает ошибка «ORA-01092: Oracle instance terminated. Disconnection forced.»

$ sqlplus /nolog
SQL> conn / as sysdba
Connected to an idle instance.
SQL> startup
ORACLE instance started.

Total System Global Area 188743680 bytes
Fixed Size 778036 bytes
Variable Size 162537676 bytes
Database Buffers 25165824 bytes
Redo Buffers 262144 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced

Исправить можно так:

cd $ORACLE_HOME/rdbms/admin
sqlplus / as sysdba
SQL>startup upgrade;
SQL>@catupgrd.sql
SQL>shutdown immediate;
SQL>startup;
SQL>@utlrp.sql

[wysija_form id=»2″]