์•„๋ž˜ ๋‚ด์šฉ์€ ํƒ€ ๋ธ”๋กœ๊ทธ์—์„œ ํผ์˜จ๊ฒƒ์ž…๋‹ˆ๋‹ค.
์ €๋Š” CentOS 6.4 / Oracle 11g์— ์ ์šฉํ•ด๋ดค๋Š”๋ฐ ์•„๋ฌด ๋ฌธ์ œ์—†์ด ์ž˜ ๋˜์—ˆ์Šต๋‹ˆ๋‹ค.



ํ™˜๊ฒฝ
Cent OS 5.5 / Oracle 10g

------------------------------------------------------------------------------

1. ์บ๋ฆญํ„ฐ์…‹ ํ™•์ธ 

SELECT * FROM sys.props$ where name='NLS_CHARACTERSET';


2. ํ”„๋กœํŒŒ์ผ ์ˆ˜์ •

export NLS_LANG=KOREAN_KOREA.UTF-8 
export NLS_LANG=KOREAN_KOREA.KO16MSWIN949 



3. ์บ๋ฆญํ„ฐ์…‹ ๋ณ€๊ฒฝ

C:\>sqlplus /nolog; 
sql>conn /as sysdba; 

 

๋ณ€๊ฒฝํ•˜๊ณ ์žํ•˜๋Š” ์บ๋ฆญํ„ฐ์…‹์„ ์ˆ˜์ •

== UTF-8 == 
sql> update sys.props$ set value$='UTF8' where name='NLS_CHARACTERSET'; 
sql> update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET'; 
sql> update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE'; 

= KO16MSWIN949 = //ํ•œ๊ธ€ํ™•์žฅ 
sql> update sys.props$ set value$='KO16MSWIN949' where name='NLS_CHARACTERSET'; 
sql> update sys.props$ set value$='KO16MSWIN949' where name='NLS_NCHAR_CHARACTERSET'; 
sql> update sys.props$ set value$='KOREAN_KOREA.KO16MSWIN949' where name='NLS_LANGUAGE'; 
sql> commit; 

 

 

์žฌ์‹œ์ž‘

sql> shutdown immediate; 
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 UTF8; 
or alter database character set KO16MSWIN949; 
sql> shutdown immediate; 
sql> startup; 







์ถœ์ฒ˜ : http://algina.tistory.com/41