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

One client PC of many won't connect to database

I have already installed Oracle on many client PCs and I didn't encounter any problems. But there is one client PC that is giving me problems. I cannot connect to the database. It is always giving ORA-12560. The tnsnames.ora is correct. I can also ping the server. What are some other possible reasons why I cannot connect to the database?

I have already installed Oracle on many client PCs and I didn't encounter any problems. But there is one client PC that is giving me problems. I cannot connect to the database. It is always giving ORA-12560. The tnsnames.ora is correct. I can also ping the server. What are some other possible reasons why I cannot connect to the database? Can you englighten me on this please?
Basically, the ORA-12560 error is telling you that you have a protocol mismatch. In order for a client to talk to the database on the server, you need to use a networking protocol. A strong majority of the time, this networking protocol will be TCP/IP. The ORA-12560 error is saying that the networking protocol defined in your local TNSNAMES.ORA configuration file does not match the networking protocol defined on your database server's LISTENER.ORA. Use the same protocols on both ends, and the ORA-12560 error will go away.

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