Oracle 12C RAC DB throwing ORA-02396 error while connecting using DB link

I do have an java program(war) deployed in weblogic and use Weblogic DB conn pool to connect DB from weblogic. In wls conn Pool and DB link in Data Base using scan ip of the target DB. PFB my infra set up. [1]: https://i.stack.imgur.com/qHvAg.png wls: 12.1.3.0.0_wls DB: Oracle 12C RAC

my requirement was to update an record in DB cross data centre. So I am calling store proc of DB1 from Wls1 and then inside proc I have written

EXECUTE IMMEDIATE update table1 set colm1='Inactive' where colm2=''; commit

EXECUTE IMMEDIATE update table1@DB_LINK_TO_Data_Center2 set colm1='Inactive' where colm2=''; //do some stuff commit;

Same set up is done in DC2 as well with proc as

EXECUTE IMMEDIATE update table1 set colm1='Inactive' where colm2=''; commit

EXECUTE IMMEDIATE update table1@DB_LINK_TO_Data_Center1 set colm1='Inactive' where colm2=''; //do some stuff commit;

Now intermittently I am getting ORA-02396 error while updating cross DC. ideal timeout set at DB side is 30 min but I am getting this in few seconds itself.

https://stackoverflow.com/questions/66740591/oracle-12c-rac-db-throwing-ora-02396-error-while-connecting-using-db-link March 22, 2021 at 01:05PM