Video 49 How to install Oracle SQL Developer in Windows 7
How to install Oracle SQL Developer in Windows 7 - Database Tutorial 49 - Oracle DBA tutorial. This video explains about 'How to install Oracle SQL Developer in Windows 7
The concept is as follows:
Download the SQL Developer Software from Oracle's website
You would need to have an account with Oracle.
If you do not have one, you can create one for free.
After the download, install it.
Install it in any folder that you prefer.
During the installation, it will ask for the location of your JDK (Java Development Kit) files
Generally you will find the JDK files under a folder that starts with JDK.
And that folder will be in C:\Program Files\Java
If you do not have one, follow the method explained in the video to download and install JDK
Once the installation of JDK is complete, then complete the SQL Developer installation too.
Then copy the files tnsnames.ora and sqlnet.ora from your ORACLE_HOME\NETWORK\ADMIN folder, where ORACLE_HOME is the folder where you installed the Oracle Software.
For example, in this video, ORACLE_HOME is C:\app\sam\product\11.2.0\dbhome_1
So, I went to C:\app\sam\product\11.2.0\dbhome_1\NETWORK\ADMIN
There I found the files tnsnames.ora and sqlnet.ora
I copied them to C:\Users\sam\Downloads\Oracle 11g\sqldeveloper64-3.2.20.09.87-no-jre\sqldeveloper folder, where I have installed SQL Developer.
Stay in the folder, C:\Users\sam\Downloads\Oracle 11g\sqldeveloper64-3.2.20.09.87-no-jre\sqldeveloper.
Then invoke SQL Developer by double clicking, sqldeveloper.exe file.
This will open SQL Developer application.