[Ubuntu14.04] install the oracle database management software sqldeveloper record, ubuntu14.04oracle

[Ubuntu14.04] install the oracle database management software sqldeveloper record, ubuntu14.04oracle

RT.

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

Article 1: [ubuntu14.04] Build a PHP5 + Apache2 + Oracle environment

This article will install the oracle database management software sqldeveloper on ubuntu14.04. The tutorial is as follows:

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

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:

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

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 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 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:

Refer to this article:

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

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/fontssudo mkdir fallbackcd fallbackcp msyh. ttf. /# msyh. ttf is a font file. Here, it uses. You can also use other font files as long as they support Chinese characters. Sudo mkfontdirsudo 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 sql1_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.