Overview

Method

1. Oracle 11g Gateway 

1.1 Oracle Gateway (GW), Xming Download

You can build client applications on local or remote Oracle Databases easily and for free. 

To connect to a remote Oracle server, download and install from the site below. Please download from the location below.

http://www.oracle.com/technetwork/database/enterprise-edition/downloads/index.html

 ※ The path may change due to site renewal. 

※ This manual is based on LINUX OS (64bit).

Check the version of the Oracle server and download the ‘GW’ of the same version. 

However, access to a remote server via 11g GW from 10g is allowed. 

This document aims for the following configuration.

To install ‘Oracle GW’, download and install the utilities below.

‘Xming’ is a utility that helps install programs with a GUI in OS environments like Linux.

Download Xming X Server for Windows

If you check the folder where ‘Xming’ is installed, you will find ‘Xlaunch’. This is the setting for the remote server’s ‘Display’.

※ Select ‘Multiple windows’. It displays each running program in a separate window.

※ This task is not performed by Tibero engineers.

Specify which program to run. (Since only the GUI is run, do not specify anything)

※ This task is not performed by Tibero engineers.

Leave the default and click Next. (Since only the GUI is run, do not specify anything)

※ This task is not performed by Tibero engineers.

2. Oracle Gateway Installation Using Xming

2.1 Conditions for Running Xming

‘Xming’ shows the GUI (Graphical User Interface) of the remote server on the host OS through the host OS’s ssh port. At this time, you must access as root and execute the ‘xhost +’ command. Since the permission to run Xhost on the server belongs to root (superuser), after running ‘xhost +’ as root, move to the account that needs installation. Below is the procedure to access the server for installing Oracle GW via Xming.

Click SSH - X11 and set as below.

※ Enter the IP of the host PC (the PC where the GUI runs) in the Xdisplay location. (ex: 10.10.10.1:0)

2.2 Oracle GW Installation

After completing the above procedure, access the server as root and execute the following commands.

login as: root
root@192.168.41.143's password:
Last login: Mon Sep  4 13:51:44 2017 from 192.168.41.41
[root@hostname~]# xhost +
access control disabled, clients can connect from any host
[root@hostname~]#
[root@hostname~]# su - oracle
[tibero7@hostname:/home/oracle]$

※ In some cases, running xhost may require additional OS packages.

Enter the following in the profile of the oracle account.

[oracle@hostname:/home/oracle/gateways]$ sh runInstaller
## Oracle to Tibero env
export ORACLE ORACLE_HOME=/app/oracle
export ORACLE_SID=orcl
export PATH=$PATH:$ORACLE_HOME/bin:$PATH
export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$LD_LIBRARY_PATH
export DISPLAY="192.168.41.41:0.0"
export TNS_ADMIN=$ORACLE_HOME/network/admin

Create the oracle account and run runInstaller to install Oracle GW.

[oracle@hostname:/home/oracle/gateways]$ sh runInstaller
※ If the screen is garbled, run export LANG=C.

Select the API that can connect to the desired heterogeneous DB. (Here, ODBC Type is selected for Tibero)

When the installation is complete, a message appears to run the following shell scripts. (Path varies depending on the installation home)

1./home/oracle/oraInventory/orainstRoot.sh

2./app/oracle/root.sh

※ You can run them as root.

2.3 Listener Environment Configuration Check

$ORACLE_HOME/network/admin/listener.ora information. This document guides only the content below for integration between Tibero DB and Oracle.

LTIBERO =
        (ADDRESS_LIST =
        (ADDRESS = (PROTOCOL = TCP)(HOST = IP of the server where the listener will run)(PORT = 1522))
        )

SID_LIST_LTIBERO=
        (SID_LIST=
        (SID_DESC=
                (SID_NAME=tibero) ## Same info as ODBC init$TB_SID.ora
                (ORACLE_HOME=/app/oracle) ## Oracle Home
                (PROGRAM=dg4odbc) ## ODBC driver name
        )
)

2.4 Listener Startup and Check

Start the listener according to the settings in $ORACLE_HOME/network/admin/listener.ora in section 2.3.

[oracle@hostname:/app/oracle/network/admin]$ lsnrctl start LTIBERO

LSNRCTL for Linux: Version 11.2.0.1.0 - Production on 04-SEP-2017 15:03:31

Copyright (c) 1991, 2009, Oracle.  All rights reserved.

Starting /app/oracle/bin/tnslsnr: please wait...

TNSLSNR for Linux: Version 11.2.0.1.0 - Production
System parameter file is /app/oracle/network/admin/listener.ora
Log messages written to /app/oracle/log/diag/tnslsnr/hostname/ltibero/alert/log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.41.142)(PORT=1522)))

Connecting to (ADDRESS=(PROTOCOL=TCP)(HOST=192.168.41.142)(PORT=1522))
STATUS of the LISTENER
------------------------
Alias                     LTIBERO
Version                   TNSLSNR for Linux: Version 11.2.0.1.0 - Production
Start Date                04-SEP-2017 15:03:31
Uptime                    0 days 0 hr. 0 min. 0 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFF
Listener Parameter File   /app/oracle/network/admin/listener.ora
Listener Log File         /app/oracle/log/diag/tnslsnr/hostname/ltibero/alert/log.xml
Listening Endpoints Summary...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.41.142)(PORT=1522)))
Services Summary...
Service "tibero" has 1 instance(s).
  Instance "tibero", status UNKNOWN, has 1 handler(s) for this service...
The command completed successfully
[oracle@hostname:/app/oracle/network/admin]$

※ You can confirm that it started normally.