问如何使用带有服务名和登录名的cx_Oracle连接到Oracle数据库？

EN

import cx_Oracle
con = cx_Oracle.connect('username/password@host_name/service_name')
print con.version
con.close()

import cx_Oracle as orc 
user= 'username'
pwd = 'password'
host = 'url.or.path.to.db' #could look like path or url depending on where it's hosted
service_name = 'servicename'
portno = 1234 #note this is dummy port no

con = orc.connect(user, pwd, '{}:{}/{}'.format(host,portno,service_name))

con = cx_Oracle.connect('username/password@'service_name')