Skip to main content

Search

Welcome to Tibero GTS!

Precautions for Tibero to Oracle dblink

Document Type | Technical Information

Category | Interface/Integration

Applicable Product Version | Tibero 7.2.4.

Document Number | TMITI034

 

Overview

This document describes precautions when using Tibero to Oracle DBLINK.
 

 

Method

Environment Configuration

Configuration

  • Tibero to Oracle DBLINK Local method configuration

 

Gateway Configuration Status

  • No TBGW_HOME environment variable set in the Tibero user's profile

  • No tbgw.cfg file exists in the Tibero-related directory

  • Oracle Client Instance is installed

  • Oracle connection information exists in the tnsnames.ora file

  • Oracle alias information exists in the tbdns.tbr file


Confirmed Issues

DB link log location

  • Gateway log files are created inside the engine, which may be lost during patching or other operations.

  • A separate gateway folder is created inside the engine, and log files are generated within that folder.

total 20
drwxr-xr-x. 2 ps1 psall 211 Nov 27  2024 .
drwxr-xr-x. 3 ps1 psall  17 Nov 27  2024 ..
-rw-r--r--. 1 ps1 psall 275 Nov 27  2024 gw4orcl_2_20241127131748_4879.log
-rw-r--r--. 1 ps1 psall 760 Nov 28  2024 gw4orcl_3_20241127131748_4879.log
-rw-r--r--. 1 ps1 psall 196 Nov 27  2024 gw4orcl_5_20241127131748_4879.log
-rw-r--r--. 1 ps1 psall 392 Nov 27  2024 gw4orcl_6_20241127131748_4879.log
-rw-r--r--. 1 ps1 psall 392 Nov 27  2024 gw4orcl_7_20241127131748_4879.log


Default location : $TB_HOME/client/gateway/oracle/log/backup

 

DB link log location

[ps1@psdblcbp:/sdiske/ps1/tr/sobang/tibero7/client/bin]$ ll gw4*
-rwxr-xr-x. 1 ps1 psall 38325880 Oct 13 15:22 gw4db2_v10*
-rwxr-xr-x. 1 ps1 psall 38325896 Oct 13 15:22 gw4db2_v9*
-rwxr-xr-x. 1 ps1 psall 38476600 Oct 13 15:22 gw4orcl*
[ps1@psdblcbp:/sdiske/ps1/tr/sobang/tibero7/client/bin]$ pwd
/sdiske/ps1/tr/sobang/tibero7/client/bin


#tbdsn.tbr
gw_local=(
(GATEWAY=
(PROGRAM=/sdiske/ps1/tr/sobang/tibero7/client/bin/gw4orcl)
(TARGET=oraclesd)
(TX_MODE=GLOBAL)
)
)


#The gateway binary inside the engine is set to be used directly

 

Unable to apply Gateway related settings

  • Cannot apply gateway-related parameters because the tbgw.cfg file does not exist.

  • If you create the $TB_HOME/client/gateway/oracle/config/tbgw.cfg file, it can be applied.

 

Tibero restart required when setting TBGW_HOME environment variable

  • Tibero must be restarted to apply the TBGW_HOME environment variable.

 

Conclusion

When configuring Tibero to Oracle DBLINK, DBLINK operates normally as long as the Oracle Client is installed and the Oracle alias exists in the tbdsn.tbr file, regardless of the TBGW_HOME environment variable or tbgw.cfg file.

However, in such an environment, related files may be lost during Tibero patching or other operations, and if the history of the environment is unknown, tracing gateway logs may not be easy. Also, it is not possible to apply parameters to improve performance in the Tibero to Oracle DBLINK environment.

Therefore, it is recommended to set the TBGW_HOME environment variable and place gateway-related files and logs outside the engine to configure DBLINK.

 

 

 

Related to