Hi All,
We have a database we need to connect to which contains a DBLink to yet another database. The DBLink itself is fine, and indeed using the OraDirect component we can connect to the database itself.
However, when attempting to access tables over the DBLink we're getting the following error (using the SQL select * from person@xyzlink);
OracleException: ORA-12514: TNS:listener could not resolve SERVICE_NAME given in connect descriptor
(Yes the connection works otherwise). I also tested and received the same error using one of the sample applications.
Any ideas?