rac 环境下修改oracle数据库字符集

rac 环境下修改oracle数据库字符集为GBK

由于数据库导入数据报字符集错误,所以修改字符集合导出数据字符集一致

1、首先要查询当前RAC环境的字符集

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

USERENV('LANGUAGE')

--------------------------------------------------------------------------------

AMERICAN_AMERICA.WE8ISO8859P1

2. 修改RAC的spfile中cluster_database为false非RAC(如果不修下面会报错)

 SQL>alter system set cluster_database=false scope=spfile sid='rac2';

3、停止数据库(rac1rac2都要停止)

SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.

4、启动数据库(只在rac1上面操作)

SQL> startup nomount;

ORACLE instance started.

Total System Global Area 1577058304 bytes

Fixed Size                  2084264 bytes

Variable Size             436208216 bytes

Database Buffers         1124073472 bytes

Redo Buffers               14692352 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.

5、修改字符集

SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;

SQL> ALTER DATABASE character set INTERNAL_USE zhs16gbk;

sql> alter system set cluster_database=true scope=spfile sid='RAC2'; (把cluster_database改为true

6、验证(两个节点都要测)

SQL> SHUTDOWN IMMEDIATE;

Database closed.

Database dismounted.

ORACLE instance shut down.

SQL> startup;

ORACLE instance started.

Total System Global Area 1577058304 bytes

Fixed Size                  2084264 bytes

Variable Size             436208216 bytes

Database Buffers         1124073472 bytes

Redo Buffers               14692352 bytes

Database mounted.

Database opened.

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

USERENV('LANGUAGE')

--------------------------------------------------------------------------------

AMERICAN_AMERICA.ZHS16GBK

7、最后倒入数据导入成功不报字符集错误了 

注:非RAC环境也可以用上面的方法修改只不过不需要修改spfile中的cluster_database

 

评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值