-
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
Hello guys..
I just moved into this new job and inherited this problem when i started the database.
======================
SQL> startup
ORACLE instance started.
Total System Global Area 303532544 bytes
Fixed Size 731648 bytes
Variable Size 285212672 bytes
Database Buffers 16777216 bytes
Redo Buffers 811008 bytes
Database mounted.
ORA-01092: ORACLE instance terminated. Disconnection forced
==================================
so, i went into alert log and saw this...
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
so, i changed the pfile and changed undo_management from AUTO to MANUAL and started the database. Database started fine. So then, i deleted the old UNDO that is creating the problems, and created a new UNDO, and shutdown the database.
Then, I went and changed the pfile and changed the undo_management from MANUAL to AUTO and started the database.
Its giving the same error....
any help ?
thanks for help
Ron
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|