Getting Error : ORA-28545: error diagnosed by Net8 when connecting to an agent Unable to retrieve te
We have a working Sql linked server and Oracle database link to sql server no problem there. We are adding snowflake into the picture. On the Windows server we have an ODBC data source connected to snowflake and it works. We created a Sql linked server and it works. We create an oracle database link just the same as above and get an error when I test it
Link : "SNOWFLAKE.xxxxx.ORG"
Error : 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 SNOWFLAKE
Oracle version is 19.3.0.0.0 and running on aix version 7.3