I am able to TNSPING and connect using SQL*Plus to both of these databases. I have created a private DBlink in my local DB pointing to the remote DB. However, when I try to refer any object in the remote DB using this DBlink, I get the "ORA-12535: TNS:operation timed out " error. Since I am able to TNSPING and connect to the DBs, the .ora files are correct.
I have referred to all of the articles I could find on the Internet but these did not help in solving the issues. Can you please let me know what I may have missed out?
I have created the DBlink using the following -
CREATE DATABASE LINK TESTDB.US.ORACLE.COM CONNECT TO scott IDENTIFIED
BY tiger USING '(DESCRIPTION =(ADDRESS_LIST = (ADDRESS = (COMMUNITY =
us.oracle.com)(PROTOCOL = TCP)(HOST =ora10g)(PORT =
1521)))(CONNECT_DATA = (SID = TESTDB)))';
For more solutions to common Oracle errors, check out our Solving common Oracle errors guide.
This was first published in July 2008