Posts Tagged ‘SQL Developer’

Resetting the SQL Developer layout.

While working with SQL Developer, if the Connections Navigator disappears or if you cannot dock the Log window in its original place, perform the following steps to fix the problem:
1. Exit from SQL Developer.
2. Search for the windowinglayout.xml file.
3. Go to the directory that has windowinglayout.xml and delete it.
4. Restart SQL Developer.

Categories: Oracle, RDBMS Tags:

How to fix SQL Developer MSVCR71.DLL not found error.

2011-12-27 5 comments

I recently installed Oracle SQL Developer on a Windows Server 2003 64-bits version. I had done this many times in the past with no problems, and so I was surprised when I went to run it and got error “This application failed to start because MSVCR71.dll was not found”.
I searched my computer for the missing DLL file and found nothing in the Windows folders, but several hits under the SQL Developer folders. So, the runtime was included with the Oracle SQL Developer files, but because its folder was not on the path, there was no way for it be found. How is this supposed to work? The SQL Developer is simply a zip file. You don’t install it. Just unzip it. Oracle is depending on the runtimes being available (i.e. improperly installed) in their software distribution strategy for SQL Developer. But, as Microsoft tightens the reigns, and as people start obeying the rules, this approach falls short. You can’t simply distribute it as a zip file and expect it to work. You’re going to have to provide a little bit of configuration to get the runtimes on the path.
To fix it, properly, you need to install SQL Developer yourself. Fortunately, this is quite simple:
1. Run regedit.
2. Expand

HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Windows\CurrentVersion\App Paths

3. Add a new Key to App Paths called sqldeveloper.exe
4. Set the (Default) value to the full path to the SQL Developer executable (including the executable name).
5. Create a new String value for sqldeveloper.exe called Path and set its value to the jdk\jre\bin folder in the SQL Developer files

This problem isn’t limited to Oracle SQL Developer. It will be common to any application distributed without an installation process that is dependent on a runtime file that should be located in the Windows folder.