About Redhat Enterprise Linux 6.4 under oracle11g Chinese garbled problem summary

About Redhat Enterprise Linux 6.4 under oracle11g Chinese garbled problem summary

Time: 20140722 Li Fudong (Yi Tsai)

First, the phenomenon

1, Oracle and Sqldeveloper font garbled;

2, Sqldeveloper cannot enter and display Chinese.

Second, the problem analysis

1. First, the Chinese input method should be installed correctly.

2, Oralce and sqldeveloper-dependent jdk/jre do not support Chinese fonts

Third, the solution

1, install the Chinese Input Method Ibus-pinyin (from the Redhat installation file of the package found a few ibus the beginning of the pack, RPM can be);

2, Chinese Input method installed successfully, in the menu: system-Preference-Input method to select Chinese input methods can be;

3. Install the JDK (jdk1.7 installed here)

4, find Jdk/jre/lib/fonts directory, and then mkdir fallback;

5, Find/-name *.TTC find zgy font file, then ln-s font file directory/font filename fallback/

6. Execute Mkfontdir and Mkfontscale under fallback

7, netca/dbca/sqldeveloper.sh and so on to confirm whether can input Chinese;

8, to this end, or not, guess sqldeveloper default call is Oracle's own JRE, so delete the JRE under Oracle

9, restart Sqldeveloper, at this time can use Chinese input, and select is not garbled!

Iv. Summary

1, confirm that the JDK/JRE is used by Oracle and Sqldeveloper, the method is to remove the JDK under the Oracle test, will prompt;

2, the corresponding environment variables to be set correctly, including/etc/profile, ~/.bash_profile, examples are as follows:

Vi/etc/profile

Append to end of/etc/profile file:

#set Java Environment

Export java_home=/opt/jdk1.7

Export path= $JAVA _home/bin: $PATH

Export classpath= $CLASSPATH: $JAVA _home/lib: $JAVA _home/jre/lib

Export path= $JAVA _home/bin: $JAVA _home/jre/bin: $PATH

: Wq

Source/etc/profile

VI ~/.bash_profile

#set Oracle Environment

Export nls_lang= "simplified Chinese_china. ZHS16GBK "

Export Oracle_base=/opt/oracle

Export Oracle_home= $ORACLE _base/product/orahome

Export ORACLE_SID=ORCL

Export Oracle_owner=oracle

Export oracle_term=vt100

Export path= $PATH: $ORACLE _home/bin: $HOME/bin

Export path= $ORACLE _home/bin: $ORACLE _home/apache/apache/bin: $PATH

Ld_library_path= $ORACLE _home/lib:lib:/usr/lib:/usr/local/lib

Export Ld_library_path

Path= $PATH:/usr/sbin;export PATH

Path= $PATH:/usr/bin;export PATH

: Wq

SOURCE ~/.bash_profile

This article is from "Easy to blog" blog, please be sure to keep this source http://lifudong.blog.51cto.com/2357095/1441662

About Redhat Enterprise Linux 6.4 under oracle11g Chinese garbled problem summary