SAP Knowledge Base Article - Preview

2964406 - ORA-00942 on some DBACockpit functions

Symptom

Even though most of DBACockpit functions still work, the error below may be displayed at the bottom of the screen:

ORA-00942: table or view does not exist

An example is while navigating to Performance -> Additional Functions -> Database Parameters

In the work process trace, the error below is recorded:

Tue Aug 25 10:48:09 2020
C  check2: OCIStmtExecute() failed with -1=OCI_ERROR
C          SQL error 942:
C     ORA-00942: table or view does not exist                                                                                       
C     statement for table '                              ':
C         SELECT line FROM sys.ext_tab_dbac_alert                                                                                   
C     stmt_fetch() -> orc=942, 103=DBSL_ERR_DBOBJECT_UNKNOWN
C  head_p=0000000002FF4410, cid=0: dbsl err=103=DBSL_ERR_DBOBJECT_UNKNOWN-> dbds err=512=DS_DBOBJECTUNKNOWN,dbdsoci.c:1200
C  *** ERROR => ^^ Ds_fetch(cid=0) -> err=512=DS_DBOBJECTUNKNOWN
[dbdsoci.c    1282]


Read more...

Environment

  • Any OS
  • Any Netweaver version
  • Oracle database 

Product

SAP NetWeaver all versions

Keywords

st04 st04n db02 dba cockpit , 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.