人大金仓初始化数据库报错“initdb: error: invalid locale name "zh_CN.UTF-8"”
Tags: initdbzh_CN.UTF-8人大金仓故障处理
报错
1 2 3 4 5 6 7 8 9 10 11 12 13 14 | =============================================================================== InitDB error ------------ The files belonging to this database system will be owned by user "kingbase". This user must also own the server process. initdb: error: invalid locale name "zh_CN.UTF-8" ->1- Next 2- Again ENTER THE NUMBER OF THE DESIRED CHOICE, OR PRESS <ENTER> TO ACCEPT THE DEFAULT: |
解决
该报错的主要原因就是本地缺失中文字符集,因为人大金仓初始化数据库默认使用参数--lc-ctype=zh_CN.UTF-8,所以需要直接安装中文字符集即可。
1 2 3 4 5 6 7 8 9 10 11 12 13 | locale -a | grep zh yum install *zh_CN* kde-l10n-Chinese localedef -c -f UTF-8 -i zh_CN zh_CN.utf8 locale -a | grep zh_CN [root@lhrkingbase ~]# locale -a | grep zh_CN zh_CN.gb18030 zh_CN.gb2312 zh_CN.gbk zh_CN.utf8 /opt2/Kingbase/ES/V8/Server/bin/initdb -U system -x lhr -E UTF-8 --lc-ctype=zh_CN.UTF-8 --lc-collate=zh_CN.UTF-8 -D /opt2/Kingbase/ES/V8/data --block-size=8 -m pg |