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.
Meet all of our Oracle Database / Applications experts
View all Oracle Database / Applications questions and answers
Start the conversation
0 comments