SAP Knowledge Base Article - Preview

2813050 - BR1336E Creating database owner SAPSR3SHD failed


In the middle of an upgrade, SUM stopped in the PREP_INSTALL/SHDINST_DB_PREP phase with the following message:

The following entry can be fouundin the log file SHDUSRCRE.LOG

EXECUTING /usr/sap/TST/SUM/abap/exe/brconnect -u -c -f crown -o SAPSR3SHD -p <HIDDEN> -RDBBR0801I BRCONNECT 7.40 (34)
BR0280I BRCONNECT time stamp: 2018-07-25 06:35:42
BR0262I Enter database user name[/password]:
BR1334E Owner SAPSR3SHD already exists in database
BR0182E Checking parameter/option '-o|-owner' failed
BR1336E Creating database owner SAPSR3SHD failed

Following error or similar may record in SHDUSRCRE.SAV file (below information may only occur in brtools trace level 15):

BR0301E SQL error -1950 at location password_change-18, SQL statement:
'INSERT INTO "OPS$XXXXXX".SAPUSER (USERID, PASSWD) VALUES ('SAPSR3SHD-CRYPT', '********************************************************')'
ORA-01950: no privileges on tablespace 'SYSTEM'

With this log information, you will find exactly involved OPS$ user is, and the exactly error why SAPSR3SHD creation failed.






BR1334E, BR0182E, BR1336E, SAPSR3SHD, SAPSR3SHD already exists, , KBA , BC-DB-ORA-SYS , Database Interface / DBMS , BC-DB-ORA , Oracle , Problem

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.