oracle dblink to dba2 Express-C

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/

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 . . .

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