October 31 2014

ORA-06512SYS.DBMS_SERVER_ALERT

操作:Configure an alert on the SYSTEM tablespace of the PROD database. The alert should register as a warning at 87% full and critical at 95% full

 

报错信息:

SQL> exec DBMS_SERVER_ALERT.SET_THRESHOLD(9000,4,’85’,4,’97’,1,1,NULL,5,’SYSTEM’);
BEGIN DBMS_SERVER_ALERT.SET_THRESHOLD(9000,4,’85’,4,’97’,1,1,NULL,5,’SYSTEM’); END;

*
ERROR at line 1:
ORA-13914: Threshold notification failed.
ORA-06512: at “SYS.DBMS_SERVER_ALERT”, line 4
ORA-06512: at line 1

解决方法:

@?/rdbms/admin/catproc.sql   重新执行一下
SQL> exec DBMS_SERVER_ALERT.SET_THRESHOLD(9000,4,’85’,4,’97’,1,1,NULL,5,’SYSTEM’);

PL/SQL procedure successfully completed.

 

 

note:

sqlplus / as sysdba
@?/rdbms/admin/catalog.sql 建数据字典视图
@?/rdbms/admin/catproc.sql 存储过程包
@?/rdbms/admin/catblock.sql 建锁相关的几个视图
@?/rdbms/admin/catoctk.sql 建密码工具包dbms_crypto_toolkit
@?/rdbms/admin/catexp7.sql 同上
@?/rdbms/admin/owminst.plb 建工作空间管理相关对象, 如dbms_wm
sqlplus system/oracle
@?/sqlplus/admin/pupbld.sql
@?/sqlplus/admin/help/hlpbld.sql helpus.sql



Copyright 2019. All rights reserved.

Posted 2014年10月31日 by ucjmh in category "oracle

Leave a Reply

Your email address will not be published. Required fields are marked *