1 2 3 Previous Next 34 Replies Latest reply: Mar 5, 2013 11:57 PM by sb92075 Go to original post RSS
      • 30. Re: TNS-12535: TNS:operation timed out
        moslee
        EdStevens

        You're right.. I too don't see any meaning in naming anything other than the default of LISTENER. This naming convention was done by my predecessors... I just merely follow their naming convention..
        • 31. Re: TNS-12535: TNS:operation timed out
          moslee
          Hi

          Unfortunately, there is no lines that contain "12535".. "TNS-12502" happens when I was doing the telnet from client...

          15-FEB-2013 06:57:49 * (CONNECT_DATA=(SID=ATDMP)(GLOBAL_NAME=ATDMPQA.NECSS.NEC.COM.SG)(CID=(PROGRAM=c:\oracle\ora92\bin\ORACLE.EXE)(HOST=ISD29)(USER=Administrator))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.169.1.29)(PORT=1146)) * establish * ATDMP * 0
          15-FEB-2013 07:10:37 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.1.192)(PORT=49856)) * establish * ATDMP * 0
          15-FEB-2013 07:17:37 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.1.192)(PORT=50086)) * establish * ATDMP * 0
          15-FEB-2013 09:29:33 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 09:29:49 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=LAN-1880)(USER=amosleeyp))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.5.61)(PORT=55883)) * establish * ATDMP * 0
          15-FEB-2013 09:33:53 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 09:34:10 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=C:\oracle\ora92\bin\sqlplus.exe)(HOST=LAN-1880)(USER=amosleeyp))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.5.61)(PORT=56162)) * establish * ATDMP * 0
          15-FEB-2013 09:35:38 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 09:37:30 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 09:38:34 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 09:40:30 * 12502
          TNS-12502: TNS:listener received no CONNECT_DATA from client
          15-FEB-2013 10:19:59 * (CONNECT_DATA=(SID=ATDMP)(CID=(PROGRAM=null)(HOST=__jdbc__)(USER=null))) * (ADDRESS=(PROTOCOL=tcp)(HOST=168.168.1.192)(PORT=51639)) * establish * ATDMP * 0
          • 32. Re: TNS-12535: TNS:operation timed out
            sb92075
            moslee wrote:
            Hi

            Unfortunately, there is no lines that contain "12535".. "TNS-12502" happens when I was doing the telnet from client...
            Then you are looking at the wrong listener.log file
            12535, 00000, "TNS:operation timed out"
            // *Cause: The requested operation could not be completed within the time out
            // period.
            // *Action: Look at the documentation on the secondary errors for possible
            // remedy. See SQLNET.LOG to find secondary error if not provided explicitly.
            // Turn on tracing to gather more information.
            • 33. Re: TNS-12535: TNS:operation timed out
              moslee
              KIV
              • 34. Re: TNS-12535: TNS:operation timed out
                sb92075
                moslee wrote:
                KIV
                THANKS!

                ENJOY
                1 2 3 Previous Next