WLS 11G multi connection pool fails to recover hours after DB ERROR = ORA-00257 is fixed
Hello,
This is happening with WLS 11G (10.2) and Oracle RACK 10.2.0.4.
Hours after DB ERROR = ORA-00257 is fixed and cleared in the database side,
the multiple connection pool failed to recover and is still keeping the old bad connection.
That application keeps throwing database connection exceptions.
Steps to Reproduce the issue:
(1) Both WLS servers have exact DB configuration, using multi connection pool to oracle RACK system
(2) The archive log disk space is full, the database failed to write archive log;
WLS 11G detected the issue.
(3) DBA cleared the logs space;
(4) one of the connection pool in WLS 11G server failed to recover even hours after the db fixed while other recovered ok.
0