(PROTOCOL = TCP)
(HOST = xxxxxxx.xxxx.xx.com)(PORT = 1527)
(CONNECT_DATA = (SID = xxxxxx)
When the SQL Server client attempts to connect to the Oracle database I receive an error message stating that there is "no listener". I believe the problem is that Oracle is listening on port 1527 but the client is calling using port 1521 even though the tnsnames.ora file has port = 1527.
When I use the tnsnames.ora file within my company's network the 1527 port works fine. When I use the tnsnames.ora configuration file from outside my company's network it fails because when the connection traverses the firewall somehow port 1521 is used. My understanding is that port 1521 is the Oracle default/standard.
My question is, what can I do to make the client call the server using port 1527 which is what the server is listening on?