streams RSE$CLEAN_RECOVERABLE_SCRIPT and SM$CLEAN_AUTO_SPLIT_MERGE new jobs, when using streams setup between 11.2 and below RDBMS (Doc ID 1533923.1)

Last updated on NOVEMBER 02, 2016

Applies to:

Oracle Database - Enterprise Edition - Version 11.2.0.1 and later
Information in this document applies to any platform.

Symptoms

Daily it is reported:

dbms_reco_script_int.sys_purge: exception, sql code = -6550, error message: ORA-06550: line 1, column 8:
PLS-00201: identifier 'DBMS_STREAMS_RPC.DROP_SCRIPT@BISTREAM.HEALTHOTAGO.CO.NZ' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
Errors in file /u01/oracle/diag/rdbms/hcodat/hcodat/trace/hcodat_j000_17937.trc:
ORA-12012: error on auto execute of job "SYS"."RSE$CLEAN_RECOVERABLE_SCRIPT"
ORA-06550: line 1, column 8:
PLS-00201: identifier 'DBMS_STREAMS_RPC.DROP_SCRIPT@BISTREAM.HEALTHOTAGO.CO.NZ' must be declared
ORA-06550: line 1, column 8:
PL/SQL: Statement ignored
ORA-06512: at "SYS.DBMS_RECO_SCRIPT_INT", line 290
ORA-06512: at "SYS.DBMS_RECOVERABLE_SCRIPT", line 135
ORA-06512: at "SYS.DBMS_STREAMS_AUTO_INT", line 2781
ORA-06512: at line 1

Changes

 streams configuration between 11.2 and below RDBMS

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