Home » Infrastructure » Windows » ORA-01092 error starting database (urgent, please)
ORA-01092 error starting database (urgent, please) [message #101105] Tue, 04 May 2004 00:17 Go to next message
Giuseppe Garzotto
Messages: 8
Registered: November 2002
Junior Member
Hello everybody,

Oracle 9i on Windows 2000 SP4.

Due to a scandisk, the undo tablespace's datafile
result corrupt and now it have size 0.
So, my Oracle Server doesn't start completely.

Looking for a solutions in various internet forums, I
perform the following action:

E:> sqlplus /nolog
SQL> connect / as sysdba
SQL> shutdown abort
SQL> startup
SQL> alter database datafile 'e:oracleora92orclundotbs01.dbf' offline drop;
SQL> shutdown
SQL> startup

At the end of startup, the database is mounted but I
get an ORA-01092: ORACLE instance terminated. Forced
disconnection error.

I try to recreate the undo tablespace with a command
similar to the one found in createdb.sql, but the
database is not open, so the command wasn't accepted.

I also try, after reading this,

http://www.dbasupport.com/oracle/ora9i/undo.shtml

to put undo_management=MANUAL and undo_tablespace=
in the init.ora file, but I get back the same error.

My question is: it is possible to start the database
without the undo tablespace, and then recreate the
undo tablespace when the database is started ?

Thanks a lot in advice

Giuseppe Garzotto
Re: ORA-01092 error starting database (urgent, please) [message #101233 is a reply to message #101105] Wed, 30 June 2004 01:13 Go to previous messageGo to next message
JOY PATEL
Messages: 1
Registered: June 2004
Junior Member
Just stop and restart your oracle 8i Instance service.This is practically accepted solution.
I hope it work.
Best luck !

enjoy.
Re: ORA-01092 error starting database (urgent, please) [message #101347 is a reply to message #101105] Sat, 21 August 2004 14:34 Go to previous message
Stephen
Messages: 26
Registered: January 2000
Junior Member
I got the same trouble.
It took me about two days to bring
it back.

Here is the way.
1. recover the undo tablespace datafile . I was promp for log file options: filename,
auto, cancel. after try all of these I just
hit the return, I got recover completed.

After that I still got same error when I try to open the database.

I almost gived it up. Then I tried this.

startup mount

SQL> alter database datafile 'F:ORACLEORADATAMP415UNDOTBS01.DBF' online

Database altered.

SQL> select name, status from v$datafile;

NAME
---------------------------------------------------------------------------

STATUS
-------
F:ORACLEORADATAMP415SYSTEM01.DBF
SYSTEM

F:ORACLEORADATAMP415UNDOTBS01.DBF
ONLINE
........

11 rows selected.

SQL> alter database open;

Database altered.

If you have any question send me a email.
good luck!
Previous Topic: Urgent
Next Topic: problem when installing personal oracle 8i on windows 98
Goto Forum:
  


Current Time: Thu Mar 28 10:39:07 CDT 2024