Return
-
Title
Foglight data guard issue LOGIC3 Database -
Description
Getting CREATE TABLE followed by DROP TABLE repeated over and over again on monitored database by the Oracle user defined in the agent properties. This is affecting database performance. Statements are similar to the following:
SQL> create table QSI_ALERT_TAIL_1303437111317 ( text varchar2(500) )
2 organization external (
3 type oracle_loader
4 default directory Q_ALERT_LOG_prd3_loc
5 access parameters (
6 records delimited by newline nologfile nobadfile skip
52881947 fields terminated by "$" ltrim
8 REJECT ROWS WITH ALL NULL FIELDS
9 )
10 location('alert_prd3.log')
11 )
12 /
default directory Q_ALERT_LOG_prd3_loc
*
ERROR at line 4:
ORA-06564: object Q_ALERT_LOG_PRD3_LOC does not existThis is happening on a standby instance of the monitored database when redo logs are being replayed on the standby
Sign In Required
You need to be signed in and under a current maintenance contract to view premium knowledge articles.