Shulou(Shulou.com)06/02 Report--

After you run the shell script, the roll.sql file is generated. Just run roll.sql to release the distributed lock in dba_2pc_pending.

Note: decide whether the where condition is required in the shell script, such as whether the filter status is prepare, other, or all.

-- shell script-#! / bin/bash. / home/oracle/.profilesqlplus-S / as sysdba

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.