2017-04-27 14:45:06.170+10 00001049 00001049 1 info log Starting 1 connection(s) on pool 'default <%myInstance%>' (Oracle, server='<%myTnsName%>', login='<%myLogin%>') 2017-04-27 14:45:06.261+10 00001049 00001049 1 error log ORA-210000 Oracle error: ORA-12518: TNS:listener could not hand off client connection (iRc=-2006) 2017-04-27 14:45:06.261+10 00001049 00001049 1 error log WDB-200000 Unable to connect to database '<%myTnsName%>' of type 'Oracle' with login '<%myLogin%>' (iRc=-2006) 2017-04-27 14:46:00.259+10 00001049 00001049 1 info log Stopping Web server (pid=4169, tid=4169)...
We faced exact same issue with Adobe campaign Classic too with build 8795.. Restart of oracle Listener caused the problem to go away and campaign started working. However this is not really acceptable that i will have to restart and do not know the reason behind it, why listner hang. if you find out root cause , request to please post.
We have only one app server and i can understand that as sessions were going to only one instance , that got hung and our app went down. How about you all ? Do you also have only one server or you have multiple adobe campaign server and still face the same issue ?
All indications point to this error originating from the database. As I mentioned before we have seen this a couple times however in those instances the client's database administrators corrected the problem. Unfortunately Support cannot speak on exactly how to troubleshoot your database as it is outside of the application and is not something we have any knowledge on.