"ubuntu14.04" Installs Oracle database management software Sqldeveloper records

Rt.

This is the second chapter in building the Oracle development Environment Journal.

The first article is:"ubuntu14.04" Build php5+apache2+oracle environment

This article installs the Oracle database management software Sqldeveloper on the ubuntu14.04 system. The reference tutorials are as follows:

Http://www.linuxidc.com/Linux/2010-06/26782.htm

The whole process of thinking is as follows:

1. Check the local JDK version, and if it is older, reconfigure the JDK environment

2. Download the corresponding version of Sqldeveloper from Oralce official

3. Solve Sqldeveloper Chinese display garbled

4. Settings 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)

Above is the JDK version on my system, if your version is too low, it is highly recommended that you upgrade the JDK version. Otherwise, during the installation of the latest version of the Sqldeveloper process, the boot will prompt the JDK version to be too low.

To reconfigure the JDK tutorial:

Http://www.linuxidc.com/linux/2014-11/109216.htm

The latest version of the JDK available on the Oracle website is 1.8, and we'll go directly to the URL below to download the corresponding version of the JDK:

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

The specific version needs to depend on your system, for example, my system is Ubuntu X64 14.04, then download the jdk-8u31-linux-x64.tar.gz version. Remember not to download the installation package in RPM format. We are a Debian/ubuntu type system and do not support RPM installation files.

Download complete, unzip the file, and then check if your system has a JDK installed, that is, check your system has the following directory:

/usr/lib/jvm

If not, use

sudo MKDIR/USR/LIB/JVM

Create a directory. If so, simply copy the extracted JDK folder that we downloaded to the directory.

Next, configure the environment variables for the JDK:

sudo vim ~/.profile

Add the following statement below the file:

# #For jdk1.8.0_31 pathexport java_home=/usr/lib/jvm/jdk1.8.0_31export jre_home=${java_home}/jreexport CLASSPATH=.:$ {Java_home}/lib:${jre_home}/libexport Path=${java_home}/bin: $PATH

The path to the Java_home constant needs to be configured according to your actual situation.

Then it makes the configuration effective immediately:

SOURCE ~/.profile

No surprises, you can see the same output as I did by looking at your JDK version again via the Java-version command.

Even if your system has already installed an older version of the JDK, you do not have to deal with 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 official:

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

When downloading, as is the Ubuntu system, select the other platform version when the version is selected.

After the download is done, unzip it and place it in the user's home directory, such as my ~/giantchan/.

Then go to the folder via the command line:

CD ~/User name/sqldeveloper

Run sqldeveloper.sh

sudo./sqldeveloper.sh

The first time you start, you will be prompted to enter the path to the JDK. How do I see the path to the JDK?

Which Javac

We can print out the directory of the JDK through this command:

/usr/lib/jvm/jdk1.8.0_31/bin/javac

We intercept the path to the jdk1.8.0_31/here, namely:

/usr/lib/jdk1.8.0_31

Remember not to take "/bin/javac", otherwise you will get an error, because sqldeveloper.sh will automatically look for the bin directory under this directory. If you add the path to the bin directory, it will be repeated.

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

sudo vim/home/user name/.sqldeveloper/4.1.0 (version number)/product.conf

Find the following statement to modify the path of the true JDK:

Setjavahome/usr/lib/jvm/jdk1.8.0_31

Save exit after the modification is complete.

Rerun the./sqldeveloper.sh file. At this point, you can start sqldeveloper normally. However, the client interface will still appear in Chinese garbled. The next third step is to solve the garbled problem.

3. Solve the problem of garbled sqldeveloper in Ubuntu:

Refer to this article:

http://blog.csdn.net/hymer2011/article/details/6888344

We download any Chinese font TTF file from the Internet (must be TTF).

Then follow the steps in the tutorial step by step:

CD Java_home/jre/lib/fontssudo mkdir fallbackcd fallbackcp Msyh.ttf.         # Here the Msyh.ttf is a font file, this is used in Microsoft Ya Black, you can also use other font files, as long as the support of Chinese. sudo mkfontdirsudo Mkfontscale

Then restart the sqldeveloper. At this point, Sqldeveloper has been successfully installed on Ubuntu, it can run normally.

4. Run from the command line:

We can add the following command to the ~/.BASHRC file:

#oracle sqldeveloperalias sqld= ' cd ~/user name/sqldeveloper && sudo./sqldeveloper.sh '

The setting takes effect immediately with the source command:

SOURCE ~/.BASHRC

After that, you can start the Sqldeveloper software by Sqld command.

"ubuntu14.04" Installs Oracle database management software Sqldeveloper records