10 Replies Latest reply: Dec 5, 2012 7:05 AM by 966883 RSS

    No more data to read from socket

    855721
      Hi,

      I am trying to connect to Orcacle 11g by using SQL Developer but I am getting this error message:

      Status: Failure- Test failed : No more data to read from socket



      Can anyone please help me with it.

      Edited by: 852718 on Apr 17, 2011 3:39 PM
        • 1. Re: No more data to read from socket
          -K-
          As this is your first post, please read the forum announcements first. Then get back with more info.

          Regards,
          K.
          • 2. Re: No more data to read from socket
            855721
            Hi,

            I read the forum announcement but it didn't answer my question. Can you help me with it?
            It us my first post

            Sadiq
            • 3. Re: No more data to read from socket
              -K-
              Let me repeat:

              For All Forum Posters

              Posters, please mind these common-sense rules when participating here:

              When asking a question, provide all the details that someone would need to answer it. For example we need SQL Developer version, DB version, Java version, and OS as a minimum. A reproducible example is also important, where appropriate.
              When answering a question, please be courteous; there are different levels of experience represented here. A poorly worded question is better ignored than flamed - or better yet, help the poster ask a better question.
              It is considered good form to reward answerers with points (as "helpful" - 5 pts - or "correct" - 10pts).
              See more Forum tips in the FAQ
              • 4. Re: No more data to read from socket
                613575
                Smile to the world and it will smile back?

                Your argument is valid - the way you transfer it is - making the guy not return. To what extend was that what you intended?

                Best reghards
                Niels Jessen, Denmark
                • 5. Re: No more data to read from socket
                  -K-
                  Yeah, you're right... and those were actually friendly posts, I don't always ask for "please" and usually don't bother after my first post ;)
                  If I'm brief in my responses above, it's because I know the kind of posters who won't be happy until you do their work for them and give it on a silver plate within 30 minutes.
                  Seems this is the case here - if the OP really wants his problem solved he would give the details asked for.

                  Have fun,
                  K.
                  • 6. Re: No more data to read from socket
                    613575
                    I totally agree! Client satisfaction is in focus.

                    To the point: I was looking for a solution to this issue that I experienced with SQL Developer 3.0.03 Build MAIN-03.97 and I reinstalled 2.1.1.64 Build MAIN-64.45 -- and it does not show the "No more data to read from socket" message but actually runs the SQL and renders the expected result.

                    To my need this release is as good as release 3.0 - so I stay with 2.1 untill the issue is fixed.

                    Cheers

                    Niels
                    • 7. Re: No more data to read from socket
                      -K-
                      You can install both of them.
                      If you want, open a new thread for your issue (with the needed environment details), and let's see if we can catch what's wrong...

                      Regards,
                      K.
                      • 8. Re: No more data to read from socket
                        orafad
                        NielsKrarupJessen wrote:
                        ... with SQL Developer 3.0.03 Build MAIN-03.97 and I reinstalled 2.1.1.64 Build MAIN-64.45 -- and it does not show the "No more data to read from socket"
                        Could you try the GA release, Version 3.0.04?
                        • 9. Re: No more data to read from socket
                          966883
                          orafad wrote:
                          NielsKrarupJessen wrote:
                          ... with SQL Developer 3.0.03 Build MAIN-03.97 and I reinstalled 2.1.1.64 Build MAIN-64.45 -- and it does not show the "No more data to read from socket"
                          Could you try the GA release, Version 3.0.04?
                          >
                          >
                          ... with SQL Developer 3.0.03 Build MAIN-03.97 and I reinstalled 2.1.1.64 Build MAIN-64.45 -- and it does not show the "No more data to read from socket"
                          Could you try the GA release, Version 3.0.04? Hi,

                          Perhaps I could elaborate on this problem, as I am also running into it.

                          Details below:
                          OS: 64bit Windows 7 Enterprise
                          SQL Client: JDeveloper 11.1.2.3.0
                          Database: Oracle XE 11g Express (11.2.0)

                          When I try and create a connection in Jdeveloper, I receive the following error:

                          "Test failed: No more data to read from socket"

                          This is after having fixed a problem with the Listener not running as it couldnt connect to my hostname. I changed the hostname is listener.ora to 127.0.0.1. I have also changed the XE database connection type from to 'SHARED'.

                          Any help would be appreciated - more details below.

                          Thanks,

                          Matthew

                          Listener status:

                          C:\Windows\system32>lsnrctl status

                          LSNRCTL for 32-bit Windows: Version 11.2.0.2.0 - Production on 04-DEC-2012 12:23:27

                          Copyright (c) 1991, 2010, Oracle. All rights reserved.

                          Connecting to (DESCRIPTION=(ADDRESS=(PROTOCOL=IPC)(KEY=EXTPROC1)))
                          STATUS of the LISTENER
                          ------------------------
                          Alias LISTENER
                          Version TNSLSNR for 32-bit Windows: Version 11.2.0.2.0 - Production
                          Start Date 04-DEC-2012 12:02:46
                          Uptime 0 days 0 hr. 20 min. 43 sec
                          Trace Level off
                          Security ON: Local OS Authentication
                          SNMP OFF
                          Default Service XE
                          Listener Parameter File C:\oraclexe\app\oracle\product\11.2.0\server\network\admin\listener.ora
                          Listener Log File C:\oraclexe\app\oracle\diag\tnslsnr\MW7EU8NMTVSIVZ\listener\alert\log.xml
                          Listening Endpoints Summary...
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=ipc)(PIPENAME=\\.\pipe\EXTPROC1ipc)))
                          (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=127.0.0.1)(PORT=1521)))
                          Services Summary...
                          Service "CLRExtProc" has 1 instance(s).
                          Instance "CLRExtProc", status UNKNOWN, has 3 handler(s) for this service...
                          Service "PLSExtProc" has 1 instance(s).
                          Instance "PLSExtProc", status UNKNOWN, has 1 handler(s) for this service...
                          Service "XE" has 1 instance(s).
                          Instance "XE", status UNKNOWN, has 1 handler(s) for this service...
                          The command completed successfully

                          Listener.ora:

                          SID_LIST_LISTENER =
                          (SID_LIST =
                          (SID_DESC =
                          (SID_NAME = PLSExtProc)
                          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
                          (PROGRAM = extproc)
                          )
                          (SID_DESC =
                          (SID_NAME = CLRExtProc)
                          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
                          (PROGRAM = extproc)
                          )
                          (SID_DESC =
                          (SID_NAME = XE)
                          (ORACLE_HOME = C:\oraclexe\app\oracle\product\11.2.0\server)
                          (PROGRAM = extproc)
                          )
                          )

                          LISTENER =
                          (DESCRIPTION_LIST =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                          )
                          )


                          DEFAULT_SERVICE_LISTENER = (XE)
                          Tnsnames.ora:
                          XE =
                          (DESCRIPTION =
                          (ADDRESS = (PROTOCOL = TCP)(HOST = 127.0.0.1)(PORT = 1521))
                          (CONNECT_DATA =
                          (SERVER = SHARED)
                          (SERVICE_NAME = XE)
                          )
                          )

                          EXTPROC_CONNECTION_DATA =
                          (DESCRIPTION =
                          (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                          )
                          (CONNECT_DATA =
                          (SID = PLSExtProc)
                          (PRESENTATION = RO)
                          )
                          )

                          ORACLR_CONNECTION_DATA =
                          (DESCRIPTION =
                          (ADDRESS_LIST =
                          (ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1))
                          )
                          (CONNECT_DATA =
                          (SID = CLRExtProc)
                          (PRESENTATION = RO)
                          )
                          )
                          • 10. Re: No more data to read from socket
                            966883
                            Hi, just to follow up (if anyone else is also running into this problem).

                            Basically, you just have to remove the listener.ora file, and stop and start the TNS Listener through "lsnrctlr stop" and "lsnrctlr start".

                            I couldn't stop the listener from within the command line, I needed to go into Windows Services to stop it.

                            You can find the full solution below:

                            Listener does not currently know of SID given in connection descriptor