Hi,
I have got this error from database through web logic server
Test "SELECT 1 FROM DUAL" set up for pool "jdbc_contig_prod" failed with exception: "java.sql.SQLException: ORA-02396: exceeded maximum idle time, please connect again".>
and database alert log file is also showing the the same " ORA-02396: exceeded maximum idle time, please connect again "
OS: Red hat enterprise Linux 6.5, 64-bit
DB: Oracle 11.2.0.1
my findings,
SQL> select profile,resource_name,limit from dba_profiles where resource_name='DILE_TIME';
Profile resource_name limit
--------- --------------------- ---------
APPLICATION IDLE_TIME 60
SQL> select profile from dba_users where username= 'CONTIG';
PROFILE
------------------
APPLICATION
But,
According to wls jdbc setting, WLS should not has idle connection more than 900 seconds, which is far lower than database 60 min idle time out setting. Why database will get the exceeded maximum idle time? Is it possible from other source?
<inactive-connection-timeout-seconds>900</inactive-connection-timeout-seconds>
<test-frequency-seconds>120</test-frequency-seconds>
Any suggestions on this? what could be the problem( WLS jdbc setting for idle_time is 900seconds and where as DATABASE profile setting for CONTIG user is 60mins)
Thanks,