steps to Reset user password using BRtools in oracle SAP database:
linux_server>:oraoradb1 26> brtools
BR0651I BRTOOLS 7.20 (22)
BR0280I BRTOOLS time stamp: 2021-08-24 12.38.55
BR0656I Choice menu 1 - please make a selection
-------------------------------------------------------------------------------
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
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
8
BR0280I BRTOOLS time stamp: 2021-08-24 12.38.59
BR0663I Your choice: '8'
BR0280I BRTOOLS time stamp: 2021-08-24 12.38.59
BR0656I Choice menu 2 - please make a selection
-------------------------------------------------------------------------------
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
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
4
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.06
BR0663I Your choice: '4'
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.06
BR0657I Input menu 59 - please enter/check input values
-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user
1 - BRCONNECT profile (profile) ............... [initoradb1.sap]
2 - Database user/password (user) ............. [/]
3 ~ Database owner to change password (owner) . []
4 ~ Log file name (log) ....................... []
5 - Message language (language) ............... [E]
6 - BRCONNECT command line (command) .......... [-p initoradb1.sap -l E -f chpass]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
3
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.23
BR0663I Your choice: '3'
BR0681I Enter string value for "owner" []:
TEST_USER
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.26
BR0683I New value for "owner": 'TEST_USER'
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.26
BR0657I Input menu 59 - please enter/check input values
-------------------------------------------------------------------------------
BRCONNECT options for changing password of database user
1 - BRCONNECT profile (profile) ............... [initoradb1.sap]
2 - Database user/password (user) ............. [/]
3 ~ Database owner to change password (owner) . [TEST_USER]
4 ~ Log file name (log) ....................... []
5 - Message language (language) ............... [E]
6 - BRCONNECT command line (command) .......... [-p initoradb1.sap -l E -f chpass -o TEST_USER]
Standard keys: c - cont, b - back, s - stop, r - refr, h - help
-------------------------------------------------------------------------------
BR0662I Enter your choice:
c
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.30
BR0663I Your choice: 'c'
BR0259I Program execution will be continued...
BR0291I BRCONNECT will be started with options '-p initoradb1.sap -l E -f chpass -o TEST_USER'
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.30
BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:
c
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.36
BR0257I Your reply: 'c'
BR0259I Program execution will be continued...
###############################################################################
BR0801I BRCONNECT 7.20 (22)
BR0280I BRCONNECT time stamp: 2021-08-24 12.39.37
BR1048I Enter new password for database user 'TEST_USER' (max. 30 characters):
BR0280I BRCONNECT time stamp: 2021-08-24 12.39.54
BR1048I Reenter new password for database user 'TEST_USER' (max. 30 characters):
BR0280I BRCONNECT time stamp: 2021-08-24 12.39.58
BR0829I Password changed successfully in database for user TEST_USER
BR0280I BRCONNECT time stamp: 2021-08-24 12.39.58
BR0802I BRCONNECT completed successfully
###############################################################################
BR0292I Execution of BRCONNECT finished with return code 0
BR0280I BRTOOLS time stamp: 2021-08-24 12.39.58
BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRTOOLS:
s
BR0280I BRTOOLS time stamp: 2021-08-24 12.40.06
BR0257I Your reply: 's'
BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:
y
BR0280I BRTOOLS time stamp: 2021-08-24 12.40.09
BR0257I Your reply: 'y'
BR0260E BRTOOLS cancelled by user
BR0280I BRTOOLS time stamp: 2021-08-24 12.40.09
BR0654I BRTOOLS terminated with errors
*************************************************************************************
There wont be Brtools entry for password reset in alert log
**************************************************************************************
No comments:
Post a Comment