Search code examples
oracleweb-servicestnsnamestns

tns not resolving correctly through webservice

I realise there are some similar questions on here already but I couldn't see one that matched my problem so I'm afraid I had to ask a new question.

I have a webservice running on a server, which is throwing a ORA-12154: TNS:could not resolve the connect identifier specified" error. However when I log onto the said server i am able to tnsping the entry successfully, and connect to it via sqlplus, but not through the webservice.

If anyone has any suggestions as to things to look for then I would greatly appreciate it.

Cheers

Solution

  • Some other things to look at include:

    1. If you're using a service name instead of SID, are you specifying the entire service name?
    2. If you're using the ORACLE_SID environmental variable, check the case (mydb vs MYDB)
    3. Check for a sqlnet.log file
    4. If you're using a username/password@SID connect string, you may need to quote your password if it contains special characters (like an @ symbol).