My Oracle Support Banner

DBMS_STREAMS_ADVISOR_ADM.ANALYZE_CURRENT_PERFORMANCE erroring with ORA-23605 (Doc ID 988332.1)

Last updated on MARCH 02, 2020

Applies to:

Enterprise Manager for Oracle Database - Version 10.2.0.4 to 11.2.0.1 [Release 10.2 to 11.2]
Information in this document applies to any platform.

Symptoms


When you try to run DBMS_STREAMS_ADVISOR_ADM.ANALYZE_CURRENT_PERFORMANCE for 10gR2 database from 11g database, you get ORA-23605

Begin
DBMS_STREAMS_ADVISOR_ADM.ANALYZE_CURRENT_PERFORMANCE(
component_name => '<COMPONENT_NAME>',
component_db => '<COMPONENT_DB>',
component_type => 1);
end;
/

begin
*
ERROR at line 1:
ORA-23605: invalid value "<COMPONENT_NAME>" for STREAMS parameter
canon_component_name
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 82
ORA-06512: at "SYS.DBMS_LOGREP_UTIL", line 125
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL", line 4875
ORA-01403: no data found
ORA-06512: at "SYS.DBMS_STREAMS_ADV_ADM_UTL_INVOK", line 1797
ORA-06512: at "SYS.DBMS_STREAMS_ADVISOR_ADM", line 83
ORA-06512: at line 2



OR

You are trying to use 11gR1 database with OEM Grid Control 10gR5 to manage/monitor Streams on several 10gR2 databases.
However, in Grid Control 10.2.0.5 (which has the patch 8445475) the 11gR1 database does not show all 10gR2 Streams databases which you have configured to monitor .

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.