遠程客戶端操作數(shù)據(jù)，發(fā)現(xiàn)無法連接到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發(fā)現(xiàn)設(shè)置的有一點問題,修改為:
<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>
===========================================================
打完收工。
