Oracle集群模式修改pdb字符集

提示：文章写完后，目录可以自动生成，如何生成可参考右边的帮助文档

---

前言

12c的12.1版本后的新特性，pdb可采用不同的字符集，需要注意的是超集关系，一般AL32UTF8与ZHS16GBK共存，cdb字符集必须为AL32UTF8

---

提示：以下是本篇文章正文内容，下面案例可供参考

一、操作日志，仅供参考

[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 31 16:19:34 2021
Version 19.3.0.0.0

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



Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> SQL> 
SQL> 
SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 TSPDB			  READ WRITE NO
SQL> 
SQL> 
SQL> 
SQL> select userenv('language') from dual;

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

SQL> 
SQL> 
SQL> alter session set container =tspdb;

Session altered.

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

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

SQL> 
SQL> 
SQL> exit
Disconnected from Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ dbca
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ 
[oracle@rac1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 31 16:25:42 2021
Version 19.3.0.0.0

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


Connected to:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL> 
SQL> 
SQL> show pdbs                                           

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 TSPDB			  READ WRITE NO
SQL> 
SQL> 
SQL> alter pluggable database TSPDB close instance=all;
alter pluggable database TSPDB close instance=all
                                     *
ERROR at line 1:
ORA-00933: SQL command not properly ended


SQL> alter pluggable database TSPDB close instances=all;

Pluggable database altered.

SQL> 
SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 TSPDB			  MOUNTED
SQL> 
SQL> 
SQL> alter pluggable database TSPDB open read write restricted;

Pluggable database altered.

SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 TSPDB			  READ WRITE YES
SQL> 
SQL> 
SQL> alter session set container=TSPDB;

Session altered.

SQL> 
SQL> alter database character set internal_use ZHS16GBK;     

Database altered.

SQL> 
SQL> alter pluggable database TSPDB close;

Pluggable database altered.

SQL> 
SQL> 
SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 3 TSPDB			  MOUNTED
SQL> 
SQL> 
SQL> alter pluggable database TSPDB open instances=all;

Pluggable database altered.

SQL> 
SQL> 
SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 3 TSPDB			  READ WRITE NO
SQL> 
SQL> 
SQL> select userenv('language') from dual;

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

SQL> 
SQL> 
SQL> conn / as sysdba
Connected.
SQL> 
SQL> 
SQL> show pdbs

    CON_ID CON_NAME			  OPEN MODE  RESTRICTED
---------- ------------------------------ ---------- ----------
	 2 PDB$SEED			  READ ONLY  NO
	 3 TSPDB			  READ WRITE NO
SQL> select userenv('language') from dual;

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

SQL>