By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
I have created a database link from one database to another (for example, DB link from A to B and then from B to A). This is in Oracle 8i. I am able to access data from A to B. But when I try from B to A, I am getting the error "ORA-12505: TNS Could not resolve SID given in connect descriptor." I have checked the tnsnames.ora in the system and entries seem to be correct.
The ORA-12505 error simply means that the ORACLE_SID in your TNS alias does not match any ORACLE_SID defined for the database listener. You'll have to make sure your TNS alias SID matches the one defined in the listener's LISTENER.ORA configuration file.