OracleXE 한글 깨짐 고치기

1. oracle sys 접속
C\>sqlplus /nolog
SQL>conn /as sysdba;

2. 한글설정 properties update
SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_CHARACTERSET';
SQL>update sys.props$ set value$='KO16MSWIN949' where name='NLS_NCAHR_CHARACTERSET';
SQL>update sys.props$ set value$='AMERICAN_AMERICA.KO16MSWIN949' where name='NLS_LANGUAGE';
SQL>commit;
SQL>shutdown immediate;

3. DATABASE charset 변경
SQL>startup mount;
SQL>ALTER SYSTEM ENABLE RESTRICTED SESSION;
SQL>ALTER SYSTEM SET JOB_QUEUE_PROCESSES=0;
SQL>ALTER SYSTEM SET AQ_TM_PROCESSES=0;
SQL>ALTER DATABASE OPEN;
SQL>ALTER DATABASE CHARACTER SET KO16MSWIN949;
SQL>shutdown immediate;
SQL>startup;

4. 만약 server와 client의 characterset 다를 경우 일치시켜야함!
(ORA-29275: partial multibyte character)

server characterset 확인
SELECT * FROM NLS_DATABASE_PARAMETER WHERE PARAMETER = 'NLS_CHARACTERSET'

client characterset 확인
regedit 실행
KEY_LOCAL_MACHINE\SOFTWARE\ORACLE\KEY_XE
NLS_LANG 값 확인