Friday, September 25, 2020
    Home Oracle Internals Ubuntu and Oracle SQL Developer

    Ubuntu and Oracle SQL Developer

    Blog post explains how to install and use of Oracle SQL Developer on Ubuntu linux server

    Ubuntu and Oracle SQL Developer

    A few days ago, tired of the constant Conficker infections and strong of the fact that my pc is a simple workstation from which I connect to the real machines I work with (a mixture of Windows Server 2003 and GNU / Linux environments, real and virtualized ), I thought about formatting my PC running Windows XP to upgrade to Ubuntu 8.10.

    A tool that I have been using for some time now and that gives me the same satisfaction as Toad (but in addition, it is free and does not require licenses) is Oracle SQL Developer. This software is made in Java so it is available for several platforms, including GNU / Linux, although there is no deb package for Debian and Debian like distributions. If you want, you can use the Alien tool to convert the rpm into a deb, or you can always download a zip file containing the entire environment ready for use.

    - Advertisement -

    The version for GNU / Linux does not come with the Java SDK, which is necessary to run the SQL Developer interface, but with Ubuntu 8.10, for example, you can easily remedy the lack with:

    $ sudo aptitude install sun-java6-jdk

    Assuming you want to use the zip file provided by Oracle, you can unpack it, for example, in / usr / src /:

    $ tar xzf
    $ sudo mv sqldeveloper / usr / src /

    - Advertisement -

    The script to be launched is contained in / usr / src / sqldeveloper (the path must be adapted according to the installation directory chosen):

    $ cd / usr / src / sqldeveloper
    $ ./

    However, you may notice an error message appearing on the terminal:

    Oracle SQL Developer
    Copyright (c) 2008, Oracle. All rights reserved.

    Type the full pathname of a J2SE installation (or Ctrl-C to quit), the path will be stored in ~ / .sqldeveloper / jdk

    In this case, you have to finish creating the script with Ctrl-C, then create a directory called .sqldeveloper (pay attention to the point before the name, as it is a hidden directory) in your home and within this directory create a file called jdk . This file must contain the path to the jvm so:

    $ mkdir /home/username/.sqldeveloper
    $ cd ~ / .sqldeveloper
    $ touch jdk
    $ echo / usr / lib / jvm / java-6-sun> jdk

    When you want to make a strong Oracle DBA career then you should be aware of database services and other database technology. Without having knowledge of Oracle internals, Oracle performance tuning, and skill of Oracle database troubleshooting you can’t be an Oracle DBA expert. This expert DBA Team club blog always provides you latest technology news and database news to keep yourself up to date. You should need to be aware of Cloud database technology like DBaaS. These all Oracle DBA tips are available in a single unique resource at our orageek. Meanwhile, we are also providing some sql tutorials for Oracle DBA. This is the part of Dbametrix Group and you would enjoy more advanced topics from our partner resource.

    Consider Reading to these articles:

    - Advertisement -
    - Advertisment -

    Most Popular

    ORA-01194: file 1 needs more recovery to be consistent

    The blog post explains how to restore and recover database using until cancel with error ORA-01194

    How to enable Archivelog

    This blog post explains how to enable archive log mode in Oracle database for newest versions.

    Shared vs Static Library Performance

    The article explains the benefits of a shared library and static library usage in application building for improving application performance.

    Migration methods of Oracle Database

    Blog post explains which tricks and methods are simple to perform migration of small and large Oracle database

    Recent Comments