Oracle 11g如何處理EM按鍵亂碼

Oracle 11g如何處理EM按鍵亂碼

今天用Mac串連VMware Fusion虛擬機器資料庫，突然想用EM，忽然發現確定按鍵為亂碼。如：

分析：解決問題就是找到正確的字型。

處理方法：

1. 通過Windows機器c:\windows\fonts下找到simsun.ttc 這樣的字型檔。

2. 在$Oracle_home/jdk/jre/lib/fonts 目錄下建立檔案夾，名字為fallback

    [oracle@test ~]$ cd $ORACLE_HOME/jdk/jre/lib/fonts/
    [oracle@test fonts]$ mkdir fallback

3. 將simsun.ttc上傳到linux機器剛剛建立的fallback目錄中並改名為simsum.ttf

    ftp上傳省略

    [oracle@test fallback]$ ls
    simsun.ttc
    [oracle@test fallback]$ mv simsun.ttc simsun.ttf
    [oracle@test fallback]$ ls
    simsun.ttf

4. 清理cache

    [oracle@test fallback]$ cd                /11g/app/oracle/product/11.1.0/dbhome_1/oc4j/j2ee/oc4j_applications/applications/em/em/cabo/images/cache/zhs/
    [oracle@test zhs]$ ls
    b049hVl.imx    b498zwk.imx    b70gpYl.imx    bb5DgWk-2.imx  bb5DgWk.imx    beeJtrj.imx
    b0byrAl.imx    b54Gjjk.imx    b8f_7mj.imx    bb5DgWk-3.gif  bb5e67kMn.imx  bf8f3pRUd.imx
    b11ZkGl.imx    b5b-vtk.imx    ba936LkSR.imx  bb5DgWk-3.imx  bbaGAYl.imx    t00MaF3.imx
    b2549BKrI.imx  b61CMCk.imx    bb06006NO.imx  bb5DgWk-4.gif  bbcbaZ4nV.imx  t0MaF3.imx
    b48tkDl.imx    b6956szjB.imx  bb5DgWk-1.imx  bb5DgWk-4.imx  beaVDSk.imx
    [oracle@test zhs]$ rm -rf *.gif

5. 重新啟動EM

[oracle@test zhs]$ emctl status dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://test:1158/em/console/aboutApplication
Oracle Enterprise Manager 11g is running.
------------------------------------------------------------------
Logs are generated in directory /11g/app/oracle/product/11.1.0/dbhome_1/test_orcl/sysman/log
[oracle@test zhs]$ emctl stop dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://test:1158/em/console/aboutApplication
Stopping Oracle Enterprise Manager 11g Database Control ...
 ...  Stopped.
[oracle@test zhs]$ emctl start dbconsole
Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
https://test:1158/em/console/aboutApplication
Starting Oracle Enterprise Manager 11g Database Control ................... started.
------------------------------------------------------------------
Logs are generated in directory /11g/app/oracle/product/11.1.0/dbhome_1/test_orcl/sysman/log
[oracle@test zhs]$

6. 開啟EM，字型恢複中文正常

總結：雖然是個字型的問題，但是這裡面覆蓋的內容還是挺多的，本人也是通過借鑒他人的文章才處理的這麼快，感謝分享文章的朋友們，又處理完個新問題，好happy。