查看字符集
select userenv('language') from dual;
重启机器
[root@VM-0-3-centos ~]# su -l oracle
[oracle@VM-0-3-centos ~]$ sqlplus /nolog
SQL> conn /as sysdba;
SQL> shutdown immediate;
SQL> startup mount
ORACLE instance started.
Total System Global Area 771749224 bytes
Fixed Size 9139560 bytes
Variable Size 666894336 bytes
Database Buffers 92274688 bytes
Redo Buffers 3440640 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;
SQL> ALTER DATABASE character set INTERNAL_USE ZHS16GBK;
Database altered.
SQL> SHUTDOWN IMMEDIATE;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 771749224 bytes
Fixed Size 9139560 bytes
Variable Size 666894336 bytes
Database Buffers 92274688 bytes
Redo Buffers 3440640 bytes
Database mounted.
Database opened.
