Wednesday, December 19, 2012

How to install sqldeveloper on Linuxmint 14/Ubuntu12.10

Oracle SQL Developer is an Integrated development environment (IDE) for working with SQL in Oracle databases. Oracle Corporation provides this product free; it uses the Java Development Kit.

Oracle SQL Developer supports Oracle products and a variety of third-party plugins which users may deploy to connect to non-Oracle databases. Oracle SQL Developer works with IBM DB2, Microsoft Access, Microsoft SQL Server, MySQL, Sybase Adaptive Server, and Teradata databases.

Oracle SQL Developer supports automatic tabs, code insight, bracket matching and syntax coloring for PL/SQL.

1- Download Sqldeveloper from Oracle Website

Pirat9@pirat9-VirtualBox ~/Downloads $ ls
 sqldeveloper-3.2.20.09.87-no-jre.zip

2- Check your installed Java version using the command:

pirat9@pirat9-VirtualBox ~/Downloads $ java   -version
Output
java version "1.7.0_07"
 OpenJDK Runtime Environment (IcedTea7 2.3.2) (7u7-2.3.2a-1ubuntu1)
 OpenJDK 64-Bit Server VM (build 23.2-b09, mixed mode)
 pirat9@pirat9-VirtualBox ~/Downloads $

3- extract SQldeveloper

Cd the directory where you downloaded sqldeveloper and extract the file:

unzip Sqldeveloper .x.x.zip

cd   sqldeveloper

Now make the script executable:

chmod +x  sqldeveloper.sh

4- Now run the sqldeveloper script

./sqldeveloper.sh
Oracle SQL Developer
Copyright (c) 1997, 2011, Oracle and/or its affiliates. All rights reserved.Type the full pathname of a J2SE installation (or Ctrl-C to quit),
the path will be stored in ~/.sqldeveloper/jdk

Please put your Java PATH