Could not drop database shadow user 'SAPSR3SHD in phase MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB

[former_member196171]

I am upgrading EHP6 /NW73 to EHP7/NW74 , upgrade is in at tail end of  preprocessing step, getting following error , please help if you can

Could not drop database shadow user 'SAPSR3SHD in phase MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB

Severe error(s) occurred in phase MAIN_SHDIMP/SUBMOD_SHDDEL2/SHDUNINST_DB!
Last error code set: brconnect exited with 5
Could not drop database shadow user 'SAPSR3SHD', see logfile 'SHDUNINST.LOG'

SAPup> Starting subprocess with PID 16646212 in phase 'SHDUNINST_DB' at 20160204203721
    ENV: DIR_LIBRARY=/usr/sap/SID/SUM/abap/exe
    ENV: JAVA_HOME=/usr/sap/SID/DVEBMGS00/exe/sapjvm_5
    ENV: LIBPATH=/usr/sap/SID/SUM/abap/exe:/usr/sap/SID/SUM/jvm/jre/lib/ppc64/server:/usr/sap/SID/SUM/jvm/jre/lib/ppc64:/usr/sap/SID/SUM/jvm/jre/lib/ppc64/jli:/usr/s
ap/SID/SUM/jvm/jre/../lib/ppc64:/opt/CA/SharedComponents/lib:/opt/CA/CAlib:/opt/CA/SharedComponents/ccs/dia/lib:/opt/CA/SharedComponents/ccs/dia/dna/lib:/opt/CA/Shar
edComponents/JRE/1.5.0/bin:/opt/CA/SharedComponents/JRE/1.5.0/bin/classic:/opt/CA/SharedComponents/ccs/atech/services/bin:/opt/CA/ca_lic:/usr/sap/SID/SYS/exe/uc/rs60
00_64:/usr/sap/SID/SYS/exe/run:/oracle/client/12x/instantclient
    ENV: NLS_LANG=AMERICAN_AMERICA.UTF8
    ENV: ORACLE_BASE=/oracle
    ENV: ORACLE_HOME=/usr/sap/SID/SUM/abap/tmp
    ENV: ORACLE_SID=SID
    ENV: PATH=/usr/sap/SID/SUM/abap/exe:/usr/sap/SID/DVEBMGS00/exe/sapjvm_5/bin:/usr/bin:/etc:/usr/sbin:/usr/ucb:/usr/bin/X11:/sbin:/usr/java5/jre/bin:/usr/java5/bin
:/opt/CA/SharedComponents/bin:/opt/CA/SharedComponents/ccs/atech/services/bin:/opt/CA/SharedComponents/ccs/atech/agents/bin:/opt/CA/SharedComponents/ccs/bin:/opt/CA/
SharedComponents/ccs/scripts:/opt/CA/SharedComponents/ccs/snmp/bin:/opt/CA/UnicenterNSM/nsmutils/bin:/usr/sap/SID/SYS/exe/uc/rs6000_64:/usr/sap/SID/SYS/exe/run:/home
/k1sadm:.
    ENV: SAPCHECK=/usr/sap/SID/SUM/abap/tmp
    ENV: SAPDATA_HOME=/usr/sap/SID/SUM/abap/tmp
    ENV: SAPSYSTEMNAME=SID
    ENV: dbms_type=ORA
    ENV: dbs_ora_schema=SAPSR3
    ENV: dbs_ora_tnsname=SID
    PWD: /usr/sap/SID/SUM/abap/tmp

EXECUTING /usr/sap/SID/SUM/abap/exe/brconnect -u -c -f drown -o SAPSR3SHD -f -RDB
BR0801I BRCONNECT 7.40 (17)
BR0280I BRCONNECT time stamp: 2016-02-04 20:37:21
BR0262I Enter database user name[/password]:
BR0280I BRCONNECT time stamp: 2016-02-04 20:37:21
BR0301E SQL error -1031 at location drown_main-1, SQL statement:
'/* BRCONNECT */ DROP USER "SAPSR3SHD" CASCADE'
ORA-01031: insufficient privileges
BR1338E Dropping database owner SAPSR3SHD failed

BR0280I BRCONNECT time stamp: 2016-02-04 20:37:21
BR0804I BRCONNECT terminated with errors
SAPup> Process with PID 16646212 terminated with status 5 at 20160204203721!

[former_member265124]

Hello,

Regarding your issue, can you please check the mentioned SAP notes:

700548 - FAQ: Oracle authorizations

1870519 - Oracle Database Vault and SAP Shadow User (SAP<SID>SHD)

Could you please check authorization for BRtool

113747 - Owners and authorizations for BR*Tools

Hope this helps!!

Regards,

Maha

[former_member229807]

Hello Abu Zahir,

Insufficient privileges to Schema user :

Go under /usr/sap/SID/SYS/run/exe and run

sqlplus /nolog @sapdba_role.sql SAPSR3

Check the sapdba_role.log outputfile ..

If you could not find sapdba_role.sql in the above mentioned path, kindly refer SAP note

134592 - Import of SAPDBA role (sapdba_role.sql)

After granting the access repeat the phase.

Please let me know if issue is resolved.

Regards,

Ateek Shaha