{"id":476,"date":"2017-05-07T22:58:49","date_gmt":"2017-05-07T13:58:49","guid":{"rendered":"http:\/\/dong1lkim.oboki.net\/?p=476"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"tibero6-single-%ec%84%a4%ec%b9%98","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/tibero6-single-%ec%84%a4%ec%b9%98\/","title":{"rendered":"[Tibero] Tibero6 Single \uc124\uce58"},"content":{"rendered":"<h1>Tibero 6 Single Installation<\/h1>\n<h2>\uc0ac\uc804 \uc900\ube44<\/h2>\n<h3>\uc758\uc874 \ud328\ud0a4\uc9c0 (root \uad8c\ud55c \ud544\uc694)<\/h3>\n<p>\ub2e4\uc74c \ud328\ud0a4\uc9c0\ub4e4\uc758 \ud574\ub2f9 \ubc84\uc804 \uc774\uc0c1\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n<ul>\n<li>gcc-3.4.6-11<\/li>\n<li>gcc-c++-3.4.6-11<\/li>\n<li>libgcc-3.4.6-11<\/li>\n<li>libstdc++-3.4.6-11<\/li>\n<li>libstdc++-devel-3.4.6-11<\/li>\n<li>compat-libstdc++-33-3.2.3-47.3<\/li>\n<li>libaio-0.3.105-2<\/li>\n<li>libaio-devel-0.3.105-2<\/li>\n<\/ul>\n<h3>\uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \ub514\ub809\ud1a0\ub9ac \uc124\uc815<\/h3>\n<h4>\uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f sh \ud504\ub85c\ud30c\uc77c \uc124\uc815<\/h4>\n<h5>\uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 (root \uad8c\ud55c \ud544\uc694)<\/h5>\n<p>\uc120\ud0dd\uc0ac\ud56d\uc73c\ub85c DBA \ub610\ub294 DB \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uc2dc\uc2a4\ud15c \uacc4\uc815, \uadf8\ub8f9\uc73c\ub85c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4.<br \/>\n\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>useradd tibero -g dba -u 8629\n<\/code><\/pre>\n<h5>tibero \uc2dc\uc2a4\ud15c \uacc4\uc815 \ud504\ub85c\ud30c\uc77c \uc124\uc815<\/h5>\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 RDBMS ENV\nexport TB_HOME=\/app\/tibero\/tibero6\nexport TB_SID=tibero # DB_NAME\uacfc \ub3d9\uc77c\ud558\uac8c \uc124\uc815\ud558\ub294 \uac83\uc774 \uc88b\uc73c\uba70 \uc124\uc815\ud558\uace0\uc790 \ud558\ub294 DB_NAME\uc5d0 \ub530\ub77c \"tibero\" \uac12\uc744 \uc9c0\uc815\ud55c\ub2e4.\nexport PATH=$TB_HOME\/bin:$TB_HOME\/client\/bin:$JAVA_HOME:$PATH\nexport LD_LIBRARY_PATH=$TB_HOME\/lib:$TB_HOME\/client\/lib:$LD_LIBRARY_PATH\n\n# Frequently used and useful aliases for Tibero\nalias tbcfg='cd $TB_HOME\/config'\nalias tbcli='cd $TB_HOME\/client\/config'\nalias tblog='cd \/logs\/tibero'\nalias tbhome='cd $TB_HOME'\nalias tbcfgv='vi $TB_HOME\/config\/$TB_SID.tip'\nalias tbcliv='vi $TB_HOME\/client\/config\/tbdsn.tbr'\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<h4>\ub514\ub809\ud1a0\ub9ac \uad8c\ud55c \uc124\uc815 (root \uad8c\ud55c \ud544\uc694)<\/h4>\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>JDK \uc124\uce58<\/h3>\n<h4>OpenJDK \uc124\uce58<\/h4>\n<p>Tibero RDBMS \uc11c\ubc84\ub294 java \uc758\uc874\uc131\uc774 \uc5c6\ub2e4. RDBMS \uc11c\ube44\uc2a4\ub9cc \uc81c\uacf5\ud558\ub294 \ud638\uc2a4\ud2b8\uc5d0\ub294 \uad73\uc774 \uc124\uce58\ud558\uc9c0 \uc54a\uc544\ub3c4 \ub41c\ub2e4.<br \/>\ntbexport, tbimport \ub4f1 java\ub97c \uc774\uc6a9\ud558\ub294 client \uc720\ud2f8\ub9ac\ud2f0\ub97c \uc0ac\uc6a9\ud558\uae30 \uc704\ud574\uc11c \uc124\uce58\ud558\ub294 \uac83\uc73c\ub85c \uc120\ud0dd\uc0ac\ud56d\uc774\ub2e4.<\/p>\n<h5>OpenJDK tarball \uc900\ube44<\/h5>\n<p>\uc544\ub798 \ub9c1\ud06c\uc5d0\uc11c \uc124\uce58\ud558\uace0\uc790 \ud558\ub294 \ubc84\uc804\uc758 Java Development Kit \uc124\uce58\ud55c\ub2e4. (jdk-7u80-linux-x64.tar.gz \uae30\uc900\uc73c\ub85c \uc124\uce58 \uc9c4\ud589)<br \/>\n<a href=\"http:\/\/www.oracle.com\/technetwork\/java\/javase\/downloads\/java-archive-downloads-javase7-521261.html\">Java SE 7 Archive Downloads Link<\/a><\/p>\n<h5>JDK \uc124\uce58<\/h5>\n<p>\ub2e4\uc74c \uacbd\ub85c\uc5d0 \ubc14\uc774\ub108\ub9ac\ub97c \uc555\ucd95 \ud574\uc81c\ud558\uace0, symbolic link \ub97c \uc0dd\uc131\ud55c \ub4a4 \uc0ac\uc6a9\ud55c\ub2e4.<\/p>\n<ul>\n<li>\uc124\uce58 \uacbd\ub85c\n<ul>\n<li>\/app\/jdk\/jdk1.7.0_80<\/li>\n<\/ul>\n<\/li>\n<li>Symbolic link \uacbd\ub85c\n<ul>\n<li>\/app\/jdk<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<h6>JDK \ubc14\uc774\ub108\ub9ac \uc555\ucd95 \ud574\uc81c<\/h6>\n<pre><code class=\"bash\">tar -xvzf jdk-7u80-linux-x64.tar.gz\nmv jdk1.7.0_80 \/app\/jdk\/1.7.0_80\n<\/code><\/pre>\n<h6>symbolic link \uc0dd\uc131<\/h6>\n<pre><code class=\"bash\">cd \/app\/jdk\nln -s .\/1.7.0_80\/* .\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.<\/p>\n<h3>Tibero 6 \uc5d4\uc9c4 \uc124\uce58<\/h3>\n<p>\uc544\ub798 \uba85\ub839\uc744 \uc218\ud589\ud558\uba74 <code>\/app\/tibero\/tibero6<\/code> \uacbd\ub85c\uc5d0 tibero \uc5d4\uc9c4\uc774 \uc124\uce58\ub41c\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>technet\uc5d0\ub294 \uc6b4\uc601\uccb4\uc81c \ubcc4\ub85c \uc0ac\uc804 \ube4c\ub4dc\ub41c \ubc14\uc774\ub108\ub9ac \ud30c\uc77c\uc744 \uc81c\uacf5\ud558\uae30 \ub54c\ubb38\uc5d0 \uc555\ucd95 \ud574\uc81c\ub9cc \ud558\uba74 \ud574\ub2f9 \uacbd\ub85c\uc5d0 pre-compiled, executable \ud30c\uc77c\uc774 \uc0dd\uc131\ub41c\ub2e4.<\/p>\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<p>\uc704 \uc2a4\ud06c\ub9bd\ud2b8\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc2e4\ud589\ub41c \uacbd\uc6b0<\/p>\n<pre><code>---\nUsing TB_SID \"tibero\"\n\/app\/tibero\/tibero6\/config\/tibero.tip generated\n\/app\/tibero\/tibero6\/config\/psm_commands generated\n\/app\/tibero\/tibero6\/client\/config\/tbdsn.tbr generated.\nRunning client\/config\/gen_esql_cfg.sh\nDone.\n---\n<\/code><\/pre>\n<p>\uc704\uc640 \uac19\uc774 $TB_SID.tip,tbdsn.tbr,psm_commands \ud30c\uc77c\ub4e4\uc774 \uc0dd\uc131\ub41c\ub2e4.<br \/>\n\ubb38\uc81c\uac00 \ubc1c\uc0dd\ud558\ub294 \uacbd\uc6b0 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \ud504\ub85c\ud30c\uc77c\uc774 \uc801\uc6a9\uc774 \ub418\uc5c8\ub294\uc9c0 Tibero \ubc14\uc774\ub108\ub9ac\uac00 \ud638\uc2a4\ud2b8 \uc11c\ubc84\uc758 \uc6b4\uc601\uccb4\uc81c\uc5d0 \ub9de\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n<h4>tip \ud30c\uc77c \uc124\uc815<\/h4>\n<p><code>vi $TB_HOME\/config\/$TB_SID.tip<\/code> \ud30c\uc77c\uc744 \uc218\uc815\ud558\uc5ec Tibero \uc5d4\uc9c4 \uc124\uc815\uc744 \ub9c8\ubb34\ub9ac\ud55c\ub2e4.<\/p>\n<p>\uc5ec\uae30\uae4c\uc9c0 \ubaa8\ub4e0 \uacfc\uc815\uc744 \uadf8\ub300\ub85c \ub530\ub77c\ud588\ub2e4\uba74 \ub2e4\uc74c\uacfc \uac19\uc774 \uc0dd\uc131\ub418\uc5c8\uc744 \uac83\uc778\ub370<\/p>\n<pre><code class=\"yml\">DB_NAME=tibero\nLISTENER_PORT=8629\nCONTROL_FILES=\"\/app\/tibero\/tibero6\/database\/tibero\/c1.ctl\"\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<\/code><\/pre>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 \uc218\uc815\ud55c\ub2e4.<\/p>\n<pre><code class=\"yml\">DB_NAME=tibero\nLISTENER_PORT=8629\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\nCONTROL_FILES=\"\/data\/tibero\/c1.ctl\",\"\/data\/tibero\/c2.ctl\"\nDB_CREATE_FILE_DEST=\"\/data\/tibero\"\nLOG_DEFAULT_DEST=\"\/logs\/tibero\"\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. comma \ub85c \uad6c\ubd84\ud558\uc5ec \uc5ec\ub7ec \uacbd\ub85c\ub97c \uc9c0\uc815\ud560 \uc218 \uc788\ub2e4. \ubb3c\ub9ac\uc801\uc73c\ub85c \ubd84\ub9ac\ub41c \uacbd\ub85c\uc5d0 \uc774\uc911\ud654\ud558\ub294 \uac83\uc744 \uad8c\uc7a5.<\/p>\n<p><code>DB_CREATE_FILE_DEST<\/code><br \/>\n\ub370\uc774\ud130\ud30c\uc77c \uc0dd\uc131 \uad6c\ubb38\uc5d0\uc11c \uc808\ub300\uacbd\ub85c\ub97c \uae30\uc7ac\ud558\uc9c0 \uc54a\uace0 \ud30c\uc77c \uba85\ub9cc \uae30\uc7ac\ud558\ub294 \uacbd\uc6b0 \ud574\ub2f9 \ub370\uc774\ud130\ud30c\uc77c\uc774 \uc0dd\uc131\ub418\ub294 \uacbd\ub85c\ub97c \uc9c0\uc815\ud55c\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.<\/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<h3>Tibero nomount \uae30\ub3d9 \ubc0f \ub370\uc774\ud130\ubca0\uc774\uc2a4 \uc0dd\uc131<\/h3>\n<p>\ub2e4\uc74c\uacfc \uac19\uc774 <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.<\/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 ('redo01.log','redo02.log') size 32M,\n        group 1 ('redo11.log','redo12.log') size 32M,\n        group 2 ('redo21.log','redo22.log') size 32M\nmaxdatafiles 1024\nmaxlogfiles 100\nmaxlogmembers 8\nnoarchivelog\n  datafile 'system01.dbf' size 128M autoextend on next 32M maxsize 32G\ndefault tablespace USR \n  datafile 'usr01.dbf' size 128M autoextend on next 32M maxsize 32G\ndefault temporary tablespace TEMP\n  tempfile 'temp01.dbf' size 128M autoextend on next 32M maxsize 32G\n  extent management local AUTOALLOCATE\nundo tablespace UNDO\n  datafile 'undo01.dbf' size 128M autoextend on next 32M maxsize 32G\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\/system.sh<\/code> \uc2a4\ud06c\ub9bd\ud2b8\ub97c \uc2e4\ud589\ud574<br \/>\ndefault 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 \uc124\uce58\uac00 \uc815\uc0c1\uc801\uc73c\ub85c \uc644\ub8cc\ub418\uc5c8\ub294\uc9c0 \ud655\uc778\ud55c\ub2e4.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Tibero 6 Single Installation \uc0ac\uc804 \uc900\ube44 \uc758\uc874 \ud328\ud0a4\uc9c0 (root \uad8c\ud55c \ud544\uc694) \ub2e4\uc74c \ud328\ud0a4\uc9c0\ub4e4\uc758 \ud574\ub2f9 \ubc84\uc804 \uc774\uc0c1\uc774 \uc124\uce58\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4. gcc-3.4.6-11 gcc-c++-3.4.6-11 libgcc-3.4.6-11 libstdc++-3.4.6-11 libstdc++-devel-3.4.6-11 compat-libstdc++-33-3.2.3-47.3 libaio-0.3.105-2 libaio-devel-0.3.105-2 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f \ub514\ub809\ud1a0\ub9ac \uc124\uc815 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 \ubc0f sh \ud504\ub85c\ud30c\uc77c \uc124\uc815 \uc2dc\uc2a4\ud15c \uc0ac\uc6a9\uc790 \uc0dd\uc131 (root \uad8c\ud55c \ud544\uc694) \uc120\ud0dd\uc0ac\ud56d\uc73c\ub85c DBA \ub610\ub294 DB \uc0ac\uc6a9\uc790\uac00 \uc6d0\ud558\ub294 \uc2dc\uc2a4\ud15c \uacc4\uc815, \uadf8\ub8f9\uc73c\ub85c [&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,50],"class_list":["post-476","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-tibero","tag-50"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/476","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=476"}],"version-history":[{"count":7,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/476\/revisions"}],"predecessor-version":[{"id":1309,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/476\/revisions\/1309"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=476"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=476"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=476"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}