Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

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

Open
ria-ops opened this issue Mar 7, 2023 · 1 comment

Comments

@ria-ops
Copy link

ria-ops commented Mar 7, 2023

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
Copy link

sosmolovskii commented May 18, 2023

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)

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

2 participants