Q
Problem solve Get help with specific problems with your technologies, process and projects.

Problem connecting to a remote database

I'm having a problem connecting to a remote database. I have added the info from a valid tnsnames.ora file used at the server site into my own tnsnames.ora, their firewall has been opened for port 1521 from the IP address of my PC, a tnsping from a command prompt responds with OK (xxx msec) as expected, but all attempts to establish a connection to the database result in: ERROR: ORA-12203: TNS:unable to connect to destination Any clues?

If you have verified that all of your parameters for the TNS entry are correct, then I suspect that the firewall may be your issue. When you contact the listener for a database connection, the server creates a server process for you (typically a dedicated server process). It is only contacting the listener that uses port 1521. Any communications between the client application and the server process occur on a different, random port. This can cause problems with certain firewall systems. To solve this, you can force all application/process communications through the listener's port by adding USE_SHARED_SOCKETS=TRUE in your registry. Then, restart the database server. Metalink has tons more information on Oracle databases and firewalls.

For More Information


This was last published in January 2003

Dig Deeper on Oracle database design and architecture

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close