SUM Current Phase: PREP_INSTALL/SHDINST_DB_PREP - Creating SAPSR3SHD User failed

[DieterLorenz]

Hello,

SUM cannot create a SAPSR3SHD User because missing permissions. The development System was running fine. We wanted to upgrade to EHP 8. I have checked all permission from the SAPSR3 User. SAPDBA role and SAPCONN role.

Now SUM wanted to have a Oracle VAULT User, but we did not use ORACLE VAULT User.

EXECUTING Y:\SUM\SUM\abap\exe\brconnect.EXE -u -c -f crown -o SAPSR3SHD -p <HIDDEN> -RDB
BR0801I BRCONNECT 7.40 (17)
BR0280I BRCONNECT time stamp: 2018-05-23 10:50:28
BR0262I Enter database user name[/password]:
BR0251W Function SetConsoleCtrlHandler() failed at location BrOraSigPatch-2
BR0253W errno 87: The parameter is incorrect.

BR0280I BRCONNECT time stamp: 2018-05-23 10:50:29
BR1335I Database owner SAPSR3SHD created successfully
BR0280I BRCONNECT time stamp: 2018-05-23 10:50:29
BR0301E SQL error -1950 at location password_change-15, SQL statement:
'INSERT INTO "OPS$SPE-CH-MD9\ADM".SAPUSER (USERID, PASSWD) VALUES ('SAPSR3SHD-CRYPT', '********************************************')'
ORA-01950: no privileges on tablespace 'SYSTEM'
BR0832E Setting password for user SAPSR3SHD failed

BR0280I BRCONNECT time stamp: 2018-05-23 10:50:29
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 6564 terminated with status 5 at 20180523105029!

Thanks a lot

[DieterLorenz · Accepted solution]

I reset the SUM and repeat - no luck. After the note

644104 - ORA-01536 / ORA-01950 für alle Benutzer auch für SECACCTMGR prüfen

set password

brconnect -u / -c -f chpass -o SAPSR3SHD -p password

Create User:

create user SECACCTMGR identified by password;

grant sapconn to SECACCTMGR;

grant create user to SECACCTMGR;

grant drop user to SECACCTMGR;

grant alter user to SECACCTMGR;

alter user SECACCTMGR quota unlimited on SYSTEM;

GRANT CONNECT, RESOURCE TO "OPS$SPE-CH-MD9\ADM".SAPUSER;

GRANT UNLIMITED TABLESPACE TO "OPS$SPE-CH-MD9\SAPSERVICE";

GRANT UNLIMITED TABLESPACE TO "OPS$SPE-CH-MD9\ADM";

GRANT UNLIMITED TABLESPACE TO SECACCTMGR ;

After that it works with the SHD User creation step !