原因:linux系统新建实例默认字符集为英文字符集,新建实例时忘记修改了。
解决办法:sqlplus登录执行一下命令,修改字符集。
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS16GBK;
alter database character set INTERNAL_USE ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP
解决办法:sqlplus登录执行一下命令,修改字符集。
SHUTDOWN IMMEDIATE;
STARTUP MOUNT;
ALTER SYSTEM ENABLE RESTRICTED SESSION;
ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
ALTER SYSTEM SET AQ_TM_PROCESSES=0;
ALTER DATABASE OPEN;
ALTER DATABASE CHARACTER SET ZHS16GBK;
alter database character set INTERNAL_USE ZHS16GBK;
SHUTDOWN IMMEDIATE;
STARTUP