Pages

Wednesday, January 29, 2020

ORA-01017: invalid username/password; logon denied after SAP system refresh



Pre-requisite:
Below procedure is valid for Oracle 11g because it supports OPS$ mechanism

Procedure :

     1. Select username from dba_users where username like 'OPS%';
     2. Drop user OPS$SAPSERVICEP<OLD_SID> cascade;
     3. Drop user OPS$<OLD_SID>ADM cascade;
     4. Drop user OPS$ORA<OLD_SID> cascade;
     5. Create user OPS$SAPSERVICE<NEW_SID> identified externally;
     6. Create user OPS$ORA<NEW_SID> identified externally;
     7. Create user OPS$<NEW_SID>ADM identified externally;
     8. Grant connect,resource, sapdba to OPS$<NEW_SID>ADM;
     9. Grant connect,resource, sapdba to OPS$ORA<NEW_SID>;
     10. Create table OPS$<NEW_SID>ADM.SAPUSER(USERID VARCHAR(256),PASSWD VARCHAR(256));
     11. Insert into OPS$<SID>ADM.SAPUSER values('SAPSR3','<Password>');


Suggestion:
After reset the SAPSR3 password using above method, use brtools to rest it again, So that
the password will be saved in encrypted form in the table.

No comments:

Post a Comment