FATAL: 12541 ... ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)

[ria-ops]

Tried following the steps and run the docker on local, having oracle DB connected on Docker and used the credentials of docker in ora2pg.config. Oracle is up and when Im trying to setup ORA2PG getting TNS issue. (FATAL: 12541 ... ORA-12541: TNS:no listener (DBD ERROR: OCIServerAttach)) Tried multiple means modified TNS file made it appropriative nothing seems to be working. Oracle connection is in a good condition.

[sosmolovskii]

You can use additional environment variables when run docker image to fix this issue: -e ORA_HOST="dbi:Oracle:host=company.uz;sid=dbname;port=1521"
-e ORA_USER=user_name
-e ORA_PWD=password

For example: docker run
-e CONFIG_LOCATION=/config/ora2pg.conf
-e OUTPUT_LOCATION=/data
-e ORA_HOST="dbi:Oracle:host=company.uz;sid=dbname;port=1521"
-e ORA_USER=user_name
-e ORA_PWD=password
-v /host/path/to/config:/config
-v /host/path/to/data:/data
georgmoser/ora2pg

(if you want to use multiline-command do not forget about "" in the end of each line)