Oracle11gRAC更改字符集为ZHS16GBK的过程
发表于:2024-10-24 作者:千家信息网编辑
千家信息网最后更新 2024年10月24日,SQL>conn / as sysdbaSQL> show parameter clusterNAME TYPE VALUE------------------------------------ -
千家信息网最后更新 2024年10月24日Oracle11gRAC更改字符集为ZHS16GBK的过程SQL>conn / as sysdba
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
SQL> alter system enable restricted session;
System altered.
SQL> show parameter job_queue_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 1000
SQL> show parameter aq_tm_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
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 internal_use ZHS16GBK;
alter database character set internal_use ZHS16GBK
*
ERROR at line 1:
ORA-12720: operation requires database is in EXCLUSIVE mode
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
Database opened.
SQL> alter database character set internal_use ZHS16GBK;
Database altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
Database opened.
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> alter system set job_queue_processes=1000;
alter system set job_queue_processes=1000
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 8833
Session ID: 2271 Serial number: 3
SQL> startup mount
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
SQL> alter system set job_queue_processes=1000;
System altered.
SQL> show parameter aq
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
SQL> alter system set aq_tm_processes=1;
System altered.
SQL> alter database open;
Database altered.
SQL> show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
SQL>
SQL> show parameter cluster
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
cluster_interconnects string
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
AL32UTF8
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup mount
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
SQL> alter system enable restricted session;
System altered.
SQL> show parameter job_queue_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
job_queue_processes integer 1000
SQL> show parameter aq_tm_processes;
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 1
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 internal_use ZHS16GBK;
alter database character set internal_use ZHS16GBK
*
ERROR at line 1:
ORA-12720: operation requires database is in EXCLUSIVE mode
SQL> alter system set cluster_database=FALSE scope=spfile sid='*';
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup restrict
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
Database opened.
SQL> alter database character set internal_use ZHS16GBK;
Database altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> startup
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
Database opened.
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
SQL> alter system set cluster_database=TRUE scope=spfile sid='*';
System altered.
SQL> shu immediate
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> alter system set job_queue_processes=1000;
alter system set job_queue_processes=1000
*
ERROR at line 1:
ORA-01034: ORACLE not available
Process ID: 8833
Session ID: 2271 Serial number: 3
SQL> startup mount
ORACLE instance started.
Total System Global Area 6.2934E+10 bytes
Fixed Size 2268712 bytes
Variable Size 6039798232 bytes
Database Buffers 5.6774E+10 bytes
Redo Buffers 118157312 bytes
Database mounted.
SQL> alter system set job_queue_processes=1000;
System altered.
SQL> show parameter aq
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
aq_tm_processes integer 0
SQL> alter system set aq_tm_processes=1;
System altered.
SQL> alter database open;
Database altered.
SQL> show parameter cluster_database
NAME TYPE VALUE
------------------------------------ ----------- ------------------------------
cluster_database boolean TRUE
cluster_database_instances integer 2
SQL> select * from nls_database_parameters where parameter='NLS_CHARACTERSET';
PARAMETER
------------------------------
VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
ZHS16GBK
SQL>
字符
过程
数据库的安全要保护哪些东西
数据库安全各自的含义是什么
生产安全数据库录入
数据库的安全性及管理
数据库安全策略包含哪些
海淀数据库安全审计系统
建立农村房屋安全信息数据库
易用的数据库客户端支持安全管理
连接数据库失败ssl安全错误
数据库的锁怎样保障安全
软件开发项目经理怎么考
diy服务器推荐
软件开发人员的不足之处
深信服安全服务器
实时数据库系统
软件开发价格
c软件开发工程师前景
文件服务器安全 勒索病毒
计算机网络技术专业涉及到的学科
nosql数据库类型
it软件开发合理化建议
网络安全手抄报彩铅
户描网络安全课
戴威尔网络安全证
能源物联网软件开发
泛微oa管理员密码数据库
数据防泄密软件开发公司价格表
服务器渗透论坛
携号转网可以用数据库吗
软件开发适合零基础吗
上海盖世网络技术有限公司同行
小米路由 vpn 服务器
网络安全教育视频会议记录
服务器渗透论坛
mysql创建数据库账号
数据库安全性需要考虑
Ibm服务器e9错误
海盐软件开发有限公司
软件开发运维
网络安全防御设备作用