Overview

This describes the method to prepare the connection environment necessary for integration between Oracle Database and Tibero by installing Oracle 11g Gateway and configuring the Listener.

Method

1. Oracle 11g Gateway

1.1 Oracle Gateway (GW) Download

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

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

Download from the following location.

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

※ The path may change due to site renewal. 

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

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

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

This document aims for the following configuration.

For ‘Oracle GW’ installation, the GW files are received from the Oracle website split into two files.

The installation location is as follows, and the two files were decompressed at the location (D:\oragw).

※ $ORACLE_HOME is set to D:\oragw.

1.2 Oracle Gateway (GW) Installation

Run ‘setup.exe’.. Follow the steps below.

※ Select ‘Next (N)’ without entering an email address.

※ To only start Oracle Listener, select ‘Install database software only (I)’.

Set the language pack. (‘English, Korean’)

※ Select ‘Enterprise Edition (3.340GB)’.

※ This task is not performed by Tibero engineers.

Set $Oracle Base(0) to D:\oragw and Software Location (S) to D:\oragw\oracle.

※ Oracle Base: The base directory where Oracle Software will be installed

※ Oracle Home: The base directory where Oracle will run

※ This task is not performed by Tibero engineers.

※ If the message below is confirmed, the installation was successful.

‘The database configuration files were installed in D:\oragw, and other components selected during installation were installed in D:\oragw\oracle. Please be careful not to accidentally delete these configuration files.

2. Oracle Listener Startup

2.1 Apply Environment Files and Confirm Startup

If installed as above, tnsnames.ora and listener.ora files do not exist. Create them as follows.

listener.ora file

LTIBERO =
    (DESCRIPTION_LIST =
      (DESCRIPTION =
         (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.140)(PORT = 1522))
       )
     )

SID_LIST_LTIBERO =
              (SID_LIST =
                (SID_DESC =
                  (SID_NAME=tibero)
                  (ORACLE_HOME = D:\oragw/oracle)            
                  (PROGRAM = dg4odbc)
                )
              )

※ HOST = IP of the server where the listener will start

tnsnames.ora file

tibero =
  (DESCRIPTION =
    (ADDRESS = (PROTOCOL = TCP)(HOST = 192.168.41.142)(PORT = 1522))
    (CONNECT_DATA = (SID = tibero)
    )
    (HS=OK)
  )

※ This is a test configuration. 
For DBLINK configuration according to this document, the tnsnames.ora setting must be configured on the Oracle server.
 

Listener start: lsnrctl start LTIBERO (Stop: lsnrctl stop LTIBERO)

C:\Users\tmax>lsnrctl start LTIBERO

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-Sep-2017 16:41:32

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

Starting tnslsnr: please wait...

TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
System parameter file is D:\oragw\oracle\network\admin\listener.ora
Logged messages to d:\oragw\diag\tnslsnr\tmax-PC\ltibero\alert\log.xml
Listening on: (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.41.140)(PORT=1522)))


Connected to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.41.140)(PORT=1522)))
Listener Log
------------------------
Alias                     LTIBERO
Version                   TNSLSNR for 64-bit Windows: Version 11.2.0.1.0 - Production
Start Date                04-Sep-2017 16:41:35
Uptime                    0 days 0 hr. 0 min. 3 sec
Trace Level               off
Security                  ON: Local OS Authentication
SNMP                      OFFListener parameter file  D:\oragw\oracle\network\admin\listener.ora
Listener log file         d:\oragw\diag\tnslsnr\tmax-PC\ltibero\alert\log.xml
Endpoint Summary Listening...
  (DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=192.168.41.140)(PORT=1522)))
Service Summary...
The "tibero" service has 1 instance.
  The "tibero" instance (UNKNOWN status) has 1 handler for this service.
The command completed successfully

C:\Users\tmax>lsnrctl stop LTIBERO

LSNRCTL for 64-bit Windows: Version 11.2.0.1.0 - Production on 04-Sep-2017 16:43:27

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

Connected to (DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=192.168.41.140)(PORT=1522)))
The command completed successfully

※ This task should be requested from Oracle and is not performed by Tibero engineers.