{"id":96,"date":"2017-04-11T15:15:52","date_gmt":"2017-04-11T06:15:52","guid":{"rendered":"https:\/\/dong1lkim.oboki.net\/?p=96"},"modified":"2019-09-01T22:21:58","modified_gmt":"2019-09-01T13:21:58","slug":"db-link","status":"publish","type":"post","link":"https:\/\/oboki.net\/workspace\/data-engineering\/database\/tibero\/db-link\/","title":{"rendered":"[Tibero] Database Link"},"content":{"rendered":"<h1>Tibero Database Link<\/h1>\n<blockquote><p>\n  Database Link\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 object \uc911\uc758 \ud558\ub098\ub85c\uc11c \ub124\ud2b8\uc6cc\ud06c \uc0c1\uc758 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9\n<\/p><\/blockquote>\n<p>Tibero &lt;-&gt; Oracle \uc774\uae30\uc885 RDBMS \uac04\uc758 \uc811\uadfc\uc744 \uc704\ud55c \ub9e4\uac1c\uccb4(Gateway)\uac00 \ud544\uc694<\/p>\n<h2>Tibero to Oracle (Local \ubc29\uc2dd)<\/h2>\n<p>Gateway\ub97c \ubbf8\ub9ac \uae30\ub3d9\ud558\uc9c0 \uc54a\uace0 DB Link \uac00 \ud638\ucd9c\ub420 \ub54c\ub9c8\ub2e4 Gateway\uac00 \uae30\ub3d9\ub418\ub294 \ubc29\uc2dd.<br \/>\nTibero \ud504\ub85c\uc138\uc2a4\uac00 Gateway \uc124\uc815 \uc815\ubcf4\ub97c \uc54c\uace0\uc788\uc5b4\uc57c \ud558\ubbc0\ub85c DB\uac00 \uc774\ubbf8 \uc2e4\ud589\ub418\uace0 \uc788\ub294 \uacbd\uc6b0, \uc7ac\uae30\ub3d9\uc774 \ud544\uc694<\/p>\n<h3>Local \ubc29\uc2dd Tibero to Oracle DB Link \uc0dd\uc131 \uc808\ucc28<\/h3>\n<h4>1. Install Oracle instantclient<\/h4>\n<h4>2. Tibero \uc2dc\uc2a4\ud15c \uacc4\uc815 profile \uc124\uc815<\/h4>\n<p><code>vi ~\/.bash_profile<\/code><\/p>\n<pre><code class=\"bash\"># Tibero Gateway ENV\nexport TBGW_HOME=\/tibero\/gateway\nexport ORACLE_HOME=\/tibero\/instantclient_12_2\nexport ORACLE_SID=diora12c\nexport LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH\nexport PATH=$ORACLE_HOME:$PATH\n<\/code><\/pre>\n<h4>3. tbdsn.tbr \uc124\uc815<\/h4>\n<p><code>vi $TB_HOME\/client\/config\/tbdsn.tbr<\/code><\/p>\n<pre><code class=\"conf\">diora12c=(\n  (GATEWAY=\n  (PROGRAM=\/tibero\/gateway\/gw4orcl)\n  (TARGET=diora12c)\n  (TX_MODE=GLOBAL)\n  )\n)\n<\/code><\/pre>\n<h4>4. gateway \uc704\uce58<\/h4>\n<p><code>cp $TB_HOME\/client\/bin\/gw4orcl_11g $TBGW_HOME\/gw4orcl<\/code><\/p>\n<h4>5. tnsnames.ora \uc124\uc815<\/h4>\n<p><code>vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/code><\/p>\n<pre><code class=\"conf\">diora12c =\n  (DESCRIPTION=\n    (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.244.45)(PORT=1521))\n    (CONNECT_DATA=(SID=diora12c))\n    (HS=OK)\n  )\n<\/code><\/pre>\n<h4>6. DB Link \uc0dd\uc131<\/h4>\n<pre><code class=\"sql\">create database link olink connect to scott identified by 'tiger' using 'diora12c';\n<\/code><\/pre>\n<h2>Tibero to Oracle (Listener \ubc29\uc2dd)<\/h2>\n<p>\ubcc4\ub3c4\uc758 Gateway \ud504\ub85c\uc138\uc2a4\uac00 \uba3c\uc800 \uc2e4\ud589\ub418\uc5b4 \uc788\uc5b4\uc57c \ud55c\ub2e4.<\/p>\n<h3>Listener \ubc29\uc2dd Tibero to Oracle DB Link \uc0dd\uc131 \uc808\ucc28<\/h3>\n<h4>1. Install Oracle instantclient<\/h4>\n<h4>2. Tibero \uc2dc\uc2a4\ud15c \uacc4\uc815 profile \uc124\uc815<\/h4>\n<p><code>vi ~\/.bash_profile<\/code><\/p>\n<pre><code class=\"bash\"># Tibero Gateway ENV\nexport TBGW_HOME=\/tibero\/gateway\nexport ORACLE_HOME=\/tibero\/instantclient_12_2\nexport ORACLE_SID=diora12c\nexport LD_LIBRARY_PATH=$ORACLE_HOME:$LD_LIBRARY_PATH\nexport PATH=$ORACLE_HOME:$PATH\n<\/code><\/pre>\n<h4>tbdsn.tbr \uc124\uc815<\/h4>\n<p><code>vi $TB_HOME\/client\/config\/tbdsn.tbr<\/code><\/p>\n<pre><code class=\"conf\">diora12c_lsnr=(\n  (GATEWAY=\n  (LISTENER=(HOST=localhost)(PORT=9998))\n  (TARGET=diora12c)\n  (TX_MODE=GLOBAL)\n )\n<\/code><\/pre>\n<h4>4. gateway \uc704\uce58<\/h4>\n<p><code>cp $TB_HOME\/client\/bin\/gw4orcl_11g $TBGW_HOME\/gw4orcl<\/code><\/p>\n<h4>5. tbgw.cfg \uc124\uc815<\/h4>\n<pre><code class=\"bash\">mkdir -p $TBGW_HOME\/oracle\nmkdir -p $TBGW_HOME\/oracle\/config\nmkdir -p $TBGW_HOME\/oracle\/log\n<\/code><\/pre>\n<p><code>vi $TBGW_HOME\/oracle\/config\/tbgw.cfg<\/code><\/p>\n<pre><code class=\"conf\">LISTENER_PORT=9998\nLOG_DIR=\/tibero\/gateway\/oracle\/log\nLOG_LVL=2\n<\/code><\/pre>\n<h4>6. tnsnames.ora \uc124\uc815<\/h4>\n<p><code>vi $ORACLE_HOME\/network\/admin\/tnsnames.ora<\/code><\/p>\n<pre><code class=\"conf\">diora12c =\n  (DESCRIPTION=\n    (ADDRESS=(PROTOCOL=tcp)(HOST=192.168.244.45)(PORT=1521))\n    (CONNECT_DATA=(SID=diora12c))\n    (HS=OK)\n  )\n<\/code><\/pre>\n<h4>7. DB Link \uc0dd\uc131<\/h4>\n<pre><code class=\"sql\">create database link olink connect to scott identified by 'tiger' using 'diora12c_lsnr';\n<\/code><\/pre>\n<h2>Oracle to Tibero<\/h2>\n<h3>Install Tibero client<\/h3>\n<h3>tnsnames.ora<\/h3>\n<pre><code class=\"conf\">tibero =\n  (DESCRIPTION=\n    (ADDRESS=(PROTOCOL=tcp)(HOST=didb.localdomain)(PORT=8686))\n    (CONNECT_DATA=(SID=tibero))\n    (HS=OK)\n  )\n<\/code><\/pre>\n<h3>listener.ora<\/h3>\n<pre><code class=\"conf\">tibero =\n(DESCRIPTION=\n (ADDRESS = (PROTOCOL = TCP)\n  (HOST = didb.localdomain)\n  (PORT = 8686)\n )\n)\n\nSID_LIST_tibero=\n(SID_LIST =\n (SID_DESC =\n  (SID_NAME = tibero)\n  (ORACLE_HOME = \/oracle\/product\/12.2.0.1\/diora)\n  (PROGRAM = dg4odbc)\n )\n)\n<\/code><\/pre>\n<h3>inittibero.ora<\/h3>\n<pre><code class=\"yml\"># This is a sample agent init file that contains the HS parameters that are\n# needed for the Database Gateway for ODBC\n#\n# HS init parameters\n#\nHS_FDS_CONNECT_INFO = tibero\nHS_FDS_TRACE_LEVEL = OFF\nHS_FDS_SHAREABLE_NAME = \/oracle\/tibero6\/client\/lib\/libtbodbc.so\n#\n# ODBC specific environment variables\n#\n#set ODBCINI=&lt;full path name of the odbc initilization file&gt;\n#\n# Environment variables required for the non-Oracle system\n#\nHS_NLS_NCHAR=UCS2\nset TBCLI_WCHAR_TYPE=ucs2\n<\/code><\/pre>\n<h3>tbdsn.tbr<\/h3>\n<pre><code class=\"conf\">#-------------------------------------------------\n# \/oracle\/tibero6\/client\/config\/tbdsn.tbr\n# Network Configuration File.\n# Generated by gen_tip.sh at Mon Apr 10 17:08:28 KST 2017\ntibero=(\n    (INSTANCE=(HOST=$TIBERO_HOST)\n              (PORT=8629)\n              (DB_NAME=tibero)\n    )\n    )\nTBCLI_LOG_LVL=TRACE\nTBCLI_LOG_DIR=\/oracle\/tibero6\/client\/log\n<\/code><\/pre>\n","protected":false},"excerpt":{"rendered":"<p>Tibero Database Link Database Link\ub294 \ub370\uc774\ud130\ubca0\uc774\uc2a4 \ub0b4\uc758 object \uc911\uc758 \ud558\ub098\ub85c\uc11c \ub124\ud2b8\uc6cc\ud06c \uc0c1\uc758 \ub2e4\ub978 \ub370\uc774\ud130\ubca0\uc774\uc2a4\uc5d0 \uc811\uadfc\ud558\uae30 \uc704\ud574 \uc0ac\uc6a9 Tibero &lt;-&gt; Oracle \uc774\uae30\uc885 RDBMS \uac04\uc758 \uc811\uadfc\uc744 \uc704\ud55c \ub9e4\uac1c\uccb4(Gateway)\uac00 \ud544\uc694 Tibero to Oracle (Local \ubc29\uc2dd) Gateway\ub97c \ubbf8\ub9ac \uae30\ub3d9\ud558\uc9c0 \uc54a\uace0 DB Link \uac00 \ud638\ucd9c\ub420 \ub54c\ub9c8\ub2e4 Gateway\uac00 \uae30\ub3d9\ub418\ub294 \ubc29\uc2dd. Tibero \ud504\ub85c\uc138\uc2a4\uac00 Gateway \uc124\uc815 \uc815\ubcf4\ub97c \uc54c\uace0\uc788\uc5b4\uc57c \ud558\ubbc0\ub85c DB\uac00 \uc774\ubbf8 \uc2e4\ud589\ub418\uace0 \uc788\ub294 [&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":[89,23],"class_list":["post-96","post","type-post","status-publish","format-standard","hentry","category-tibero","tag-database","tag-tibero"],"_links":{"self":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/96","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=96"}],"version-history":[{"count":7,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/96\/revisions"}],"predecessor-version":[{"id":1313,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/posts\/96\/revisions\/1313"}],"wp:attachment":[{"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/media?parent=96"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/categories?post=96"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/oboki.net\/workspace\/wp-json\/wp\/v2\/tags?post=96"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}