I am trying to query SQL Server from a 10.2.0.4 instance. 64-bit Oracle 10.2.0.4 is installed on Red Hat 4. 32-bit unixODBC and freetds are installed on the box as well. I can use isql to query the SQL Server database, so I assume that means the odbc.ini, odbcinst.ini and freetds.conf are correct.
I have created the init.ora file in the $OH/hs/admin using several examples online. A seperate listener is configured, and a tns entry is in place. I can tnsping the entry. I have created a dblink to use the HS piece. When I try to query I get:
SQL> select * from sys.databases@dhole;
select * from sys.databases@dhole
ERROR at line 1:
ORA-28545: error diagnosed by Net8 when connecting to an agent
Unable to retrieve text of NETWORK/NCR message 65535
ORA-02063: preceding 2 lines from DHOLE
Any suguestions on where to look?