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 ONE Support launchpad (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.