Django + 多oracle schema连接测试

目标：Django + 多oracle schema连接测试，尽量不装oracle client等插件，尽量用成熟技术

关键字：Django oracle 

环境：Django2.1.4    cx-Oracle 8.1.0   oracle client11g   操作系统：win10 64位

 

1.安装

    1.1  升级PIP到21.0.1

　1.2  安装cx-Oracle 8.1.0

　1.3  安装oracle client 

　　   1.3.1  选运行时

　　　1.3.2  配置TNS_ADMIN路径为C:\product\11.2.0\client_1\network\admin

　　　1.3.3  将tnsnames.ora放至路径C:\product\11.2.0\client_1\network\admin

2.配置

　　2.1 Pycharm setting

DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'mis5',
'USER': 'root',
'PASSWORD': 'root',
'HOST': 'localhost',
'PORT': '3306',
},
'moe2pda': {
'ENGINE': 'django.db.backends.oracle',
'NAME': 'v1i402',
'USER': 'MESMOE2PDA',
'PASSWORD': 'atmoMESMOE2PDA',
'HOST': '10.174.251.138',
'PORT': '1521',
},
'DMTLL1QUA': {
'ENGINE': 'django.db.backends.oracle',
'NAME': 'v3mesadg', #service_name
'USER': 'MESDMTLL1QUA',
'PASSWORD': 'atmoMESDMTLL1QUA',
'HOST': '10.174.251.138',
'PORT': '1521',
},
'DMTLL2QUA': {
'ENGINE': 'django.db.backends.oracle',
'NAME': 'v3mesadg', # service_name
'USER': 'MESDMTLL2QUA',
'PASSWORD': 'atmoMESDMTLL2QUA',
'HOST': '10.174.251.138',
'PORT': '1521',
}
}

2.2   对应TNS

V1I402 =
(DESCRIPITON =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.174.251.138)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = V1I402)
)
),
DMTLL1QUA =
(DESCRIPITON =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.174.251.138)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = v3mesadg)
)
),
DMTLL2QUA =
(DESCRIPITON =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 10.174.251.138)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = v3mesadg)
)
)