日期:2014-05-17  浏览次数:20983 次

紧急求救,ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect
descriptor
这个错误怎么解决阿?我本地连接pl/sql不行哦。
配置文件如下:请大侠帮忙看一下:

tnsnames.ora文件:

# TNSNAMES.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.



ORAPOP =
  (DESCRIPTION =
  (ADDRESS_LIST =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )
  (CONNECT_DATA =
  (SERVICE_NAME = ORAPOP)
  )
  )
-----------------------------------------

sqlnet.ora文件:

# SQLNET.ORA Network Configuration File: E:\oracle9i\network\admin\sqlnet.ora
# Generated by Oracle configuration tools.

SQLNET.AUTHENTICATION_SERVICES= (NTS)

NAMES.DIRECTORY_PATH= (TNSNAMES,HOSTNAME,ONAMES)

------------------------------------------
listener.ora文件

# LISTENER.ORA Network Configuration File: E:\oracle9i\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.

LISTENER =
  (DESCRIPTION_LIST =
  (DESCRIPTION =
  (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
  )
  )





------解决方案--------------------
Backup LISTENER.ORA file!!!!!!!

In ...\network\admin open listener.ora

see

SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = PLSExtProc)
(ORACLE_HOME = D:\Ora10g)
(PROGRAM = extproc)
)
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
)

Add the entry 
(SID_DESC =
(SID_NAME = test)
(ORACLE_HOME = D:\Ora10g)
)
with regard to the particular Oracle Home and SID Name.

Restart the listener:
c:>lsnrctl stop
c:>lsnctl start

------解决方案--------------------
你的监听没有配好,监听再配下看看
------解决方案--------------------
监听文件的内容不全。

补充如5楼