...

...

Installing Oracle SQL Developer

...

 

...

To interact with an Oracle Database Server as a developer, you will need to use the Oracle SQL Developer software. This software is available for Windows 32-bit with Java Development Kit included. Download it by clicking here.

Image Removed

If you are running Windows 64-bit, Mac OS X, Linux or other platforms

Download Java SDK

A. Download the latest version of Java Development Kit by clicking here.

B. After downloading the Java SDK  software file, you will run the file directly from the download folder as an Administrator

C. The first Java SDK Setup window is a Welcome message.  Click NEXT.  

D. The next Java SDK Setup window offers a choice of all features or selected features.   You can also select a different working folder than the default.  Accept all features and defaults.  Click NEXT.

E. The next Java SDK Setup window displays the progress of copying Java SDK files to the selected working folder.  This step takes about one  minute.

F. The next Java SDK Setup window offers you a chance to change the location name of that folder.  Make a note of the Java setup destination folder, because the ORACLE Developer software will request that you enter the name of this folder so that it can prepare the ORACLE and JAVA linkage. Click NEXT.

G. The  next Java SDK Setup window displays the status of the installation itself.  This step takes about two minutes to run.

H. The  final Java SDK Setup window displays a message indicating the successful installation of Java SDK. 

Download oracle Developer

1. Select the Oracle SQL Developer download that best suits your platform by clicking here.

2. Once you have downloaded the ORACLE Developer zip file from the ORACLE download your site into a standard Windows Download folder.  You will extract the contents of that folder to another folder named, C:\Temp4. Right-click the downloaded zip file as shown, and select, Extract All.

Image Removed

3. Once your ORACLE Database Developer files are extracted to your C:\Temp4 folder, you will navigate to that folder and open the newly created subfolder there, named “sqldeveloper”.  You will double-click this folder to open it and access its contents.

Image Removed

4. Once inside your new folder, C:\Temp4\sqldeveloper, you will locate the executable Setup file, also named “sqldeveloper”. Double-click that executable file and select, Run as Administrator, as shown below.

Image Removed

5. The first action of the ORACLE Developer setup executable is to prompt you to request the folder location of the Java SDK executable that you recorded as a part of step 3.7 above. The prompt is shown below:

Image Removed

6. You will enter the folder location referred to in step F above, and add “\bin\java.exe” to it as shown below:

Image Removed

Next, click OK.

7. When the Java SDK folder location is registered by the ORACLE Developer setup program, the ORACLE Developer Copyright logo will appear.  also named “sqldeveloper”, and double-click that file, in order to Run as Administrator as shown below.

Image Removed

8. Oddly, although you downloaded the recommended versions of ORACLE software, you’ll receive a warning that these versions of Java and ORACLE Developer are incompatible.   ORACLE Corporation is aware of this, and they advise you to simply click YES to continue processing.

Image Removed

9. As the ORACLE Developer software installation proceeds, a graphic display of the percentage completed will also display. This step takes several minutes.

Image Removed

10. For custom installations you might wish to restrict ORACLE Developer to a subset of its default file types.  However, for this demo you will accept all the default file types for ORACLE Developer.  You will indicate this by adding a check mark next to all of the file types displayed in the following window.   Then click OK as shown:

Image Removed

At this point you will wait a few more minutes for the ORACLE Developer setup to complete.

11. When the ORACLE Developer setup finally completes, it will display the following window:

Image Removed

12. Next you will navigate to the ORACLE 11g installation folder at C:\app\MIS325\product\11.2.0\dbhome_1 and locate the subfolder named, “Network.”   Enter that subfolder 

13. Next, within the “Network” folder you will navigate to the ORACLE 11g subfolder named, “Admin”.  Enter that subfolder, as well.

14. Once inside C:\app\MIS325\product\dbhome_1\NETWORK\ADMIN,  you will locate two system files, namely, “sqlnet” and “tnsnames”.  You will copy those files, so that you can paste the copies to another folder.  (NOTE: Add “listener” file for Listener functionality.)

15 Next, you will navigate to your ORACLE Developer install folders (in this case to C:\Temp4\sqldeveloper) and you’ll paste these two files.  (NOTE:  Paste “listener” file, too, for listener functionality.)

16. With copies of the “sqlnet” and “tnsnames” and “listener” files copied to the ORACLE Developer main folder, you can now initiate a connection of ORACLE Developer with your ORACLE 11g database that you installed in chapter two.  You will begin by click on the green “plus” sign under the “Connections” tab in the upper left part of the ORACLE SQL Developer window. Click on it.

17. At this point the ORACLE SQL Developer program will prompt you for Connection Name (in this demo, ORA), Username (use SYSTEM), the Password (use the password you entered in step 2.9), Connection type (select TNS from the dropdown box) and Network Alias (select your DB name from the dropdown box).  Now click Connect.

free of charge from Oracle for Windows, Macintosh and Linux operating systems.

Oracle SQL Developer requires the Java Development Kit (JDK) to run. If you are using Windows, you have the option to download a version of SQL Developer that includes the JDK. To do this, pllease follow the simple installation instructions below.

If you are using Macintosh or Linux or want to specify a separate JDK to use on Windows, then follow the two part installation instructions below.

If you encounter any error messages, please refer to the troubleshooting section at the end of this document.

Simple installation for Windows

1. Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the Oracle SQL Developer for 32-bit Windows, since it already contains a copy of the JDK. The 32-bit version of Oracle SQL Developer will run on 64-bit Windows.
   
   
2. There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish.  
   
   Image Added
   
3. The first time you launch SqlDeveloper  you will also be prompted to associate certain file types with it. You should all file types and click ok.
   
   Image Added
   
   
4. Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
   
   Image Added

Two part installation for Windows, Mac and Linux

Download and Install Java SDK

1. Download the latest version of Java Development Kit from http://www.oracle.com/technetwork/java/javase/downloads/index.html and run it.
   
   
2. We recommend you accept all default options. When prompted for a location to install the JDK, whether you keep the default or change it, make a note of where you install it, since the first time Oracle SQL Developer runs it will ask you where JDK is installed. 

Download and Install Oracle Developer 

1. Visit http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/index.html and download the version of Oracle SQL Developer you require.
   
   
2. There is no installer for this software. Simply download the ZIP file, extract the zipped-up folder, and launch the SqlDeveloper executable inside that folder. You may move the extracted folder where you want on your hard drive and create a shortcut to it on your desktop or wherever you wish. 
   
   
3. The first time you launch Oracle SQL Developer you will be promoted to tell it the location of your installed JDK. Use the Browse button to browse to the the location of Java.exe. For example: a typical installation path for JDK version 7 on Windows is C:\Program Files\Java\jre\bin\java.exe"
   
   Image Added

1. The first time you launch SqlDeveloper  you will also be prompted to associate certain file types with it. You should all file types and click ok.
   
   Image Added
   
   
2. Once it finishes launching, Oracle SQL Developer should look like this. You may begin using it.
   
   Image Added

Troubleshooting

1. Even if you downloaded and installed the latest version of Java, you may receive a message similar to the following that your version of Java is unsupported. We recommend you check the box the skip this message from now on and click yes to continue.
   
   Image Added
   
   
2. Depending on the version of JDK you have and what version of SQL Developer you downloaded you may receive a message that MSVCR100.dll (or a similarly named DLL) is missing. This DLL is a file that you should find in the same directory as Java.exe. Simply COPY that file and PASTE it into the same directory as SqlDeveloper.exe. Then relaunch Oracle SQL Developer.