1. Change the database character set to GBKSHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET job_queue_processes=0;
ALTER SYSTEM SET aq_tm_processes=0;
ALTER DATABASE OPEN;
ALTER DATABASE National CHARACTER SET al16utf16; Change the international character set alter DATABASE CHARACTER set ZHS16GBK; Change the local character set shutdown IMMEDIATE; STARTUP; 2. If the error message, please control the information if prompted: Ora-12717:cannot issue ALTER DATABASE National CHARACTER SET when NCLOB, NCHAR
Or NVARCHAR2 data exists is changed using the following statement: Alter DATABASE national CHARACTER SET internal_use al16utf16; If prompted: Ora-12712:new character set must be a superset of the old character set is changed using the following statement: Alter DATABASE character set in Ternal_use ZHS16GBK; If prompted: Ora-01109:database not open then change the use of the following statement: ALTER DATABASE OPEN; If prompted: Ora-12719:operation requires database is in RESTRICTED mode changes using the following statement: Alter SYSTEM ENABLE RESTRICTED SESSION; If prompted: Ora-12721:operation cannot execute when other sessions is active then change using the following statement: SHUTDOWN IMMEDIATE;
STARTUP MOUNT EXCLUSIVE; If you are still prompted for the same error:
Select Sid,serial#,username,machine from v$session; see what sessions are available, and then
Alter system kill session ' SID ' serial# ' immediate;
Alter system kill session ' 158,7 ' immediate;
Oracle 10g database Character Set changes