When executing DBACOCKPIT related transactions or operations, for example DB02 or DB13 operations, it reports error "ORA-01031: insufficient privileges".
Looking into the log and trace file (dev_w file in ST11), it is running the following SQL command, which triggers the ORA-01031 error.
SELECT ... FROM <Synonym name> WHERE ...
Here the <Synonym name> can be:
- SAP Application Server
- Oracle database.
ORA-01031, insufficient privileges, DBACOCKPIT, DB02, DB13, SAP_SDBAH, SDB_SDBAD, SAP_DBCHECKORA, SAP_DBMSGORA, SAP_DBSTATC, SAP_DBSTAIHORA, SAP_DBSTATHORA, SAP_DBSTATIORA, SAP_DBSTATTORA , KBA , BC-CCM-MON-ORA , Database Monitors for Oracle , Problem
About this pageThis 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.