cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Change System & Sys Passwords using Brtools

Former Member

on ‎12-19-2011 9:54 AM

0 Kudos

Hi

whenever I try to change the system and sys passwords using brtools instead of getting a message confirming the change in the password I get prombted to change another SAP id which is not what I want to do

I inly want to change the sys and system passwords , how can I do it

BR0280I BRTOOLS time stamp: 2011-12-19 12.17.54

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: 2011-12-19 12.17.58

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2011-12-19 12.17.58

BR0657I Input menu 59 - please check/enter input values

-

BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initB70.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 initB70.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: 2011-12-19 12.18.05

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.05

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

c

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.08

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0801I BRCONNECT 7.00 (24)

BR0280I BRCONNECT time stamp: 2011-12-19 12.18.09

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

BR0280I BRCONNECT time stamp: 2011-12-19 12.18.30

BR0261E BRCONNECT cancelled by signal 2

BR0280I BRCONNECT time stamp: 2011-12-19 12.18.30

BR0804I BRCONNECT terminated with errors

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

BR0292I Execution of BRCONNECT finished with return code 133

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

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.30

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

s

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.35

BR0257I Your reply: 's'

BR0679I Do you really want to cancel BRTOOLS? Enter y[es]/n[o]:

y

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.36

BR0257I Your reply: 'y'

BR0260E BRTOOLS cancelled by user

BR0280I BRTOOLS time stamp: 2011-12-19 12.18.36

BR0654I BRTOOLS terminated with errors

aduxbi02:orab70 5> exit

aduxbi02:orab70 6> logout

$ brconnect

rsh: brconnect: not found.

$ clear

$ brtools

rsh: brtools: not found.

$ uname -a

HP-UX aduxbi02 B.11.31 U ia64 3298220317 unlimited-user license

$ whoami

bho00744

$ bdf

Filesystem kbytes used avail %used Mounted on

/dev/vg00/lvol3 5144576 391304 4716152 8% /

/dev/vg00/lvol1 5144576 613288 4495928 12% /stand

/dev/vg00/lvol8 15892480 14010800 1868584 88% /var

/dev/vg00/lvol7 10256384 3135072 7065704 31% /usr

/dev/vg00/usrsap 1638400 19381 1517834 1% /usr/sap

/dev/vg00/lvol6 10256384 4836384 5377760 47% /tmp

/dev/vg00/oracle 2064384 225221 1724269 12% /oracle

/dev/vg00/stage 10256384 1751828 7973058 18% /oracle/stage

/dev/vg00/lvol5 15368192 5665016 9627376 37% /opt

/dev/vg00/lvol4 1048576 27984 1012680 3% /home

/dev/vg03/B70ora 2457600 1191298 1187233 50% /oracle/B70

/dev/vg03/B70DbHom 6144000 5064471 1012252 83% /oracle/B70/102_64

/dev/vg03/B70mirrA 212992 104180 102018 51% /oracle/B70/mirrlogA

/dev/vg03/B70mirrB 212992 104180 102018 51% /oracle/B70/mirrlogB

/dev/vg03/B70origA 212992 117124 89883 57% /oracle/B70/origlogA

/dev/vg03/B70origB 212992 117124 89883 57% /oracle/B70/origlogB

/dev/vg03/B70arch 2048000 17654 1903521 1% /oracle/B70/oraarch

/dev/vg03/B70data1 45252608 36782518 7940774 82% /oracle/B70/sapdata1

/dev/vg03/B70data2 24576000 21650098 2743037 89% /oracle/B70/sapdata2

/dev/vg03/B70data3 24576000 21179058 3184637 87% /oracle/B70/sapdata3

/dev/vg03/B70data4 36864000 31196806 5312998 85% /oracle/B70/sapdata4

/dev/vg03/B70reorg 16384000 244343 15130935 2% /oracle/B70/sapreorg

/dev/vg03/B70mnt 3072000 1734323 1254659 58% /sapmnt/B70

/dev/vg03/dump 2048000 17587 1903520 1% /tmp/B70/dump

/dev/vg03/B70usap 8192000 6864178 1244843 85% /usr/sap/B70

/dev/vg04/B71ora 2457600 390328 1939141 17% /oracle/B71

/dev/vg04/B71DbHom 6160384 3851066 2166360 64% /oracle/B71/102_64

/dev/vg04/B71mirrA 229376 104180 117378 47% /oracle/B71/mirrlogA

/dev/vg04/B71mirrB 229376 104180 117378 47% /oracle/B71/mirrlogB

/dev/vg04/B71origA 229376 117124 105243 53% /oracle/B71/origlogA

/dev/vg04/B71origB 229376 130868 92357 59% /oracle/B71/origlogB

/dev/vg04/B71arch 2064384 164724 1781001 8% /oracle/B71/oraarch

/dev/vg04/B71data1 36864000 21256551 14631985 59% /oracle/B71/sapdata1

/dev/vg04/B71data2 36864000 15611542 19924183 44% /oracle/B71/sapdata2

/dev/vg04/B71data3 36864000 29271807 7117681 80% /oracle/B71/sapdata3

/dev/vg04/B71data4 55312384 29952561 23775284 56% /oracle/B71/sapdata4

/dev/vg04/B71reorg 16384000 12332842 3797995 76% /oracle/B71/sapreorg

/dev/vg04/B71mnt 5120000 4277193 790135 84% /sapmnt/B71

/dev/vg04/B71usap 8192000 5716970 2320398 71% /usr/sap/B71

$ su - orab70

Password:

(c)Copyright 1983-2006 Hewlett-Packard Development Company, L.P.

(c)Copyright 1979, 1980, 1983, 1985-1993 The Regents of the Univ. of California

(c)Copyright 1980, 1984, 1986 Novell, Inc.

(c)Copyright 1986-2000 Sun Microsystems, Inc.

(c)Copyright 1985, 1986, 1988 Massachusetts Institute of Technology

(c)Copyright 1989-1993 The Open Software Foundation, Inc.

(c)Copyright 1990 Motorola, Inc.

(c)Copyright 1990, 1991, 1992 Cornell University

(c)Copyright 1989-1991 The University of Maryland

(c)Copyright 1988 Carnegie Mellon University

(c)Copyright 1991-2006 Mentat Inc.

(c)Copyright 1996 Morning Star Technologies, Inc.

(c)Copyright 1996 Progressive Systems, Inc.

Confidential computer software. Valid license from HP required for

possession, use or copying. Consistent with FAR 12.211 and 12.212,

Commercial Computer Software, Computer Software Documentation, and

Technical Data for Commercial Items are licensed to the U.S. Government

under vendor's standard commercial license.

aduxbi02:orab70 1> brtools

BR0651I BRTOOLS 7.00 (24)

BR0280I BRTOOLS time stamp: 2011-12-19 13.47.52

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:

clear

BR0280I BRTOOLS time stamp: 2011-12-19 13.47.55

BR0664W Invalid choice: 'clear'

BR0662I Enter your choice:

8

BR0280I BRTOOLS time stamp: 2011-12-19 13.47.59

BR0663I Your choice: '8'

BR0280I BRTOOLS time stamp: 2011-12-19 13.47.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: 2011-12-19 13.48.02

BR0663I Your choice: '4'

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.02

BR0657I Input menu 59 - please check/enter input values

-

BRCONNECT options for changing password of database user

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

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

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

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

5 - BRCONNECT command line (command) .......... [-p initB70.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: 2011-12-19 13.48.04

BR0663I Your choice: '2'

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.04

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

system

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.09

BR0683I New value for "user": 'system'

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

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.14

BR0657I Input menu 59 - please check/enter input values

-

BRCONNECT options for changing password of database user

1 - BRCONNECT profile (profile) ............... [initB70.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 initB70.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: 2011-12-19 13.48.17

BR0663I Your choice: 'c'

BR0259I Program execution will be continued...

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

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.17

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

c

BR0280I BRTOOLS time stamp: 2011-12-19 13.48.23

BR0257I Your reply: 'c'

BR0259I Program execution will be continued...

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

BR0801I BRCONNECT 7.00 (24)

BR0280I BRCONNECT time stamp: 2011-12-19 13.48.23

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

Show replies
Show replies
Answer

Accepted Solutions (0)

Answers (3)

Answers (3)

Former Member
‎12-21-2011 6:02 PM
0 Kudos

system and sys users belongs to oracle .you can change password through SQL promt only.

No need use BRTOOLS.For SAP users(schemas) use BRTOOLS.

Show replies
Show replies
Former Member
‎12-19-2011 10:17 AM
0 Kudos

Hi

Is this the right way to change ths sys and systems passwords , throught oracle directly ?

All of the readings regarding changing Oracle passwords state that they should be done in Brtools because it updates certain SAP tables with the new password information while doing it diterctly under SQLPLUS will only update Oracle

Show replies
Show replies
Former Member
‎12-19-2011 10:40 AM
0 Kudos

For SYS, system, we do it via oracle sqlplus and then use that system password to reset other SAP/DB user's passwords via brtools/brconnect - For e.g. -

brconnect -u system/<syst_pwd> -f chpass -o SAPR3 -p <new_sap_pwd>

Thanks

Former Member
‎12-19-2011 10:56 AM
0 Kudos

Try to refer another discussion thread, why SYS, system users are not mandatorily be reset by brconnect/brtools...however these can be reset, via brtools

Thanks

former_member188883
Active Contributor
‎12-19-2011 12:18 PM
0 Kudos

Hi Rayyan,

All of the readings regarding changing Oracle passwords state that they should be done in Brtools because it updates certain SAP tables with the new password information while doing it diterctly under SQLPLUS will only update Oracle

All the SAP tables are owned by schema user and not system or SYS users. Both these users are used only by Oracle processes. Hence it has to be changed by SQL command.

Hope this is useful.

Regards,

Deepak Kori

former_member188883
Active Contributor
‎12-19-2011 9:59 AM
0 Kudos

Hi,

You cannot change password for System and SYS using brtools. You need to use SQL statement to change the password.

SQL> Alter user system identified by <newpasswd>;

Hope this is useful.

Regards,

Deepak Kori

Show replies
Show replies
Ask a Question