Tuesday, July 11, 2017

Steps to Configure Unicode Fonts in Oracle Reports



                A.  Steps to install fonts to server
                A.1 )  Create a directory for new fonts
     Ex -  #  mkdir /usr/share/fonts/truetype
             A.2) Copy the font to the above directory 
             A.3)  Navigate to the directory & Execute below Commands
                # mkfontscale && mkfontdir
               # fc-cache
                A.4)  Add the new font directory to the X11 font path

                # chkfontpath --add /usr/share/fonts/truetype
                A.5) Restart X font server
                # /etc/rc.d/init.d/xfs restart

Step 2 .  Copy the Fonts to the Below Folder & change the ownership to the app server user
                 $ORACLE_INSTANCE/reports/fonts/
Step 3 .   Add the Fonts to [PDF:Subset] section in uifont.ali File as follows. 

Ex - 
[PDF:Subset]
"Khmer OS System"="KhmerOS_sys.ttf"
"Khmer OS"="KhmerOS.ttf"

 Step 4 .   To display fonts in Styles use the settings as follows in uifont.ali file.

 Ex -

[PDF:Subset]
"Roboto"..Italic.Bold..="Roboto-BoldItalic.ttf"
"Roboto"...Bold..="Roboto-Bold.ttf"
"Roboto"..Italic...="Roboto-Italic.ttf"
             "Roboto".....="Roboto-Regular.ttf"

 Step 5.   To Enable Unicode fonts In report, Change the  

                NLS_LANG To  AMERICAN_AMERICA.UTF8  in            
                $ORACLE_INSTANCE /config/reports/bin/reports.sh

 I.e.  NLS_LANG=AMERICAN_AMERICA.UTF8;

Step 6.   To Effect the changes Restart the opmnctl

Please Note
This font configuration Document Created based on Khmer & Roboto font configuration

No comments:

Post a Comment