ORA-01031: insufficient privileges during ACT_UPG phase in upgrade

Symptom:

During phase ACT_UPG in upgrade ORA-01031 occurs.

Runtime Errors         DBSQL_SQL_ERROR

Exception              CX_SY_OPEN_SQL_DB

Parameters:

P1 "DDPRS"

P2 "SQL code: 1031"

P3 "SQL message: ORA-01031: insufficient privileges"

P4 "SQL dbsl rc: 99"

Troubleshooting:

1. Check in ST22 in shadow instance, if any related runtime errors has occured.

2. From the run time error we can see the table having issues.

3. Also check the work process associated.

4. From St11 check the concerned workprocess trace.

Solution:

1. In ACT_UPG  phase if this issue occurs check roles assigned to SAPSR3 and SAPSR3SHD users:

SQL>Select grantee,granted_role from dba_role_privs where grantee =’SAPSR3’;

SQL>Select grantee,granted_role from dba_role_privs where grantee =’SAPSR3SHD’;

SAP DBA AND SAPCONN  role should be assigned .

Refere notes : 

134592 - Import of SAPDBA role (sapdba_role.sql)


834917 - Implementation of SAPCONN role (sapconn_role.sql)

2. If still the issue is not solved , grant permission on the table as below :

grant select, insert, update, delete on sapsr3.<Table> to SAPSR3;
grant select, insert, update, delete on sapsr3.<Table> to SAPSR3SHD;
grant select, insert, update, delete on sapsr3SHD.<Table> to SAPSR3SHD;
grant select, insert, update, delete on sapsr3shd.<Table> to SAPSR3;

Hope this helps!!!

Abraham