Connector config - 

curl -i -X POST -H "Accept:application/json" -H "Content-Type:application/json" \
    http://localhost:8083/connectors/ -d '{
  "name": "debezium-ora-001",
  "config": {
    "connector.class": "io.debezium.connector.oracle.OracleConnector",
    "tasks.max": "1",
    "topic.prefix": "server1",
    "database.server.name": "ip-10-0-23-62",
    "database.tablename.case.insensitive":"true",
    "database.hostname": "3.93.192.48",
    "database.port": "1623",
    "database.user": "dbzuser",
    "database.password": "SysPassword1",
    "database.dbname": "logstby",
    "schema.include.list": "LOCAL",
    "table.include.list": "LOCAL.CUSTOMER_ORDER,LOCAL.CUSTOMER_ORDER_ITEM,LOCAL.REGIONS",
    "schema.history.internal.kafka.bootstrap.servers": "localhost:9092",
    "schema.history.internal.kafka.topic": "debezium.oracle",
    "database.connection.adapter": "logminer",
    "internal.log.mining.read.only": "true"
  }
}'


Result - 

HTTP/1.1 201 Created
Date: Thu, 23 May 2024 10:56:02 GMT
Location: http://localhost:8083/connectors/debezium-ora-001
Content-Type: application/json
Content-Length: 744
Server: Jetty(9.4.53.v20231009)

{"name":"debezium-ora-001","config":{"connector.class":"io.debezium.connector.oracle.OracleConnector","tasks.max":"1","topic.prefix":"server1","database.server.name":"ip-10-0-23-62","database.tablename.case.insensitive":"true","database.hostname":"3.93.192.48","database.port":"1623","database.user":"dbzuser","database.password":"SysPassword1","database.dbname":"logstby","schema.include.list":"LOCAL","table.include.list":"LOCAL.CUSTOMER_ORDER,LOCAL.CUSTOMER_ORDER_ITEM,LOCAL.REGIONS","schema.history.internal.kafka.bootstrap.servers":"localhost:9092","schema.history.internal.kafka.topic":"debezium.oracle","database.connection.adapter":"logminer","internal.log.mining.read.only":"true","name":"debezium-ora-001"},"tasks":[],"type":"source"}