Techo Tip: Quick Securestore fix, System Migration “QA Refresh”
Quick Secstore fix at DB level: After copying/migrating a system transports and RFC’s dont work until fix the Secstore using transaction /nsecstore and delete entry’s /HMAC_INDEP/RFC_EXTERNAL and RFC_INTERNAL. However on 4.6 and 4.7 kernel 6.20 and 6.40 systems this may not work.
For a more detailed explanation see note 1532825
There is a quicker way, albeit not supported by SAP.
Before startsap, after DB copy and rename:
A quicky is to use sqlplus or sql to do it direct delete:
In the text below owner is assumed to be sapr3 but on your system it could be sapsr3
sqlplus / as sysdba
SQL> select * from sapr3.rsectab
SQL> create table sapr3.rsectab_bck as select * from sapr3.rsectab;
SQL> delete from sapsr3.rsectab
Here is the screen shot of the problem that is resolved using the /nsecstore delete method the above direct delete resolves