Ƽº£·Î ¼³Ä¡(Tibero 6, Windows10)
À©µµ¿ì¿¡¼ Ƽº£·Î¸¦ ¼³Ä¡Çغ¸°íÀÚ ÇÑ´Ù.
Windows 10¿¡¼ Tibero 6 ¼³Ä¡!!!!
Tibero 6´Â Tibero 5¿Í ¼³Ä¡°úÁ¤ÀÌ µ¿ÀÏÇÏ´Ù.
Tibero 5 ¼³Ä¡°úÁ¤Àº ¾Æ·¡ °Ô½Ã¹°¿¡ ÀÖ°í, Tibero 6¿¡ ´ëÇØ À̹ÌÁö ¾øÀÌ °£´ÜÇÏ°Ô Á¤¸®Çغ»´Ù.
Tibero 6 ¼³Ä¡
1. ¶óÀ̼¾½º ½Åû
- ¶óÀ̼¾½º ½ÅûÇÏ´Â ¹æ¹ýÀº ¾Æ·¡ °Ô½Ã¹°À» ÂüÁ¶ÇÑ´Ù.
- ½Åû½Ã Host Name ºÎºÐ ÁÖÀÇÇÑ´Ù.
2. ¼³Ä¡ÆÄÀÏ ´Ù¿î·Îµå
https://technet.tmaxsoft.com/ko/front/download/findDownloadList.do?cmProductCode=0301
¼³Ä¡ÇÏ°íÀÚ ÇÏ´Â ¹öÀüÀ» ´Ù¿î·Îµå ¹Þ´Â´Ù
À̹ø¿¡´Â Tibero 6 ÀÇ Windows 64ºñÆ®¿ëÀ» ´Ù¿î·Îµå ¹Þ¾Ò´Ù.
3. ȯ°æº¯¼ö ¼ÂÆÃ
TB_HOME : C:\Tibero\tibero6
TB_SID : tibero
PATH ¿¡ %TB_HOME%\bin °ú %TB_HOME%\client\bin À» µî·ÏÇØÁØ´Ù.
4. ¼³Ä¡
* µµ½ºÃ¢À» ½ÇÇà½ÃÄѼ ÀÛ¾÷À» ÁøÇàÇÏ¿´´Âµ¥, µµ½ºÃ¢À» °ü¸®ÀÚ ±ÇÇÑÀ¸·Î ½ÇÇàÇÏ¿© ÁøÇàÇÏ¿´´Ù.
C:\Tibero Æú´õ¸¦ »ý¼ºÇÏ°í ´Ù¿î·Îµå ¹ÞÀº ÆÄÀÏÀ» ¾ÐÃàÀ» Ç®¾î¼ ÇÏÀ§·Î À̵¿½ÃŲ´Ù.
C:\Tibero\tibero6 ¿ä·± ¸ð¾çÀÇ °æ·Î°¡ µÇµµ·Ï ¸»ÀÌ´Ù.
¶óÀ̼¾½º ÆÄÀÏÀ» C:\Tibero\tibero6\license ¹ØÀ¸·Î ³Ö¾îÁØ´Ù.
cd c:\Tibero\tibero6\bin
·Î À̵¿ÇÑ´Ù.
C:\Tibero\tibero6\bin> tbinstall %TB_HOME% %TB_SID%
À» ½ÇÇàÇÑ´Ù.
c:\Tibero\tibero6\config °æ·Î·Î À̵¿ÇÑ´Ù.
C:\Tibero\tibero6\config> gen_tip.bat
À» ½ÇÇàÇÑ´Ù.
5. ¼¹ö ±âµ¿
C:\Tibero\tibero6\bin À¸·Î À̵¿ÇÑ´Ù.(»ç½Ç À̵¿ÇÏÁö ¾Ê¾Æµµ µÇ±ä ÇÑ´Ù. ÀÌ¹Ì path ¿¡ µî·ÏÇÑ °æ·ÎÀ̹ǷÎ)
C:\Tibero\tibero6\bin> tbboot nomount
¿¡·¯°¡ ³´Ù¸é
1) ¶óÀ̼¾½º¸¦ Á¦´ë·Î ½ÅûÇß´ÂÁö Á¡°Ë
2) ȯ°æº¯¼ö ¼³Á¤ÀÌ Á¦´ë·Î µÇ¾ú´ÂÁö Á¡°ËÇÑ´Ù.
¿¡·¯°¡ ¾ø´Ù¸é
C:\Tibero\tibero6\bin> tbsql sys/tibero
¸¦ ½ÇÇàÇÏ¿© Tibero ¿¡ Á¢¼Ó
SQL>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;
¸¦ ½ÇÇàÇÏ¿© database¸¦ »ý¼ºÇÑ´Ù.
SQL>quit ;
ºüÁ®³ª¿Â´Ù.
Tibero¸¦ Àç±âµ¿ÇÑ´Ù.
C:\Tibero\tibero6\bin> tbboot
¿¡·¯¾øÀÌ ¿Ã¶ó¿À¸é ¼³Ä¡¼º°ø
6. ±âŸ ÀÛ¾÷
C:\Tibero\tibero6\script·Î À̵¿
C:\Tibero\tibero6\script> cscript //H:CScript
C:\Tibero\tibero6\script>system.vbs
¸¦ ½ÇÇà
Æнº¿öµå¸¦ ¹°¾îº¸´Âµ¥ tibero ¶ó°í ÀÔ·ÂÇÑ´Ù.
Y/N ÀÇ °æ¿ì¿¡´Â ¸ðµÎ Y ÀÔ·Â.
Done