修改字符级之前先备份数据库吧。 SQL> SHUTDOWN IMMEDIATE; SQL> STARTUP MOUNT; SQL> ALTER SYSTEM ENABLE RESTRICED 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;或 字符级 http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689
我按 http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689中讲的做了 c:\>svrmgrl 在svrmgrl中执行: shutdown startup mount ALTER SYSTEM ENABLE RESTRICTED SESSION; ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0; ALTER SYSTEM SET AQ_TM_PROCESSES=0; ALTER DATABASE OPEN; update props$ set value='ZHS16GB' WHERE NAME='NLS_CHARACTERSET'; update props$ set value='ZHS16GB' WHERE NAME='NLS_NCHAR_CHARACTERSET'; 结果更糟,现在数据库打不开了 ORA-12701: CREATE DATABASE character set is not known !!!!!!! 现在怎么办啊?各位救命啊!
SQL> SHUTDOWN IMMEDIATE;
SQL> STARTUP MOUNT;
SQL> ALTER SYSTEM ENABLE RESTRICED 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;或
字符级
http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689
http://expert.csdn.net/Expert/topic/1815/1815886.xml?temp=.628689中讲的做了
c:\>svrmgrl
在svrmgrl中执行:
shutdown
startup mount
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
update props$ set value='ZHS16GB' WHERE NAME='NLS_CHARACTERSET';
update props$ set value='ZHS16GB' WHERE NAME='NLS_NCHAR_CHARACTERSET';
结果更糟,现在数据库打不开了
ORA-12701: CREATE DATABASE character set is not known !!!!!!!
现在怎么办啊?各位救命啊!