Wednesday, 24 July 2013

How to install SQL Developer on Linux?

     How to install SQL Developer on Linux?

  :- below is steps for installing sql Developer on linux...

Step 1: download sql developer using below link..

            http://www.oracle.com/technetwork/developer-tools/datamodeler/overview/index.html

Step 2: Download latest Java SE Development Kit 6....
 http://www.oracle.com/technetwork/java/javase/downloads/jdk6u35-downloads-1836443.html

Step 3:install sqldeveloper rpm package....
  # rpm -Uvh sqldeveloper-3.2.20.09.87-1.noarch.rpm

Step 4: give permission to JDK
#chmod a+x   jdk-6u35-linux-i586-rpm.bin

step 5: execute the rpm..
# ./jdk-6u35-linux-i586-rpm.bin

Step 6: After successfully execute jdk..
set JAVA_HOME path and sqldeveloper path in oracle user bash_profile.
   EXAMPLE:
      JAVA_HOME=/usr/java/jdk1.6.0_35/; export JAVA_PATH
      PATH=$JAVA_HOME/bin:$PATH:/opt/sqldeveloper/; export PATH

Step 7: execute bash_profile...   
      $. .bash_profile

Step 8: execute sqldeveloper command

      $sqldeveloper

1) click on +  button for connection


2)specify you connection parameter  



 3)after specify connection parameter click on connect button.now you ready to execute your sql query.

 

               ################END##################################

No comments:

Post a Comment

work on autovacuum postgreSQL parameter

 In This blog, we are discussing the auto vacuum parameter on a small scale. we will understand the below parameters and will see how to mod...