Changing Oracle9i Database Language
¸®´ª½º¿¡ ¿À¶óŬÀ» ¼³Ä¡ÇÒ ¶§, ¾ð¾î¸¦ Çѱ¹¾î·Î ÇÏ´Â °æ¿ì ¿À·ù°¡
³ª´Â »ç·Ê(¿©·¯ »çÀÌÆ®ÀÇ ±âÁ¸ ¼³Ä¡ÀÚµé ÀÇ°ß)°¡ ÀÖ´Ù ÇÏ¿©, s2clinux
¼³Ä¡ ´ç½Ã ¿µ¾î·Î ¼³Ä¡ÇÏ¿´´Ù.
Á¤»óÀûÀ¸·Î Oracle9i database ¼³Ä¡ÇÑ ÀÌÈÄ¿¡, ¿À¶óŬ µ¥ÀÌÅͺ£À̽º¿¡
Á¢¼ÓÇÏ¿© µ¥ÀÌÅ͸¦ Çѱ۷ΠÀúÀåÇÏ´Â °æ¿ì Çѱ¹¾î Áö¿øÀÌ µÇÁö
¾ÊÀ¸¹Ç·Î, ¼³Ä¡ÇÑ ÈÄ¿¡ ¾ð¾î¸¦ Çѱ¹¾î·Î º¯°æÇÏ´Â ¹æ¹ýÀ» ¼³¸íÇÏ°íÀÚ
ÇÑ´Ù.
¡¡
1. ¿À¶óŬ µ¥ÀÌÅͺ£À̽º ¹®Àڼ°ú ¾ð¾î¼Â º¯°æ
¡¡
- ¹®ÀÚ¼Â(CHARACTER SET) º¯°æ
¿À¶óŬ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ·Î Á¢¼ÓÇÏ¿© NLS_CHARACTERSET,
NCHARÀÇ CHARACTERSET¿¡ Çѱ¹¾î¸¦ Áö¿øÇϵµ·Ï ÆĶó¹ÌÅÍÀÇ
¼Ó¼º°ªÀ» KO16KSC5601·Î º¯°æÇÑ´Ù.
- ¾ð¾î¼Â(LANGUAGE SET) º¯°æ
¹®Àڼ°ú ¸¶Âù°¡Áö·Î ¿À¶óŬ µ¥ÀÌÅͺ£À̽º °ü¸®ÀÚ·Î Á¢¼ÓÇÏ¿©
NLS_LANGUAGE ÆĶó¹ÌÅÍÀÇ ¼Ó¼º°ªÀ»
AMERICAN_AMERICA.KO16KSC5601·Î º¯°æÇÑ´Ù.
[¹®Àڼ º¯°æ]
SQL> update sys.props$ set value$='KO16KSC5601' where name='NLS_CHARACTERSET';
1 row updated.
SQL> update sys.props$ set value$='KO16KSC5601' where name='NLS_NCHAR_CHARACTERSET';
1 row updated.
[¾ð¾î¼Â º¯°æ]
SQL> update sys.props$ set value$='AMERICAN_AMERICA.KO16KSC5601' where name='NLS_LANGUAGE';
1 row updated.
[º¯°æ»çÇ× ÀúÀå ¹× µ¥ÀÌÅͺ£À̽º À翬µ¿]
SQL> commit;
Commit complete.
SQL> shutdown
Database closed.
Database dismounted.
Oracle instance shut down.
SQL>startup
ORACLE instance started.
Total System Global Area 235999352 bytes
Fixed Size 450680 bytes
Variable Size 201326592 bytes
Database Buffers 33554432 bytes
Redo Buffers 667648 bytes
Database mounted.
Database opened.
[º¯°æ»çÇ× È®ÀÎ]
SQL> select * from
v$nls_parameters;
¡¡
2. ¿À¶óŬ ¾ð¾î ȯ°æº¯¼ö º¯°æ
¿À¶óŬÀ» ¼³Ä¡ÇÒ ¶§ ÁöÁ¤ÇØ ÁÖ¾ú´ø .bash_profile ÆÄÀÏ¿¡¼ Oracle
¾ð¾î ȯ°æº¯¼ö¸¦ ´ÙÀ½°ú °°ÀÌ º¯°æÇØ ÁØ´Ù.
export NLS_LANG=AMERICAN_AMERICA.KO16KSC5601