Monday, August 30, 2021

How to Reset user password using BRtools in oracle SAP database?

 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