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;

Important

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

Delete Spool Request in SP01
SARFC: Application Server RFC Resources
SAP Logon: A script is trying to attach to the GUI
SAProuter: SNC processing failed: SncSetMyNameU
© 2017 ITsiti. All Rights Reserved
Powered by KEEM