После обновления 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