修改NLS_CHARACTERSET 字符集

gsforget321

于 2024-08-22 17:57:54 发布

阅读量728

点赞数 3

文章标签：数据库

本文链接：https://blog.csdn.net/gsforget321/article/details/141434429

版权

LINUX8.10 + ORACLE 11G数据库，NLS_CHARACTERSET 字符集变成了US7ASCII，要改成AL32UTF8
1. shutdown immediate
2. startup mount
3. ALTER SYSTEM ENABLE restricted SESSION;
4. alter database open;
5. ALTER DATABASE CHARACTER SET INTERNAL_USE AL32UTF8;
6. ALTER SYSTEM DISABLE restricted SESSION;

验证字符集：
select property_name,property_value from database_properties where property_name like '%CHARACTERSET%';

以下是具体操作步骤：
SQL> !cat /etc/redhat-release
Rocky Linux release 8.10 (Green Obsidian)

SQL> select property_name,property_value from database_properties where property_name like '%CHARACTERSET%';

PROPERTY_NAME
--------------------------------------------------------------------------------
PROPERTY_VALUE
--------------------------------------------------------------------------------
NLS_CHARACTERSET
US7ASCII

NLS_NCHAR_CHARACT