oracle notes

Posted on 2009-06-30 filed under: Oracle (RSS) 19 views

EM services start and stop (10g)

emctl start dbconsole

emctl stop dbconsole

emctl status dbconsole

Oracle10g EM garbled the quick fixes

Show only English.

To the IE select "Tools "==>" "==>" internet options to add "==>" English language "==>"" ==> and then moved up in English.

http://www.eygle.com/archives/2006/03/oracle10g_em_font_change.html

Had not been how to use 10g of EM tools, take a look at today's open and found that there are the garbled word problem for a long time. Online spread the N kinds of solutions, look carefully, in fact, this problem solved.

If the installation, our system environment variable is the Chinese environment, then there would not have this problem. The root causes of this problem is to install, JDK / JRE character set automatically.

In the $ ORACLE_HOME / jdk / jre / lib and $ ORACLE_HOME / jre / 1.4.2 / lib / directory will have a variety of character sets the font configuration file:

[oracle@danaly ~]$ cd $ORACLE_HOME/jdk/jre/lib
[oracle@danaly lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat  font.properties.zh_CN.Redhat2.1  
font.properties.zh_CN.Sun  font.properties.zh_CN_UTF8.Sun

[oracle@danaly lib]$ cd $ORACLE_HOME/jre/1.4.2/lib/
[oracle@danaly lib]$ ls font*zh_CN*
font.properties.zh_CN.Redhat  font.properties.zh_CN.Redhat2.1  
font.properties.zh_CN.Sun  font.properties.zh_CN_UTF8.Sun

As long as we use the appropriate file to replace the Chinese character set to the default file, I choose to use to replace the default font font.properties.zh_CN.Redhat definition files:

[oracle@danaly lib]$ cp font.properties.zh_CN.Redhat font.properties

Need to be cleaned up after you replace the Cache, you can restart EM.

Cache is usually located in the path:

$ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs

Gif files you can remove all. And then restart the EM:

[oracle@danaly zhs]$ emctl stop dbconsole
TZ set to PRC
oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 oracle Corporation.  All rights reserved.
http://danaly.hurrray.com.cn:1158/em/console/aboutApplication
Stopping oracle Enterprise Manager 10g Database Control ... 
 ...  Stopped. 
[oracle@danaly zhs]$ emctl start dbconsole
TZ set to PRC
oracle Enterprise Manager 10g Database Control Release 10.2.0.1.0  
Copyright (c) 1996, 2005 oracle Corporation.  All rights reserved.
http://danaly.hurrray.com.cn:1158/em/console/aboutApplication
Starting oracle Enterprise Manager 10g Database Control .............. started. 
------------------------------------------------------------------
Logs are generated in directory 
/opt/oracle/product/10.2.0/danaly.hurrray.com.cn_danaly/sysman/log

Now landing Web page, EM display can display Chinese.

Note: If, after more than deal with the Chinese still can not display correctly, please refer to the following description:

Open just a good replacement font.properties, or view the original Chinese text documents:

[oracle @ smsdbrac1 lib] $ tail -2 font.properties.zh_CN.Redhat
filename.-misc-zysong18030-medium-r-normal--*-% d-*-*- c-*- iso10646-1 = / usr / share / fonts / zh_CN / TrueType / zysong.ttf

Includes attention to the Chinese font file filename, make sure that the file in your server if there is, if does not exist, there is a change of a font file to the Chinese, but also can download and install a new font file:

[oracle @ smsdbrac1 lib] $ ls-al / usr / share / fonts / zh_CN / TrueType / zysong.ttf
-rw-r - r - 1 root root 9249332 Mar 29 2002 / usr / share / fonts / zh_CN / TrueType / zysong.ttf

Starter Edition

oracle em in garbled button

2009-06-12 06:53

oracle em in garbled button solution:
1. Jdk modify the fonts below.
[oracle @ rac2 db_1] $ cd $ ORACLE_HOME / jdk / jre / lib /
[oracle @ rac2 lib] $ mv font.properties font.properties_bak
[oracle @ rac2 lib] $ cp font.properties.zh_CN.Redhat font.properties

2. Jre to amend the following fonts
[oracle @ rac2 lib] $ cd $ ORACLE_HOME/jre/1.4.2/lib
[oracle @ rac2 lib] $ mv font.properties font.properties_bak
[oracle @ rac2 lib] $ cp font.properties.zh_CN.Redhat font.properties

3. The cache to clear em
[oracle @ rac2 lib] $ cd $ ORACLE_HOME/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs
[oracle @ rac2 zhs] $ rm *. gif

4. Restart em
[oracle @ rac2 zhs] $ emctl stop dbconsole
[oracle @ rac2 zhs] $ emctl start dbconsole

In addition, the need to pay attention to the last line of the set font.properties font file, if there is no need to specify the font file already exists, but also pay attention to font file must have the authority to operate

Such as:
[oracle @ localhost lib] $ tail-n 3 font.properties
filename.-misc-zysong18030-medium-r-normal--*-% d-*-*- c-*- iso10646-1 = / usr / share / fonts / chinese / TrueType / uming.ttf