1. Character Set 확인

SELECT * FROM V$NLS_PARAMETERS;

NLS_CHARACTERSET    UTF8

 

2. DB의 NLS_CHARACTERSET를 UTF8 -> AL32UTF8로 변경하기

DB에 원격 접속하여

# sqlplus / as sysdba

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;
SQL> shutdown immediate;
SQL> startup;

 

3. 변경확인

SELECT * FROM V$NLS_PARAMETERS;

NLS_CHARACTERSET    AL32UTF8