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.
SAP Knowledge Base Article - Preview