Symptom
You want to change SAPSR3 password using BRTOOLS.
Solution
1. Login to the system operating level. As in this example, the operating system is Linux SuSe. Switch to ORASID user and execute brtools command. Select 8 – Additional functions.
BR*Tools main menu 1 = Instance management 2 - Space management 3 - Segment management 4 - Backup and database copy 5 - Restore and recovery 6 - Check and verification 7 - Database statistics 8 - Additional functions 9 - Exit program
2. Select 4 – Change password of database user.
Additional BR*Tools functions 1 = Show profiles and logs 2 - Clean up DBA logs and tables 3 - Adapt NEXT extents 4 - Change password of database user 5 - Create/change synonyms for DBA tables 6 - Reset program status
3. Choose 2 ~ Database user/password (user). Fill in the user as SAPSR3 and password as per needed. Choose c to continue.
BRCONNECT options for changing password of database user 1 - BRCONNECT profile (profile) ............... [initSID.sap] 2 - Database user/password (user) ............. [SAPSR3/********] 3 ~ Database owner to change password (owner) . [] 4 ~ Log file name (log) ....................... [] 5 - Message language (language) ............... [E] 6 - BRCONNECT command line (command) .......... [-p initSID.sap -l E -f chpass]
4. Type c again to continue.
BR0259I Program execution will be continued... BR0291I BRCONNECT will be started with options '-p initSID.sap -l E -f chpass' BR0280I BRTOOLS time stamp: 2013-04-24 12.10.46 BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
5. BRTOOLS will process the password changes. Once completed, you can test to login using the new password.
Note
You can also execute the BRTOOLS directly by using below command to change the SAPSR3 password.
brconnect -c -l E -f chpass -o SAPSR3 -password NEW-PASSWORD
