change password for user dbs_ora_schema

[Former Member]

Dear all,

We are trying to change password for user SAPSR3

>connect

USERNAME: SAPSR3

PASSWOR: sum123

>select * from ops$sidadm.SAPUSER;

SAPSR3-CRYPT

V01/0040ZctvSB67Wv3kuge8b9yFz7s2nNmHI/C+

Password encrypted above is actually 'sum123'

when i change password for user SAPSR3 as test123;

>alter user SAPSR3 identified by test123;

R3trans -d return 0012

Because password in SAPUSER table does not match with test123,

when i changed the same to test123

>select * from ops$sidadm.SAPUSER;

SAPSR3

test123

Still R3trans -d returns 0012

So what is the procedure to change password for user dbs_ora_schema???

Best Regards,

AjitR

[stefan_koehler · Accepted solution]

Hello AjitR,

> So what is the procedure to change password for user dbs_ora_schema???

Really simple procedure:

http://help.sap.com/saphelp_nw70/helpdata/en/4f/c3883989676778e10000000a11402f/content.htm

Regards

Stefan

[Former Member]

I would suggest you to use BRTools to change the SAPR3 password.

As ora<sid> run brtools

o choose “8” for additional functions

o choose “4” to change password of database user

o choose “3” to specify the db user to change password then enter “SAPSR3”

o a summary screen will be shown then press “c” to continue on changing the password

o change the password to “xxxxxx"

[Former Member]

Folks,

If you have gone through my post i am aware of procedure to change password for any user but when i change password for user SAPSR3 from 'sum123' to 'test123'...R3trans -d does not connect.

because original content of table SAPUSER is

>select * from ops$sidadm.SAPUSER;

SAPSR3-CRYPT

V01/0040ZctvSB67Wv3kuge8b9yFz7s2nNmHI/C+

( this is encrypted for sum123)

I changed the same to test123

>select * from ops$sidadm.SAPUSER;

SAPSR3-CRYPT

test123

But still R3trans -d does not work...

Now i have changed both password for user sapsr3 to 'sum123'

ans inserted contents back to encrypted password

SAPSR3-CRYPT

V01/0040ZctvSB67Wv3kuge8b9yFz7s2nNmHI/C+

And then R3trans -d works fine.

Means password in SAPUSER table is not changable directly by adding or deleting existing lines.

I guess i need to re-run ops$user.sql script......

points rewarded anyways.

[stefan_koehler]

Hello,

>> If you have gone through my post i am aware of procedure to change password for any user but when i change password for user SAPSR3 from 'sum123' to 'test123'...R3trans -d does not connect.

Have you opened the link that i wrote above?

You asked how you can change the password of the oracle database user SAPSR3 and the solution is:

http://help.sap.com/saphelp_nw70/helpdata/en/4f/c3883989676778e10000000a11402f/content.htm

> shell> su - ora<SID>

> shell> brconnect -u / –f chpass –u SAPSR3

This command changes the password of the oracle user SAPSR3 and updates the content of the table OPS$<SID>ADM.SAPUSER.

You can not change the password of SAPSR3 manually, because of the password is encrypted (like you have already seen).

> Means password in SAPUSER table is not changable directly by adding or deleting existing lines.

Correct -> use brconnect

> I guess i need to re-run ops$user.sql script......

That has nothing to do with it.

Regards

Stefan

[fidel_vales]

Hi,

You are a bit ....

You have been provided with the correct method to change the password but you continue to try your wrong method.

The reason is clear if you read your own post:

I changed the same to test123
select * from ops$sidadm.SAPUSER;
SAPSR3-CRYPT
test123

You areindicating to SAP that the encrypted password for the sapuser is test123.

Do you realize that test123 is the unencrypted password?

Please, use the "supported" method to change the passord and stop trying to hack it.

[Former Member]

Thanks guys to identify my mistake but i have changed password using Brtools also

But result is still the same

Now i will also try with comman

brconnect -u / –f chpass –u SAPSR3

And let you know shortly

Thanks once again....let me try it....Apologies for misunderstanding ....

[Former Member]

Below is the result am i typing something wrong

C:Documents and Settingspi7adm>brconnect -u / -f chpass -u SAPSR3

BR0801I BRCONNECT 7.00 (28)

BR0154E Unexpected option value 'ûf' found at position 3

BR0154E Unexpected option value 'chpass' found at position 4

BR0154E Unexpected option value 'ûu' found at position 5

BR0154E Unexpected option value 'SAPSR3' found at position 6

BR0280I BRCONNECT time stamp: 2008-04-21 18.35.09

BR0804I BRCONNECT terminated with errors

Please let me know....

[Former Member]

Check the syntax

http://help.sap.com/saphelp_nw70/helpdata/en/4f/c3883989676778e10000000a11402f/content.htm

[stefan_koehler]

Hello,

BR0154E Unexpected option value 'ûf' found at position 3

Try to type the command.. you have copy and paste an unknown illegal character.

Regards

Stefan

[Former Member]

Stefan and shaji,

Thanks to both of you...this time i have changed passoword using brtools and provided details for

Database owner to change password (owner) . [sapsr3]

and then changed password for sapsr3

Output was

BR0829I Password changed successfully in database for user SAPSR3

BR0830I Password changed successfully in table OPS$CYXI\PI7ADM.SAPUSER for us

SAPSR3

and now my system is up and running with new password

Thanks to both of you ....Points rewarded and sorry for beign impatient as it was my PRD box unfortunately.....

I am closing this thread.

[Former Member]

Thanks