Oracle 10 G listener stat
i am getting that error always listner going down.then again i restart the database. please give me solution开发者_C百科.
NI connect error 12514, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=localhost.localdomain)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=Eagle)(CID=(PROGRAM=EagleDataPushe
r11)(HOST=localhost.localdomain)(USER=root))))
VERSION INFORMATION:
TNS for Linux: Version 10.2.0.1.0 - Production
TCP/IP NT Protocol Adapter for Linux: Version 10.2.0.1.0 - Production
Time: 20-FEB-2011 16:16:50
Tracing not turned on.
Tns error struct:
ns main err code: 12564
TNS-12564: TNS:connection refused
ns secondary err code: 0
nt main err code: 0
nt secondary err code: 0
nt OS err code: 0
It would be useful to turn on tracing for the listener to get more info. It's a little unclear exactly what you're experiencing. However, if you are able to connect for some time after a database restart (rather than a listener restart) but after a while you start getting this error, then this might suggest something is opening connections and not freeing them; eventually you'll reach the database's process or session limit. What kind of clients are connecting, and how? If you're able to connect locally as SYSDBA, look at V$SESSION
and see if there are a lot of entries you aren't expecting.
精彩评论