{"id":9090,"date":"2020-04-22T10:16:52","date_gmt":"2020-04-22T01:16:52","guid":{"rendered":"http:\/\/www.gisdeveloper.co.kr\/?p=9090"},"modified":"2020-05-28T09:32:10","modified_gmt":"2020-05-28T00:32:10","slug":"centos7%ec%97%90-tibero6-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"http:\/\/www.gisdeveloper.co.kr\/?p=9090","title":{"rendered":"CentOS7\uc5d0 Tibero6 \uc124\uce58"},"content":{"rendered":"

\ud2f0\ubca0\ub85c(Tibero)\ub294 \ud2f0\ub9e5\uc2a4\uc18c\ud504\ud2b8\uc758 \uc790\ud68c\uc0ac\uc778 \ud2f0\ub9e5\uc2a4\ub370\uc774\ud130\uc5d0\uc11c \uac1c\ubc1c\ud55c DBMS\uc774\ub2e4. 2003\ub144\uc5d0 \ucc98\uc74c \ubc30\ud3ec\ub418\uc5c8\uace0, \ud604\uc7ac \ubc84\uc804 6\uc774 \uc81c\uacf5\ub418\uace0 \uc788\ub2e4. \uc774 \uae00\uc740 CentOS7\uc5d0\uc11c Tibero6\uc744 \uc124\uce58\ud558\ub294 \uacfc\uc815\uc744 \uc815\ub9ac\ud55c \uae00\uc774\ub2e4.<\/p>\n

\ub2e4\uc6b4\ub85c\ub4dc \ud398\uc774\uc9c0<\/a>\uc5d0\uc11c Tibero6\uc744 Linux 64bits \uc6a9\uc73c\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\ub294\ub2e4. \uc2e4\uc81c \ub2e4\uc6b4\ub85c\ub4dc\uc640 \ub77c\uc774\uc120\uc2a4 \ubc1c\uae09\uc744 \uc704\ud574 \ud68c\uc6d0 \uac00\uc785\uc774 \ud544\uc694\ud558\uba70 \uba54\uc77c \uc778\uc99d\uc744 \ud1b5\ud574 \uac00\uc785 \ucc98\ub9ac\uac00 \uc774\ub8e8\uc5b4\uc9c4\ub2e4. \ud604\uc7ac \uc774 \uae00\uc744 \uc791\uc131\ud558\ub294 \uc2dc\uc810\uc744 \uae30\uc900\uc73c\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \ud30c\uc77c\uba85\uc740 tibero6-bin-FS07_CS_1912-linux64-174424-opt.tar.gz \uc774\uba70, \uc774 \ud30c\uc77c\uc744 \uc124\uce58\ud558\uace0\uc790 \ud558\ub294 \uc704\uce58\uc5d0 \uc774\ub3d9\uc2dc\ud0a8 \ud6c4 \uc555\ucd95\uc744 \ud47c\ub2e4. (\ud544\uc790\uc758 \uacbd\uc6b0 \/etc\/tibero \ub514\ub809\ud1a0\ub9ac\ub85c \ud558\uc600\uace0 \uc555\ucd95\uc744 \ud480\uba74 tibero6\uc774\ub77c\ub294 \ud558\uc704 \ud3f4\ub354\uac00 \uc0dd\uc131\ub418\uace0 \uc774 \ud558\uc704 \ud3f4\ub354 \uc548\uc5d0 \uc555\ucd95\uc774 \ud480\ub9bc)<\/p>\n

\r\ntar -zxvf tibero6-bin-FS07_CS_1912-linux64-174424-opt.tar.gz\r\n<\/pre>\n
\ubc1c\uae09 \ubc1b\uc740 \ub77c\uc774\uc120\uc2a4 \ud30c\uc77c\uc740 \uc124\uce58\ub41c \ub514\ub809\ud1a0\ub9ac\uc778 \/etc\/tibero\uc758 \ud558\uc704 \ub514\ub809\ud1a0\ub9ac\uc778 \/etc\/tibero\/tibero6\/license\uc5d0 \ubcf5\uc0ac\ud55c\ub2e4. \ucc38\uace0\ub85c \ub77c\uc774\uc120\uc2a4 \ud30c\uc77c\uc744 \ubc1c\uae09\ubc1b\uae30 \uc704\ud574\uc11c\ub294 \uc2e4\uce58\ud560 \uc11c\ubc84\uc758 Host Name\uc744 \uc785\ub825\ud574\uc57c \ud558\ub294\ub370 \ub9ac\ub205\uc2a4\uc758 \uacbd\uc6b0 hostname \uba85\ub839\uc5b4\ub97c \uc785\ub825\ud574 \uc27d\uac8c \ud655\uc778\uc774 \uac00\ub2a5\ud558\ub2e4.<\/p>\n
\uc124\uce58\ub97c \uc704\ud55c \uc880 \ub354 \ud3b8\ub9ac\ud55c \ubc29\ubc95\uc774 \uc788\uc744\uc9c0\ub3c4 \ubaa8\ub974\uaca0\uc73c\ub098, \ud2f0\ubca0\ub85c\ub294 \ud504\ub85c\uadf8\ub7a8\uc758 \uc124\uce58\ub97c \ub2e8\uc21c\ud788 \uc555\ucd95\uc744 \ud478\ub294 \ubc29\uc2dd\uc5d0\uc11c \uc2dc\uc791\ud574, \ud658\uacbd\uc124\uc815\uc744 \uc9c1\uc811 \ucf58\uc194\uc5d0\uc11c \uc785\ub825\ud574 \uc218\ud589\ud574 \uc918\uc57c \ud55c\ub2e4. \uba3c\uc800 \/etc\/sysctl.conf\uc758 \ud30c\uc77c\uc5d0 \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4.<\/p>\n
\r\nkernel.shmmni = 4096\r\nkernel.shmall = 2097152\r\nkernel.shmmax = 2147483648\r\nkernel.sem = 10000 32000 10000 10000\r\n\r\nfs.file-max = 6815744\r\n\r\nnet.ipv4.ip_local_port_range = 1024 65500\r\n<\/pre>\n
\/etc\/security\/limits.conf \ud30c\uc77c\uc5d0\ub3c4 \ub2e4\uc74c\uc758 \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4.<\/p>\n
\r\ntibero           soft    nproc           2047\r\ntibero           hard    nproc           16384\r\ntibero           soft    nofile          1024\r\ntibero           hard    nofile          65536\r\n<\/pre>\n
\/etc\/sysyemd\/logind.conf \ud30c\uc77c\uc758 \ub0b4\uc6a9 \uc911 RemoveIPC=no\uc758 \uc8fc\uc11d\uc744 \uc81c\uac70\ud55c\ub2e4.<\/p>\n
\ud658\uacbd\ubcd1\uc218\ub97c \uc124\uc815\ud558\uae30 \uc704\ud574 \ub2e4\uc74c\uc744 \uc785\ub825\ud55c\ub2e4.<\/p>\n
\r\nexport TB_HOME=\/etc\/tibero\/tibero6 \r\nexport TB_SID=tibero \r\nexport LD_LIBRARY_PATH=$TB_HOME\/lib:$TB_HOME\/client\/lib \r\nexport PATH=$PATH:$TB_HOME\/bin:$TB_HOME\/client\/bin\r\n<\/pre>\n
\uc774\uc81c \ud2f0\ubca0\ub85c\ub97c \uc704\ud574 \uc774\ubbf8 \uc791\uc131\ub41c \uc258\uc744 \uc2e4\ud589\ud55c\ub2e4.<\/p>\n
\r\n$TB_HOME\/config\/gen_tip.sh\r\n<\/pre>\n
\uc5ec\uae30\uae4c\uc9c0\uac00 \ud2f0\ubca0\ub85c \uc11c\ubc84\ub97c \uc2e4\ud574\ud558\uae30 \uc704\ud55c \uc900\ube44\uacfc\uc815\uc774\uba70, \uba3c\uc800 \ud2f0\ubca0\ub85c \uc11c\ubc84\ub97c NOMOUNT \ubaa8\ub4dc\ub85c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n
\r\ntbboot nomount\r\n<\/pre>\n
tbsql \ud504\ub85c\uadf8\ub7a8\uc744 \ud1b5\ud574 \ud2f0\ubca0\ub85c \uc11c\ubc84\uc5d0 \uc811\uc18d\ud560 \uc218 \uc788\uc73c\uba70, \uc544\ub798\ucc98\ub7fc sys \uacc4\uc815\uc73c\ub85c \ucd08\uae30 \uc554\ud638(tibero)\ub97c \uc9c0\uc815\ud574 \uc811\uc18d\ud55c\ub2e4.<\/p>\n
\r\ntbsql sys\/tibero\r\n<\/pre>\n
SQL> \ud504\ub86c\ud504\ud2b8\uac00 \ub728\uba74 \uc131\uacf5\ud55c \uac83\uc774\uace0, \uc0c8\ub85c\uc6b4 ‘tibero'(\uc6d0\ud55c\ub2e4\uba74 \ub2e4\ub978 \uc774\ub984\ub3c4 \uac00\ub2a5\ud568)\ub77c\ub294 \uc774\ub984\uc758 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. <\/p>\n
\r\ncreate database \"tibero\" \r\n  user sys identified by tibero \r\n  maxinstances 8 \r\n  maxdatafiles 100 character set MSWIN949 \r\n  national character set UTF16 \r\n  logfile \r\n    group 1 'log001.log' size 100M, \r\n    group 2 'log002.log' size 100M, \r\n    group 3 'log003.log' size 100M \r\n  maxloggroups 255 \r\n  maxlogmembers 8 \r\n  noarchivelog \r\n    datafile 'system001.dtf' size 100M autoextend on next 100M maxsize unlimited \r\n    default temporary tablespace TEMP \r\n      tempfile 'temp001.dtf' size 100M autoextend on next 100M maxsize unlimited \r\n      extent management local autoallocate \r\n    undo tablespace UNDO \r\n      datafile 'undo001.dtf' size 100M autoextend on next 100M maxsize unlimited \r\n      extent management local autoallocate;\r\n<\/pre>\n
\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\uc5d0\ub294 \ub2e4\uc18c \uc2dc\uac04\uc774 \uc18c\uc694\ub418\uba70, \uc644\ub8cc\ub418\uba74 quit\ub97c \uc785\ub825\ud574 tbsql\uc744 \uc885\ub8cc\ud558\uace0, \ud2f0\ubca0\ub85c \uc11c\ubc84\ub97c NORMAL \ubaa8\ub4dc\ub85c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n
\r\ntbboot\r\n<\/pre>\n
\ub9c8\uc9c0\ub9c9\uc73c\ub85c  $TB_HOME\/scripts\uc758 system.sh\ub97c \uc2e4\ud589\ud55c\ub2e4. \uc2e4\ud589\uacfc\uc815 \uc911 sys\uc640 syscat\uc758 \uc554\ud638\ub97c \uc785\ub825\ud574\uc57c \ud558\ub294\ub370, \uac01\uac01 tibero\uc640 syscat\uc774\ub2e4. \ub610\ud55c \uc911\uac04 \uc911\uac04\uc5d0 \uc2e4\ud589\ud560 \uc791\uc5c5 \uc218\ud589 \uc5ec\ubd80\ub97c \ubb3b\ub294\ub370, \ud2b9\ubcc4\ud55c \uacbd\uc6b0\uac00 \uc544\ub2cc\ud55c y\ub97c \uc785\ub825\ud574 \uc791\uc5c5\uc744 \uc218\ud589\ud55c\ub2e4.<\/p>\n
\uc774\uc81c \ud2f0\ubca0\ub85c \uc11c\ubc84\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc218\ud589\ub418\ub294\uc9c0, \ud655\uc778\ud558\uae30 \uc704\ud574 \ub2e4\uc74c\ucc98\ub7fc \uc785\ub825\ud55c\ub2e4.<\/p>\n
\r\nps -ef | grep tbsvr\r\n<\/pre>\n
\uadf8 \uacb0\uacfc\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n
\"\"<\/p>\n
\ud2f0\ubca0\ub85c \uc11c\ubc84\uc758 \uc885\ub8cc\ub294 tbdown\uc774\uba70, \uae30\ubcf8 Listener Port\ub294 8629\uc774\ub2e4. \uadf8\ub9ac\uace0 \uc2e4\uc81c \ub370\uc774\ud130\uac00 \uc800\uc7a5\ub418\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \uc704\uce58\ub294 \uc124\uce58\ub41c \ud2f0\ubca0\ub85c\uc758 \ub514\ub809\ud1a0\ub9ac\ub97c \uae30\uc900\uc73c\ub85c  \/etc\/tibero\/tibero6\/database\/{\ub370\uc774\ud130\ubca0\uc774\uc2a4\uba85}\uc774\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"
\ud2f0\ubca0\ub85c(Tibero)\ub294 \ud2f0\ub9e5\uc2a4\uc18c\ud504\ud2b8\uc758 \uc790\ud68c\uc0ac\uc778 \ud2f0\ub9e5\uc2a4\ub370\uc774\ud130\uc5d0\uc11c \uac1c\ubc1c\ud55c DBMS\uc774\ub2e4. 2003\ub144\uc5d0 \ucc98\uc74c \ubc30\ud3ec\ub418\uc5c8\uace0, \ud604\uc7ac \ubc84\uc804 6\uc774 \uc81c\uacf5\ub418\uace0 \uc788\ub2e4. \uc774 \uae00\uc740 CentOS7\uc5d0\uc11c Tibero6\uc744 \uc124\uce58\ud558\ub294 \uacfc\uc815\uc744 \uc815\ub9ac\ud55c \uae00\uc774\ub2e4. \ub2e4\uc6b4\ub85c\ub4dc \ud398\uc774\uc9c0\uc5d0\uc11c Tibero6\uc744 Linux 64bits \uc6a9\uc73c\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\ub294\ub2e4. \uc2e4\uc81c \ub2e4\uc6b4\ub85c\ub4dc\uc640 \ub77c\uc774\uc120\uc2a4 \ubc1c\uae09\uc744 \uc704\ud574 \ud68c\uc6d0 \uac00\uc785\uc774 \ud544\uc694\ud558\uba70 \uba54\uc77c \uc778\uc99d\uc744 \ud1b5\ud574 \uac00\uc785 \ucc98\ub9ac\uac00 \uc774\ub8e8\uc5b4\uc9c4\ub2e4. \ud604\uc7ac \uc774 \uae00\uc744 \uc791\uc131\ud558\ub294 \uc2dc\uc810\uc744 \uae30\uc900\uc73c\ub85c \ub2e4\uc6b4\ub85c\ub4dc \ubc1b\uc740 \ud30c\uc77c\uba85\uc740 tibero6-bin-FS07_CS_1912-linux64-174424-opt.tar.gz \uc774\uba70, … <\/p>\n
\ub354 \ubcf4\uae30 “CentOS7\uc5d0 Tibero6 \uc124\uce58”<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9090","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"_links":{"self":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9090","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=9090"}],"version-history":[{"count":8,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9090\/revisions"}],"predecessor-version":[{"id":9322,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=\/wp\/v2\/posts\/9090\/revisions\/9322"}],"wp:attachment":[{"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=9090"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=9090"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.gisdeveloper.co.kr\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=9090"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}