0

The problem is the link between raspberry pie and Oracle database. We've tried a lot of things now, but the problem isn't solved. After downloading the oracleinstantclient-32bit Basic files and sqlplus files via the web from the raspberry pie, unpack the file collection and set the absolute path export LD_LIBRARY_PATH and PATH as well. But always:

cx_Oracle.DatabaseError: DPI-1047: Canot location a 32-bit Oracle Client library: "libclntsh.so: cannot open shared object file or directory". See https://oracle.github.Issues such as io/odpi/doc/installation.html#linux for help.

I'd like to access Oracle DB from Python through QUERY statements from Raspberry Pi.

MT0
  • 143,790
  • 11
  • 59
  • 117
전남식
  • 1
  • 3

1 Answers1

2

It looks like you've asked here a couple times (1 2), but maybe the answers were confusing? Let me be clear.

You cannot run Oracle Client on Raspberry Pi.*

Oracle does not support the ARM CPU architecture which the Raspberry Pi uses. You downloaded and unzipped the Oracle Instant Client, but it can't actually run. And without the Oracle Client libraries, cx_oracle will not work, and neither will generic Python ODBC connectors.

There are some alternatives to using Oracle Instant Client - the linked answer above lists some, and the Python documentation lists others.

The easiest way is probably to use the Oracle JDBC library to connect - install JPype, JayDeBeApi and the Oracle JDBC library (ojdbc7.jar).

* Okay, you technically can run Oracle Client on Raspberry Pi, people have done it by running a $30 x86 emulator. But that's probably more complicated than you want.

kfinity
  • 8,581
  • 1
  • 13
  • 20