Home » RDBMS Server » Networking and Gateways » Not able to connect to Oracle(12c) to progress using Oracle database gateway(12c) for ODBC (Oracle12c , Oracle database gateway for ODBC 12c , Progress Version 11)
Not able to connect to Oracle(12c) to progress using Oracle database gateway(12c) for ODBC [message #671786] Wed, 19 September 2018 08:55 Go to previous message
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

 
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Connections to this server version are no longer supported
Next Topic: Listener not connecting to database
Goto Forum:
  


Current Time: Sat Dec 07 14:03:40 CST 2019