Oracle latency timeout problem

Printable View

09-03-2002, 09:53 AM
TO_raptor

Oracle TNS timout/Listener errors .. still facing problems

Hi All,
I posted some data from my sqlnet.log that was generated in my system32 where I have a DLL that connects to the Oracle server.

I get the following error.
***********************************************************************
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=CONNDB )(CID=(PROGRAM=C:\WINNT\System32\inetsrv\inetinfo.exe)(HOST=SERVERNAME)(USER=USERNAME))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 30-AUG-2002 09:55:28
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0

somehow my last post mysteriously disappeared.
But i was responded to by a gentleman who advised me to set the IP address on the hosts file on the server.

In response to that .. I would like to state that the webserver is already configured with the IP of the server in the Oracle client on the webserver. So latency due to the DNS name resolution should not be encountered.

However the dba s advise me that the oracle commincation is setup tp be secure and excrypted. some one said that that could be the reason for some latency and hence failure.

Please advise what else could be going wrong.

Thanks very much.

TO
09-03-2002, 10:16 AM
tamilselvan

Set CONNECT_TIMEOUT to 0 in listener.ora and restart it.
09-05-2002, 09:35 AM
TO_raptor

done .. but no good

Thanks for your reply but it did not work for me. I made this change on the database server and 'reloaded' the listener.ora file.

But I am still getting the errors as follows:

(from sqlnet.log)

***********************************************************************
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=SVCNAM E)(CID=(PROGRAM=C:\WINNT\System32\inetsrv\inetinfo.exe)(HOST=SVRNAME)(USER=USRNAME))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 04-SEP-2002 18:37:08
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0

***********************************************************************
Fatal NI connect error 12541, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=XX.XX.XX.XX)(PORT=1527))(CONNECT_DATA=(SERVICE_NAME=SVCNAM E)(CID=(PROGRAM=C:\WINNT\System32\inetsrv\inetinfo.exe)(HOST=SVRNAME)(USER=USRNAME))))

VERSION INFORMATION:
TNS for 32-bit Windows: Version 8.1.7.0.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 8.1.7.0.0 - Production
Time: 05-SEP-2002 03:58:00
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12541
TNS-12541: TNS:no listener
ns secondary err code: 12560
nt main err code: 511
TNS-00511: No listener
nt secondary err code: 61
nt OS err code: 0

Could enabling tracing on the client help?

Could the encryption / security features on the client/server be affecting this?

It would be a tremendous help if you could advise me something to remedy this.

Thanks a lot.

TO

[Edited by TO_raptor on 09-05-2002 at 09:42 AM]
10-09-2003, 08:51 AM
fordikon

Any solutions for this
Fatal NI connect error 12535, connecting to:
(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=100.2.1.73)(PORT=1521))(CONNECT_DATA=(SERVER=DEDICATED)(SE RVICE_NAME=bali)(CID=(PROGRAM=d:\oracle\ora92\bin\ORACLE.EXE)(HOST=TERMINATOR)(USER=Administrator))) )

VERSION INFORMATION:
TNS for 32-bit Windows: Version 9.2.0.1.0 - Production
Oracle Bequeath NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Windows NT TCP/IP NT Protocol Adapter for 32-bit Windows: Version 9.2.0.1.0 - Production
Time: 09-OCT-2003 14:08:48
Tracing not turned on.
Tns error struct:
nr err code: 0
ns main err code: 12535
TNS-12535: TNS:operation timed out
ns secondary err code: 12560
nt main err code: 505
TNS-00505: Operation timed out
nt secondary err code: 60
nt OS err code: 0