Garbled in fact is the main set of Chinese is the default system language, as long as the set back to English to solve the garbled. To prevent garbled during Oracle installation, it is recommended that you use English as your system language to install Oracle
Reply Hobby 22:37:30
To solve one: set the language to English, restart the system
[Root@zfdb ~]# more/etc/sysconfig/i18n
Lang= "en_US. UTF-8 "
Sysfont= "Latarcyrheb-sun16"
Solution Two:
Many people in the rhel5 installed oracle10g when garbled, in fact, in the installation and use of garbled places there are several, can be divided into three categories:
1. When the installation of garbled
2. Some of the application of garbled, such as DBCA, NETCA
This column more highlights: http://www.bianceng.cnhttp://www.bianceng.cn/database/Oracle/
3. Some oc4j Web applications, such as isqlplus, EM cause these problems are one, that is, these programs use the JDK, the corresponding JDK (or JRE) use of the font profile font.properties The fonts in the and operating system fonts or font profiles do not match. The solution is to change the two to the same.
1. Download, unpack ship.db.cpio.gz, generate directory Disk1
2. CD disk1/stage/components/oracle.swd.jre/1.4.2.0.0/1/datafiles/
Unzip All_except_bin.jar
(This generates a directory of JRE)
CD jre/1.4.2/lib/
MV Font.properties Font.properties.bak
CP Font.properties.zh_CN. Redhat8.0 font.properties
Cd.. /.. /.. /
Zip-r all_except_bin.jar.new jre/
MV All_except_bin.jar.new All_except_bin.jar
(So tired, in fact, is to replace the font.properties file.) so that the Chinese character display is no problem when installed. 3. Do the same, the Disk1/stage/components/oracle.jdk/1.4.2.0.0/1/datafiles/sol_bin.1.1.jar file inside the font.properties file to replace, When you create a database and perform a network configuration, the garbled characters are gone. Isqlplus and EM garbled also solved. Already installed, do not need to reinstall, just the following three files, clear the cache directory, restart the corresponding program or services on it.
$ORACLE _home/javavm/lib/ojvmfonts/font.properties
$ORACLE _home/jre/1.4.2/lib/font.properties
$ORACLE _home/jdk/jre/lib/font.propertiesemctl Stop Dbconsole
Isqlplusctl stop
And then delete the directory
$ORACLE _home/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/and
$ORACLE _home/oc4j/j2ee/oc4j_applications/applications/isqlplus/isqlplus/cabo/images/cache/zhs/all the GIF files below,
Restart the service, it's OK.