Ƽº£·Î ¼³Ä¡(Linux)
¸®´ª½º ȯ°æ¿¡¼ Ƽº£·Î ¼³Ä¡Çغ¸°íÀÚ ÇÑ´Ù.
Tibero6 , Linux
¸·»ó Çغ¸´Ï À©µµ¿ì¿¡¼ ¼³Ä¡ÇÏ´Â °Í°ú °ÅÀÇ ´Ù¸£Áö ¾Ê´Ù.
À©µµ¿ì¿¡¼ ¼³Ä¡ÇÏ´Â °ÍÀº ¾Æ·¡ URLÀ» Âü°íÇÑ´Ù.
1. ¶óÀ̼¾½º ½Åû
- ¶óÀ̼¾½º ½ÅûÇÏ´Â ¹æ¹ýÀº ¾Æ·¡ °Ô½Ã¹°À» ÂüÁ¶ÇÑ´Ù.
- ½Åû½Ã Host Name ºÎºÐ ÁÖÀÇÇÑ´Ù.
- È£½ºÆ® ³×ÀÓÀ» ãÀ» ¶§ #uname -n À¸·Î ³ª¿Â °ÍÀ¸·Î ÇÏ´Ï Çѹø¿¡ Àß µÇ¾ú´Ù.
2. ¼³Ä¡ÆÄÀÏ ´Ù¿î·Îµå
¿¡¼ Linux (x86) 64-bit ¸¦ ´Ù¿î¹Þ¾Ò´Ù.
3. ȯ°æº¯¼ö ¼ÂÆÃ
TB_HOME : C:\Tibero\tibero6
TB_SID : tibero
PATH ¿¡ %TB_HOME%\bin °ú %TB_HOME%\client\bin À» µî·ÏÇØÁØ´Ù.
¸¦ À©µµ¿¡¼ ¼ÂÆÃÇØÁá´Âµ¥ ¸®´ª½º¿¡¼ µ¿ÀÏÇÏ°Ô ¼ÂÆÃÇØÁØ´Ù.
#vi /etc/profile
·Î ÆÄÀÏÀ» ¿¾î¼ ¸Ç ¾Æ·§ºÎºÐ¿¡
export TB_HOME=/usr/local/Tibero/tibero6
export TB_SID=tibero
export LD_LIBRARY_PATH=$TB_HOME/lib:$TB_HOME/client/lib
export PATH=$PATH:$TB_HOME/bin:$TB_HOME/client/bin
³»¿ëÀ» Ãß°¡ÇÑ´Ù.
#. /etc/profile
À» ½ÇÇàÇÏ¿© profile À» °»½ÅÇÑ´Ù. ȤÀº ssh¸¦ ·Î±×¾Æ¿ô Çß´Ù°¡ ´Ù½Ã µé¾î¿Íµµ µÈ´Ù.
/usr/local/Tibero/tibero6/config ·Î À̵¿ÇÏ¿©
gen_tip.sh ¸¦ ½ÇÇàÇÑ´Ù. (ÀÌ ¸í·ÉÀÌ ½ÇÇàµÇ¸é ȯ°æ ÆÄÀÏ(.tip)°ú tbdsn.tbr, psm_commands ÆÄÀÏÀÌ »ý¼ºµÈ´Ù°í ÇÔ)
#./gen_tip.sh
4. ¼¹ö ±âµ¿
½À°üÀûÀ¸·Î /usr/local/Tibero/tibero6/bin ¹ØÀ¸·Î À̵¿À» ÇÏ°í ³ª¼.
#tbboot nomount
½ÇÇà
#tbsql sys/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;
SQL>quit;
·Î ºüÁ®³ª¿Â´Ù.
tbboot ·Î Tibero¸¦ Àç±âµ¿
#tbboot
5. ½ºÅ©¸³Æ® ½ÇÇà
/usr/local/Tibero/tibero6/scripts
·Î À̵¿À» ÇÑ ÈÄ¿¡ system.sh ½ÇÇàÀ» ÇÑ´Ù.
#./system.sh
ÇØ´ç Æú´õ¾È¿¡ ÀÖ´Â sqlµéÀ» ½ÇÇàÇÏ´Â °ÍÀ̶ó°í ÇÑ´Ù. sql ÆÄÀÏÀ» ¼öÇàÇϸé role, System user, view, package µîÀÌ »ý¼ºµÈ´Ù.
sys ÀÇ ±âº» ¾ÏÈ£´Â tibero ÀÌ°í
syscat ÀÇ ±âº» ¾ÏÈ£´Â syscat ÀÌ´Ù.
Æнº¿öµå¸¦ ÀÔ·ÂÇÏ°í Áú¹®¿¡ Y¸¦ ¿©·¯¹ø ´©¸£¸é ½ÇÇàÀÌ ¿Ï·áµÈ´Ù.
Done.
¼³Ä¡ÇÏ¸é¼ ¶óÀ̺귯¸® ¿À·ù°¡ 2¹ø ÀÖ¾ú´Ù.
error while loading shared libraries: libnsl.so.1: cannot open shared object file: No such file or directory
yum install -y libnsl
error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory
yum install -y ncurses*
À§¿Í °°ÀÌ ÇÏ´Ï Çѹø¿¡ Àß µÇ¾ù´Ù.
´õ ±Ã±ÝÇÑ Á¡Àº ¼³Ä¡¸Å´º¾óÀ» ÂüÁ¶ÇÑ´Ù.
¸Å´º¾óÀ» Àо¸é¼ ÇÏ´Ï ÂªÀº ½Ã°£¾È¿¡ ¼³Ä¡°¡ ¿Ï·áµÇ¾ú´Ù. ÆÄÀÏ ´Ù¿î·Îµå ÇÏ´Â °÷¿¡ ÀÖ´Â ¸Å´º¾óÀÌ´Ù.