Re: [debezium] Settings OpenLogReplicator

[Chris Cranford]

Hi -

It seems you may be supplying the database name rather than the service name in the OpenLogReplicator configuration. 
Please check that you're supplying the right value.

Additionally, let me as is this Oracle instance using Oracle Automatic Storage Management (ASM) or Oracle Real Application Clusters (RAC)?
If the answer to either of these is Yes, OpenLogReplicator isn't an option as it doesn't support either of these.

Thanks,
-cc

On 12/8/25 9:45 AM, Vladislav P wrote:

Good afternoon.

Help with setting up OpenLogReplicator.
Launching the following container (OpenLogReplicator):

```
open-log-replicator:
    image: hgneon/openlogreplicator:1.8.5
    container_name: open_log_replicator
    ports:
      - "12435:8080"
    volumes:
      - ./openlogreplicator/checkpoint:/opt/OpenLogReplicator/checkpoint
      - ./openlogreplicator/fra:/opt/fra
      - ./openlogreplicator/log:/opt/OpenLogReplicator/log
      - ./openlogreplicator/oradata:/opt/oradata
      - ./openlogreplicator/output:/opt/output
      - ./openlogreplicator/scripts:/opt/OpenLogReplicator/scripts
```

Debezium-connect using the image: quay/debezium/connect:3.3.1.Final
The following file is located on the path of openlogreplicator/scripts:

```
{
"version": "1.8.5",
"source": [{
"alias": "SOURCE",
"name": "ORACLE",
"reader": {
"type": "online",
"path-mapping": [],
"user": "...",
"password": "...",
"server": "//IP(example 10.10.10.100):1521/dbname"
},
"format": {
"type": "json",
"message": 2,
"xid": 0,
"column": 2,
"db": 3,
"timestamp": 0,
"timestamp-tz": 0,
"interval-dts": 9,
"interval-ytm": 4,
"char": 0,
"scn": 0,
"scn-type": 1,
"rid": 1,
"unknown": 0,
"schema": 7,
"unknown-type": 0,
"timestamp-all": 1,
"flush-buffer": 1048576
}
}],
"target": [{
"alias": "TEST",
"source": "SOURCE",
"writer": {
"type": "file",
"output": "/tmp/file_%i.json",
"new-line": 1,
"append": 0,
"max-file-size": 10485760
}
}]
}
```

Target should have a type network, but there are still problems with it. So far, I've decided to test it on file.


At startup, I see an error in the open-log-replicator container:

2025-12-08 13:51:09 ERROR 10051 OCI: [ORA-12504: TNS:listener was not given the SERVICE_NAME in CONNECT_DATA]

If you connect to the database through other means, then everything works.



--
You received this message because you are subscribed to the Google Groups "debezium" group.
To unsubscribe from this group and stop receiving emails from it, send an email to debezium+u...@googlegroups.com.
To view this discussion visit https://groups.google.com/d/msgid/debezium/e4f84d69-d387-4307-9f29-f8d2fd527e99n%40googlegroups.com.

[Vladislav P]

Hi Chris, thanks for responding.
Yes, we use Oracle Real Application Clusters (RAC).

But what's interesting is that when I changed the config as follows, I saw another error in the console.  It turns out that he was able to connect to the database.

"reader": {
"type": "online",
"path-mapping": [

"/u_ora/data1/test", "/opt/oradata",
"/u_ora/data2/test  ", "/opt/oradata",
"/u_ora/arch", "/opt/fra"

],
"user": "...",
"password": "...",

"server": "(DESCRITION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP>)(PORT=1521)))(CONNECT_DATA=(SERVICE=DEDICATED)(SERVICE_NAME=<service_name>)))"
}
ERROR: 
2025-12-08 20:23:24 INFO 00000 OpenLogReplicator v1.8.5 (C) 2018-2025 by Adam Leszczynski (), see LICENSE file for licensing information
2025-12-08 20:23:24 INFO 00000 arch: x86_64, build-arch: , system: Linux, release: 6.1.0-9-amd64, build: Debug, compiled: 2025-08-14 19:03, modules: Kafka OCI Prometheus Protobuf
2025-12-08 20:23:24 INFO 00000 adding source: SOURCE
2025-12-08 20:23:24 INFO 00000 adding target: TEST
2025-12-08 20:23:24 INFO 00000 next number for /tmp/file_%i.json is: 0
2025-12-08 20:23:24 INFO 00000 writer is starting with Writer: file:/tmp/file_%i.json
2025-12-08 20:23:24 WARN 10003 file: checkpoint/ORACLE-chkpt.json - get metadata returned: No such file or directory
2025-12-08 20:23:24 INFO 00000 connecting to the database instance of ORACLE to (DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=<IP>)(PORT=1521)))(CONNECT_DATA=(SERVICE=DEDICATED)(SERVICE_NAME=<DBNAME>)))
2025-12-08 20:23:24 INFO 00000 version: Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production, context: <test>, resetlogs: 0, activation: 0, con_id: 0, con_name: <dbname>
2025-12-08 20:23:24 WARN 60026 stripping trailing '/' from db_recovery_file_dest parameter; new value: /u_ora/arch
2025-12-08 20:23:24 INFO 00000 loading character mapping for CL8MSWIN1251
2025-12-08 20:23:24 INFO 00000 loading character mapping for UTF8
2025-12-08 20:23:24 ERROR 10003 file: /opt/oradata/redo_1_01.log - get metadata returned: No such file or directory
2025-12-08 20:23:24 HINT check mapping, failed to read: /u_ora/data1/test/redo_1_01.log mapped to: /opt/oradata/redo_1_01.log run as uid: 1000 gid: 54322
2025-12-08 20:23:24 HINT - path: /opt/oradata/redo_1_01.log - get metadata returned: No such file or directory
2025-12-08 20:23:24 HINT - path: /opt/oradata - type: directory permissions: 40755 uid: 0 gid: 0
2025-12-08 20:23:24 HINT - path: /opt/oradata - can be listed but does not contain: redo_1_01.log
2025-12-08 20:23:24 HINT - path: /opt - type: directory permissions: 40755 uid: 0 gid: 0
2025-12-08 20:23:24 ERROR 10027 can't read any member of group 1
2025-12-08 20:23:24 INFO 00000 Replicator for: ORACLE is shutting down
2025-12-08 20:23:24 INFO 00000 Memory HWM: 32MB, builder HWM: 1MB, misc HWM: 0MB, parser HWM: 0MB, disk read buffer HWM: 0MB, transaction HWM: 0MB, swapped: 0MB, disk write buffer HWM: 1MB
2025-12-08 20:23:24 INFO 00000 writer is stopping: file:/tmp/file_%i.json, hwm queue size: 0

понедельник, 8 декабря 2025 г. в 19:43:59 UTC+4, Chris Cranford:

[Chris Cranford]

Hi -

The issue isn't connecting to the database, the issue is that it needs to weave transaction changes across multiple redo threads, which are maintained in multiple files in multiple physical destinations.
As I said, unfortunately OLR is not yet compatible with Oracle RAC.

-cc

To view this discussion visit https://groups.google.com/d/msgid/debezium/19aa9358-1d8b-484a-9740-a4de14af85abn%40googlegroups.com.