0 Replies Latest reply: Mar 6, 2013 9:43 AM by Arturo Gutierrez RSS

    ORA-13900: Disabling a server Alert

    Arturo Gutierrez
      Hello,
      I'm trying to disable the BLOCKED_USERS alert with this error:


      exec DBMS_SERVER_ALERT.SET_THRESHOLD(WARNING_OPERATOR => DBMS_SERVER_ALERT.OPERATOR_DO_NOT_CHECK,metrics_id => 4000, warning_value => '0', CRITICAL_OPERATOR => DBMS_SERVER_ALERT.operator_do_not_check, critical_value => '0', observation_period => 1, consecutive_occurrences => 1, INSTANCE_NAME =>NULL, OBJECT_TYPE => DBMS_SERVER_ALERT.OBJECT_TYPE_SESSION, OBJECT_NAME => NULL);

      *
      ERROR at line 1:
      ORA-13900: missing or invalid parameter warning operator
      ORA-06512: at "SYS.DBMS_SERVER_ALERT", line 4
      ORA-06512: at line 1


      Any know why this erro?
      Many Thanks
      Arturo