我正在使用cx_oracle pip软件包连接到工作中的oracle数据库。
dsn_tns = cx_Oracle.makedsn('1.2.3.4', '1521', service_name='TRADES')
conn = cx_Oracle.connect(user='analytics_user', password='welcome', dsn=dsn_tns)
c = conn.cursor()
c.execute('SELECT * FROM all_tables')
但是,我连接到的oracle db具有2个主机IP地址。
我得到的原始连接字符串是这样的;
SERVICE =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(Port=1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.222.33.44)(Port=1521))
(CONNECT_DATA =
(SERVICE_NAME = TRADES)
)
)
无论如何在cx_oracle上同时使用两者?还是有其他我可以使用的软件包允许呢?SQL_Alchemy?
您可以按原样使用DSN字符串,而无需使用SERVICE =
:
DSN = """
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.2.3.4)(Port=1521))
(ADDRESS = (PROTOCOL = TCP)(HOST = 1.222.33.44)(Port=1521))
(CONNECT_DATA =
(SERVICE_NAME = TRADES)
)
)
"""
with cx_Oracle.connect(user='user', password='pass', dsn=dsn_tns) as conn:
c = conn.cursor()
c.execute('SELECT * FROM all_tables')
感谢@ Christopher-Jones在这里的详细信息oracle-net-connect-descriptor-strings
本文收集自互联网,转载请注明来源。
如有侵权,请联系 [email protected] 删除。
我来说两句