Oracle Weblogic Server (MOSC)

MOSC Banner

Database connection is not getting closed from secondary RAC node and transitioning back to primary

edited Aug 22, 2011 1:08AM in Oracle Weblogic Server (MOSC) 1 commentAnswered
We are configuring datasource with failover configuration talking to two RAC node. Here is URL from connection pool:

jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=node2-vip)(PORT=1521))(ADDRESS=(PROTOCOL=TCP)(HOST=node1-vip)(PORT=1521))(FAILOVER=on)(LOAD_BALANCE=off))(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME= anpdb)))

Intention of above configuration is that weblogic should talk to node2-vip however it should failover to node1-vip if node2-vip goes down. We have observed that weblogic is correctly behaving in this way, i.e. when node2-vip goes down all connection goes to node1-vip.

However, when node2-vip comes back then we don't see that connection which has failedover to node1-vip is coming back to node2-vip. Could someone please help me in understanding desired behavior of weblogic and when can we expect connection back to original node "node2-vip".

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