Referencia
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
Postagens
