一.环境
python3.5
red hat 4.7
# 安装
pip install cx_Oracle
# 链接数据库
import os import cx_Oracle import pandas as pd os.environ['NLS_LANG'] = 'SIMPLIFIED CHINESE_CHINA.UTF8' import settings def GetDBInfo(): ''' ''' host = settings.DB_ID # 数据库ip port = settings.DB_PORT # 端口 sid = settings.SEVER_NAME # 数据库名称 dsn = cx_Oracle.makedsn(host, port, sid) # db = cx_Oracle.connect('oilusr/oilusr@10.20.7.96:1521/lionnewtest') db = cx_Oracle.connect(settings.DB_USER_NAME,settings.DB_PASSORD, dsn) return db