import cx_Oracle
conn=cx_Oracle.connect('账号','密码@ODS','HOST：PORT/SERVICE_NAME')
cursor=conn.cursor()
re=cursor.execute('select * from hqods.wh_TSKILLGROUP')
row=cursor.fetchone()
print(row[0])
cursor.close()
conn.close()
#上面是我在Pycharm写的代码
#下面是PL/SQL 的文件中一个名为:tnsnames 内的内容
ODS备份 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST =这里我就先隐藏了)(PORT =这里我就先隐藏了))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)
ODS =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = 这里我就先隐藏了)(PORT = 这里我就先隐藏了))
)
(CONNECT_DATA =
(SERVICE_NAME = xxx)
)
)
#
数据库没有连上，配置有问题
https://blog.csdn.net/minsenwu/article/details/45288873
conn=cx_Oracle.connect(r'账号',r'密码@ODS',r'HOST：PORT/SERVICE_NAME')
这样试试
HOST后面的冒号是中文冒号 应该要用英文冒号