How to Lock All SM59 RFC Connection via Oracle Command

Share this article :

As part of the SAP system refresh activities, you are required to disable the SM59 RFC connections in case they are pointing to the wrong systems!

The Oracle command below was taken from below link (credit to the original post).

Quick n Dirty Disable all RFC hosts after production system refresh to QA (to stop RFC outbound leaks) // Glenn Cadman

So, log in to the Oracle sqlplus and hit below command,

1. Take a backup of rfcdes table.

SQL> create table sapr3.rfcdes_BACKUP as select * from sapr3.rfcdes;

2. Below command will updating the SM59 hostname.

SQL> update sapr3.rfcdes set rfcoptions=replace(rfcoptions,’H=’,’H=LOCKED.’);

SQL> commit;


If you want to revert the SM59 RFC setting to the original, execute below command,

SQL> update sapr3.rfcdes set rfcoptions=replace(rfcoptions,’H=LOCKED.’,’H=’);

Tags: ,

Related posts

SAP Print Processing
SPAM/SAINT Version Update
MsSLoginClient, not_unique
How to Use SAP EPM Add-in via Firefox Browser
© 2017 ITsiti. All Rights Reserved
Powered by KEEM