You planning to execute the SAP system refresh (SAP on Oracle database) and part of the task is to disable all the RFC connections in transaction code SM59. If the SAP system is configured with multiple RFC connections – that going to be a long journey for you!
So, in order to get this done quickly – You can use below method to disable and enable multiple RFC connections by using Oracle SQL command.
Disable RFCs
update DB-SCHEMA.rfcdes set rfcoptions = replace(rfcoptions, 'H=', 'H=#');
Enable RFCs
update DB-SCHEMA.rfcdes set rfcoptions = replace(rfcoptions, 'H=#', 'H=');
Note
DB-SCHEMA = Database schema (SAPSR3)
