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