linux 查看oracle数据库字符集,Linux 下修改oracle 的字符集

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 ZHS16GBK;

alter database character set ZHS16GBK

*

ERROR at line 1:

ORA-12712: new character set must be a superset of old character set

---我也尝试了换用其它的字符集，也是不行，同样报错

SQL> alter database character set AL32UTF8;

alter database character set AL32UTF8

*

ERROR at line 1:

ORA-12712: new character set must be a superset of old character set ---至此网上的步骤调试失败，所以我继续查资料，又进行了如下的调试

SQL> shutdown immediate

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup restrict

ORACLE instance started.

Total System Global Area 285212672 bytes

Fixed Size 1218992 bytes

Variable Size 113247824 bytes

Database Buffers 167772160 bytes

Redo Buffers 2973696 bytes

Database mounted.

Database opened.