Streams "Persistent Queue State" Metric Collection Error Ora-1031 Using Enterprise Manager (Doc ID 550437.1)

Last updated on FEBRUARY 08, 2017

Applies to:

Oracle Database - Enterprise Edition - Version 10.1.0.4 to 11.2.0.2 [Release 10.1 to 11.2]
Information in this document applies to any platform.
***Checked for relevance on 21-Jul-2011***


Symptoms

Using Oracle Enterprise Manager  to get information for the metric "Streams Propagation - Persistent Queue State" from a database gives an insufficient privileges error message - ORA-01031 -

=== Collection Error Full Description ===
Target production.com
Type Database Instance
Metric Streams Propagation - Persistent Queue State
Collection Timestamp Dec 11, 2007 4:22:00 PM
Error Type Collection Failure
Message ORA-01031: insufficient privileges ORA-06512: at line 18

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms