Oracle version is : 22.214.171.124
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 dbms_server_alert.set_threshold(:metrics_id, ,:warning_operator, :warning_value, :critical_operator, :critical_value, 1, :consecutive_occurrences, :instance_name, :object_type, :object_name); END;
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?