| vikas |
Posted: Nov 05, 2007 07:03:08 AM |
Total Post: 5
Joined: Aug, 2007
|
Hi,
while opening the database I am getting following error message
ORA-01092: ORACLE instance terminated. Disconnection forced
after analyzing alert file found below error message
ORA-30012: undo tablespace 'UNDO' does not exist or of wrong type.
How should I check the same.
In pfile undo parameter is set to undo_tablespace=UNDO
please help me resove this issue.
Thanks in advance.
Regards,
Vikas J |
|
|
 vikas |
| Posted: Nov 05, 2007 08:12:04 AM |  |
|
Total Post: 5
Joined: Aug, 2007
|
Thanks I resolved the issue
|
|
|
|
|
| Mohammed Taj |
| Posted: Nov 07, 2007 10:36:17 AM | |
|
Total Post: 746
Joined: Jul, 2007
|
It is better if you also post solution.
May be it is happen becuase database content different undo tablespace name then init.ora file.
there is two types of file
spfile
pfile --- always edit only pfile but forget to recreate spfile so whenever database instance startup using default spfile use old undo tablespace name and database give error and goes down.
|
|
|
|
|
| vikas |
| Posted: Nov 20, 2007 05:38:27 AM | |
|
Total Post: 5
Joined: Aug, 2007
|
you are absolutly right mohamad.
This issue is due to undotbs not properly define.
Same is rectifed by starting database with pfile in mount stage
and created proper undotbs.
thanks,
Vikas J
|
|
|
|
|
| Time Zone: EDT |
Send this thread to your friend |
