Symptom
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_SDBAH,
SAP_SDBAD,
SAP_DBCHECKORA,
SAP_DBMSGORA,
SAP_DBSTATC,
SAP_DBSTAIHORA,
SAP_DBSTATHORA,
SAP_DBSTATIORA,
SAP_DBSTATTORA.
Read more...
Environment
- SAP Application Server
- Oracle database.
Keywords
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 page
This 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.