Shulou(Shulou.com)06/01 Report--

Select * from v$nls_parameter displays the values of nls_characterset and nls_nchar_characterset

The methods to modify the character set nls_characterset and nls_nchar_ setvalues are as follows:

1. Modify nls_characterset:

Sqlplus "/ as sysdba"

SQL > SHUTDOWN IMMEDIATE

SQL > STARTUP MOUNT

SQL > ALTER SYSTEM ENABLE RESTRICTED SESSION

SQL > ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0

SQL > ALTER SYSTEM SET AQ_TM_PROCESSES=0

SQL > ALTER DATABASE OPEN

SQL > ALTER DATABASE CHARACTER SET INTERNAL_USE UTF8;-- > indicates that the character set format has been changed to UTF8

SQL > SHUTDOWN IMMEDIATE

SQL > STARTUP

Where INTERNAL_USE means to skip character set checking

2. Modify nls_nchar_characterset:

Sqlplus "/ as sysdba"

SQL > SHUTDOWN IMMEDIATE

SQL > STARTUP MOUNT

SQL > ALTER SYSTEM ENABLE RESTRICTED SESSION

SQL > ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0

SQL > ALTER SYSTEM SET AQ_TM_PROCESSES=0

SQL > ALTER DATABASE OPEN

SQL > ALTER DATABASE NATIONAL CHARACTER SET INTERNAL_USE UTF8

SQL > SHUTDOWN IMMEDIATE

SQL > STARTUP

3. Modify the LANG parameters under linux:

Vi / etc/sysconfig/i18n--- > modify the parameters of LANG

4. Modify the NLS_LANG parameters under linux:

Cd /

Vi .bash _ profile

Modify the parameter settings of EXPORT NLS_LANG

After you exit after modification, enter the following command under the command line to reset the environment

. .bash _ profile

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.