rac环境修改数据库字符集

来源：恒创科技编辑：恒创科技编辑部

2023-12-06 01:33:59

实验目标：rac环境修改数据库字符集.

SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
--------------------------------------------------------------------------------
AMERICAN_AMERICA.WE8MSWIN1252

SQL> alter system set cluster_database=false scope=spfile sid='pacs1'; (说明：此参数需修改，否则后面操作会报错)

System altered.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@hisdb1 ~]$ srvctl stop database -d pacs

启动数据库(节点1执行)

[oracle@hisdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 7 10:55:25 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.

Connected to an idle instance.

SQL> startup nomount;
ORACLE instance started.

Total System Global Area 2956300288 bytes
Fixed Size                  2256912 bytes
Variable Size             687869936 bytes
Database Buffers         2248146944 bytes
Redo Buffers               18026496 bytes
SQL> alter database mount exclusive;

Database altered.

SQL> alter system enable restricted session;

System altered.

SQL> alter system set job_queue_processes=0;

System altered.

SQL> alter database open;

Database altered.

SQL> alter system enable restricted session;

System altered.

SQL> alter database character set internal_use al32utf8;

Database altered.

SQL> alter system set cluster_database=true scope=spfile sid='pacs1';  (说明：此处需将cluster_database修改回true，否则后面启动数据库会报错)

System altered.

SQL> shutdown immediate;
Database closed.
Database dismounted.
ORACLE instance shut down.
SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
[oracle@hisdb1 ~]$ srvctl start database -d pacs
[oracle@hisdb1 ~]$ sqlplus / as sysdba

SQL*Plus: Release 11.2.0.4.0 Production on Sun Aug 7 11:00:14 2022

Copyright (c) 1982, 2013, Oracle.  All rights reserved.


Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
SQL> select userenv('language') from dual;

USERENV('LANGUAGE')
----------------------------------------------------
AMERICAN_AMERICA.AL32UTF8