Hi,
Database is Oracle 11.2.0.3 EE on AIX 6.1 and Power 7.
We are using a file watcher on our test database to refresh a schema
when we receive the dumps from prod and then run some process.
This file watcher was working with no problem for ~ 1 year, but since
a few weeks sometimes like yesterday evening we received the dump but
the job was not started by the file watcher.
Looking into the file watcher queue table
(SYS.SCHEDULER_FILEWATCHER_QT) I found a message enqueued
corresponding to my dump, here is the user_data (I have changed user,
server, directory, filename in the content of the message) :
SYS.SCHEDULER_FILEWATCHER_RESULT('****','/zzzz/xxxx','flag_ftp_xxx_20092016_OK',0,'2016-09-20
18:23:00.0',1474395780000,SYS.SCHEDULER_FILEWATCHER_REQ_LIST(SYS.SCHEDULER_FILEWATCHER_REQUEST('uuuuuu','DRIVER_LDP_FW','/zzzz/xxxx','flag_ftp_xxx_*_OK','yyyy','LOCAL_CREDENTIAL',0,30000)))
The message is in ready state, Enqueue and Dequeue are both enabled on
the queue.
There is no error message in the alert log at that time.
Any idea ?
Regards,
Thomas
--
//www.freelists.org/webpage/oracle-l