Using Debezium Connector for Oracle with LogMiner and without XSTREAM-CodePudding

I am trying to create a connector for oracle using LogMiner adapter. I preconfigured my oracle db in that way. My dockerfile

FROM store/oracle/database-enterprise:12.2.0.1

# creating directory inside the container, where all sql scripts will be locaited
#WORKDIR /home/oracle/setup/custom_scripts

WORKDIR /opt/oracle/oradata

WORKDIR /opt/oracle/oradata/recovery_area

WORKDIR /opt/oracle/oradata/ORCLCDB
WORKDIR /opt/oracle/oradata/ORCLCDB/ORCLPDB1/

WORKDIR /u01/app/oracle/product/12.2.0/dbhome_1/inventory
WORKDIR /u01/app/oracle/product/12.2.0/dbhome_1/bin

#Running my custom scripts
COPY configDBora.sh /home/oracle/setup/

RUN chgrp 54321 /opt/oracle/oradata
RUN chown 54321 /opt/oracle/oradata

RUN chgrp 54321 /opt/oracle/oradata/recovery_area
RUN chown 54321 /opt/oracle/oradata/recovery_area

RUN chgrp 54321 /u01/app/oracle/product/12.2.0/dbhome_1/inventory
RUN chown 54321 /u01/app/oracle/product/12.2.0/dbhome_1/inventory

RUN chgrp 54321 /u01/app/oracle/product/12.2.0/dbhome_1/bin
RUN chown 54321 /u01/app/oracle/product/12.2.0/dbhome_1/bin

My configDBora.sh based on

When I try to insert into any of this table on oracle db there is no capture of insert (or update) query. Who can tell me where have I gone wrong ? I really need help over this question.

CodePudding user response：

The first step that I decided to do moving my DB to Oracle 19c Enterprise Edition. I added setup-logminer.sh from my

3. I moved my DB from CDB to PDB because it's bad to work in CDB. You have to use pluggable database.

{
...
    "table.include.list": "DEBEZIUM.*",
...
}