有ZHS16MACCGB231280这个字符集吗？

显示全部楼层 · 2015-8-18 12:18:21

很奇怪，偶想打PATCH时发现偶的数据库字符集竟然是
CREATE DATABASE TVSN05
MAXINSTANCES 1
MAXLOGHISTORY 1
MAXLOGFILES 5
MAXLOGMEMBERS 3
MAXDATAFILES 100
DATAFILE '/export/home/oracle/oradata/TVSN05/system01.dbf' SIZE 250M REUSE AUTOEXTEND ON NEXT10240
K MAXSIZE UNLIMITED
EXTENT MANAGEMENT LOCAL
DEFAULT TEMPORARY TABLESPACE TEMP TEMPFILE '/export/home/oracle/oradata/TVSN05/temp01.dbf' SIZE 40M
REUSE AUTOEXTEND ON NEXT640K MAXSIZE UNLIMITED
UNDO TABLESPACE "UNDOTBS1" DATAFILE '/export/home/oracle/oradata/TVSN05/undotbs01.dbf' SIZE 200M REU
SE AUTOEXTEND ON NEXT5120K MAXSIZE UNLIMITED
CHARACTER SET [B]ZHS16MACCGB231280[/B]
NATIONAL CHARACTER SET AL16UTF16
LOGFILE GROUP 1 ('/export/home/oracle/oradata/TVSN05/redo01.log') SIZE 102400K,
GROUP 2 ('/export/home/oracle/oradata/TVSN05/redo02.log') SIZE 102400K,
GROUP 3 ('/export/home/oracle/oradata/TVSN05/redo03.log') SIZE 102400K
同时发现DBMS_STANDARD不可用，这个谁遇到过？

千问 · 2015-8-18 12:18:21

查到了，确实有

千问 · 2015-8-18 12:18:21

呵呵，怎么会用这个字符集，比较奇怪

千问 · 2015-8-18 12:18:21

...........
catalog/catproc.sql运行不下去了....

千问 · 2015-8-18 12:18:21

遇到过这个ZHS16CGB231280，没遇到过你那个

千问 · 2015-8-18 12:18:21

数据库支持的字符集可以用如下语句查询
[php]
selectnls_charset_id(value) nls_charset_id, value nls_charset_name,
to_char(nls_charset_id(value),'xxxx') hex_id
from v$nls_valid_values
where parameter = 'CHARACTERSET'
order by nls_charset_id(value)
[/php]

千问 · 2015-8-18 12:18:21

先修改字符集为ZHS16GBK吧

千问 · 2015-8-18 12:18:21

ZHS16CGB231280要比ZHS16GBK小

千问 · 2015-8-18 12:18:21

最初由 Toms_zhang 发布
[B]先修改字符集为ZHS16GBK吧

[/B]其他系统都是ZHS16CGB231280，所以，忍着吧