Tell Me How To Access Oracledb From Raspberry Pi Through Query

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 Ba

Solution 1:

It looks like you've asked here a couple times (12), 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.