- 论坛徽章:
- 0
|
在安装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软件,呵呵,消息不乱码了。
本文来自ChinaUnix博客,如果查看原文请点:http://blog.chinaunix.net/u/18055/showart_1849479.html |
|