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)