Monday, November 23, 2020
dbametrix
More
    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 -
    dbametrix

    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 sqldeveloper-1.5.4.59.40-no-jre.zip
    $ sudo mv sqldeveloper / usr / src /

    - Advertisement -
    dbametrix

    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
    $ ./sqldeveloper.sh

    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 -
    dbametrix
    - Advertisment -
    dbametrix

    Most Popular

    Oracle Scheduler Jobs Example

    Blog post explains how to configure job scheduler in Oracle by example with how to manage, delete, drop, disable and enable jobs with how to check history of job if broken and enable.

    Identifying important information in Big Data

    The way in which Big Data technologies have evolved in the real word enterprise goes on to show that even technologists and scientists who might have disparaged the word (Big Data) previously

    Five Reasons Why Database Outsourcing

    The blog post explains why database outsourcing and remote dba support becomes most popular during present time of Covid-19 Pandemic.

    Hardware of Database Server

    The blog post explains how to choose best hardware of your database server for getting high performance and security.

    Recent Comments