DbSl Trace: Cannot run a UNICODE kernel against a non-UTF8 database (charset = AL32UTF8)

1、问题

DbSl Trace: Cannot run a UNICODE kernel against a non-UTF8 database (charset = AL32UTF8)

2、分析

安装的编码要求是unicode UTF8的，要是你安装的不是UTF 8子集编码的就转不了，要重新自定义安装时选择UTF8。可以用下列语句查寻当前的oracle数据库编码

select * from v$nls_parameters;

select * from nls_database_parameters;

select * from sys.props$;

3、办法

SHUTDOWN 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 INTERNAL_USE UTF8; 

update props$ set VALUE$='UTF8' where NAME='NLS_NCHAR_CHARACTERSET';

update props$ set value$='UTF8' where name='NLS_CHARACTERSET';

commit;

SHUTDOWN immediate; 
startup;