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

找到C:/oracle/product/10.1.0/db_1/NETWORK/ADMIN目录下的

tnsnames.ora 和listener.ora

1， 检查tnsnames.ora  中的           
 ORCL =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
    (CONNECT_DATA =
      (SERVER = DEDICATED)
      (SERVICE_NAME = orcl)   是否和你要连接的名称相同
    )
  )

EXTPROC_CONNECTION_DATA =
  (DESCRIPTION =
    (ADDRESS_LIST =
      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
    )
    (CONNECT_DATA =
      (SID = PLSExtProc)
      (PRESENTATION = RO)
    )
  )

 

2.检查listener.ora 中是否有
和tnsnames.ora 相对应的SID_NAME = ORCL

 

如果没有则在istener.ora 中加上下面加粗的这段代码

SID_LIST_LISTENER =
  (SID_LIST =
    (SID_DESC =
      (SID_NAME = PLSExtProc)
      (ORACLE_HOME = C:/oracle/product/10.1.0/db_1)
      (PROGRAM = extproc)
    )
 (SID_DESC =
      (GLOBAL_DBNAME = ORCL)
      (ORACLE_HOME = C:/oracle/product/10.1.0/db_1)
      (SID_NAME = ORCL)
    )
)

LISTENER =
  (DESCRIPTION_LIST =
    (DESCRIPTION =
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC))
      )
      (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
      )
    )
  )

 

3.用lsnrctl start 重新启动服务，就可以解决

 

用lsnrctl status 可以查看服务状态。。。