Change the SYS & SYSTEM Oracle passwords with BRTOOLS, any concerns ?

[Former Member]

Hello, I would like to change both the SYS and SYSTEM Oracle passwords with BRTOOLS :

(1) Can I use BRTOOLS to change them, or, I have to change them through SQLPlus ?

(2) Any concerns, will this password change affect my SAP normal operations ?

(3) Do I need to re-start the whole SAP UNIX system when I complete the password changing ?

(4) Or changing these 2 passwords is totally an Oracle RDBMS issue, it will not have any effect on SAP ?

[former_member204746]

Use these one-liner commands:

brconnect -c -u / -p init%ORACLE_SID%.sap-f chpass -o SAPR3 -password Whatever_you_want

brconnect -c -u / -p init%ORACLE_SID%.sap -f chpass -o SYSTEM -password Whatever_you_want

brconnect -c -u / -p init%ORACLE_SID%.sap -f chpass -o SYS -password Whatever_you_want

set this topic as answered when finished.

[volker_borowski2]

Hi,

just to throw in:

there are some special chars, that should not be used in an Oracle-User Password.

Like i.e. "@" which will work, when used in sapinst as an install master PW,

but will give you a real headache, when you need to connect

Volker

[former_member255719]

Hi

Is there any specific procedure to change the sapsr3db password which has special character" @ " in it .if yes please provide the commands

[fidel_vales]

Hello

> (1) Can I use BRTOOLS to change them, or, I have to change them through SQLPlus ?

You can change the passwords for the DB users SYS & SYSTEM with SQLPLUS, o con BRTOOLS. Both are good. The following is a good link to the relevant information in the documentation:

http://help.sap.com/saphelp_nw70/helpdata/en/c6/f1901c7f31f3429028326b7fb7597e/frameset.htm

If you want to change the password for the SAP ABAP DB user then you can ONLY use BRTOOLS

> (2) Any concerns, will this password change affect my SAP normal operations ?

SAP "normal" operations do not use SYS or SYSTEM, no interference if you change the password

> (3) Do I need to re-start the whole SAP UNIX system when I complete the password changing ?

If you only change the two mentioned users, it is not necessary to restart anything.

> (4) Or changing these 2 passwords is totally an Oracle RDBMS issue, it will not have any effect on SAP ?

as "follow up" from point 2, it is a pure Oracle issue, it does not affect SAP

[Former Member]

But I failed. I was going to change the password of SYSTEM, but why SAP asked me to enter the password of SAPDEV ?

Why ? OK, then I entered the SAPDEV password (it is the same as SYSTEM's old password).

Then, I called SQLPlus and entered login name : SYSTEM, but why its correct password was still the old one, the new one failed. Why ?

I just wanted to change the password of SYSTEM, why it was related to SAPDEV ?

Here is the screen message :

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: 2010-01-15 10.22.46

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2010-01-15 10.22.46

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: 2010-01-15 10.23.14

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2010-01-15 10.23.14

BR0657I Input menu 59 - please check/enter input values

-

---

BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initDEV.sap]

2 - Database user/password (user) ............. [/]

3 ~ Database owner to change password (owner) . []

4 - Message language (language) ............... [E]

5 - BRCONNECT command line (command) .......... [-p initDEV.sap -l E -f chpass]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

2

BR0280I BRTOOLS time stamp: 2010-01-15 10.28.56

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2010-01-15 10.28.56

BR0681I Enter string value for "user" [/]:

SYSTEM

BR0280I BRTOOLS time stamp: 2010-01-15 10.29.08

BR0683I New value for "user": 'SYSTEM'

BR0263I Enter password for database user 'SYSTEM' (maximum 8 characters):

BR0280I BRTOOLS time stamp: 2010-01-15 10.29.32

BR0657I Input menu 59 - please check/enter input values

-

---

BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initDEV.sap]

2 - Database user/password (user) ............. [SYSTEM/*******]

3 ~ Database owner to change password (owner) . []

4 - Message language (language) ............... [E]

5 - BRCONNECT command line (command) .......... [-p initDEV.sap -l E -f chpass]

Standard keys: c - cont, b - back, s - stop, r - refr, h - help

-

---

BR0662I Enter your choice:

c

BR0280I BRTOOLS time stamp: 2010-01-15 10.29.41

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

BR0291I BRCONNECT will be started with options '-p initDEV.sap -l E -f chpass'

BR0280I BRTOOLS time stamp: 2010-01-15 10.29.41

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-01-15 10.29.49

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

###############################################################################

BR0801I BRCONNECT 6.40 (39)

BR0280I BRCONNECT time stamp: 2010-01-15 10.29.52

BR0263I Enter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.34.58

BR0263I Reenter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.35.57

BR0482W The passwords entered must be identical

BR0280I BRCONNECT time stamp: 2010-01-15 10.35.57

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2010-01-15 10.36.31

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2010-01-15 10.36.31

BR0263I Enter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.37.03

BR0263I Reenter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.08

BR0482W The passwords entered must be identical

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.08

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.11

BR0256I Enter 'c[ont]' to continue, 's[top]' to cancel BRCONNECT:

c

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.14

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.14

BR0263I Enter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.16

BR0263I Reenter password for database user 'SAPDEV' (maximum 8 characters):

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.18

BR0829I Password changed successfully in database for user SAPDEV

BR0830I Password changed successfully in table OPS$DEVADM.SAPUSER for user SAPDEV

BR0280I BRCONNECT time stamp: 2010-01-15 10.38.18

BR0803I BRCONNECT completed successfully with warnings

###############################################################################

BR0292I Execution of BRCONNECT finished with return code 1

BR0668I Warnings or errors occurred - you can continue to ignore them or go back to repeat the last action

BR0280I BRTOOLS time stamp: 2010-01-15 10.38.18

BR0670I Enter 'c[ont]' to continue, 'b[ack]' to go back, 's[top]' to abort:

c

BR0280I BRTOOLS time stamp: 2010-01-15 10.38.44

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

BR0280I BRTOOLS time stamp: 2010-01-15 10.38.44

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:

[Former Member]

This one is better to read :

.....

1 - BRCONNECT profile (profile) ............... [initDEV.sap]

2 - Database user/password (user) ............. [SYSTEM/*******]

3 ~ Database owner to change password (owner) . []

4 - Message language (language) ............... [E]

5 - BRCONNECT command line (command) .......... [-p initDEV.sap -l E -f chpass]

.....

BR0263I Enter password for database user 'SAPDEV' (maximum 8 characters):

.....

BR0263I Reenter password for database user 'SAPDEV' (maximum 8 characters):

.....

BR0829I Password changed successfully in database for user SAPDEV

BR0830I Password changed successfully in table OPS$DEVADM.SAPUSER for user SAPDEV

.....

BR0803I BRCONNECT completed successfully with warnings

But the new SYSTEM password is same as the password of SAPDEV (since both SAPDEV and SYSTEM were using the same password before, eventually, SYSTEM is still using its old password).

Why changing the password of SYSTEM needed to enter the password of SAPDEV ?

[Former Member]

Check SAP Note :562863

SYS ans SYSTEM can be changed from SQLPLUS level itself as it doesnt need any update in the SAPUSER table

so you can go ahead and use alter user "username" identified by <password"

But remember when you change the password for SYSTEM. By default, sapdba and the BR tools are connected to the database with the SYSTEM user and standard password. If you change this now, you can only start the tools by explicitly specifying the user name and password. To do this, use the option "-u <username>/<password>". Otherwise, calling sapdba, brbackup, brconnect, brarchive and brrestore fails with ORA-01017

Gerard

[Former Member]

I have already read SAP Note : 562863.

My question is : why I just wanted to change the password of SYSTEM and SYS, but SAP asked me to enter the password of SAPDEV, why ?

[fidel_vales]

Hello,

Please, please, please.

READ what BRTOOLS is expecting YOU to enter. This is what you told BRTOOLS:

 1 - BRCONNECT profile (profile) ............... http://initDEV.sap
 2 - Database user/password (user) ............. SYSTEM/*******
 3 ~ Database owner to change password (owner) . [] 
 4 - Message language (language) ............... [E]
 5 - BRCONNECT command line (command) .......... http://-p initDEV.sap -l E -f chpass

YOU did input NOTHING on the point 3, YOU did not tell BRTOOLS what user you want to change the password.

Therefore, as YOU are NOT telling BRCTOOLS what password YOU want to change, BRTOOLS use the default owner, and that is the SAP database user, in your case SAPDEV

[Former Member]

Thanks.

Someone told me that point. Now I know :

Point 2 : I need to specify the user which has sufficient privileges to change a user's password.

Point 3 : I need to specify the user which to be changed with his password.

I already fixed my problem, thanks a lot.

[Former Member]

hi,

you change only system and sapsr3 user's password with brtools for sap connection. but if you backup with sys user, you should change sys' s password with brtools.

ferhan

[Former Member]

hi,

you should use the brtools.

http://help.sap.com/saphelp_nw70/helpdata/EN/da/eea6a71c958b4798102ce174d061ac/frameset.htm

ferhan