To change the database character set, perform the following steps. Not all of them are absolutely necessary, but they are highly recommended:
SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
<do a full backup>
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL> ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL> ALTER DATABASE OPEN;
SQL> ALTER DATABASE CHARACTER SET <new_character_set_name>;
SQL> SHUTDOWN IMMEDIATE; -- or NORMAL
SQL> STARTUP;
To change the national character set, replace the ALTER DATABASE CHARACTER SET statement with the ALTER DATABASE NATIONAL CHARACTER SET statement. You can issue both statements together if desired.
你是ORALCE8!?
你修改错了,nsl_nchar_characterset 不是系统字符级参数,只要修改‘NLS_CHARACTERSET’
你得把它UPDATE成原来的值。
试下这个方法:再DOS下
SVRMGRL
SVRMGRL>connect internal;
SVRMGRL>startup mount;
SVRMGRL>update sys.props$ set value$='US7ASCII' where name like 'NLS_CHAR%';
后还有使注册表HOME下面的 NLS_LANG跟数据库一样。