I have a weird problem connecting jdbc to oracle database server.
We have applications on the tomcat server. These applications use the oracle database. All applications use the same credentials.
Applications work fine all day. There is no activity at night. In the morning, we get several (2 or 3) ORA-01017 errors (invalid username / password) when applications try to connect to the database.
Then the reconnection is done and the applications will work fine.
This works for several days (about 5 days), and then one or more application blocks! All reconnection attempts fail.
We monitored the network connection and found that if a failure is ORA-01017 NO CREDENTIALSnot possible, the connection will be sent.
Of course, no one touches the system at night.
One attempt at a workaround is that we restart the tomcat server every morning at 6 o’clock to clear every connection cache or pool. It does not help.
What's wrong? Any ideas?
The ongoing 5-day interval in the appearance of a complete block (when repeated every day) looks very strange to me.
Configuration :
Oracle Database 10.2, JDBC Driver 11.2 thin, tomcat 6.0.24, JDK 6, OS are windows, some of which are dialog boxes for Avaya Voice Portal 5.0.
Our own (non-VP) applications use simple connections (no merging).
The system was originally configured on a Windows 2003 server with a WAN between apserver and tomcat.
Linux (CentOS) . ORA-01017.