我正在尝试对一个Python程序中新安装的Oracle client 12.2 in RHEL 7 linux进行健全性测试,但是失败了,出现了上述错误,不确定我缺少了什么。请帮助处理此案例:cx_Oracle.DatabaseError: ORA-12514: TNS:listener does not currently know of service
requested in connect descriptor
我的tnsnames.ora文件在/home目录下FRDLD2D1 =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(Host = frdld2d1.de.db.com)(Port = 1825))
)
(CONNECT_DATA =
(SID = FRDLD2D1)
)
)
而我的python程序则在下面#!/usr/bin/python
import cx_Oracle
#connection = cx_Oracle.connect('PNTH_LOGGINGB_OWNER/password')
connection = cx_Oracle.connect('PNTH_LOGGINGB_OWNER/password@10.245.63.34:1825/orcl')
cursor = connection.cursor()
querystring = "select * from BDR_JOB_MASTER_LOG where ROWNUM <= 1;"
cursor.execute(querystring)
frdld2d1.de.db.com-IP地址:10.245.63.34
如果这里有任何问题,请谅解。
tnsping由于是instaclient版本,因此不存在要测试的实用程序
oracle-instantclient12.2-basic-12.2.0.1.0-1.x86_64.rpm。
但是有了SQLPlus,我就可以毫无问题地连接数据库了。