Exception CX_DBA_ADBC, CX_SQL_EXCEPTION - ORA-00942

Referencia

Note 1546456 - DBACockpit: Remote File Access for some Oracle files

Transações Afetadas

- DB02

- ST04

Problema

ORA-00942: table or view does not exist

Exception CX_DBA_ADBC in function unit READ_TEXT_FILE line 12 ( function group S_ORA_COCKPIT_5 include  )

        Kernel Error ID:     

        WP ID:       2 

        WP PID:      13303910

        SYSID:       DEV

        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

  

Solução

- Crie o script sappost3.sql, copie e cole o script abaixo.

- Troque o SID TMP para o SID do seu sistema.

- Execute no sqlplus e verifique se o problema foi resolvido.

spool sappost3.log

connect / as sysdba

drop directory ext_dir_dbac_client;

create directory ext_dir_dbac_client as '/usr/sap/TMP/SYS/profile/oracle';

drop table ext_tab_dbac_tnsnames;

create table ext_tab_dbac_tnsnames

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_client

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('tnsnames.ora'));

drop table ext_tab_dbac_sqlnet;

create table ext_tab_dbac_sqlnet

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_client

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('sqlnet.ora'));

GRANT READ ON DIRECTORY ext_dir_dbac_client TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_client TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_tnsnames TO SAPR3;

GRANT SELECT ON ext_tab_dbac_sqlnet TO SAPR3;

drop directory ext_dir_dbac_server;

create directory ext_dir_dbac_server as '/oracle/TMP/102_64/network/admin';

drop table ext_tab_dbac_listener;

create table ext_tab_dbac_listener

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_server

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('listener.ora'));

GRANT READ ON DIRECTORY ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_server TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_listener TO SAPR3;

drop directory ext_dir_dbac_alert;

create directory ext_dir_dbac_alert as '/oracle/TMP/saptrace/background';

drop table ext_tab_dbac_alert;

create table ext_tab_dbac_alert

  (line varchar2(2000))

  ORGANIZATION EXTERNAL

  (type oracle_loader

  default directory ext_dir_dbac_alert

    access parameters

      (RECORDS DELIMITED BY NEWLINE

      NOLOGFILE)

    location ('alert_TMP.log'));

GRANT READ ON DIRECTORY ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;

GRANT WRITE ON DIRECTORY ext_dir_dbac_alert TO SAPR3 WITH GRANT OPTION;

GRANT SELECT ON ext_tab_dbac_alert TO SAPR3;

spool off

exit

Abraços