大势趋007

每个人都是🏆
  新随笔  :: 管理

修改oracle 字符集

Posted on 2024-05-06 12:07  大势趋007  阅读(16)  评论(0)    收藏  举报 
[oracle@prdb19 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 6 11:50:26 2024
Version 19.23.0.0.0
Copyright (c) 1982, 2023, Oracle.  All rights reserved.
Connected to an idle instance.
SQL>  startup RESTRICT;  
ORACLE instance started.

Total System Global Area 8388605528 bytes
Fixed Size                  8959576 bytes
Variable Size            1157627904 bytes
Database Buffers         7214202880 bytes
Redo Buffers                7815168 bytes
Database mounted.
Database opened.
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 8388605528 bytes
Fixed Size                  8959576 bytes
Variable Size            1157627904 bytes
Database Buffers         7214202880 bytes
Redo Buffers                7815168 bytes
Database mounted.
ORA-03113: end-of-file on communication channel
Process ID: 28645
Session ID: 9 Serial number: 29952
[oracle@prdb19 ~]$ sqlplus / as sysdba
SQL*Plus: Release 19.0.0.0.0 - Production on Mon May 6 11:52:21 2024
Version 19.23.0.0.0
Copyright (c) 1982, 2023, Oracle.  All rights reserved.
startConnected to an idle instance.
SQL> up
ORACLE instance started.
Total System Global Area 8388605528 bytes
Fixed Size                  8959576 bytes
Variable Size            1157627904 bytes
Database Buffers         7214202880 bytes
Redo Buffers                7815168 bytes
Database mounted.
Database opened.
SQL>