Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

Oracle version is :

I have created alerting on every error occurring in database, and in this alert log I've found the following errors

ORA-13901: Object UNDOTBS01 was not found.
ORA-06512: at "SYS.DBMS_SERVER_ALERT", line 7
ORA-06512: at line 1

Username: DBSNMP 

,:warning_operator, :warning_value,                                          
:critical_operator, :critical_value, 
:object_type, :object_name);          

This error is repeating every 30-60 minutes.

Yesterday, I've created undo tablespace called UNDOTBS01, tried to assign it to the parameter undo_tablespace.

alter system set undo_tablespace=UNDOTBS01

Got the following error:

ORA-02097: parameter cannot be modified because specified value is invalid
ORA-30015: previously offlined undo tablespace 'UNDOTBS1' is still pending

After that I dropped the UNDOTBS01 tablespace.

drop tablespace UNDOTBS01;

It was dropped.

I don't know what is causing the error and how to solve?

share|improve this question
You really need to patch your database - was buggy. Is the error still happening now that the tablespace has been dropped? – Phil Feb 4 '14 at 7:53
@Phil I have the full installation of Can I upgrade my database using this installation? Or do I need to download the patch? Is the patch software different from the fresh installation? Does runInstaller of the fresh installation have the option like upgrade? And is the patch(> different from the patch( to – kupa Feb 5 '14 at 13:06

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.