Skip to Content

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

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

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • Best Answer
    May 24 at 08:44 AM

    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 !

    Add comment
    10|10000 characters needed characters exceeded