Configure Oracle Net Listener for the gateway (listener.ora)
- Last UpdatedJan 04, 2023
- 1 minute read
- PI System
- PI SQL Client ODBC 2021
- Developer
The Oracle Listener monitors incoming requests from the Oracle database. For the Oracle Listener to monitor DG4ODBC, information about DG4ODBC must be added to the Oracle Listener configuration file: ORACLE_HOME\network\admin\listener.ora. Use the following steps:
-
Create a SID_NAME for DG4ODBC.
-
Specify the executable that the listener should start in response to DG4ODBC connection requests.
Examples
# listener.ora Network Configuration File: C:\WINDOWS.X64_180000_db_home\NETWORK\ADMIN\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = pisqlclient)
(ORACLE_HOME = C:\WINDOWS.X64_180000_db_home)
)
…
Where:
|
Variable |
Description |
|---|---|
|
PROGRAM |
Specifies the executable name of the Oracle Database Gateway for ODBC. |
|
SID_NAME |
The name of the gateway init file without the init prefix or ora extension. In the example, the init file is named initpisqlclient, and so pisqlclient is used as the SID_NAME. |
|
ORACLE_HOME |
Specifies the Oracle home directory where the gateway resides. |