±Þ.. Å«ÀÏÀ̳׿ä

   Á¶È¸ 5675   Ãßõ 0    

DB 캐릭터셋변경중

SQL> update sys.props$ set value$='UTF8' where name='NLS_CHARACTERSET';

1 row updated.

SQL> update sys.props$ set value$='UTF8' where name='NLS_NCHAR_CHARACTERSET';

1 row updated.

SQL> update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE';

1 row updated.


SQL> shutdown immediate;

Database closed.

Database dismounted.

ORACLE instance shut down.


한후 STARTUP 을 하는데


ORA-01092 ORACLE instance terminated. Disconnection forced 라고 뜹니다


 전으로 돌리고 싶은데 에러문에 바꿀수가없네요 ...


복구하는방법이없을까요 ?

박지훈
ªÀº±Û Àϼö·Ï ½ÅÁßÇϰÔ.
http://blog.naver.com/idtong/130062721498
¸Ç ¾Æ·¡¿¡ ÇØ°á¹æ¹ýÀ» »ç¿ëÇØ º¸¼¼¿ä.

À̺κÐÀÌ À߸øµÈ °ÍÀ¸·Î º¸ÀÔ´Ï´Ù.
SQL> update sys.props$ set value$='KOREAN_KOREA.UTF8' where name='NLS_LANGUAGE';
'KOREAN_KOREA.UTF8' --> 'KOREAN'
     
Startup ÀÚü°¡ Áö±Ý ¾ÈµÇ°íÀÖ½À´Ï´Ù.
          
https://oracleblog.org/working-case/how-to-open-database-when-update-props-table/
1. $ORACLE_HOME/nls/lbuilder/lbuilder¸¦ ½ÇÇàÇÏ¿©
2. ´Ù¸¥ LANGUAGE¸¦ Àоî 'KOREAN_KOREA.UTF8'·Î º¯°æ ÈÄ
3. $ORACLE_HOME/nls/data µð·ºÅ丮¿¡ ³Ö¾î º¸¼¼¿ä.


QnA
Á¦¸ñPage 2113/5750
2014-05   5371902   Á¤ÀºÁØ1
2015-12   1885853   ¹é¸Þ°¡
2014-01   4736   Á¦·ÎÄݶó
2015-05   5227   ¹Î»çÀå
2016-07   10995   ±èÁØÀ¯
2011-09   6510   ¹Ì¼ö¸Ç
2019-11   3109   ¾È¹«ºñ
2011-09   6191   À±ÀΰÉ
2014-01   8496   2CPUÃÖÁÖÈñ
2015-05   3984   ³ªÆÄÀ̰­½ÂÈÆ
2016-07   4877   ÇÏ´ÃÀ»³¯ÀÚ
2018-09   4835   ȣȣ
2011-09   6215   ¾Æ¸§´Ù¿î³ëÀ»
2018-09   4372   ¼ºÈ£
2024-05   2535   Áú¹®
2014-02   6465   ÀÚ¿¬ÀÎ
2021-03   9754   ¿©ÁÖ³ó¹Î76
2024-05   2726   ½ÅÀº¿Ö
2024-05   2047   chotws
2011-10   6220   EYESSHOT
2019-12   2642   ½Öcpu
2015-06   5272   °ËÀº¹Ù¶÷