Monday, September 16, 2013

SQL Developer


Oracle SQL Developer is a free graphical tool for database development. With SQL Developer, you can browse database objects, run SQL statements and SQL scripts, and edit and debug PL/SQL statements. You can also run any number of provided reports, as well as create and save your own. SQL Developer enhances productivity and simplifies your database development tasks. SQL Developer can connect to any Oracle Database version 10g and later and runs on Windows, Linux and Mac OSX.

The latest release of Oracle SQL Developer is version 4 and even it supports oracle database.
In this post we are going to see how to download and install the SQL Developer. As a DBA these utilities are very helpful and makes our job easier.
Step1:  Download the SQL Developer V3.2.2 and Java JDK6u45
  • You can download the SQL Developer from here. Make sure you logged into Oracle and must accept the license agreement before download. 

  • In order to deploy the SQL Developer in windows 64 bit platform we need to download the Java 6 JDK. That can be downloaded from here.  I downloaded and installed jdk-6u45-windows-x64.exe
Step2:  Set the PATH 
  • Extract the downloaded sqldeveloper64-3.2.20.09.87-no-jre file. Get into the folder and find the sqldeveloper application. It will give you a small windows asking for java path as shown below.
                       
  • Click OK.  Welcome page of SQL Developer         

STEP 3: Make the Connection
  • To establish a connection between our database and SQL developer, firstly our database server must be up and running and listener must be up. Click on "+" symbol to enter the connection details.
Here In my case my database server is running on Linux VM.
           IP Address:     192.168.1.5 (Bridged)
           Schema:          HR
           ORACLE_SID:   test
  • Once the test connection is success you can click on Connect to start working with HR schema. Expand the tab you can see the all Database Objects.
This is how we can simply make the connection. Make sure your target IP is pinging from the windows and listener must be up and running. Please let me know your views on this.

No comments:

Post a Comment