Oracle19c安装时选的UTF8后续改成GBK

Active code page: 65001

C:\Users\Administrator>sqlplus / as sysdba

SQL*Plus: Release 19.0.0.0.0 - Production on 星期六 3月 1 16:26:34 2025
Version 19.3.0.0.0

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


连接到:
Oracle Database 19c Enterprise Edition Release 19.0.0.0.0 - Production
Version 19.3.0.0.0

SQL>
SQL> SHUTDOWN IMMEDIATE;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> STARTUP MOUNT
ORACLE 例程已经启动。

Total System Global Area 1.0335E+10 bytes
Fixed Size                 12578048 bytes
Variable Size            1811939328 bytes
Database Buffers         8489271296 bytes
Redo Buffers               20975616 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 ZHS16GBK;
ALTER DATABASE CHARACTER SET ZHS16GBK
*
第 1 行出现错误:
ORA-12712: 新字符集必须为旧字符集的超集


SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;

数据库已更改。

SQL> shutdown immediate;
数据库已经关闭。
已经卸载数据库。
ORACLE 例程已经关闭。
SQL> startup
ORACLE 例程已经启动。

Total System Global Area 1.0335E+10 bytes
Fixed Size                 12578048 bytes
Variable Size            1811939328 bytes
Database Buffers         8489271296 bytes
Redo Buffers               20975616 bytes
数据库装载完毕。
数据库已经打开。
SQL> select * from v$nls_parameters;

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
NLS_LANGUAGE
SIMPLIFIED CHINESE
         0

NLS_TERRITORY
CHINA
         0

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------

NLS_CURRENCY
￥
         0

NLS_ISO_CURRENCY
CHINA

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
         0

NLS_NUMERIC_CHARACTERS
.,
         0

NLS_CALENDAR

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
GREGORIAN
         0

NLS_DATE_FORMAT
DD-MON-RR
         0


PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
NLS_DATE_LANGUAGE
SIMPLIFIED CHINESE
         0

NLS_CHARACTERSET
ZHS16GBK
         0

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------

NLS_SORT
BINARY
         0

NLS_TIME_FORMAT
HH.MI.SSXFF AM

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
         0

NLS_TIMESTAMP_FORMAT
DD-MON-RR HH.MI.SSXFF AM
         0

NLS_TIME_TZ_FORMAT

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
HH.MI.SSXFF AM TZR
         0

NLS_TIMESTAMP_TZ_FORMAT
DD-MON-RR HH.MI.SSXFF AM TZR
         0


PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
NLS_DUAL_CURRENCY
￥
         0

NLS_NCHAR_CHARACTERSET
AL16UTF16
         0

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------

NLS_COMP
BINARY
         0

NLS_LENGTH_SEMANTICS
BYTE

PARAMETER
--------------------------------------------------------------------------------
VALUE
--------------------------------------------------------------------------------
    CON_ID
----------
         0

NLS_NCHAR_CONV_EXCP
FALSE
         0


已选择 19 行。

SQL>