Oracle database connection using python is not Working

Question

I'm trying to connect to the oracle database in python using cx_Oracle. But I'm stuck with the below error.

For reference my code

  def runQuery(self,query):
        with cx_Oracle.connect(config.username,config.password,config.dsn,encoding=config.encoding) as connection:
            try:
                print(connection.version)
            except cx_Oracle.Error as error:
                print(error)

Config File

username = 'dummy'
password = 'dummy'
dsn = 'dummy@//localhost:1521/ORCLCDB.localdomain'
port = 1512
encoding = 'UTF-8'

For additional knowledge, using the docker image of the oracle database for this purpose.

May I know how can clear the issue and proceed and could someone please help to find what is missing in my implementation.

This site has many similar questions, check your client version 32-bit or 64-bit, check LD_LIBRARY_PATH...Please try the suggestions first. — Lalit Kumar B
– Lalit Kumar B, Commented May 13, 2020 at 12:45
My client version is 64bit . How we can check LD_LIBRARY_PATH — Aaditya R Krishnan
– Aaditya R Krishnan, Commented May 13, 2020 at 12:48
Echo the LD_LIBRARY_PATH variable and see if it's pointing to the location where your instant client is installed. If not, export or set it based on your OS. — Lalit Kumar B
– Lalit Kumar B, Commented May 13, 2020 at 12:51

totalamateurhour · Accepted Answer · 2020-05-13 12:52:17Z

2

Do you have Oracle Instant Client installed? Looks like you are using Ubuntu. For an RPM-based distro, installation would look like this. There are instructions out there to install Oracle Instant Client on Ubuntu as well, but perhaps you are better of putting your Python code and cx_Oracle in a container as well, as Chris Jones explains here.

answered May 13, 2020 at 12:52

totalamateurhour

3761 silver badge4 bronze badges

Sign up to request clarification or add additional context in comments.

4 Comments

Aaditya R Krishnan Over a year ago

I'm developing the script in ubuntu. But I need to run the script in both ubuntu and window, How can implement the oracle connection in python irrespective of the operating system

totalamateurhour Over a year ago

Put everything in a container. See Chris Jones' blog posts

Aaditya R Krishnan Over a year ago

I can't use docker in the real scenario. Used it as ease for installing the oracle DB in Linux

totalamateurhour Over a year ago

Then you'll need to make sure the OS in question has cx_Oracle and Oracle Instant Client installed properly. Instructions for Windows are here .

Collectives™ on Stack Overflow

Oracle database connection using python is not Working

1 Answer 1

4 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

4 Comments

Your Answer

Sign up or log in

Post as a guest

Related