MogDB
Ecological Tools

MTK Environment

Migrating different databases requires installation of necessary client software.


Oracle

  1. Visit Oracle Instant Client to choose the corresponding platform.

  2. Choose the corresponding version, such as Version 19.10.0.0.0.
  3. Download theBasic Package (ZIP) package and upload it to the server, and run the following command to decompress it:

    # This package applies to the arm64 platform.
    unzip instantclient-basic-linux.arm64-19.10.0.0.0dbru.zip

    After the package is decompressed, the directory like instantclient_19_10 will be obtained.

  4. Configure environment variables.

    Linux:
    export LD_LIBRARY_PATH=< target directory>/instantclient_19_10:$LD_LIBRARY_PATH
    Mac:
    export DYLD_LIBRARY_PATH=< target directory>/instantclient_19_10$DYLD_LIBRARY_PATH

DB2

  1. Visit DB2 ODBC CLI
  2. Choose the platform version. Download package and upload it to the server, and run the following command to decompress it:

    tar -zxvf linuxx64_odbc_cli.tar.gz -C /db2client
  3. Configure environment variables.

    export DB2HOME=/db2client/clidriver
    export CGO_CFLAGS=-I$DB2HOME/include
    export CGO_LDFLAGS=-L$DB2HOME/lib
    export PATH=$DB2HOME/bin:$PATH
    Linux:
    export LD_LIBRARY_PATH=$DB2HOME/lib:$LD_LIBRARY_PATH
    Mac:
    export DYLD_LIBRARY_PATH=$DB2HOME/lib:$DYLD_LIBRARY_PATH
  4. Test
  5. db2cli --version

If the DB2 ODBC CLI driver is not installed, the following error will occur.

mtk: error while loading shared libraries: libdb2.so.1: cannot open shared object file: No such file or directory
mtk: error while loading shared libraries: libdb2.so.1: cannot open shared object file: No such file or directory

MySQL

No client needs to be installed.


openGauss

No client needs to be installed.