Changing NLS_CHARACTERSET for a Database

Changing NLS_CHARACTERSET for a Database
conn / 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 WE8MSWIN1252;

SQL> SHUTDOWN IMMEDIATE

SQL> STARTUP


NOTE: It would be better to check the alert log for any ORA:00600 errors after we change the characterset.
If there is any problem, after we change the characterset there will be ORA:00600 errors.

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

select * from nls_database_parameters;