I am able to TNSPING and connect using SQL*Plus to both of these databases. I have created a private DBlink in...
By submitting your personal information, you agree that TechTarget and its partners may contact you regarding relevant content, products and special offers.
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.
How to avoid common Oracle TNS pratfalls
Dig Deeper on Oracle database administration
Have a question for an expert?
Please add a title for your question
Get answers from a TechTarget expert on whatever's puzzling you.