[Undo tablespace problem caused] ORA-01092: Oracle instance terminated. Disconnection forced

1. Start the database and report an error.

SQL> startup
Oracle instance started.

Total system global area 1076851960 bytes
Fixed size 738552 bytes
Variable Size 285212672 bytes
Database buffers 788529152 bytes
Redo buffers 2371584 bytes
Database mounted.
ORA-01092: Oracle instance terminated. Disconnection forced

2. view log files

Tue Dec 19 09:32:01 2006
Errors in file/Oracle/admin/udump/ora9i_ora_5070.trc:
ORA-30012: Undo tablespace 'undotbs' does not exist or of wrong type
Tue Dec 19 09:32:01 2006
Error 30012 happened during dB open, shutting down Database
User: Terminating instance due to error 30012.
Instance terminated by user, pid = 5070
ORA-1092 signalled during: Alter database open...

3. An error is reported when the tablespace is rolled back. Check the information of the tablespace to be rolled back.

SQL> startup Mount
Oracle instance started.

Total system global area 1076851960 bytes
Fixed size 738552 bytes
Variable Size 285212672 bytes
Database buffers 788529152 bytes
Redo buffers 2371584 bytes
Database mounted.

SQL> select name from V $ datafile;

Name
--------------------------------------------------------------------------------
/Oracle/oradata/ora9i/system01.dbf
/Oracle/oradata/ora9i/tbs_users.dbf
/Opt/oradata/users. BDF
/Opt/oradata/misc16.dbf
/Opt/oradata/data_history.dbf
/Oracle/oradata/ora9imocstdata. DBF
/Oracle/oradata/ora9i/undo_tbs_01.dbf
/Oracle/oradata/ora9i/tbs_misc16.dbf
/Oracle/oradata/ora9i/system02.dbf
/Oracle/oradata/ora9i/index. DBF
/Oracle/oradata/ora9i/perfstat. DBF

SQL> show parameter undo

Name type value
----------------------------------------------------------------------------------------
Undo_management string auto
Undo_retention integer 10800
Undo_suppress_errors Boolean false
Undo_tablespace string undotbs

SQL> select name from V $ tablespace;

Name
------------------------------------------------------------
System
Undo_tbs
Temp
Users
Ts_misc16
Data_history
Mocstdata
Index
Perfstat
Mocsdata

It is found that the name of the Undo tablespace is undo_tbs instead of undotbs.

4. Modify initora9i. ora

Set *. undo_tablespace = 'undo _ TBS'

5. Restart

SQL> Shutdown
ORA-01109: Database not open

Database dismounted.
Oracle instance shut down.
SQL> startup Mount
Oracle instance started.

Total system global area 1076851960 bytes
Fixed size 738552 bytes
Variable Size 285212672 bytes
Database buffers 788529152 bytes
Redo buffers 2371584 bytes
Database mounted.
SQL> alter database open;

Database altered.

SQL> show parameter undo

Name type value
----------------------------------------------------------------------------------------
Undo_management string auto
Undo_retention integer 10800
Undo_suppress_errors Boolean false
Undo_tablespace string undo_tbs

6. Problem Solving