HP OM 汉化一例

在安装OM软件时选择了字符集为中文，但后来发现对模板汉化时出现乱码问题：


安装时选择没错：

数据库字符集 (NLS_LANG)
 
典型实例有

 
american_america.WE8ISO8859P15          (英语/缺省值)

american_canada.WE8ISO8859P15           (加拿大 - 英语)
 
canadian french_canada.WE8ISO8859P15    (加拿大 - 法语)
 
french_france.WE8ISO8859P15             (法语)
     
german_germany.WE8ISO8859P15            (德语)
    
japanese_japan.JA16SJIS                 (日语)
  
korean_korea.KO16KSC5601                (韩语)
  
russian_cis.CL8ISO8859P5                (俄语)
 
simplified chinese_china.ZHS16CGB231280 (简体中文)
  
spanish_spain.WE8ISO8859P15             (西班牙语)
 
traditional chinese_taiwan.ZHT16BIG5    (繁体中文)

  
其他的有效设置请参照您的 Oracle 手册 :
[simplified chinese_china.ZHS16CGB231280]

simplified chinese_china.ZHS16CGB231280

正在检查 NLS_LANG 变量 (simplified chinese_china.ZHS16CGB231280)

完成检查

查找ORACLE参数文件：
nnm# more /sbin/init.d/ov500   
#!/sbin/sh
#
# @(#) HP OpenView ICVT:  NNM Release B.07.50  Oct 17 2005
# @(#) $Revision: /main/5 $
#
# NOTE:    This script is not configurable!  Any changes made to this
#          scipt will be overwritten when you upgrade to the next
#          release of OpenView.
#
# WARNING: Changing this script in any way may lead to a system that
#          is unbootable.  Do not modify this script.
#
#       This script starts various OpenView processes.
#
# WARNING: OpenView users of commercial database products should shutdown
#          their databases AFTER this script executes.
#
ECHO_CMD_SUN=/usr/5bin/echo
ECHO_CMD_HP=echo
PATH=$PATH:/usr/bin:/bin
export PATH
 
case $1 in
'start_msg')
        echo "Starting OpenView" ;;
 
'stop_msg')
        echo "Stopping OpenView" ;;
 
   'start')
        if [ "${OVHOME}" = "" ] ; then
                case `uname` in
                        SunOS)
                                ECHO_CMD = $ECHO_CMD_SUN
                                OVHOME=/opt/OV
                                PATH=/usr/5bin:/usr/ucb:/usr/etc:$PATH
                                export PATH
                                ;;
                        HP-UX)
                                ECHO_CMD=$ECHO_CMD_HP
                                OVHOME=/opt/OV
                                PATH=/bin:/usr/bin:/etc:$PATH
                                export PATH
                                ;;
                esac
        fi
        # set environment variables for startup
        if [ -f /etc/rc.config ] ; then
           . /etc/rc.config
        else
           echo "ERROR: /etc/rc.config defaults file MISSING"
        fi
        # set environment variables for network management programs
        if [ -f $OVHOME/bin/netnmrc.sh ] ; then
            . $OVHOME/bin/netnmrc.sh
        fi
 
        # set environment variables for Databases
        if [ -f $OVHOME/bin/ovSetDBEnv ] ; then
            . $OVHOME/bin/ovSetDBEnv
        fi



nnm# more /opt/OV/bin/ovSetDBEnv
#!/bin/sh
#
# @(#)ovSetDBEnv
# HP OpenView Release B.0X.XX (will be replaced by copy_proot)
# Copyright (c) 1991-1995 Hewlett-Packard Company (updated by copy_proot)
#
################################################################################
#
# File:         ovSetDBEnv
# Description:  This script will add Oracle or Ingres environment variables to
#               the current shell.
#
# Usage:        . ovSetDBEnv
#
#  Note: This file MUST BE SOURCED! If it is just run, the environment
#        variables will revert to their previous state after the
#        script completes.
#
# Author:       Paul Price, NSMD
# Created:      April 23, 1996
# Modified:
# Language:     Bourne Shell
# Package:
# Patches:     
#
################################################################################
 
# find the correct location of the configuration file, depending on platform
case `uname` in
        SunOS)
                case `uname -r` in
                        4.*) OVDB_CONFIG_FILE="/usr/OV/conf/ovdbconf"
                             ORA_CONFIG_FILE="/usr/OV/conf/ovdbora" ;;
                        5.*) OVDB_CONFIG_FILE="/etc/opt/OV/share/conf/ovdbconf"
                             ORA_CONFIG_FILE="/opt/OV/conf/ovdbora" ;;
                esac ;;
        HP-UX)
                case `uname -r` in
                        *.09.*) OVDB_CONFIG_FILE="/usr/OV/conf/ovdbconf"
                                ORA_CONFIG_FILE="/usr/OV/conf/ovdbora" ;;
                        *.1?.*) OVDB_CONFIG_FILE="/etc/opt/OV/share/conf/ovdbconf"
                                ORA_CONFIG_FILE="/opt/OV/conf/ovdbora" ;;
                esac ;;
esac



呵呵，我的应该是HP-UX B.11.31

nnm# more /etc/opt/OV/share/conf/ovdbconf
DB_VENDOR Oracle
DB_NAME openview
DB_RELEASE 10.2.0
DB_TIME_STAMP ""
DB_USER ovdb
ORACLE_SID openview
ORACLE_HOME /oracle/product/10.2/db_1
ORACLE_BASE /oracle
DBA_USER oracle
DATA_DIR /oradata
CREATE_DIR /oracle/admin/openview/create
INDEX_DIR /oradata
ADMIN_DIR /oracle
OS_AUTHENT_PREFIX
CHARACTER_SET WE8ISO8859P1
BASE_DATA_TS_SIZE 25
BASE_INDEX_TS_SIZE 5
DATA_TS_SIZE
INDEX_TS_SIZE
TEMP_TS_SIZE
DATA_TS_EXTENT_SIZE
DATA_TS_MAX_SIZE
INDEX_TS_EXTENT_SIZE
ECHO_CMD echo
PROMPT TRUE
DBA_PROGRAM sqlplus
OV_USER ovdb
DBA_LOGFILE /var/opt/OV/share/log/sqlplus_log
ORACLE_BASE_REV 10
ORACLE_SECOND_REV 2
NLS_LANG simplified chinese_china.ZHS16CGB231280
djt_nm#



nnm#  more /opt/OV/conf/ovdbora
DB_VENDOR Oracle
DB_NAME openview
DB_RELEASE 10.2.0
DB_TIME_STAMP ""
DB_USER ovdb
ORACLE_SID openview
ORACLE_HOME /oracle/product/10.2/db_1
ORACLE_BASE /oracle
DBA_USER oracle
DATA_DIR /oradata
CREATE_DIR /oracle/admin/openview/create
INDEX_DIR /oradata
ADMIN_DIR /oracle
OS_AUTHENT_PREFIX
CHARACTER_SET WE8ISO8859P1
BASE_DATA_TS_SIZE 25
BASE_INDEX_TS_SIZE 5
DATA_TS_SIZE
INDEX_TS_SIZE
TEMP_TS_SIZE
DATA_TS_EXTENT_SIZE
DATA_TS_MAX_SIZE
INDEX_TS_EXTENT_SIZE
ECHO_CMD echo
PROMPT TRUE
DBA_PROGRAM sqlplus
OV_USER ovdb
DBA_LOGFILE /var/opt/OV/share/log/sqlplus_log
ORACLE_BASE_REV 10
ORACLE_SECOND_REV 2
NLS_LANG simplified chinese_china.ZHS16CGB231280
nnm#


 将这两个NLS_LANG改成中文所需要的"simplified chinese_china.ZHS16CGB231280",再重启动OM软件，呵呵，消息不乱码了。