Answer

Why am I receiving the ORA-12535 error when using a remote database?

An Oracle user asks why they are receiving the error ORA-12535: TNS: operation timed out when using a remote database.

Published: 10 Jul 2008

I have two databases. One local (in domain ad.xyz.com) and a remote database (domain us.oracle.com). I am logging in to these from a client machine and I do not have DBA access.

I am able to TNSPING and connect using SQL*Plus to both of these databases. I have created a private DBlink in...

Step 2 of 2:

You forgot to provide an Email Address.

This email address doesn’t appear to be valid.

This email address is already registered. Please log in.

You have exceeded the maximum character limit.

Please provide a Corporate Email Address.
- I agree to TechTarget’s Terms of Use, Privacy Policy, and the transfer of my information to the United States for processing to provide me with relevant information as described in our Privacy Policy.
Please check the box if you want to proceed.
- I agree to my information being processed by TechTarget and its Partners to contact me via phone, email, or other means regarding information relevant to my professional interests. I may unsubscribe at any time.
Please check the box if you want to proceed.

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)))';

The only thing TNSPING tells you is that the database listener is up and is configured for the SID defined in your tns string. It does not indicate whether or not you can actually connect to the Oracle instance. The most common reason why you are receiving the ORA-12535 error is due to a firewall configuration issue. While the Listener is listening on port 1521, the connection will use a different port. The firewall could be blocking this other port. You may need to work with your network administrators to resolve this issue.

For more solutions to common Oracle errors, check out our Solving common Oracle errors guide.

Next Steps

How to avoid common Oracle TNS pratfalls

How to connect to a pluggable database in Oracle Multitenant

Using Oracle 12c Unified Auditing to set database audit policies

Solve a PL-SQL error that creates dynamic tables

Coca-Cola Bottling swaps out Oracle for DB2