ODBC Gateway for oracle xe 18c docker image

[GAHila]

QUESTION: Has anyone made the docker image provided by oracle work with an ODBC Gateway to a postgres database?

Here is the image provided by Oracle: https://github.com/oracle/docker-images/tree/main/OracleDatabase/SingleInstance/dockerfiles/18.4.0

and I followed a few guides how to set it up. However I can make ODBC connection work but do not see the SID in lsnrctl status.

Wondering if that image has customization that would not allow that. I followed these guides to configure it: https://dbsguru.com/steps-to-create-a-database-link-from-oracle-to-postgresql/. https://www.enterprisedb.com/postgres-tutorials/how-configure-heterogeneous-connections-oracle-postgresql

My changes were all inside a running container and if I could get it to work for testing purposes. I can provide more details on what I have configured if this will help but first wondering if this is possible at all with this image.

[jatinTyagi98]

I want to work on it. /assign

[jatinTyagi98]

@GAHila can you give some more context to the issue ?