I have an application which is running locally where I am facing the following error:
ORA-12514: TNS:listener does not currently know of service requested in connect descriptor
Already I have tested the connection using TNSPing which resolved correctly also I have tried SQLPlus to try connecting but it failed with the same error as above. I used following syntax for SQLPlus:
sqlplus username/password@addressname[or host name]
I have already verified following action items:
· TNS Listener on the server is running properly.
· Oracle itself on the server is running properly.
Does anybody have any solution on my problem?