Not able to connect to Oracle(12c) to progress using Oracle database gateway(12c) for ODBC [message #671786] |
Wed, 19 September 2018 08:55 |
|
saterp
Messages: 4 Registered: September 2018
|
Junior Member |
|
|
Need help to connect the Oracle and Progress Database using Oracle gateway for ODBC.
Server1: I configured the database server TNS.ora and listner.ora entries like below.
Listener.ora:
--start of listener file---
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = E:\app1\SM00444837\product\12.1.0\dbhome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:E:\app1\SM00444837\product\12.1.0\dbhome_1\bin
\oraclr12.dll")
)
(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = GW_TO_PROG)
(ORACLE_HOME = E:\app1\SM00444837\product\12.1.0\dbhome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1host)(PORT = 1521))
)
)
ADR_BASE_LISTENER = E:\app1\SM00444837\product\12.1.0\dbhome_1\log
---end of listener file--------
tnsnames.ora:
--start of tns file---
# tnsnames.ora Network Configuration File: E:\app1\SM00444837\product
\12.1.0\dbhome_1\network\admin\tnsnames.ora
# Generated by Oracle configuration tools.
ORACLR_CONNECTION_DATA =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = IPC)(KEY = EXTPROC1521))
)
(CONNECT_DATA =
(SID = CLRExtProc)
(PRESENTATION = RO)
)
)
#This is the oracle database in local system
TEST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1host)(PORT = 1521))
(CONNECT_DATA =
(SERVER = DEDICATED)
(SERVICE_NAME = TEST)
)
)
#This is the target system DSN name where this DSN connects to Progress db in target system
GW_TO_PROG =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST= server2host)(PORT=1522))
(CONNECT_DATA= (SID=GW_TO_PROG))
(HS=OK)
)
--------End of tns file-------------
initGW_TO_PROG.ora:
--start of initGW_TO_PROG.ora file--
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
# HS init parameters
#"GW_TO_PROG" is target system DSN which connects to progress in target system
HS_FDS_CONNECT_INFO = "GW_TO_PROG"
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
-----end of initGW_TO_PROG.ora file--
Server2: I have configured the Oracle database gateway for ODBC and DSN entry to connect to
the progress DB, Progress db is also installed in the server2.
Listener.ora:
---Start of listener.ora file------
# listener.ora Network Configuration File: D:\app1\tg\HM00495608\product
\12.1.0\tghome_1\network\admin\listener.ora
# Generated by Oracle configuration tools.
SID_LIST_LISTENER =
(SID_LIST =
(SID_DESC =
(SID_NAME = CLRExtProc)
(ORACLE_HOME = D:\app1\tg\HM00495608\product\12.1.0\tghome_1)
(PROGRAM = extproc)
(ENVS = "EXTPROC_DLLS=ONLY:D:\app1\tg\HM00495608\product\12.1.0\tghome_1\bin
\oraclr12.dll")
)
(SID_DESC =
(PROGRAM = dg4odbc)
(SID_NAME = GW_TO_PROG)
(ORACLE_HOME = D:\app1\tg\HM00495608\product\12.1.0\tghome_1)
)
)
LISTENER =
(DESCRIPTION_LIST =
(DESCRIPTION =
(ADDRESS = (PROTOCOL = TCP)(HOST = Server2host)(PORT = 1522))
)
)
-----end of listener.ora file----
tnames.ora:
# tnsnames.ora Network Configuration File: D:\app1\tg\HM00495608\product
\12.1.0\tghome_1\NETWORK\ADMIN\tnsnames.ora
# Generated by Oracle configuration tools.
#TEST is the oracle database SID hosted in server1
TEST =
(DESCRIPTION =
(ADDRESS_LIST =
(ADDRESS = (PROTOCOL = TCP)(HOST = server1host)(PORT = 1521))
)
(CONNECT_DATA =
(SERVICE_NAME = TEST)
)
)
GW_TO_PROG =
(DESCRIPTION=
(ADDRESS=(PROTOCOL=TCP)(HOST=server2host)(PORT=1522))
(CONNECT_DATA= (SID=GW_TO_PROG))
(HS=OK)
)
---end of tnames.ora file for gateway----
---Start of InitGW_TO_PROG.ORA file in server2---
# This is a sample agent init file that contains the HS parameters that are
# needed for the Database Gateway for ODBC
#
# HS init parameters
#
HS_FDS_CONNECT_INFO = "GW_TO_PROG"
HS_FDS_TRACE_LEVEL = off
#
# Environment variables required for the non-Oracle system
#
#set <envvar>=<value>
--End of initGW_TO_PROG.ora---
I configured the oracle gateway in the target system where the Progress db is installed and
trying to connect the gateway and oracle(installed in local system)
.
I am trying to build the communication between the oracle(server1)=> Oracle gateway
(server2)=>progress DB(server2) but unable to establish the connection.
getting below error while trying to access to progress table from oracle server .
"ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from SP2 "
SP2 is a DB link pointing to GW_TO_PROG service name.
I would like to know the what changes i need to do in each of the home(oracle and gateway)
with respect to tnsname.ora , listener.ora and initdg4odbc.ora files in each.
Please review and suggest me the changes requried in these files.
do i need to add any library files to initGW_TO_PROG.ora file in both server1(Oracle server)
and server2(gateway file) like below, if so , any idea where do i find this in windows
system(both server1 and server2 are windows systems).
HS_FDS_SHAREABLE_NAME = /usr/local/lib/libodbc.so
I would be grateful for your help.
Regards,
Sathish
|
|
|