CASE - Banking Product - All Staff users Logging into APP Server &
Connecting to DB Server VIA SQL*Net . ORA-7.3.4.5 on Digital Unix 5.1
tnsping from APP Server to DB Server :-
$ tnsping <CONNECT_STRING>
OK (9300msec)
But Unix ping from APP to DB Server
$ ping <DB Server>
64 bytes from 192.168.77.66: icmp_seq=1 ttl=64 time=3 ms
sqlnet.log :- TNS-12537 , TNS-12560 , TNS-507
***********************************************************************
Fatal OSN connect error 12537, connecting to:
(LOCAL=NO)
VERSION INFORMATION:
TNS for DEC OSF/1 AXP: Version 2.3.4.0.0 - Production
Oracle Bequeath NT Protocol Adapter for DEC OSF/1 AXP: Version
2.3.4.0.0 - Production
TCP/IP NT Protocol Adapter for DEC OSF/1 AXP: Version 2.3.4.0.0 -
Production
Time: 19-APR-01 09:40:33
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12537
TNS-12537: TNS:connection closed
ns secondary err code: 12560
nt main err code: 507
TNS-00507: Connection closed
nt secondary err code: 0
nt OS err code: 0
NOTE -
Listener.ora :-
STARTUP_WAIT_TIME_LISTENER = 0
CONNECT_TIMEOUT_LISTENER = 0
TRACE_LEVEL_LISTENER = OFF
sqlnet.ora on DB & APP Server - Most Tracing Switched OFF
AUTOMATIC_IPC=OFF
TRACE_LEVEL_CLIENT=OFF
TRACE_LEVEL_SERVER=OFF
TNSPING.TRACE_LEVEL=OFF
SQLNET.EXPIRE_TIME=40
DISABLE_OOB=ON
NOTE - THe APP & DB SERvers are DIRECTLY Connected by a 100MBPS Cross-Cable
Qs. What may be the Cause ?
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: VIVEK_SHARMA
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
