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 ONE Support launchpad (Login required).
Search for additional results
Visit SAP Support Portal's SAP Notes and KBA Search.