需要安装的包:
1、cx_Oracle
2、oracle客户端:以instantclient_12.1为例
一:安装cx_Oracle:
1、下载Oracle客户端驱动(Oracle Instant Client Basic)并安装
2、安装VCForPython7.msi: Microsoft Visual C ++ Compiler for Python2.7
3、安装cx_Oracle==5.1.3
二:Oracle Instant Client 安装(注意:版本对应)
1、下载
2、在系统变量中增加:
ORACLE_HOME= “instantclient_12.1路径”
TNS_ADMIN = "“instantclient_12.1路径”
NLS_LANG = SIMPLIFIED CHINESE_CHINA.ZHS16GBK
3、新建tnsnames.ora文件,并写入以下内容:
orcl =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.1.11)(PORT = 1521))
)
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl.being.com)
)
)