Cannot create database shadow user SAPSR3SHD

[former_member279278]

Hi Experts,

I've been upgrade in SAP NW BW from 7.01 to 7.4 SR1. In phase to create user for shadow instance the follow error appear:

EXECUTING /sapinstall/SUM/abap/exe/brconnect  -u -c -f crown -o SAPSR3SHD -p <HIDDEN> -RDB

BR0801I BRCONNECT 7.40 (6)

BR0280I BRCONNECT time stamp: 2014-04-10 15:12:17

BR0262I Enter database user name[/password]:

BR1628E Invalid charcter '@' in database password

BR1336E Creating database owner SAPSR3SHD failed

BR0280I BRCONNECT time stamp: 2014-04-10 15:12:17

BR0804I BRCONNECT terminated with errors

SAPup> Process with PID 27721910 terminated with status 3 at 20140410151217!

Do you have any idea?

Thanks!

Fernand

[Former Member · Accepted solution]

Hello Fernanda

We have faced the same problem today in our production system.

It seems to be a problem only with cluster, we do not have this problem for our dev and quality system.

Finally, found a solution :

create SAPSR3SHD identified by <pwd>

grant sapconn to SAPSR3SHD;

brconnect -u / -c -f chpass -o SAPSR3SHD -p <pwd>

We have found the solution in SAP note 1870519 - Oracle Database Vault and SAP Shadow User (SAP<SID>SHD)

But... this one is for oracle Vault, this is quite strange because we do not use this functionnality.

I hope it will help you !

[claudiageissler]

It did not work at once. We additionally executed the following.

Schema User = SAPERP in our environment.

create user SAPERPSHD identified by <PW>;
grant sapconn to SAPERPSHD;
brconnect -u / -c -f chpass -o SAPERPSHD -p <PW>;

CONNECT SAPERPSHD/<PW>;

1. brtools -c
2. 8 - Additional functions
3. 4 - Change password of database user
4. 3 ~ Database owner to change password (owner)
5. fill in ther new user, which pw you'd like to change e.g. SAPERPSHD
6. c
7. new PW
8. again new PW

This worked in our SUM upgrade.

[former_member279278]

Thanks!

It's work.