1. Install Python3.x
2. Install Python module cx_Oracle
3. Download instantclient and unzip it
https://www.oracle.com/technetwork/topics/winsoft-085727.html
4. Add path of instantclient to environment
5. Copy and move files(oci.dll, oraocci**.dll, oraociei**.dll) from instantclient to site-packages of python

6. Run your code similar as below:
import cx_Oracle
cx_Oracle.connect(’%s/%s@%s:%s/%s’ % (user,pwd,ip,port,server))
How to connect with oracle through python remotely
最新推荐文章于 2025-12-04 22:03:39 发布
本文详细介绍了如何在Python环境中配置并使用cx_Oracle模块连接Oracle数据库。步骤包括安装Python及cx_Oracle模块、下载并设置Oracle Instant Client路径、将必要DLL文件复制到Python的site-packages目录,以及提供了一个简单的代码示例。
713

被折叠的 条评论
为什么被折叠?



