5 Replies Latest reply on Sep 2, 2019 2:50 AM by cj

Python cx_Oracle.DatabaseError: DPI-1050

3063555 May 22, 2019 6:31 AM

import cx_Oracle host='10.21.24.14' port='1524' service_name='TEST' pwd= 'apps456' dsn_tns = cx_Oracle.makedsn(host,port,service_name) connection = cx_Oracle.connect('apps',pwd,dsn_tns) use the in python but show the error cx_Oracle.DatabaseError: DPI-1050: Oracle Client library is at version 0.0 but version 11.2 or higher is needed please suggest / help us

1. Re: Python cx_Oracle.DatabaseError: DPI-1050

cj May 23, 2019 2:37 AM (in response to 3063555)

That error message was improved/fixed in cx_Oracle 7.1. What it's saying is that your PATH (on Windows) or LD_LIBRARY_PATH (on Linux or Unix) has an old version of Oracle Client libraries. You need to install newer ones somewhere and set PATH or LD_LIBRARY_PATH to them before you run Python. Newer Oracle client libraries will still allow you to connect to older databases (but not really old ones). Check the cx_Oracle installation instructions https://cx-oracle.readthedocs.io/en/latest/installation.html
Like Show 0 Likes(0)

Actions
2. Re: Python cx_Oracle.DatabaseError: DPI-1050

3063555 May 23, 2019 6:33 AM (in response to 3063555)

hi I have uninstalled all python with removed all setting and again installed set the environment setting. I have installed the cx_oracle via python pip install cx_oracle on my pc (window). cx_Oracle.DatabaseError: DPI-1047: Cannot locate a 64-bit Oracle Client library: "The specified module could not be found" how to connect the database server via python. please help
Like Show 0 Likes(0)

Actions
3. Re: Python cx_Oracle.DatabaseError: DPI-1050

e622a2b3-fdd8-472c-ae58-db13a45f2bed Aug 9, 2019 6:47 AM (in response to cj)

I have installed the cx_oracle via python pip install cx_oracle on my pc (window). I still have the same problem
Like Show 0 Likes(0)

Actions
4. Re: Python cx_Oracle.DatabaseError: DPI-1050

756f1e82-0253-4189-8479-bb4b52e17467 Aug 28, 2019 7:19 PM (in response to 3063555)

same here, cant get past this. why is this so difficult?
Like Show 0 Likes(0)

Actions
5. Re: Python cx_Oracle.DatabaseError: DPI-1050

cj Sep 2, 2019 2:50 AM (in response to 756f1e82-0253-4189-8479-bb4b52e17467)

Which of the two errors? What operating system? What version of cx_Oracle? What other Oracle software have you got installed?

Start with https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html#troubleshooting and post much more detail if you still have problems
Like Show 0 Likes(0)

Actions

Go to original post