-
1. Re: oracle dblink to dba2 Express-C
EdStevens Oct 16, 2019 6:54 PM (in response to 7dedb4d9-53cf-41c7-87c6-b36db56ccaf7)7dedb4d9-53cf-41c7-87c6-b36db56ccaf7 wrote:
Hi everyone.
I have in the first computer, Windows Server 2012 R2 with Oracle 11g, and also I have in the second computer Ubuntu Server 16.04 with DB2 Express-C. I would like to connect oracle 11g database to DB2 Express-C database using DBLINK, however I have in the file "tnsnames.ora" the next sentence.
DB2_HS =
(DESCRIPTION =
(ADDRESS =
(PROTOCOL = TCP)
(HOST = DB2Host)
(PORT = 50000)
)
(CONNECT_DATA =
(SID = DB2_HS)
)
(HS = OK)
)
And when I write in the command prompt "tnsping DB2_HS", it gives me the next error.
TNS-12537: TNS: Connection closed.
Can you help me with this problem? there is a tutorial step by step updated? Thank you in advance.
Why are you specifying PORT=50000? The Oracle listener, in its default configuration, runs on port 1521.
Have you installed the Oracle Transparent Gateway on the Ubuntu server? That is a necessary component. If you have installed it, then on that server, show us the output of 'lsnrctl status'.
And see https://edstevensdba.wordpress.com/2018/09/19/the-oracle-transparent-gateway/
-
2. Re: oracle dblink to dba2 Express-C
EdStevens Oct 16, 2019 6:55 PM (in response to 7dedb4d9-53cf-41c7-87c6-b36db56ccaf7)Also,
BTW, it would be really helpful if you would go to your profile and give yourself a recognizable name. It doesn't have to be your real name, just something that looks like a real name. Who says my name is really Ed Stevens? Maybe I just like a certain TV show (http://www.imdb.com/title/tt0247091/) But at least when people see that on a message they have a recognizable identity. Unlike the system generated name of 'ed0f625b-6857-4956-9b66-da280b7cf3a2', which is no better than posting as "Anonymous".
refer to https://community.oracle.com/thread/3650233 -how to change nickname-
All you ed0f625b-6857-4956-9b66-da280b7cf3a2's look alike . . .
-
3. Re: oracle dblink to dba2 Express-C
L. Fernigrini Oct 16, 2019 6:57 PM (in response to 7dedb4d9-53cf-41c7-87c6-b36db56ccaf7)You need to install and configure Oracle Database Gateway for ODBC.
What you have done is the last step in a series of configuration steps.
This is how the Gateway works:
And here is another example on the steps to follow to configure it:
https://oracle-base.com/articles/misc/heterogeneous-services-generic-connectivity