如何修复 cx_Oracle.DatabaseError: ORA-12514: TNS:listen

Question

我使用python3.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>>)
    )
)