I am supporting a lotus notes web application in LN 6.5.5. It has connectivity to Oracle for retrieving some details and display to end users. Off late, we are getting an error message intermittently and the error is "ORA-1254 TNS Could not resolve service name". Upon checking we found that tnsnames.ora file is present in the server, and tnsping to database server is having no issue.
Have you faced any similar issue in the past? Will you be able to help me out by giving some idea on how we can move forward for troubleshooting.