ORA-01092 & ORA-30040
ORA-01092 & ORA-30040
·
Mount the database.
·
Create a pfile from spfile to a desired
location. For example CREATE PFILE = ‘f:\temp\test\initorcl.ora’ from spfile;
·
Edit the pfile and give an online tablespace *.undo_tablespace='UNDOTBS3'
already existing.
·
Start the database with this new Pfile, for
example STARTUP PFILE=’F:\TEMP\TEST\initorcl.ora’
·
Create spfile from the new pfile settings loaded
using the command “CREATE SPFILE FROM PFILE;”
·
Bounce the database.
Comments
Post a Comment