告诉我如何通过QUERY从Raspberry Pi访问OracleDB [英] Tell me how to access OracleDB from Raspberry Pi through QUERY

问题描述

问题是树莓派和Oracle数据库之间的链接.现在我们已经尝试了很多东西，但是问题没有解决.从树莓派通过Web下载oracleinstantclient-32bit Basic文件和sqlplus文件后，解压缩文件集合并设置绝对路径export LD_LIBRARY_PATH和PATH.但总是:

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.

我想通过Raspberry Pi的QUERY语句从Python访问Oracle DB.

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

推荐答案

好像您在这里问过几次( 2 )，但答案可能令人困惑吗?让我说清楚.

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

您不能在Raspberry Pi上运行Oracle Client. /a> *

Oracle不支持Raspberry Pi使用的ARM CPU体系结构.您下载并解压缩了Oracle Instant Client，但实际上无法运行.如果没有Oracle客户端库，则cx_oracle将不起作用，通用Python ODBC连接器也将不起作用.

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.

有一些使用Oracle Instant Client的替代方法-上面的链接答案列出了一些方法，以及 Python文档列出其他人.

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

最简单的方法可能是使用Oracle JDBC库进行连接-安装JPype， JayDeBeApi 和Oracle JDBC库(ojdbc7.jar).

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

*好的，从技术上讲，您可以在Raspberry Pi上运行Oracle Client，人们通过运行$ 30的x86模拟器来做到这一点.但这可能比您想要的还要复杂.

* 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.

这篇关于告诉我如何通过QUERY从Raspberry Pi访问OracleDB的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！