Oracle TNS-12514错误的解决步骤

远程客户端操作数据，发现无法连接到oracle，查看listener.log有
<pre>
19-JAN-2017 14:44:37 * (CONNECT_DATA=(SERVICE_NAME=orcl)(CID=(PROGRAM=)(HOST=jdbc)(USER=testd))) * (ADDRESS=(PROTOCOL=tcp)(HOST=11.0.0.155)(PORT=51821)) * establish * orcl * 12514
TNS-12514: TNS:listener does not currently know of service requested in connect descriptor</pre>
查看listener.ora发现设置的有一点问题,修改为:
<pre>
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SDU = 32768)
(TDU = 32768)
<b>(GLOBAL_DBNAME = orcl)</b>
(ORACLE_HOME = /opt/oracle/11.2.0)
(SID_NAME = orcl)
)
)
</pre>
然后重启listener
<pre>
[oracle@db42 ~]$ lsnrctl stop

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-JAN-2017 14:46:16

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
The command completed successfully
[oracle@db42 ~]$ lsnrctl start

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 19-JAN-2017 14:46:22

Copyright (c) 1991, 2009, Oracle. All rights reserved.

Starting /opt/oracle/11.2.0/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /opt/oracle/11.2.0/network/admin/listener.ora
Log messages written to /opt/oracle/diag/tnslsnr/firebox42/listener/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.0.1.42)(PORT=1521)))

Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
STATUS of the LISTENER

---

Alias LISTENER
Version TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date 19-JAN-2017 14:46:22
Uptime 0 days 0 hr. 0 min. 0 sec
Trace Level off
Security ON: Local OS Authentication
SNMP OFF
Listener Parameter File /opt/oracle/11.2.0/network/admin/listener.ora
Listener Log File /opt/oracle/diag/tnslsnr/firebox42/listener/alert/log.xml
Listening Endpoints Summary...
(DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(KEY=EXTPROC1)))
(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=11.0.1.42)(PORT=1521)))
Services Summary...
Service "orcl" has 1 instance(s).
Instance "orcl", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
</pre>

===========================================================
打完收工。