python 链接oracle 数据库

一.环境

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