Ƽº£·Î ¼³Ä¡ (5.0sp1, À©µµ¿ì ¹öÀü)
Tibero 5.0sp1 ¼³Ä¡(À©µµ¿ì ¹öÀü)
À©µµ¿ì¿¡¼ Tibero ¸¦ ¼³Ä¡Çغ¸°íÀÚ ÇÑ´Ù.
ÀÌÀü¿¡ ÀÌ·¸°Ô ¼³Ä¡ÇÏ´Â °É ³²°å´øÁö¶ó ¾Æ·¡ ±ÛÀ» Á¤¸®ÇÏ´Â Â÷¿øÀÌ´Ù.
https://web-obj.tistory.com/129
1. ¼³Ä¡ÆÄÀÏ ´Ù¿î·Îµå
¾Æ·¡ »çÀÌÆ®¿¡ ·Î±×ÀÎÇÑ´Ù.
https://technet.tmaxsoft.com/kr/front/main/main.do
·Î±×ÀÎ Çؼ ´Ù¿î·Îµå > µ¥ÀÌŸº£À̽º > Tibero 5·Î À̵¿ÇÑ´Ù.
´Ù¿î·Îµå¸¦ Ŭ¸¯ÇÏ¿© ȸéÀ̵¿ÇÑ´Ù.
64ºñÆ® À©µµ¿ì¿¡ ¼³Ä¡ÇÒ ¿¹Á¤À̹ǷΠ64ºñÆ®¿ëÀ» ´Ù¿î¹Þ´Â´Ù.
ÆÄÀÏÀ» ¸ðµÎ ´Ù¿î¹ÞÀ¸¸é
tibero5-bin-FS05_CS_1808-windows64-164962-opt-20190404095237.tar.gz
ÆÄÀÏÀÌ Àִµ¥, tar.gz ¿©¼ ¸®´ª½º¿ëÀ¸·Î ´À²¸ÁöÁö¸¸ ¾Æ´Ñ °Í °°´Ù.
¾ÐÃàÀ» Çѹø ¶Ç´Â µÎ¹ø Ç®¸é(¾ÐÃà Ǫ´Â Åø¿¡ µû¶ó¼ ÇѹøÀ¸·Î µÇ´Â °Íµµ ÀÖ°í, ¾ÈµÇ¸é µÎ ¹ø Ç®¾îÁÖ¸é µÈ´Ù) ¾Æ·¡¿Í °°Àº Æú´õ°¡ ³ª¿Â´Ù.
tibero5 Æú´õÀÇ ÆÄÀϵéÀ» °¡Áö°í ¼³Ä¡°¡ ÁøÇàµÉ ¿¹Á¤ÀÌ´Ù.
2. µ¥¸ð ¶óÀ̼¾½º ½Åû
¶óÀ̼¾½º ¹ß±ÞÀº ¾Æ·¡ URLÀ» ÂüÁ¶ÇÏ´Â °ÍÀÌ Á¶±Ý ´õ ³ªÀ» °Í °°´Ù.
À§ ±ÛÀ» ÂüÁ¶Çß´Ù¸é 3¹øÀ¸·Î ¹Ù·Î À̵¿ÇÑ´Ù.
±×·¸Áö ¾Ê´Ù¸é ¾Æ·¡¸¦ °è¼Ó µû¶ó°£´Ù.
¼³Ä¡¸¦ Çϱâ À§Çؼ´Â ¶óÀ̼¾½º°¡ ÇÊ¿äÇÏ´Ù. °³¹ß¿ëÀ¸·Î Àӽà »ç¿ëÀ» À§Çؼµµ ¶óÀ̼¾½º°¡ ÇÊ¿äÇѵ¥ ½±°Ô ½ÅûÇÒ ¼ö ÀÖµµ·Ï µÇ¾î ÀÖ´Ù.
https://technet.tmaxsoft.com/ko/front/main/main.do
À§ »çÀÌÆ®ÀÇ ¿ìÃø¿¡ º¸¸é µ¥¸ð¶óÀ̼¾½º ½ÅûÇÏ´Â ºÎºÐÀÌ ÀÖ´Ù.
Ŭ¸¯ÇÏ¿© Á¤º¸¸¦ ÀÔ·ÂÇÏ°í Á¦ÃâÇϱ⸦ Ŭ¸¯ÇÑ´Ù.
°ð¹Ù·Î ¸ÞÀÏ·Î ³¯¶ó¿À´Ï ¸ÞÀÏÀ» È®ÀÎÇÏ¿© license.xml ÆÄÀÏÀ» ´Ù¿î¹Þ¾Æ¼
1¹ø¿¡¼ ´Ù¿î¹ÞÀº tibero>license Æú´õ ¹Ø¿¡ À§Ä¡½ÃŲ´Ù.
3. ȯ°æº¯¼ö ¼³Á¤
¼³Ä¡¸¦ À§ÇØ 3°¡Áö ȯ°æº¯¼ö¸¦ ¼³Á¤ÇØÁØ´Ù.
TB_HOME, TB_SID ¶ó´Â ȯ°æº¯¼ö¸¦ ¼³Á¤ÇÏ°í, Ƽº£·ÎÀÇ bin Æú´õ¸¦ PATH¿¡ µî·Ï½ÃÄÑÁØ´Ù.
TB_HOME : Ƽº£·Î ¼³Ä¡ °æ·Î, ¿©±â¼´Â C:\Tibero\tibero5 ·Î ÇÑ´Ù.
TB_SID : tibero ·Î ¼ÂÆÃ
PATH : Tibero °æ·Î µî·Ï %TB_HOME%\bin °ú %TB_HOME%\client\bin
Ž»ö±âÀÇ ³»PC > ¸¶¿ì½º ¿À¸¥ÂÊ ¹öÆ°¸¦ Ŭ¸¯ÇÏ¿© ½Ã½ºÅÛ Á¤º¸¸¦ ¿°í °í±Þ ½Ã½ºÅÛ ¼³Á¤À» Ŭ¸¯ÇÑ´Ù.
°í±Þ > ȯ°æº¯¼ö·Î µé¾î°£´Ù.
»ç¿ëÀÚ º¯¼öº¸´Ù´Â ½Ã½ºÅÛ º¯¼ö¿¡ µî·ÏÇϱâ·Î ÇÑ´Ù.
»õ·Î ¸¸µé±â¸¦ Ŭ¸¯ÇÏ¿© TB_HOME, TB_SID¸¦ µî·ÏÇÑ´Ù.
TB_HOME¿¡´Â C:\Tibero\tibero5
TB_SID¿¡´Â tibero ·Î µî·ÏÇϱâ·Î ÇÑ´Ù.
½Ã½ºÅÛ º¯¼ö > Path ¸¦ ¼±ÅÃÇÏ°í ÆíÁýÀ» Ŭ¸¯ÇÏ¿© âÀ» ¿¿©ÁØ´Ù.
»õ·Î ¸¸µé±â¸¦ Ŭ¸¯ÇÏ¿©
%TB_HOME%\bin
%TB_HOME%\client\bin
¸¦ ÀÔ·ÂÇØÁØ´Ù.
ÀÔ·Â ÈÄ È®ÀΠŬ¸¯.
4. ¼³Ä¡
C:\¹Ø¿¡ Tibero Æú´õ¸¦ »ý¼ºÇÏ°í ±× ÇÏÀ§¿¡ tibero5 Æú´õ¸¦ ¿Å°ÜÁØ´Ù.
À§¿¡¼ ¼³Ä¡ °æ·Î¸¦ C:\Tibero\tibero5 Àâ¾ÒÀ¸´Ï Æú´õ¸¦ ¸ÂÃçÁØ´Ù.
µµ½ºÃ¢À» °ü¸®ÀÚ±ÇÇÑÀ¸·Î ½ÇÇàÀ» ÇÏ¿© ¿¾îÁØ´Ù.
%TB_HOME%\bin À¸·Î À̵¿
cd c:\Tibero\tibero5\bin
tbinstall %TB_HOME% %TB_SID%
¶ó°í µµ½ºÃ¢¿¡¼ ÀÔ·ÂÇÑ´Ù.
ÀÌ ¸í·ÉÀÌ ½ÇÇàµÇ¸é Tibero°¡ Windows ¼ºñ½º¿¡ µî·ÏµÈ´Ù. µî·ÏµÈ Windows ¼ºñ½º´Â [½ÃÀÛ] > [¼³Á¤] > [Á¦¾îÆÇ] > [°ü¸® µµ±¸] > [¼ºñ½º]¿¡¼ È®ÀÎÇÒ ¼ö ÀÖ´Ù.
±×·¯¸é À§¿Í °°ÀÌ ¹Ý°¡¿î ¼Ò¸®°¡ ³ª¿Â´Ù.
³ª¿ÀÁö ¾Ê´Â °æ¿ì
1) ¶óÀ̼¾½º ÆÄÀÏ À§Ä¡
2) ȯ°æº¯¼ö ¼³Á¤À» ´Ù½Ã Çѹø È®ÀÎÇÑ´Ù.
±×¸®°í ¾ÆÁ÷ ³¡³ °ÍÀÌ ¾Æ´Ï´Ù.
5. gen_tip.bat ½ÇÇà
c:\Tibero\tibero5\config ·Î À̵¿ÇÏ¿© gen_tip.bat À» ½ÇÇàÇÑ´Ù.
6. ¼¹ö ±âµ¿
c:\Tibero\tibero5\binÀ¸·Î À̵¿ÇÑ´Ù.
tbboot nomount ¶ó°í ÀÔ·ÂÇÑ´Ù.
Çѹø¿¡ µÉ ÁÙ ¾Ë¾Ò´õ´Ï host id °¡ ÀÏÄ¡ÇÏÁö ¾Ê´Â´Ù°í ÇÑ´Ù. ¶óÀ̼¾½º ½ÅûÀ» ´Ù½Ã ÇØ¾ß ÇÑ´Ù.
ERROR: Mismatch host id!!
(5) Check the license file - C:\Tibero\tibero5\license\license.xml TmaxData Corporation Copyright (c) 2008-. All rights reserved.
*************************************************************************
* ERROR: Mismatch host id!!
* (5) Check the license file - C:\Tibero\tibero5/license/license.xml
*************************************************************************
Tibero_tibero is stopped or disabled. Please confirm the service state or event logs (Application / System)
7. ¶óÀ̼¾½º¸¦ ´Ù½Ã ½ÅûÇÑ´Ù.
hostname ÀÌ À߸øµÇ¾î ÀÖ´Ù´Â ¿À·ù À̹ǷΠ¼³Ä¡ÇÏ´Â pcÀÇ hostname À» ¾Ë¾Æ¾ß Çϴµ¥ ¹¹Áö? ÇÏ°í °í¹ÎÀ» ÇÏ´Ù°¡ µµ½ºÃ¢¿¡¼ hostname À» ÃĺôÙ.
hostname
±×·¨´õ´Ï ¾Æ·¡¿Í °°ÀÌ ¹º°¡ ³ª¿Â´Ù.
°¡¸¸º¸¸é À©µµ¿ìÀÇ ½Ã½ºÅÛÁ¤º¸ÀÇ µð¹ÙÀ̽º À̸§°ú °°´Ù.
¶óÀ̼¾½º¸¦ ½ÅûÇÒ ¶§ È£½ºÆ®¸í¿¡´Ù°¡ ÀÌ Á¤º¸¸¦ ÀÔ·ÂÇØÁØ´Ù.
±×¸®°í ³ª¼ ´Ù½Ã ½ÇÇàÀ» ÇØÁØ´Ù.
8. ´Ù½Ã ¼¹ö ±âµ¿
tbboot nomount
¾ÆÁ÷ ³¡³ °ÍÀÌ ¾Æ´Ï´Ù.
9. µ¥ÀÌŸ º£À̽º »ý¼º
tbsql sys/tibero ·Î Ƽº£·Î¿¡ Á¢¼ÓÇÑ´Ù.
create database "tibero"
user sys identified by tibero
maxinstances 8
maxdatafiles 100
character set MSWIN949
logfile group 1 'log001.log'
size 100M,
group 2 'log002.log'
size 100M,
group 3 'log003.log'
size 100M
maxloggroups 255
maxlogmembers 8
noarchivelog
datafile 'system001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
default temporary tablespace TEMP
tempfile 'temp001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
extent management local autoallocate
undo tablespace UNDO
datafile 'undo001.dtf'
size 100M
autoextend on next 100M
maxsize unlimited
extent management local autoallocate;
10. ¸¶¹«¸®
SQL>quit ·Î ºüÁ®³ª¿Â´Ù.
C:\Tibero\tibero5\bin> tbboot ·Î Ƽº£·Î¸¦ Àç±âµ¿ÇØÁØ´Ù.
Àç±âµ¿ÀÌ ¼º°øÇÏ¿´´Ù.
11. ±âŸ ÀÛ¾÷
»ç½Ç ÀÌ°Ç ¿Ö ÇÏ´ÂÁø ¸ð¸£°Ú´Ù. ÀÏ´Ü Ç϶ó°í ÇÏ´Â °ÍÀ¸´Ï Çغ»´Ù.
±âº» ½ºÅ©¸³Æ® È£½ºÆ®¸¦ cscript·Î º¯°æÇÑ´Ù. cscript·Î ¼³Á¤µÇ¾î ÀÖÁö ¾ÊÀº °æ¿ì vbs ÆÄÀÏÀ» ½ÇÇàÇÒ ¶§
»ç¿ëÀÚ ÀÔ·Â ºÎºÐ¿¡¼ alert âÀ¸·Î Ãâ·ÂµÇ¾î ¼³Ä¡¸¦ ÁøÇàÇÒ ¼ö ¾ø´Â Çö»óÀÌ ¹ß»ýÇÑ´Ù.
scripts Æú´õ ¹ØÀ¸·Î °¡¼
C:\Tibero\tibero5\script> cscript //H:CScript
¶ó°í ÀÔ·ÂÇÑ´Ù.
C:\Tibero\tibero5\script> system.vbs ¸í·É¾î ½ÇÇà
ÇöÀç µð·ºÅ͸®¿¡ ÀÖ´Â SQL ¹®ÀÌ ÀúÀåµÈ ÆÄÀÏ(*.sql, ÀÌÇÏ SQL ÆÄÀÏ)ÀÌ ¼öÇàµÈ´Ù°í ÇÑ´Ù.
Æнº¿öµå¸¦ ÀÔ·ÂÇ϶ó°í ³ª¿ÀÁö¸¸ Æнº¿öµå¸¦ Á¤ÇØÁØÀûÀÌ ¾ø´Â °Í °°Àºµ¥ Æнº¿öµå¸¦ ÀÔ·ÂÇ϶ó°í ³ª¿Â´Ù.
±×·¡¼ Æнº¿öµå¸¦ "tibero" ¶ó°í ÀÔ·ÂÇߴµ¥µµ ¿À·ù°¡ ³ª¿Â´Ù.
* sysÀÇ ±âº» Æнº¿öµå´Â "tibero" ÀÌ°í
syscat ÀÇ ±âº» Æнº¿öµå´Â "syscat" ÀÌ´Ù.
Á¦´ë·Î ÀÔ·ÂÇÏ¸é ¾Æ·¡¿Í °°Àº ¿À·ù°¡ ¹ß»ýÇÏÁö ¾Ê´Â´Ù.
ÇÏÁö¸¸ ÀÚ²Ù TBR-17001 Login failed°¡ ¶á´Ù.
¹Ýº¹µÇ´Â ¿À·ù¸¦ º¸¸é SYSCAT °èÁ¤ÀÇ ·Î±×ÀÎ Á¤º¸°¡ ¹®Á¦ÀÎ °ÍÀ¸·Î º¸ÀδÙ.
tbsql sys/tibero ·Î ·Î±×ÀÎ Çؼ
alter user SYSCAT identified by "tibero" ¶ó°í Çؼ ºñ¹Ð¹øÈ£ º¯°æÀ» ÇØÁá´Ù.
´Ù½Ã
C:\Tibero\tibero5\script> system.vbs ¸í·É¾î ½ÇÇà
SYS Æнº¿öµå¿¡ tibero ÀÔ·Â
SYSCAT Æнº¿öµå¿¡ tibero ÀÔ·Â
¸î°¡Áö Y/N ¿¡ Y ÀÔ·Â
Done.
ÀÌÁ¦ ¼³Ä¡°¡ ¿Ï·áµÈ °ÍÀ¸·Î º¸ÀδÙ.