开发者

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.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜