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 :
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;
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
Hope this helps!!!
Abraham
