Oracle latency timeout problem
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: Oracle latency timeout problem

  1. #1
    Join Date
    Dec 2001
    Posts
    26

    Question 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: TNSperation 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


  2. #2
    Join Date
    May 2000
    Location
    ATLANTA, GA, USA
    Posts
    3,135
    Set CONNECT_TIMEOUT to 0 in listener.ora and restart it.

  3. #3
    Join Date
    Dec 2001
    Posts
    26

    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: TNSperation 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]

  4. #4
    Join Date
    Apr 2001
    Posts
    126
    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: TNSperation 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

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