How to recreate the SYS.ALERT_QUE [ID 430146.1]

In this Document
  Goal
  Solution
  References

---

Applies to:

Oracle Server - Enterprise Edition - Version: 10.2.0.1 to 10.2.0.4 - Release: 10.2 to 10.2
Information in this document applies to any platform.
***Checked for relevance on 25-Jan-2011***

Goal

The purpose of this article is to outline the steps for recreating the SYS.ALERT_QUE 

The ALERT_QUE is used by the Grid Control and DB Control Management Agents to monitor server-generated alerts 

NOTE: 
By running the script. below, the queue tables will be recreated and the messages 
in the queue will be lost.

For 11g you can use catmwin.sql which has the steps to recreate the ALERT_QT. 
Alternatively, for 11g you can use the catproc.sql to recreate.  

Solution

SQL> connect / as sysdba

SQL>alter system enable restricted session;

To drop server alert schema.

SQL>@$ORACLE_HOME/rdbms/admin/catnoalr.sql

To re-create tables, sequence, type and queue for server alert

SQL>@$ORACLE_HOME/rdbms/admin/dbmsslrt.sql
SQL>@$ORACLE_HOME/rdbms/admin/catalrt.sql

To recompile the invalid objects

SQL>@$ORACLE_HOME/rdbms/admin/utlrp.sql

SQL> alter system disable restricted session; 

 

Note: This option may leave DBSNMP.MGMT_BSLN_INTERNAL invalid. To validate the same run catsnmp.sql

OR

SQL> connect / as sysdba

SQL>alter system enable restricted session;

To drop server alert schema.

SQL>@$ORACLE_HOME/rdbms/admin/catnoalr.sql

Rerun catproc.sql

SQL>@$ORACLE_HOME/rdbms/admin/catproc.sql

SQL> alter system disable restricted session; 

References

NOTE:603289.1 - OBJECTS MGMT_BSLN_INTERNAL and MGMT_BSLN INVALID FOR DBSNMP

Related

Products

• Oracle Database Products > Oracle Database > Oracle Database > Oracle Server - Enterprise Edition > RDBMS > Advanced Queuing

Keywords

CATPROC.SQL; DB CONTROL; GRID CONTROL; INVALID OBJECT; MANAGEMENT AGENT; OUTLINE; RESTRICTED; UTLRP.SQL

Back to Top

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/38267/viewspace-752100/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/38267/viewspace-752100/