Can anybody tell me the query I can run through sqlplus in order to do
the workaround described below.

Thanks


The workaround for that is go and open enterprise manager and connect to each db and double click apply name under Streams and under parameter tab change value "DISABLE_ON_ERROR" from Y to N.