here's my situation. I am recreating my database. I exported dumps from an 8.1.6 database and imported it into my 22.214.171.124 oracle database. After the import was complete, I copied my datafiles and recreate control files to point to my datafiles location.
I managed to pen it up to mount stage, but when i tried to alter database open i got:
ORA-01092: Oracle instance terminated. Disconnection forced.
and in the alert log i found:
ORA-30012: undo tablespace 'UNDOTBS1' does not exist or of wrong type
i tried to set my undo_management to MANUAL and startup with the pfile but it doesnt seem to work. the error still persist.
thanks for the reply. I tried commenting the UNDO parameters in the pfile and starting up the database with that pfile, but the error still persist. Unfortunately, now i am having an ora-600 error. Will look for clues at metalink.
i was trying to bring up my oracle database in a new server. Actually, i had successfully brought up a few database servers before with the same procedure. The only difference this time is that I am importing into a higher oracle version i.e. 126.96.36.199 on a Windows 2003 Server.
And honestly, a few weeks ago I had successfully bring up a database on a test workstation with this scenario and it worked. Up and running. That is why i am trying to find a solution to my problem now, because it worked before. I am a newbie, only touched oracle for only about a year now. Thanks for your relplies