ora-12514 tns 监听程序当前无法识别连接描述符中请求的服务

1用pl/sql登入数据库，报ora-12514,tns...,在dos窗口下能正常服务数据库，

于是修改 listener.ora文件

SID_LIST_LISTENER =

  (SID_LIST =
    (SID_DESC =
      (SID_NAME = tlx) 
      (ORACLE_HOME = D:\oracle\product\10.2.0\db_1)
      #(PROGRAM = extproc)---把这行删掉或注释
    )
  )


LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      #(ADDRESS = (PROTOCOL = IPC)(KEY = tlx))
      (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    )

  )

2 tnsnames.ora 没问题。

TLX =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = IP)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = tlx)
    )
  )

3 如果以上两各文件修改错误，就会引起另一个错误，ora-28547

4 重启监听，正常。