Error at PHASE PHASE SCEXEC_ALIAS in 4.71 upgrade

[Former Member]

hi,

i am getting the below error in R/3 Upgrade:

UPGRADE/SHDINST: START OF PHASE SCEXEC_ALIAS

ERROR: 8831 error messages found in C:\usr\sap\put\log\SQLEXEAL.LOG.

Analyze the log (refer to the upgrade

guide and the notes) and remove the problem(s)

that caused the error(s). After that,

repeat this phase until it is error free.

SQLEXEAL.LOG:

-

---

ERROR IN SCEXEC_ALIAS, log file PTALDC02.LOG: TPERR- ORA-01031: insufficient privileges

ERROR IN SCEXEC_ALIAS, log file PTALDC02.LOG: TPERR- ORA-01031: insufficient privileges

ERROR IN SCEXEC_ALIAS, log file PTALDC02.LOG: TPERR- ORA-01031: insufficient privileges

[Former Member · Accepted solution]

Hi. Read the note 906205 --> As Note you need -->

"

If not already done as as part of the Oracle migration, grant SAPCONN role to the SAP shadow user with the following SQL commands:

Sqlplus /nolog

SQL> Connect / as sysdba

SQL> grant SAPCONN to SAPR3SHD; (if the Shadow user is SAPR3SHD)

SQL> grant SAPCONN to SAP<SID>SHD; (if the Shadow user is SAP<SID>SHD)

SQL> exit

If you do not grant this role to the SAP shadow user, the upgrade fails in phase SCEXEC_ALIAS with the following message:

ORA-01031: insufficient privileges"

Regards. Award if helpful.

[Former Member · Accepted solution]

Thank u very much my problem got solved.