linux中oracle中文乱码解决方法

SQL> shutdown immediate;

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 internal_use AL32UTF8;  或者  ALTER DATABASE character set INTERNAL_USE ZHS16GBK;

SQL> shutdown immediate;

SQL> startup

SQL>alter system disable restricted session;