GoldenGate, Streams and Distributed Database (MOSC)

MOSC Banner

Use xstream,0RA-26824 error

my environment:19.7 RAC database for linux

 GRANT CREATE SESSION, SET CONTAINER TO c##dbzadmin CONTAINER=ALL;


 BEGIN

   DBMS_XSTREAM_AUTH.GRANT_ADMIN_PRIVILEGE(

    grantee         => 'c##dbzadmin',

    privilege_type     => 'CAPTURE',

    grant_select_privileges => TRUE,

    container        => 'ALL'

   );

 END;

 /


DECLARE

 tables DBMS_UTILITY.UNCL_ARRAY;

 schemas DBMS_UTILITY.UNCL_ARRAY;

BEGIN

  tables(1) := 'CB';

  schemas(1) := 'BDCSX_GZ';

 DBMS_XSTREAM_ADM.CREATE_OUTBOUND(

  server_name   => 'dbzxout_BDCSX_GZ',

  table_names   => tables,

  schema_names  => schemas);

END;


BEGIN

 DBMS_XSTREAM_ADM.ALTER_OUTBOUND(

  server_name => 'dbzxout_BDCSX_GZ',

  connect_user => 'c##logminer');

END;


应用查不到增量数据,并且出现0RA-26824:用户定义的XStream回调错误,oracle metalink查不到ora-26824


alert.log会出现ORA-03111:

2022-05-13T14:06:00.756911+08:00

XStream CAPTURE CAP$_DBZXOUT_BDCSX_GZ_37: First SCN: 16862956648531 (0x368a7853.00000f56)

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center