Install Oracle database management software SQL Developer in Ubuntu 14.04

Install Oracle database management software SQL Developer in Ubuntu 14.04

This is the second article about building Oracle Development Environment logs.

Article 1: Build a PHP5 + Apache2 + Oracle environment in Ubuntu 14.04

This article will install the Oracle database management software SQL Developer on Ubuntu 14.04.

The tutorial is as follows:

The entire process is as follows:

1. Check the local jdk version. If it is old, reconfigure the JDK environment.

2. Download the corresponding version of sqldeveloper from the oralce official website.

3. Solve Chinese display garbled characters of sqldeveloper

4. Set to run from the command line

Installation Process:

1. Check the local jdk version:

Java-version

Java version "1.8.0 _ 31"
Java (TM) SE Runtime Environment (build 1.8.0 _ 31-b13)
Java HotSpot (TM) 64-Bit Server VM (build 25.31-b07, mixed mode)

The above is the jdk version on my system. If your version is too low, we strongly recommend that you upgrade the jdk version. Otherwise, the system prompts that the jdk version is too low during the installation of the latest sqldeveloper version.

How to reconfigure jdk:

Currently, the latest jdk version is 1.8 on the official oracle website. Visit the following URL to download the corresponding jdk version:

Http://www.oracle.com/technetwork/java/javase/downloads/jdk8-downloads-2133151.html

The specific version depends on your system. For example, if my system is ubuntu X64 14.04, The jdk-8u31-linux-x64.tar.gz version is downloaded. Do not download the rpm installation package. We are a debian/ubuntu system and do not support rpm installation files.

Download the file, decompress the file, and check whether your system has installed jdk, that is, check whether your system has the following directory:

/Usr/lib/jvm

If not, use

Sudo mkdir/usr/lib/jvm

Create a directory. If yes, copy the decompressed jdk folder to the directory.

Next, configure the jdk environment variables:

Sudo vim ~ /. Profile

Add the following statement to the file:

# For jdk1.8.0 _ 31 PATH
Export JAVA_HOME =/usr/lib/jvm/jdk1.8.0 _ 31
Export JRE_HOME =$ {JAVA_HOME}/jre
Export CLASSPATH =. :$ {JAVA_HOME}/lib :$ {JRE_HOME}/lib
Export PATH =$ {JAVA_HOME}/bin: $ PATH

The path of the JAVA_HOME constant must be configured based on your actual situation.

Then the configuration takes effect immediately:

Source ~ /. Profile

Not surprisingly, now you can view your jdk version through the java-version command again, and you will see the same output as above.

Even if your system has already installed the old jdk version, you do not have to process the original jdk. This process automatically sets the system's jdk to the latest installed version.

2. download the latest version of the oracle sqldeveloper installation package from oracle:

Http://www.oracle.com/technetwork/developer-tools/sql-developer/downloads/sqldev-41ea-2372780.html

During the download, because it is a ubuntu system, select the Other Platform version when selecting the version.

Decompress the downloaded package and place it in the user's home directory. For example ~ /Giantchan /.

Then enter the folder through the command line:

Cd ~ /User name/sqldeveloper

Run sqldeveloper. sh

Sudo./sqldeveloper. sh

At the first startup, you will be prompted to enter the jdk path. How can I view the jdk path?

Which javac

We can print out the jdk directory through this command:

/Usr/lib/jvm/jdk1.8.0 _ 31/bin/javac

We take the path to JDK 1.8.0 _ 31/, that is:

/Usr/lib/jdk1.8.0 _ 31

Do not include "/bin/javac". Otherwise, an error is reported because sqldeveloper. sh will automatically search for the bin directory under this directory. If the bin directory path is added, it will be repeated.

If you accidentally add the bin directory, you can go to/home/user name/. sqldeveloper/4.1.0 (Version)/product. conf

Sudo vim/home/user name/. sqldeveloper/4.1.0 (Version)/product. conf

Find the following statement and modify the actual jdk path:

SetJavaHome/usr/lib/jvm/jdk1.8.0 _ 31

Save the modification and exit.

Run the./sqldeveloper. sh file again. You can start sqldeveloper normally. However, Chinese garbled characters still appear on the client interface. The third step is to solve the garbled problem.

3. Solve the garbled problem of sqldeveloper in ubuntu:

We download any Chinese Text ttf file from the Internet (ttf must be used ).

Perform the following operations step by step:

Cd JAVA_HOME/jre/lib/fonts

Sudo mkdir fallback

Cd fallback

Cp msyh. ttf./# Here, msyh. ttf is a font file. Here, it uses, or other font files, as long as it supports Chinese characters.

Sudo mkfontdir

Sudo mkfontscale

Restart sqldeveloper. So far, sqldeveloper has been successfully installed on ubuntu and can run properly.

4. Run the following command from the command line:

We can ~ /. Add the following command to the bashrc file:

# Oracle sqldeveloper
Alias sqld = 'CD ~ /Username/sqldeveloper & sudo./sqldeveloper. Sh'

Then use the source command to make the settings take effect immediately:

Source ~ /. Bashrc

You can use the sqld command to start the sqldeveloper software later.

Install Oracle 11g in RedHat Linux 6.0

Install Oracle 11gR2 (x64) in CentOS 6.4)

Steps for installing Oracle 11gR2 in vmwarevm

Install Oracle 11g XE R2 In Debian

Sharing pool for Oracle Performance Optimization