【oracle】【解决方案】ORA-12514:TNS: 监听程序当前无法辨认连接描述符中 ...

Oracle11g，报错代码为：ORA-12514:监听程序当前无法辨认连接描述符中请求的服务。
出现该题目一般有两种情况。
第一种是在你安装完之后未配置监听（在此我暂时忘记安装完之后有没有配置监听）；
第二种是之前配置了监听但是系统未写入到listener.ora文件中(在此我暂未搞明确什么时间写入，而且有些未写入也可以用但是我配置完这些后简直可以用了，不明白但祝福)，以是只需要在该文件中写入配置参数就可以了。
修改listener.ora

原listener.ora文件

1. # listener.ora Network Configuration File: C:\software\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora
2. # Generated by Oracle configuration tools.
4. SID_LIST_LISTENER =
5.   (SID_LIST =
6.     (SID_DESC =
7.       (SID_NAME = CLRExtProc)
8.       (ORACLE_HOME = C:\software\Oracle\product\11.2.0\dbhome_1)
9.       (PROGRAM = extproc)
10.       (ENVS = "EXTPROC_DLLS=ONLY:C:\software\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")
11.     )
12.   )
14. LISTENER =
15.   (DESCRIPTION_LIST =
16.     (DESCRIPTION =
17.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
18.       (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
19.        (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.131.128)(PORT = 1521))
20.     )
21.   )
22. ADR_BASE_LISTENER = C:\software\Oracle

复制代码

从上图中我们可以看出我已经配置过监听了，但是报错是由于Oracle的地点没有写到SID_DESC中，在此我们将此写入就可以了。
添加 记载

1.         (SID_DESC =
2.       (GLOBAL_DBNAME = orcl)
3.       (ORACLE_HOME = C:\software\Oracle\product\11.2.0\dbhome_1)
4.       (SID_NAME = orcl)
5.      )

复制代码

修改后listener.ora文件

1. # listener.ora Network Configuration File: C:\software\Oracle\product\11.2.0\dbhome_1\NETWORK\ADMIN\listener.ora# Generated by Oracle configuration tools.SID_LIST_LISTENER =  (SID_LIST =    (SID_DESC =      (SID_NAME = CLRExtProc)      (ORACLE_HOME = C:\software\Oracle\product\11.2.0\dbhome_1)      (PROGRAM = extproc)      (ENVS = "EXTPROC_DLLS=ONLY:C:\software\Oracle\product\11.2.0\dbhome_1\bin\oraclr11.dll")    )        (SID_DESC =
2.       (GLOBAL_DBNAME = orcl)
3.       (ORACLE_HOME = C:\software\Oracle\product\11.2.0\dbhome_1)
4.       (SID_NAME = orcl)
5.      )
6.   )  LISTENER =  (DESCRIPTION_LIST =    (DESCRIPTION =      (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))      (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))       (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.131.128)(PORT = 1521))    )  )ADR_BASE_LISTENER = C:\software\Oracle

复制代码

tnsnames.ora

原tnsnames.ora文件

1. # tnsnames.ora Network Configuration File: C:\software\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
2. # Generated by Oracle configuration tools.
4. ORACLR_CONNECTION_DATA =
5.   (DESCRIPTION =
6.     (ADDRESS_LIST =
7.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
8.     )
9.     (CONNECT_DATA =
10.       (SID = CLRExtProc)
11.       (PRESENTATION = RO)
12.     )
13.   )
15. ORCL =
16.   (DESCRIPTION =
17.     (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.131.128)(PORT = 1521))
18.     (CONNECT_DATA =
19.       (SERVER = DEDICATED)
20.       (SERVICE_NAME = orcl)
21.     )
22.   )

复制代码

修改tnsnames.ora数据

已标黄，就修改了地点。
ORCL =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = localhost )(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = orcl)
)
修改后tnsnames.ora文件

1. # tnsnames.ora Network Configuration File: C:\software\Oracle\product\11.2.0\dbhome_1\network\admin\tnsnames.ora
2. # Generated by Oracle configuration tools.
5. LISTENER_ORCL =
6.   (ADDRESS = (PROTOCOL = TCP)(HOST = localhost)(PORT = 1521))
10. ORACLR_CONNECTION_DATA =
11.   (DESCRIPTION =
12.     (ADDRESS_LIST =
13.       (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
14.     )
15.     (CONNECT_DATA =
16.       (SID = CLRExtProc)
17.       (PRESENTATION = RO)
18.     )
19.   )
21. ORCL =
22.   (DESCRIPTION =
23.     (ADDRESS = (PROTOCOL = TCP)(HOST = localhost )(PORT = 1521))
24.     (CONNECT_DATA =
25.       (SERVER = DEDICATED)
26.       (SERVICE_NAME = orcl)
27.     )
28.   )

复制代码

免责声明：如果侵犯了您的权益，请联系站长，我们会及时删除侵权内容，谢谢合作！更多信息从访问主页：qidao123.com:ToB企服之家，中国第一个企服评测及商务社交产业平台。