如何在远程机器中用Python连接Oracle数据源？

发布于 2025-01-11 13:28:35 字数 892 浏览 0 评论 0原文

我正在尝试在远程计算机中使用 Python 连接 Oracle 数据源。我的python版本和cx_Oracle详细信息如下，

这是我连接Oracle的代码，

import cx_Oracle

dsn_tns = cx_Oracle.makedsn('host_name', 'port', service_name='service_name') 
conn = cx_Oracle.connect(user='user', password='pws', dsn=dsn_tns) 
c = conn.cursor()
c.execute('select * from DB.TABLE')

for row in c:
   print(row[0])

conn.close()

即使python和Oracle都是32位，我也遇到了32位Oracle客户端库问题。

Exception has occurred: DatabaseError
DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

谁能帮我解决这个问题吗？

不太确定如何在远程计算机中管理它。如果您建议在终端上运行命令，那么我在远程计算机上处理就会很容易。

原文

I am trying to connect Oracle datasource using Python in my remote machine.
My python version and cx_Oracle details as follows,

here is my code to connect Oracle,

import cx_Oracle

dsn_tns = cx_Oracle.makedsn('host_name', 'port', service_name='service_name') 
conn = cx_Oracle.connect(user='user', password='pws', dsn=dsn_tns) 
c = conn.cursor()
c.execute('select * from DB.TABLE')

for row in c:
   print(row[0])

conn.close()

Even python and Oracle are 32 bits, I am getting 32 bit Oracle client library issues.

Exception has occurred: DatabaseError
DPI-1047: Cannot locate a 32-bit Oracle Client library: "The specified module could not be found". See https://cx-oracle.readthedocs.io/en/latest/user_guide/installation.html for help

Can anyone please help me to resolve this issue?

Not really sure how to manage this in remote machine. If you suggest the commands to run on terminals it would be easy for me to deal in remote machine.

分享到QQ

分享到微博