oracle11g安裝字元集選哪個,centos 安裝oracle 11g r2（四）-----修改字元集為ZHS16GBK

centos 安裝oracle 11g r2(四)-----修改字元集為ZHS16GBK

一、查詢兩個庫的字元集

select userenv('language') from dual;

源端：

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

USERENV('LANGUAGE')

----------------------------------------------------

AMERICAN_AMERICA.ZHS16GBK

目标端：

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

USERENV('LANGUAGE')

--------------------------------------------------------------------------------

AMERICAN_AMERICA.AL32UTF8

二、修改目标端字元集

SQL> alter system checkpoint;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL>

SQL> startup mount;

ORACLE instance started.

Total System Global Area 1586708480 bytes

Fixed Size 2253624 bytes

Variable Size 1040190664 bytes

Database Buffers 536870912 bytes

Redo Buffers 7393280 bytes

Database mounted.

SQL>

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 system set nls_language='AMERICAN' scope=spfile;

System altered.

SQL> alter system set nls_territory='AMERICA' scope=spfile;

System altered.

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 1586708480 bytes

Fixed Size 2253624 bytes

Variable Size 1040190664 bytes

Database Buffers 536870912 bytes

Redo Buffers 7393280 bytes

Database mounted.

Database opened.

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

USERENV('LANGUAGE')

--------------------------------------------------------------------------------

AMERICAN_AMERICA.ZHS16GBK

————————————————