公司安装个 oracle 12c 测试环境，准备把线上的库导出来测试性能，结果把测试库的字符集选了AL32UTF8 ，一看线上是ZHS16GBK，还是保持一致吧，遂记录 AL32UTF8 改 ZHS16GBK字符集过程：
首先最重要的事：备份！备份数据！别忘记备份数据！
C:\Windows\system32>sqlplus /nologSQL*Plus: Release 12.1.0.2.0 Production on 星期二 2月 27 10:59:23 Copyright (c) 1982, , Oracle. All rights reserved.SQL> conn / as sysdba已连接。SQL> select userenv('language') from dual;USERENV('LANGUAGE')--------------------------------------------------------------------------------SIMPLIFIED CHINESE_CHINA.AL32UTF8SQL> shutdown immediate数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> STARTUP MOUNT EXCLUSIVE;ORACLE 例程已经启动。Total System Global Area 2533359616 bytesFixed Size 3835256 bytesVariable Size 738200200 bytesDatabase Buffers 1778384896 bytesRedo Buffers12939264 bytes数据库装载完毕。SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;系统已更改。SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;系统已更改。SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;系统已更改。SQL> ALTER DATABASE OPEN;数据库已更改。SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;数据库已更改。SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;数据库已更改。SQL> SHUTDOWN IMMEDIATE数据库已经关闭。已经卸载数据库。ORACLE 例程已经关闭。SQL> STARTUPORACLE 例程已经启动。Total System Global Area 2533359616 bytesFixed Size 3835256 bytesVariable Size 738200200 bytesDatabase Buffers 1778384896 bytesRedo Buffers12939264 bytes数据库装载完毕。数据库已经打开。SQL> select userenv('language') from dual;USERENV('LANGUAGE')----------------------------------------------------SIMPLIFIED CHINESE_CHINA.ZHS16GBKSQL> col parameter format a32;SQL> col value format a32;SQL> select * from nls_database_parameters;PARAMETER VALUE-------------------------------- --------------------------------NLS_RDBMS_VERSION12.1.0.2.0NLS_NCHAR_CONV_EXCP FALSENLS_LENGTH_SEMANTICS BYTENLS_COMPBINARYNLS_DUAL_CURRENCY$NLS_TIMESTAMP_TZ_FORMATDD-MON-RR HH.MI.SSXFF AM TZRNLS_TIME_TZ_FORMATHH.MI.SSXFF AM TZRNLS_TIMESTAMP_FORMAT DD-MON-RR HH.MI.SSXFF AMNLS_TIME_FORMAT HH.MI.SSXFF AMNLS_SORTBINARYNLS_DATE_LANGUAGEAMERICANPARAMETER VALUE-------------------------------- --------------------------------NLS_DATE_FORMAT DD-MON-RRNLS_CALENDAR GREGORIANNLS_NUMERIC_CHARACTERS .,NLS_NCHAR_CHARACTERSET AL16UTF16NLS_CHARACTERSET ZHS16GBKNLS_ISO_CURRENCY AMERICANLS_CURRENCY $NLS_TERRITORYAMERICANLS_LANGUAGE AMERICAN已选择 20 行。SQL>
oracle 12c 将 AL32UTF8 字符集修改为 ZHS16GBK 完成。
