如何修复cx_Oracle.DatabaseError: ORA-12514: TNS:侦听器错误

Question

我使用python 3.6 (32位)和Oracle数据库11g，我想把我的python连接到oracle数据库。这是我的版本oracle for python cx-Oracle==7.2.1

这是我的file.ORA：

myservice = (DESCRIPTION=
(ADDRESS=
    (PROTOCOL=tcp)
    (HOST=localhost)
    (PORT= ))
(CONNECT_DATA=
    (SERVICE_NAME=orcl)))

这是我的代码：

import cx_Oracle
con= cx_Oracle.connect("db_employees/root@localhost/orcl")
cur= conn.cursor()
cur.execute('select*from employess')
for line in cur:
    print(line)
cur.close()
con.close()

但它显示了错误。这是我的错误消息：

C:\Python36>python "D:\bisa.py"
Traceback (most recent call last):
File "D:\bisa.py", line 3, in <module>
     con= cx_Oracle.connect("db_employees/root@localhost/orcl")
cx_Oracle.DatabaseError: ORA-12514: TNS:listener does

如何修复此错误？

Answer 1

在.ORA文件中尝试此操作

myservice =
   (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <<validhostname>>)(PORT = <<validportnumber>>))
    )
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = <<servicenameofDB>>)
    )
)