Trying to solve DB04 (DBACOCKPIT) ORA-00942 error

[Former Member]

Hi,

I am trying to access Alert Log through dbacockpit transaction and recive ORA-00942 error:

.

Exception CX_DBA_ADBC in function unit READ_TEXT_FILE line 12 ( function group SDBACCMS include  ) 
   Kernel Error ID:    
   WP ID:   2  
   WP PID:   10064 
   SYSID:   UEP 
   SY-SUBRC:   0  
   SQL statement: SELECT line FROM sys.ext_tab_dbac_alert 
   Database: DEFAULT
 caused by 
 Exception CX_SQL_EXCEPTION in class CL_SQL_RESULT_SET  
   Kernel Error ID:    
   DB Error:     Yes 
   SQL Code:     942  
   SQL Message:   ORA-00942: table or view does not exist 
   DB Object Exists:   No 
   Duplicated Key:   No 
   Internal Error:   5  
   Invalid Cursor:   No 
   Unknown Connection:   No 
   Connection Closed:   No

I am using Oracle 11g with Oracle client 10, my installation is distributed, central and dialog instances are separated from database.

Basis support package is: SAPKB70209

[paul_power · Accepted solution]

Hello Pavel,

Please check SAP note 1546456 DBACockpit: Remote File Access for some Oracle files

Since your system already have the code correction, please run the
script sappost2.txt attached to the note to create the oracle objects.
Please adjust the schema name, the three paths of the directories and
the name of the alert log in the script before executing the script.

If after the script, the issue persists, please send the output of the following queries as sysdba:

select owner, table_name
from dba_tables
where lower(table_name) in
      ('fext_tab_dbac_tnsnames','ext_tab_dbac_sqlnet',
       'ext_tab_dbac_listener','ext_tab_dbac_alert');

select grantee, table_name
from dba_tab_privs
where lower(table_name) in
      ('fext_tab_dbac_tnsnames','ext_tab_dbac_sqlnet')
       'ext_tab_dbac_listener','ext_tab_dbac_alert');

Regards,

Paul

[Former Member · Accepted solution]

Hello Pavel and Paul,

Thanks for posting this problem and providing the solution.

For information:

I faced the same issue on Oracle 11.2.0.3 with Basis support package SAPKB70212.

Running the script sappost2.txt which is provided in SAP Note 1546456 solved the problem.

BR,

Michel

[joe_ledesma · Accepted solution]

Replying to this old post in case since currently this post is the only search result found in either SCN search or xSearch in the support portal for the search term that I used to find it:

SELECT line FROM sys.ext_tab_dbac_alert

--which was the error I got in DBA Cockpit.

Thank you also and for posting this problem and providing the solution.

Here are updated versions of the queries to use to verify whether the database has the objects and grants and the expected output once the script on the note 1546456 has been implemented:

select owner, table_name

from dba_tables

where lower(table_name) in

      ('ext_tab_dbac_tnsnames','ext_tab_dbac_sqlnet',

      'ext_tab_dbac_listener','ext_tab_dbac_alert');

OWNER                          TABLE_NAME

------------------------------ ------------------------------

SYS                            EXT_TAB_DBAC_LISTENER

SYS                            EXT_TAB_DBAC_TNSNAMES

SYS                            EXT_TAB_DBAC_SQLNET

SYS                            EXT_TAB_DBAC_ALERT

select grantee, table_name

from dba_tab_privs

where lower(table_name) in

      ('ext_tab_dbac_tnsnames','ext_tab_dbac_sqlnet',

      'ext_tab_dbac_listener','ext_tab_dbac_alert');

GRANTEE                        TABLE_NAME

------------------------------ ------------------------------

<SCHEMA>                      EXT_TAB_DBAC_ALERT

<SCHEMA>                      EXT_TAB_DBAC_LISTENER

<SCHEMA>                      EXT_TAB_DBAC_SQLNET

<SCHEMA>                      EXT_TAB_DBAC_TNSNAMES

Follow me on Google+