I developed a page that retrieves from Oracle DB data and view it. The
connection is 100% since it works. However, once we deploy using
capistrano to our production servers, we get the following error:
Change this error message for exceptions thrown outside of an action
(like in Dispatcher setups or broken Ruby code) in public/500.html"
And in the server logs we find:
“OCIError (ORA-12154: TNS:could not resolve the connect identifier
Once we restart the 4 mongrels, everything becomes fine again and the DB
works well. The TSNAMES are 100% fine. It is matter that we need to
restart the mongrels which is sucks…
Any help please?