Oracle Weblogic Server (MOSC)

MOSC Banner

WLS 11G multi connection pool fails to recover hours after DB ERROR = ORA-00257 is fixed

edited Mar 11, 2011 5:42AM in Oracle Weblogic Server (MOSC) 3 commentsAnswered
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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center