-
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.
-
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"
-
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
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|