Tns-12654
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Tns-12654

  1. #1
    Join Date
    Jul 2005
    Posts
    87

    Tns-12654

    We are able to connect through sqlplus. But we get the following error when trying to connect through application. We are using Oracle 10.2.0.2 on HP UX-11.2.
    ===========================================================
    Fatal NI connect error 12516, connecting to:
    (DESCRIPTION=(SDU=32768)(enable=broken)(LOAD_BALANCE=yes)(ADDRESS=(PROTOCOL=TCP)(HOST=gvu0177.housto n.hp.com)(PORT=1525))(CONNECT_D
    ATA=(SERVICE_NAME=WSS1D)))

    VERSION INFORMATION:
    TNS for HPUX: Version 10.2.0.1.0 - Production
    TCP/IP NT Protocol Adapter for HPUX: Version 10.2.0.1.0 - Production
    Time: 26-MAR-2007 16:47:20
    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
    =====================================
    LSNRCTL for HPUX: Version 10.2.0.2.0 - Production on 26-MAR-2007 21:13:48
    Service "PSHDM_XPT" has 2 instance(s).
    Copyright (c) 1991, 2005, Oracle. All rights reserved. this service...
    Instance "PSHDM2", status READY, has 1 handler(s) for this service...
    Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=gvu0177)(PORT=1525)(IP=F
    IRST)))nce "RHBD1", status READY, has 2 handler(s) for this service...
    STATUS of the LISTENERatus READY, has 1 handler(s) for this service...
    ------------------------ instance(s).
    Alias LISTENER_G3U0192Cdler(s) for this service...
    Version TNSLSNR for HPUX: Version 10.2.0.2.0 - Production
    Start Date 27-FEB-2007 18:28:49
    Uptime 27 days 2 hr. 44 min. 59 secr this service...
    Trace Level offtance(s).
    Security ON: Local OS Authenticationor this service...
    SNMP OFFe(s).
    Listener Parameter File /u01/app/oracle/product/10.2.0/db_1/network/admin/list
    ener.ora"WSS2D_XPT" has 1 instance(s).
    Listener Log File /u01/app/oracle/product/10.2.0/db_1/network/log/listen
    er_g3u0192c.log has 1 instance(s).
    Listening Endpoints Summary...ADY, has 2 handler(s) for this service...
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=16.233.49.27)(PORT=1525)))
    (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=16.233.49.7)(PORT=1525)))..

    Service "WSS1D" has 1 instance(s).has 2 handler(s) for this service....og/listen
    Instance "WSS1D1", status READY, has 2 handler(s) for this service...
    Service "WSS1D_XPT" has 1 instance(s).s 2 handler(s) for this service...
    Instance "WSS1D1", status READY, has 2 handler(s) for this service....
    ========================================================
    Thanks for your help.

  2. #2
    Join Date
    Mar 2004
    Location
    DC,USA
    Posts
    650
    I doubt firewall restrictions in your case. Is the port open for traffic. Then check the in/out traffic. Traffic from application to the db server is being blocked.check the netstat?

    Also:
    Is the ping and tnsping works?
    Try changing the host name to ip and then give a try.
    "What is past is PROLOGUE"

  3. #3
    Join Date
    Sep 2001
    Location
    Makati, Philippines
    Posts
    857
    have you resolve your HOST?
    DNS might have something to do with it.
    ---------------

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width