[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>
标签：instance,Database,字符集,bytes,修改,SQL,oracle,Buffers,Size From： https://www.cnblogs.com/notonlydba/p/18174778