4 Replies Latest reply on Feb 14, 2013 12:42 PM by 574584

    SQL Developer Stopped Working

      I had been using sqldeveloper- in my machine(windows 7 enterprise 32 bit) for the last 2 weeks. I was able to log in to the database and query succesfully. I used to double click the sqldeveloper/bin/sqldeveloper.bat file to open the application.
      However this is stopped working from today. A black(batchfile) window appears and vanishes. All i could read from that was -Xmx640M: illegal argument.

      I even tried reinstalling and downloading a lowerversion of sqldeveloper. But the issue remains the same.

      Any help would be appreciated.

      Biju Radhakrishnan
        • 1. Re: SQL Developer Stopped Working
          Gary Graham-Oracle

          Rather than run the bat file, click on the sqldeveloper\sqldeveloper\bin\sqldeveloper.exe file. It will open a console window that will stay open so you can see any other error messages. You didn't recently remove Java from your system?

          SQL Developer Team

          Edited by: Gary Graham on Feb 12, 2013 2:16 PM
          Removed post meant for another thread. Sorry for any confusion.
          • 2. Re: SQL Developer Stopped Working
            Thanks Gary for the inputs.

            I had been using the bat file because when I click the sqldeveloper.exe i get an error saying "MSVCR71.dll is missing ...... Try Reinstalling the program." How ever by using the bat file it used to work fine.
            Regardig Java, I dont think it has been removed from my machine. More over I had downloaded the (SQL developer with JDK) version.

            Biju Radhakrishnan
            • 3. Re: SQL Developer Stopped Working
              Gary Graham-Oracle
              Hi Biju,

              Since the goal is to keep your CMD console window open in order to see any displayed errors, I guess I should have said...
              1. Open a CMD console window.
              2. Change directory to <SQLDEV_HOME>\sqldeveloper\sqldeveloper\bin, where <SQLDEV_HOME> is the tool's install directory.
              3. Next run either .\sqldeveloper.bat or .\sqldeveloper.exe from the console.

              Workaround MSVCR71.dll is missing by placing a copy in <SQLDEV_HOME>\sqldeveloper\sqldeveloper\bin. If you downloaded the 32-bit version of SQL Developer with the JDK included, you can find that dll in <SQLDEV_HOME>\sqldeveloper\jdk\jre\bin.

              Hopefully any additional errors you see will prove more enlightening than -Xmx640M: illegal argument, which does not really make much sense to me.

              • 4. Re: SQL Developer Stopped Working
                Thank You Gary...

                I copied and placed the dll file in the bin folder and its working now....!

                Once again Thanks a lot...

                Biju Radhakrishnan