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.
(PROTOCOL = TCP)
(HOST = DB2Host)
(PORT = 50000)
(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'.
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: