The problem appears to be that you do not have an appropriate entry in tnsnames for the instance you're trying to connect to. Make sure that the entry you have in tnsnames matches exactly the name you're using when you try to connect. For instance, if you're trying to connect to an instance "test", then the entry in tnsnames must be called "test".
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.