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 18.104.22.168 [Release 10.2 to 11.2]
Information in this document applies to any platform.
When you try to run DBMS_STREAMS_ADVISOR_ADM.ANALYZE_CURRENT_PERFORMANCE for 10gR2 database from 11g database, you get ORA-23605
component_name => '<COMPONENT_NAME>',
component_db => '<COMPONENT_DB>',
component_type => 1);
ERROR at line 1:
ORA-23605: invalid value "<COMPONENT_NAME>" for STREAMS parameter
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
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 .
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