{"id":91,"date":"2017-05-08T14:54:53","date_gmt":"2017-05-08T05:54:53","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=91"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero6-tac-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero6-tac-%ec%84%a4%ec%b9%98\/","title":{"rendered":"[Tibero] Tibero6 TAC \uc124\uce58"},"content":{"rendered":"<h1>Tibero 6 TAC Installation<\/h1>\n<h2>\uc0ac\uc804 \uc900\ube44<\/h2>\n<h3>\uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 (root \uad8c\ud55c \ud544\uc694)<\/h3>\n<p>\uad00\ub9ac \ubaa9\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc774\ubbc0\ub85c \uc124\uce58\ud558\ub294 \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\uac8c \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790, \uadf8\ub8f9, \ubcf4\uc870 \uadf8\ub8f9, uid \ub4f1\uc744 \uc124\uc815\ud574\uc11c \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n<pre><code class=\"bash\">useradd tibero -g dba -u 8629\n<\/code><\/pre>\n<h2>tibero \uacc4\uc815 \ud504\ub85c\ud30c\uc77c \uc124\uc815<\/h2>\n<p>Tibero \uacc4\uc815\uc73c\ub85c sh \uc5d0 \uc811\uadfc\ud55c \ub4a4 <code>vi ~\/.bash_profile<\/code> \ud30c\uc77c \ub9e8 \uc544\ub798\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4.<\/p>\n<pre><code class=\"bash\"># Java ENV\nexport JAVA_HOME=\/app\/jdk\nexport PATH=$JAVA_HOME\/bin:$PATH\n\n# Tibero 6 Env\nexport TB_HOME=\/app\/tibero\/tibero6\nexport TB_SID=tibero1 ## DB Instance \ubcc4 ID. \ub450\ubc88\uc9f8 \ub178\ub4dc\ub294 tibero2\nexport PATH=.:$TB_HOME\/bin:$TB_HOME\/client\/bin:$PATH\nexport LD_LIBRARY_PATH=$TB_HOME\/lib:$TB_HOME\/client\/lib:$LD_LIBRARY_PATH\n\n#export TB_PROF_DIR=$TB_HOME\/bin\/prof\nexport TBINARY_PATH=\/app\/tibero\/tbinary\n\n# Tibero TBCM Env\nexport CM_SID=tbcm1 ## Cluster Manager ID. \ub450\ubc88\uc9f8 \ub178\ub4dc\ub294 tbcm2\nexport CM_HOME=\/app\/tibero\/tibero6\n\n# Tibero aliases\nalias tbhome='cd $TB_HOME'\nalias tbbin='cd $TB_HOME\/bin'\nalias tblog='cd \/logs\/tibero'\nalias tbcfg='cd $TB_HOME\/config'\nalias tbcfgv='vi $TB_HOME\/config\/$TB_SID.tip'\nalias tbcli='cd ${TB_HOME}\/client\/config'\nalias tbcliv='vi ${TB_HOME}\/client\/config\/tbdsn.tbr'\nalias tbi='cd $TBINARY_PATH'\nalias tm='cd $TBINARY_PATH\/monitor;monitor;cd -'\n\n# User Env\nset -o vi\nstty erase ^H\n<\/code><\/pre>\n<p>profile \ud30c\uc77c\uc744 \uc800\uc7a5\ud55c \ub4a4, <strong>sh session\uc5d0 \ub2e4\uc2dc \uc811\uc18d<\/strong>\ud558\uac70\ub098 <code>. ~\/.bash_profile<\/code> \uba85\ub839\uc744 \uc218\ud589\ud558\uc5ec \ubcc0\uacbd \uc0ac\ud56d\uc744 \uc801\uc6a9\ud55c\ub2e4.<\/p>\n<h3>raw device \ubc0f \ub514\ub809\ud1a0\ub9ac \uad8c\ud55c \uc124\uc815 (root \uad8c\ud55c \ud544\uc694)<\/h3>\n<p>Tibero TAC \ub294 \uacf5\uc720 \ub514\uc2a4\ud06c\ub97c \uae30\ubc18\uc73c\ub85c \ud558\uae30 \ub54c\ubb38\uc5d0 \ub370\uc774\ud130\ud30c\uc77c\uc774 \uc800\uc7a5\ub420 \uacbd\ub85c\ub294 \ubaa8\ub4e0 DB \ub178\ub4dc\uac00 \uc811\uadfc\uac00\ub2a5\ud574\uc57c\ud55c\ub2e4. \uacf5\uc720 \ud30c\uc77c\uc2dc\uc2a4\ud15c\uc73c\ub85c\ub3c4 \uad6c\uc131\ud560 \uc218 \uc788\uc9c0\ub9cc raw device \ub97c \uae30\ubc18\uc73c\ub85c \uc124\uce58\ub97c \uc9c4\ud589\ud558\uba70 \uc544\ub798\uc640 \uac19\uc774 raw device \ub4e4\uc774 tibero \uacc4\uc815 \uc18c\uc720\uc774\uc5b4\uc5ec \ud55c\ub2e4.<\/p>\n<p><code>ls \/dev\/tbdata<\/code><\/p>\n<pre><code class=\"bash\">rlv10g00  rlv10g05  rlv1g00  rlv1g05  rlv1g10  rlv1g15  rlv1g20  rlv1g25  rlv30g00  rlv30g05  rlv5g00  rlv5g05  rlv5g10  rlv5g15\nrlv10g01  rlv10g06  rlv1g01  rlv1g06  rlv1g11  rlv1g16  rlv1g21  rlv1g26  rlv30g01  rlv30g06  rlv5g01  rlv5g06  rlv5g11  rlv5g16\nrlv10g02  rlv10g07  rlv1g02  rlv1g07  rlv1g12  rlv1g17  rlv1g22  rlv1g27  rlv30g02  rlv30g07  rlv5g02  rlv5g07  rlv5g12  rlv5g17\nrlv10g03  rlv10g08  rlv1g03  rlv1g08  rlv1g13  rlv1g18  rlv1g23  rlv1g28  rlv30g03  rlv30g08  rlv5g03  rlv5g08  rlv5g13  rlv5g18\nrlv10g04  rlv10g09  rlv1g04  rlv1g09  rlv1g14  rlv1g19  rlv1g24  rlv1g29  rlv30g04  rlv30g09  rlv5g04  rlv5g09  rlv5g14  rlv5g19\n<\/code><\/pre>\n<p><a href=\"https:\/\/oboki.net\/?p=553\">\uacf5\uc720 \ub514\uc2a4\ud06c \ubc0f raw device \uad6c\uc131 \ubc29\ubc95 \ucc38\uace0<\/a><\/p>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \uc5d4\uc9c4, \ub85c\uadf8, \ub370\uc774\ud130\ud30c\uc77c \uacbd\ub85c\ub97c \uad6c\ubd84\ud558\uc5ec \uc124\uce58\ub97c \uc9c4\ud589\ud55c\ub2e4.<br \/>\n\uc120\ud0dd\uc0ac\ud56d\uc774\uba70, I\/O \uacbd\ud569\uc744 \uc904\uc774\uac70\ub098 \uac01 \ub514\ub809\ud1a0\ub9ac\uc5d0 \uc0dd\uc131\ub418\ub294 \ud30c\uc77c\uc758 \uc911\uc694\ub3c4\uc5d0 \ub530\ub77c \uad6c\ubd84\ud558\uc5ec \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.<\/p>\n<ul>\n<li>Tibero \uc5d4\uc9c4 \uacbd\ub85c\n<ul>\n<li>\/app\/tibero\/tibero6<\/li>\n<\/ul>\n<\/li>\n<li>Tibero \uc11c\ubc84 \ub85c\uadf8 \uacbd\ub85c\n<ul>\n<li>\/logs\/tibero<\/li>\n<\/ul>\n<\/li>\n<li>Tibero \ub370\uc774\ud130\ud30c\uc77c \uacbd\ub85c\n<ul>\n<li>\/data\/tibero<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<pre><code class=\"bash\">chown tibero:dba \/app\/tibero\nchown tibero:dba \/logs\/tibero\nchown tibero:dba \/data\/tibero\n<\/code><\/pre>\n<h3>Linux \ucee4\ub110 \uc124\uc815 (root \uad8c\ud55c \ud544\uc694)<\/h3>\n<p><code>vi \/etc\/sysctl.conf<\/code> \ud30c\uc77c\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4. \uc2dc\uc2a4\ud15c \uba54\ubaa8\ub9ac\uac00 8GB\uc774\uace0 Tibero RDBMS\uac00 \uc0ac\uc6a9\ud560 \ucd5c\ub300 \uba54\ubaa8\ub9ac\uac00 4GB\uc778 \uacbd\uc6b0\ub97c \uae30\uc900\uc73c\ub85c \uc124\uc815\ud55c\ub2e4.<\/p>\n<pre><code class=\"yml\">kernel.sem = 10000 32000 10000 10000\nkernel.shmmax = 4294967296  # \uc2dc\uc2a4\ud15c\uc758 \ubb3c\ub9ac\uc801\uc778 \uba54\ubaa8\ub9ac \uc808\ubc18 (byte \ub2e8\uc704)\nkernel.shmall = 1048576 # ceil(shmmax\/PAGE_SIZE)\nkernel.shmmni = 4096\nfs.file-max = 6815744\nnet.ipv4.ip_local_port_range = 1024 65500\n<\/code><\/pre>\n<p><code>sysctl -p<\/code> \uba85\ub839\uc73c\ub85c \ubcc0\uacbd \uc0ac\ud56d \uc801\uc6a9<\/p>\n<h3>Linux ulimit \uc124\uc815 (root \uad8c\ud55c \ud544\uc694)<\/h3>\n<p><code>vi \/etc\/security\/limits.conf<\/code> \ud30c\uc77c\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4.<\/p>\n<pre><code class=\"conf\">tibero soft nofile 1024\ntibero hard nofile 65536\ntibero soft nproc 2047\ntibero hard nproc 16384\ntibero soft memlock unlimited\ntibero hard memlock unlimited\n<\/code><\/pre>\n<h2>Tibero 6 \uc124\uce58<\/h2>\n<h3>\uc124\uce58 \ud30c\uc77c \uc900\ube44<\/h3>\n<p>Tibero 6 binary \ubc0f license\ub97c \uc900\ube44\ud558\uc5ec Tibero RDBMS \uc11c\ubc84 \ud638\uc2a4\ud2b8, tibero \uacc4\uc815 \ud648 \uacbd\ub85c\uc5d0 \uc5c5\ub85c\ub4dc\ud55c\ub2e4.<\/p>\n<h4>Tibero 6 binary<\/h4>\n<p>\uc544\ub798 URL\uc5d0\uc11c \uc124\uce58\ud558\uace0\uc790 \ud558\ub294 \ubc84\uc804 \uc120\ud0dd \ud6c4 \ub2e4\uc6b4\ub85c\ub4dc (Tibero 6 FixSet06 \ubc84\uc804 \uae30\uc900\uc73c\ub85c \uc124\uce58 \uc9c4\ud589)<br \/>\n<a href=\"https:\/\/technet.tmaxsoft.com\/ko\/front\/download\/findDownloadList.do?cmProductCode=0301\">Tibero Downloads Link<\/a><\/p>\n<h4>Tibero 6 license<\/h4>\n<p>\uc815\uc2dd \ub77c\uc774\uc13c\uc2a4\uac00 \uc5c6\ub294 \uacbd\uc6b0,<br \/>\n<a href=\"https:\/\/technet.tmaxsoft.com\">Tmax TechNet<\/a> \uc5d0 \uc811\uc18d\ud558\uc5ec \ub85c\uadf8\uc778\ud55c \ub4a4 <a href=\"https:\/\/technet.tmaxsoft.com\/ko\/front\/common\/demoPopup.do\"><strong>[\ub370\ubaa8\ub77c\uc774\uc120\uc2a4 \uc2e0\uccad]<\/strong><\/a> \ubc84\ud2bc\uc744 \ud074\ub9ad\ud558\uc5ec \ub370\ubaa8 \ub77c\uc774\uc13c\uc2a4\ub97c \ubc1c\uae09\ubc1b\ub294\ub2e4. <strong>TAC cluster \ub97c \uad6c\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 Enterprise \ub77c\uc774\uc13c\uc2a4\uac00 \ud544\uc694\ud558\ub2e4.<\/strong><\/p>\n<h3>Tibero 6 \uc5d4\uc9c4 \uc124\uce58<\/h3>\n<p>\uc544\ub798 \uba85\ub839\uc744 \uc218\ud589\ud558\uc5ec <code>\/app\/tibero\/tibero6<\/code> \uacbd\ub85c\uc5d0 tibero \uc5d4\uc9c4\uc744 \uc124\uce58\ud55c\ub2e4.<\/p>\n<pre><code class=\"bash\">tar -xvzf ~\/tibero6-bin-FS06-linux64-xxxxxx-opt-tested.tar.gz -C \/app\/tibero\/.\n<\/code><\/pre>\n<p>\uc774\uc5b4\uc11c \ub77c\uc774\uc13c\uc2a4 \ud30c\uc77c\uc744 \uc5d4\uc9c4 \uacbd\ub85c \ub0b4\uc5d0 \uc704\uce58\uc2dc\ud0a8\ub2e4.<\/p>\n<pre><code class=\"bash\">mv ~\/license.xml $TB_HOME\/license\/.\n<\/code><\/pre>\n<h3>Tibero \uc124\uc815<\/h3>\n<h4>generate tip file<\/h4>\n<p>\ub2e4\uc74c \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec <em>Tibero Init Parameter (tip)<\/em> \ud30c\uc77c\uc744 \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<pre><code class=\"bash\">$TB_HOME\/config\/gen_tip.sh\n<\/code><\/pre>\n<h4>$TB_SID.tip \ud30c\uc77c \uc124\uc815<\/h4>\n<p><code>vi $TB_HOME\/config\/$TB_SID.tip<\/code> \ud30c\uc77c\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud558\uc5ec Tibero instance\ub97c \uc124\uc815\ud55c\ub2e4.<\/p>\n<pre><code class=\"yml\">DB_NAME=tibero # TB_SID \uac12\uc744 \ubc1b\uc544\uc624\ub294\ub370 tibero1,2 -&gt; tibero \ub85c \ubcc0\uacbd\nLISTENER_PORT=8629\nCONTROL_FILES=\"\/dev\/tbdata\/rlv1g01\" # local \ud30c\uc77c\uc2dc\uc2a4\ud15c\uc774 \uc544\ub2cc raw device \uacbd\ub85c\ub85c \ubcc0\uacbd\n#CERTIFICATE_FILE=\"\/app\/tibero\/tibero6\/config\/svr_wallet\/tibero.crt\"\n#PRIVKEY_FILE=\"\/app\/tibero\/tibero6\/config\/svr_wallet\/tibero.key\"\n#WALLET_FILE=\"\/app\/tibero\/tibero6\/config\/svr_wallet\/WALLET\"\n#ILOG_MAP=\"\/app\/tibero\/tibero6\/config\/ilog.map\"\n\nMAX_SESSION_COUNT=20\n\nTOTAL_SHM_SIZE=2G\nMEMORY_TARGET=4G\n\nDB_CREATE_FILE_DEST=\"\/data\/tibero\"\nLOG_DEFAULT_DEST=\"\/logs\/tibero\"\n\nCLUSTER_DATABASE=Y\nTHREAD=0 ## node2 \uc758 \uacbd\uc6b0 1\nUNDO_TABLESPACE=UNDO0 ## node2 \uc758 \uacbd\uc6b0 UNDO1\n\nLOCAL_CLUSTER_ADDR=192.168.179.81 ## node2\uc758 \uacbd\uc6b0 192.168.179.82\nCM_PORT=10010\nCM_UI_PORT=10010\nLOCAL_CLUSTER_PORT=10020\nCM_NAME=tbcm1 ## node2 \uc758 \uacbd\uc6b0 tbcm2\nCM_RESOURCE_FILE=\/app\/tibero\/tbcm1_resources\n<\/code><\/pre>\n<p><code>CONTROL_FILES<\/code><br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc758 \ucee8\ud2b8\ub864 \ud30c\uc77c \uacbd\ub85c\ub97c \uc9c0\uc815\ud55c\ub2e4. <code>gen_tip.sh<\/code>\uc744 \uc218\ud589\ud558\uba74 \ub85c\uceec \ud30c\uc77c\uc2dc\uc2a4\ud15c\uc5d0 \uae30\ubcf8 \uacbd\ub85c\ub85c \uc124\uc815\ud574\uc8fc\ub294\ub370 raw device \ub85c \ubcc0\uacbd\ud574\uc8fc\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n<p><code>DB_CREATE_FILE_DEST<\/code><br \/>\nTAC\uc5d0\uc11c raw device \ub97c \uc0ac\uc6a9\ud558\ub294 \uacbd\uc6b0 \ub370\uc774\ud130 \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\uc9c0\ub294 \uc54a\uc9c0\ub9cc <code>.passwd<\/code> \ud30c\uc77c\uc774 \uc0dd\uc131\ub418\ubbc0\ub85c \ubcc4\ub3c4 \uc9c0\uc815\uc744 \ud574\uc8fc\ub294 \uac83\uc774 \uc88b\ub2e4.<\/p>\n<p><code>LOG_DEFAULT_DEST<\/code><br \/>\nTibero RDBMS \uc11c\ubc84 \ub85c\uadf8\uac00 \uc0dd\uc131\ub418\ub294 \uacbd\ub85c\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>DB_NAME<\/code><br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc774\ub984\uc744 \uc9c0\uc815\ud55c\ub2e4. <code>gen_tip.sh<\/code> \uc218\ud589 \uc2dc, \ud504\ub85c\ud30c\uc77c\uc5d0 \uae30\uc7ac\ud55c $TB_SID \uba85\uc744 \uae30\ubcf8\uc801\uc73c\ub85c \uc0ac\uc6a9\ud55c\ub2e4. Instance \uc2dd\ubcc4\uc790\uac00 \uc544\ub2cc \ubaa8\ub4e0 instance\uac00 \uacf5\uc720\ud558\ub294 DB_NAME\uc744 \uc801\uc5b4\uc57c \ud558\ubbc0\ub85c \uc218\uc815\ud574\uc57c\ud55c\ub2e4.<\/p>\n<p><code>LISTENER_PORT<\/code><br \/>\n\ud074\ub77c\uc774\uc5b8\ud2b8\uac00 TCP\/IP \ub97c \uc774\uc6a9\ud574 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\ub294 \uacbd\uc6b0 \uc811\uc18d\ud560 \uc218 \uc788\ub294 \ud3ec\ud2b8\ub97c \uc9c0\uc815\ud55c\ub2e4. RDBMS \uc11c\ubc84\uc758 ${HOSTNAME}, ${DB_NAME} \uacfc \ud568\uaed8 \uc870\ud569\ub418\uc5b4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc720\uc77c\ud558\uac8c \uc2dd\ubcc4\ud560 \uc218 \uc788\ub3c4\ub85d \ud574\uc57c\ud55c\ub2e4.<\/p>\n<p><code>MAX_SESSION_COUNT<\/code><br \/>\n\ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uc18d\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 \ud074\ub77c\uc774\uc5b8\ud2b8 \uc138\uc158 \uc218\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>TOTAL_SHM_SIZE<\/code><br \/>\nTibero instance\uc758 \uc5ec\ub7ec \ud504\ub85c\uc138\uc2a4\ub4e4\uc774 \uacf5\uc720\ud560 \uc218 \uc788\ub294 \uba54\ubaa8\ub9ac \uc601\uc5ed(Buffer Cache, Library Cache \ub4f1)\uc758 \ud06c\uae30\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>MEMORY_TARGET<\/code><br \/>\nSGA, PGA\ub97c \ud3ec\ud568\ud558\uc5ec Tibero instance\uac00 \uc0ac\uc6a9\ud560 \uc218 \uc788\ub294 \ucd5c\ub300 \uba54\ubaa8\ub9ac \uc601\uc5ed\uc758 \ud06c\uae30\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>CLUSTER_DATABASE<\/code><br \/>\nClustering \uc744 \ud558\ub294\uc9c0 \uc5ec\ubd80\ub97c \uc9c0\uc815\ud55c\ub2e4. <code>Y<\/code>\ub85c \uc9c0\uc815\ud558\ub294 \uacbd\uc6b0 cluster manager \ud504\ub85c\uc138\uc2a4\uc758 \uc874\uc7ac\ub97c \ud655\uc778\ud558\uac8c \ub41c\ub2e4.<\/p>\n<p><code>THREAD<\/code><br \/>\ninstance \ubcc4\ub85c thread id \ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>UNDO_TABLESPACE<\/code><br \/>\ninstance \ubcc4\ub85c \uc0ac\uc6a9\ud560 UNDO_TABLESPACE \uba85\uc744 \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>LOCAL_CLUSTER_ADDR<\/code><br \/>\nDB instance \uac04\uc758 \ud1b5\uc2e0\uc744 \ub2f4\ub2f9\ud560 IP \uc8fc\uc18c\ub97c \uae30\uc785\ud78c\ub2e4.<\/p>\n<p><code>CM_PORT<\/code> &amp; <code>CM_UI_PORT<\/code><br \/>\ntbcm\uacfc tibero \uc778\uc2a4\ud134\uc2a4 \uac04\uc758 \ud1b5\uc2e0\uc744 \uc704\ud55c \ud3ec\ud2b8\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>LOCAL_CLUSTER_PORT<\/code><br \/>\ntibero \uc778\uc2a4\ud134\uc2a4 \uac04\uc758 \ud1b5\uc2e0\uc744 \uc704\ud55c \ud3ec\ud2b8\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<p><code>CM_NAME<\/code><br \/>\n\ud574\ub2f9 tibero instance\uac00 \uad00\ub9ac\ub97c \uc704\uc784\ud558\ub294 tbcm \uc774\ub984\uc744 \uae30\uc785\ud55c\ub2e4.<\/p>\n<p><code>CM_RESOURCE_FILE<\/code><br \/>\nTAC\ub97c \uad6c\uc131\ud558\uae30 \uc704\ud574\uc11c\ub294 \ub124\ud2b8\uc6cc\ud06c \ub4f1 \uc5ec\ub7ec \ub9ac\uc18c\uc2a4\ub97c \ud65c\uc6a9\ud574\uc57c\ud558\ub294\ub370 \uc774 \ub9ac\uc18c\uc2a4 \uc815\ubcf4\ub97c \uae30\ub85d\ud560 \ubc14\uc774\ub108\ub9ac \ud30c\uc77c \uacbd\ub85c\ub97c \uc9c0\uc815\ud55c\ub2e4.<\/p>\n<h4>$CM_SID.tip \ud30c\uc77c \uc124\uc815<\/h4>\n<p><code>vi $TB_HOME\/config\/$CM_SID.tip<\/code> \ud30c\uc77c\uc744 \uc544\ub798\uc640 \uac19\uc774 \uc218\uc815\ud558\uc5ec tbcm\uc744 \uc124\uc815\ud55c\ub2e4.<\/p>\n<pre><code class=\"yml\">CM_NAME=tbcm1 ## node2\uc758 \uacbd\uc6b0 tbcm2\nCM_UI_PORT=10010\nCM_RESOURCE_FILE=\/app\/tibero\/tbcm1_resources ## node2\uc758 \uacbd\uc6b0 \/app\/tibero\/tbcm2_resources\nCM_HEARTBEAT_EXPIRE=30\nCM_WATCHDOG_EXPIRE=25\n<\/code><\/pre>\n<h3>TAC \ud074\ub7ec\uc2a4\ud130 \uc0dd\uc131<\/h3>\n<p>\uc544\ub798\uc640 \uac19\uc774 <code>tbcm -b<\/code> \uba85\ub839\uc744 \ud1b5\ud574 tbcm\uc744 \uae30\ub3d9\ud55c \ub4a4 <code>cmrctl<\/code> \uba85\ub839\uc744 \uc774\uc6a9\ud574\uc11c tibero \ud074\ub7ec\uc2a4\ud130\uc5d0 \ud544\uc694\ud55c \ub9ac\uc18c\uc2a4\ub97c \ucd94\uac00\ud55c\ub2e4.<\/p>\n<h4>node1<\/h4>\n<pre><code class=\"bash\">tbcm -b\n\ncmrctl add network --nettype private --ipaddr 192.168.179.81 --portno 10030 --name prvnet\ncmrctl add network --nettype public --ifname enp1s0 --name pubnet\ncmrctl add cluster --incnet prvnet --pubnet pubnet --cfile \"\/dev\/tbdata\/rlv1g00\" --name cls\ncmrctl start cluster --name cls\ncmrctl add service --name tac --cname cls\ncmrctl add db --name $TB_SID --svcname tibero --dbhome $TB_HOME\n<\/code><\/pre>\n<h4>node2<\/h4>\n<pre><code class=\"bash\">tbcm -b\n\ncmrctl add network --nettype private --ipaddr 192.168.179.82 --portno 10030 --name prvnet\ncmrctl add network --nettype public --ifname enp1s0 --name pubnet\ncmrctl add cluster --incnet prvnet --pubnet pubnet --cfile \"\/dev\/tbdata\/rlv1g00\" --name cls\ncmrctl start cluster --name cls\ncmrctl add db --name $TB_SID --svcname tibero --dbhome $TB_HOME\n<\/code><\/pre>\n<h3>Tibero nomount \uae30\ub3d9 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h3>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 node1\uc5d0\uc11c <code>tbboot nomount<\/code> \uba85\ub839\uc744 \uc218\ud589\ud558\uc5ec Tibero RDBMS instance \ub97c \uc2e4\ud589\ud55c\ub2e4.<\/p>\n<p><code>tbboot nomount<\/code><\/p>\n<pre><code>---\n$ tbboot nomount\nListener port = 8629\n\nTibero 6  \n\nTmaxData Corporation Copyright (c) 2008-. All rights reserved.\nTibero instance started up (NOMOUNT mode).\n---\n<\/code><\/pre>\n<p>\uc815\uc0c1\uc801\uc73c\ub85c nomount \ubaa8\ub4dc\ub85c \uae30\ub3d9\uc774 \ub41c \uacbd\uc6b0 \uc704\uc640 \uac19\uc740 \uba54\uc2dc\uc9c0\uac00 \ucd9c\ub825\ub41c\ub2e4.<br \/>\n\uc774\uc5b4\uc11c tbsql \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc774\uc6a9\ud574 Tibero instance\uc5d0 \uc811\uc18d\ud55c \ub4a4 \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4. TAC\ub294 instance-level \uac00\uc6a9\uc131\uc744 \ubcf4\uc7a5\ud558\ub294 \uac83\uc73c\ub85c DB \uc790\uccb4\ub294 \ud558\ub098\uc774\ub2e4. <code>CREATE DATABASE<\/code> DDL\uc744 \uc774\uc6a9\ud55c \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\uc740 1\ubc88 \ub178\ub4dc\uc5d0\uc11c \ud55c\ubc88\ub9cc \uc218\ud589\ud55c\ub2e4.<\/p>\n<p>nomount \ubaa8\ub4dc\uc5d0\uc11c\ub294 \ub9c8\uc2a4\ud130 \uacc4\uc815\uc778 &#8216;sys&#8217; \ub85c\ub9cc \uc811\uadfc\ud560 \uc218 \uc788\uc73c\uba70, \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131\ub418\uc9c0 \uc54a\uc740 \uc0c1\ud0dc\uc5d0\uc11c\ub294 \ucd08\uae30 password &#8216;tibero&#8217; \ub85c \uc124\uc815\ub3fc \uc788\ub2e4.<\/p>\n<p><code>tbsql sys\/tibero<\/code><\/p>\n<p>\uc815\uc0c1\uc801\uc73c\ub85c \uc811\uc18d\ub418\uba74 \uc544\ub798\uc640 \uac19\uc774 SQL \ud504\ub86c\ud504\ud2b8\uac00 \ucd9c\ub825\ub41c\ub2e4.<\/p>\n<pre><code>---\n$ tbsql sys\/tibero\n\ntbSQL 6  \n\nTmaxData Corporation Copyright (c) 2008-. All rights reserved.\n\nConnected to Tibero.\n\nSQL&gt; \n---\n<\/code><\/pre>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 CREATE DATABASE DDL \uad6c\ubb38\uc744 \uc218\ud589\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4\ub97c \uc0dd\uc131\ud55c\ub2e4.<\/p>\n<pre><code class=\"sql\">create database\nuser sys identified by tibero\ncharacter set UTF8 -- UTF8, EUCKR, ASCII, MSWIN949\nlogfile group 0 ('\/dev\/tbdata\/rlv1g02','\/dev\/tbdata\/rlv1g03') size 1024M,\n        group 1 ('\/dev\/tbdata\/rlv1g04','\/dev\/tbdata\/rlv1g05') size 1024M,\n        group 2 ('\/dev\/tbdata\/rlv1g06','\/dev\/tbdata\/rlv1g07') size 1024M\nmaxdatafiles 1024\nmaxlogfiles 100\nmaxlogmembers 8\nnoarchivelog\n  datafile '\/dev\/tbdata\/rlv5g00' size 5120M autoextend off\ndefault tablespace USR\n  datafile '\/dev\/tbdata\/rlv1g08' size 1024M autoextend off\ndefault temporary tablespace TEMP\n  tempfile '\/dev\/tbdata\/rlv30g00' size 30720M autoextend off\n  extent management local AUTOALLOCATE\nundo tablespace UNDO\n  datafile '\/dev\/tbdata\/rlv30g01' size 30720M autoextend off\n  extent management local AUTOALLOCATE\n;\n<\/code><\/pre>\n<p>\uc815\uc0c1\uc801\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uac00 \uc0dd\uc131\ub418\uba74 \ub2e4\uc74c\uacfc \uac19\uc740 \uba54\uc2dc\uc9c0\uac00 \ucd9c\ub825\ub418\uba70 instance \uac00 \uc885\ub8cc\ub41c\ub2e4.<\/p>\n<pre><code>---\nDatabase created.\n\nSQL&gt; \n---\n<\/code><\/pre>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 <code>quit<\/code> \ub610\ub294 <code>exit<\/code> \uba85\ub839\uc744 \ud1b5\ud574 SQL \ud504\ub86c\ud504\ud2b8\ub97c \ube60\uc838\ub098\uc628 \ub4a4 <code>tbboot<\/code> \uba85\ub839\uc744 \ud1b5\ud574 Tibero RDBMS instance \ub97c NORMAL \ubaa8\ub4dc\ub85c \uae30\ub3d9\ud55c\ub2e4.<\/p>\n<p><code>tbboot<\/code><\/p>\n<pre><code>---\nSQL&gt; quit\nDisconnected.\n$ tbboot\nListener port = 8629\n\nTibero 6  \n\nTmaxData Corporation Copyright (c) 2008-. All rights reserved.\nTibero instance started up (NORMAL mode).\n\n---\n<\/code><\/pre>\n<p>Normal \ubaa8\ub4dc \uae30\ub3d9\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 <code>$TB_HOME\/scripts\/tpr_create_obj.sh<\/code>, <code>$TB_HOME\/scripts\/tpr_create_obj.sql<\/code> \uc2a4\ud06c\ub9bd\ud2b8\uc758 datafile \ubd80\ubd84\uc744 \ub2e4\uc74c\uacfc \uac19\uc774 \uc218\uc815\ud55c\ub2e4.<\/p>\n<p><code>vi $TB_HOME\/scripts\/tpr_create_obj.sh<\/code><\/p>\n<pre><code class=\"bash\">#! \/bin\/sh\n\nsvr_home=\"$1\"\nsvr_sid=\"$2\"\nsys_conn=\"$3\"\nsvr_sql=\"$4\"\nLOG=\"$5\"\n\ntpr_create_ts_sql=\"create tablespace syssub datafile '\/dev\/tbdata\/rlv1g09' size 1024M reuse autoextend off;\" ## \uc6d0\ubcf8: tpr_create_ts_sql=\"create tablespace syssub datafile 'tpr_ts.dtf' size 10m reuse autoextend on next 10m;\"\ntpr_report_dir_sql=\"create directory tpr_report_dir \n                    as '@SVR_HOME@\/instance\/@SVR_SID@';\"\ntpr_tip_dir_sql=\"create directory tpr_tip_dir as '@SVR_HOME@\/config';\"\n\n$svr_sql 2&gt;&gt;$LOG &gt;&gt; $LOG &lt;&lt;EOF\nconn $sys_conn@$svr_sid\nset comment off\n$tpr_create_ts_sql\n$tpr_report_dir_sql\n$tpr_tip_dir_sql\nquit\nEOF\n<\/code><\/pre>\n<p><code>$TB_HOME\/scripts\/tpr_create_obj.sql<\/code><\/p>\n<pre><code class=\"sql\">create tablespace syssub datafile '\/dev\/tbdata\/rlv1g09' size 1024M reuse autoextend off; -- \uc6d0\ubcf8: create tablespace syssub datafile 'tpr_ts.tdf' size 10m reuse autoextend on next 10m;\ncreate directory tpr_report_dir as '@SVR_HOME@\/instance\/@SVR_SID@';\n\ncreate directory tpr_tip_dir as '@SVR_HOME@\/config';\n<\/code><\/pre>\n<p>\uc218\uc815\uc774 \uc644\ub8cc\ub418\uc5c8\uc73c\uba74 <code>$TB_HOME\/scripts\/system.sh<\/code> \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud558\uc5ec default schema \ubc0f system\uc5d0 \ub300\ud55c table\uacfc view \ub97c \uc0dd\uc131\ud55c\ub2e4. &#8216;sys&#8217;, &#8216;syscat&#8217; schema\uc5d0 \ub300\ud55c \ud328\uc2a4\uc6cc\ub4dc\ub97c \uc785\ub825\ud574\uc57c\ub9cc \ud558\ub294\ub370 \ucd08\uae30 \ube44\ubc00\ubc88\ud638\ub294 \ub2e4\uc74c\uacfc \uac19\ub2e4.<\/p>\n<ul>\n<li>username: sys\n<ul>\n<li>password: tibero<\/li>\n<\/ul>\n<\/li>\n<li>username: syscat\n<ul>\n<li>password: syscat<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>system user &amp; role, system table, TPR tables \uc0dd\uc131 \ubc0f dbms_stats job\uc744 job Scheduler\uc5d0 \ub4f1\ub85d\ud560 \uac83\uc778\uc9c0 \uc5ec\ubd80\ub97c \ud310\ub2e8\ud558\uc5ec &#8216;Y&#8217; or &#8216;N&#8217; \uc911\uc5d0\uc11c \uc785\ub825\ud558\uba74 \ub418\ub294\ub370 \ubaa8\ub450 &#8216;Y&#8217;\ub97c \uc785\ub825\ud55c\ub2e4.<\/p>\n<p><code>$TB_HOME\/scripts\/system.sh<\/code><\/p>\n<pre><code>---\n$ $TB_HOME\/scripts\/system.sh\nEnter SYS password: \ntibero\n\nEnter SYSCAT password: \nsyscat\n\n.\n.\n\nCreate default system users &amp; roles?(Y\/N): \ny\n\n.\n.\n\nCreate system tables related to profile?(Y\/N): \ny\n\n.\n.\n\nCreate TPR tables?(Y\/N): \ny\n\n.\n.\n\nRegister dbms_stats job to Job Scheduler?(Y\/N):\nY\n\n.\n.\n\nDone.\nFor details, check \/app\/tibero\/tibero6\/instance\/tibero\/log\/system_init.log.\n---\n<\/code><\/pre>\n<p>\uc704\uc640 \uac19\uc774 <code>system.sh<\/code> \uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc885\ub8cc\ub418\uba74, <code>sys.log<\/code> &amp; <code>system_init.log<\/code> \ub97c \ud655\uc778\ud558\uac70\ub098 <code>tbsql sys\/tibero<\/code> \uba85\ub839\uc73c\ub85c \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\uc5ec \uc815\uc0c1\uc801\uc73c\ub85c default schema \ubc0f system table &amp; view\ub97c \uc870\ud68c\ud558\uc5ec \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131\uc774 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n<h3>TAC \ub178\ub4dc \ucd94\uac00<\/h3>\n<p>\uc544\ub798 <code>sql<\/code>\uc744 node1 \uc5d0\uc11c \uc218\ud589\ud558\uc5ec UNDO,REDO\ub97c \uc0dd\uc131\ud574\uc8fc\uace0 node 2 \ub97c \ud65c\uc131\ud654 \ud55c\ub2e4.<\/p>\n<pre><code class=\"sql\">create undo tablespace UNDO1\ndatafile '\/dev\/tbdata\/rlv30g02' size 30720M autoextend off\n  extent management local AUTOALLOCATE\n-- extent management local UNIFORM SIZE 1M\n;\n\nalter database add logfile thread 1 group 3 '\/dev\/tbdata\/rlv1g10','\/dev\/tbdata\/rlv1g11' size 1024M;\nalter database add logfile thread 1 group 4 '\/dev\/tbdata\/rlv1g12','\/dev\/tbdata\/rlv1g13' size 1024M;\nalter database add logfile thread 1 group 5 '\/dev\/tbdata\/rlv1g14','\/dev\/tbdata\/rlv1g15' size 1024M;\n\nalter database enable public thread 1;\n<\/code><\/pre>\n<p>\uc774\ud6c4 node 2 \uc5d0\uc11c <code>tbboot<\/code> \uba85\ub839\uc73c\ub85c instance\ub97c \uae30\ub3d9\ud574\uc8fc\uba74 \ub05d.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tibero 6 TAC Installation \uc0ac\uc804 \uc900\ube44 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 (root \uad8c\ud55c \ud544\uc694) \uad00\ub9ac \ubaa9\uc801\uc73c\ub85c \uc9c0\uc815\ud558\ub294 \uac83\uc774\ubbc0\ub85c \uc124\uce58\ud558\ub294 \uc2dc\uc2a4\ud15c\uc5d0 \ub9de\uac8c \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790, \uadf8\ub8f9, \ubcf4\uc870 \uadf8\ub8f9, uid \ub4f1\uc744 \uc124\uc815\ud574\uc11c \uc0ac\uc6a9\ud55c\ub2e4. useradd tibero -g dba -u 8629 tibero \uacc4\uc815 \ud504\ub85c\ud30c\uc77c \uc124\uc815 Tibero \uacc4\uc815\uc73c\ub85c sh \uc5d0 \uc811\uadfc\ud55c \ub4a4 vi ~\/.bash_profile \ud30c\uc77c \ub9e8 \uc544\ub798\uc5d0 \ub2e4\uc74c \ub0b4\uc6a9\uc744 \ucd94\uac00\ud55c\ub2e4. # Java ENV [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[8],"tags":[23,108,50],"class_list":["post-91","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-tibero","tag-108","tag-50"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/91","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/comments?post=91"}],"version-history":[{"count":6,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/91\/revisions"}],"predecessor-version":[{"id":1308,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/91\/revisions\/1308"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=91"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=91"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=91"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}