python远程连接oracle数据库总结
1. python 连接数据库代码:
def oracledbConnect(self):
try:
conn = cx_Oracle.connect("mdm","netqin123","192.168.33.160:1521/dex")
cursor = conn.cursor()
cursor.execute("""select * from t_user""")
one = cursor.fetchall()
for row in one:
print row
cursor.close()
conn.commit();
conn.close()
except cx_Oracle.Error,e:
print "Oracle Error %d: %s" % (e.args[0], e.args[1])
2. 安装cx_Oracle 插件:
参考安装“cx_Oracle-5.1.2-11g.win32-py2.7.msi”
3. 安装oracle数据库客户端:
直接安装win32_11gR2_client.zip
4. 将instantclient文件安装:
将instantclient_11_2.zip解压后,放入安装好的oracle数据库product目录下
5. copy文件到python安装目录下
将instantclient_11_2文件下 oci.dll, oraocci11.dll,oraociei11.dll copy到python安装目录下lib/site-packages下
6. 配置环境变量:
设置instantclient环境变量,添加instantclient路径到path路径下
经过以上步骤,python能成功连接oracle数据库