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文件安装:
<