I restarted both of my listeners without a problem, but when I try tnsping on the Oracle server, here's what I get:
TNS Ping Utility for 32-bit Windows: Version 10.1.0.2.0 - Production on 03-MAY-2
Copyright (c) 1997, 2003, Oracle. All rights reserved.
Used parameter files:
TNS-03505: Failed to resolve name
SQL Server and Oracle are running on the same machine. I don't have an issue with tnsping on any of the other Oracle databases. What I'm trying to figure out is if I have done anything incorrectly on the HS configuration.
If I haven't done anything incorrectly, is the Transparent Gateway an option? And can I download the Transparent Gateway from OTN for development use?