Python 连接 Oracle 报错cx_Oracle.DatabaseError: ORA-12154: TNS: 无法解析指定的连接标识符 怎么解决啊

Question

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)
)
)
#

Answer 1

数据库没有连上，配置有问题
https://blog.csdn.net/minsenwu/article/details/45288873