Oracle SQL Developer for Windows 32-bit with JDK included

 Oracle SQL Developer is available for Windows 32-bit with Java Development Kit included. Download it by clicking here.

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.

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.

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.

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:

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

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.

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.

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

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:

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:

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.

18. Now that you have connected to your ORACLE 11g database, you should see it displayed in ORACLE Developer.