oracle 12c AL32UTF8字符集修改为ZHS16GBK

[root@orcl2 12c]# su - oracle
上一次登录：六 8月 20 15:31:12 CST 2016pts/2 上
[oracle@orcl2 ~]$tnsping t_xshis


TNS Ping Utility for Linux: Version 12.1.0.2.0 - Production on 21-AUG-2016 12:57:09


Copyright (c) 1997, 2014, Oracle.  All rights reserved.


Used parameter files:
/oracle/app/oracle/product/12.1/db_1/network/admin/sqlnet.ora




Used TNSNAMES adapter to resolve the alias
Attempting to contact (DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST = orcl2)(PORT = 1525)) (CONNECT_DATA = (SERVER = DEDICATED) (SERVICE_NAME = t_xshis)))
OK (0 msec)
[oracle@orcl2 ~]$echo $ORACLE_SID
xshis2
[oracle@orcl2 ~]$export ORACLE_SID=xshis
[oracle@orcl2 ~]$sqlplus / as sysdba


SQL*Plus: Release 12.1.0.2.0 Production on Sun Aug 21 12:58:08 2016


Copyright (c) 1982, 2014, Oracle.  All rights reserved.




Connected to:
Oracle Database 12c Enterprise Edition Release 12.1.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP, Advanced Analytics
and Real Application Testing options


SQL> show parameter service


NAME                                 TYPE        VALUE
------------------------------------ ----------- ------------------------------
service_names                        string      t_xshis

SQL> 

SQL> select userenv('language') from dual;


USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8


SQL> shutdown immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP MOUNT EXCLUSIVE;
ORACLE instance started.


Total System Global Area 2.4964E+10 bytes
Fixed Size                  7656800 bytes
Variable Size            5368711840 bytes
Database Buffers         1.9529E+10 bytes
Redo Buffers               59449344 bytes
Database mounted.
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;


System altered.


SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;


System altered.


SQL> ALTER SYSTEM SET AQ_TM_PROCESSES=0;


System altered.


SQL> ALTER DATABASE OPEN;


Database altered.


SQL> ALTER DATABASE CHARACTER SET INTERNAL_USE ZHS16GBK;


Database altered.


SQL> ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE AL16UTF16;


Database altered.


SQL> SHUTDOWN IMMEDIATE
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> STARTUP
ORACLE instance started.


Total System Global Area 2.4964E+10 bytes
Fixed Size                  7656800 bytes
Variable Size            5368711840 bytes
Database Buffers         1.9529E+10 bytes
Redo Buffers               59449344 bytes
Database mounted.
Database opened.
SQL> select userenv('language') from dual;


USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.ZHS16GBK


SQL> col parameter format a32;
SQL> col value format a32;
SQL> select * from nls_database_parameters;


PARAMETER                        VALUE
-------------------------------- --------------------------------
NLS_RDBMS_VERSION                12.1.0.2.0
NLS_NCHAR_CONV_EXCP              FALSE
NLS_LENGTH_SEMANTICS             BYTE
NLS_COMP                         BINARY
NLS_DUAL_CURRENCY                $
NLS_TIMESTAMP_TZ_FORMAT          DD-MON-RR HH.MI.SSXFF AM TZR
NLS_TIME_TZ_FORMAT               HH.MI.SSXFF AM TZR
NLS_TIMESTAMP_FORMAT             DD-MON-RR HH.MI.SSXFF AM
NLS_TIME_FORMAT                  HH.MI.SSXFF AM
NLS_SORT                         BINARY
NLS_DATE_LANGUAGE                AMERICAN


PARAMETER                        VALUE
-------------------------------- --------------------------------
NLS_DATE_FORMAT                  DD-MON-RR
NLS_CALENDAR                     GREGORIAN
NLS_NUMERIC_CHARACTERS           .,
NLS_NCHAR_CHARACTERSET           AL16UTF16
NLS_CHARACTERSET                 ZHS16GBK
NLS_ISO_CURRENCY                 AMERICA
NLS_CURRENCY                     $
NLS_TERRITORY                    AMERICA
NLS_LANGUAGE                     AMERICAN


20 rows selected.


SQL>