Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

FILE_WATCHER is not running

alkrushApr 29 2018 — edited May 6 2018

Hi all,

I've downloaded the pre build oracle Virtual Box (Developer Day - Hands-on Database Application Development).

I'm trying to setup the file_watcher (https://aychin.wordpress.com/2014/08/21/oracle-file_watcher-and-its-troubleshooting/), but it doesn't work.

Here is the output in trace:

file_watcher:: 2018-04-29 10:00:08.598: Directory: /u01/app/oracle/product/12.2/db_1/demo/schema, ArrivalTime: 1525010366000, SteadyStDur: 30000
file_watcher:: 2018-04-29 10:00:08.604: LastChkTime for directory /u01/app/oracle/product/12.2/db_1/demo/schema changed to 1525010366000
file_watcher:: 2018-04-29 10:00:08.610: All checking done
file_watcher:: 2018-04-29 10:00:08.621: Setting up results information
file_watcher:: 2018-04-29 10:00:08.627: Directory: /u01/app/oracle/product/12.2/db_1/demo/schema
file_watcher:: 2018-04-29 10:00:08.633: Result file name: eod1.txt
file_watcher:: 2018-04-29 10:00:08.637: Request pattern: eod*.txt, Regex: eod.*.txt
file_watcher:: 2018-04-29 10:00:08.641: Match found, adding to list of matching requests
file_watcher:: 2018-04-29 10:00:08.645: File watching done
file_watcher:: 2018-04-29 10:00:08.679: Updating history
file_watcher:: 2018-04-29 10:00:08.679: Iteration 1
file_watcher:: 2018-04-29 10:00:08.682: Updating history entry
file_watcher:: 2018-04-29 10:00:08.682:   Dir Path: /u01/app/oracle/product/12.2/db_1/demo/schema
file_watcher:: 2018-04-29 10:00:08.682:   Last Chk Time: 29-APR-18 01.59.26.000000 PM +00:00
file_watcher:: 2018-04-29 10:00:08.695: Processing results
file_watcher:: 2018-04-29 10:00:08.695: Iteration 1
file_watcher:: 2018-04-29 10:00:08.695:   Dir Path: /u01/app/oracle/product/12.2/db_1/demo/schema
file_watcher:: 2018-04-29 10:00:08.695:   File Name: eod1.txt
file_watcher:: 2018-04-29 10:00:08.695:   File Size: 5
file_watcher:: 2018-04-29 10:00:08.695:   File Tstamp: 29-APR-18 01.59.26.000000 PM +00:00
file_watcher:: 2018-04-29 10:00:08.695:   Matching Requests: 
file_watcher:: 2018-04-29 10:00:08.695:     Request: AKRUSH.EOD_REPORTS_WATCHER
SCHED 04-29 10:00:08.890 1 00 13765 ora 3(sjssuWriteJssuFlags):Using Flags 9
*** 2018-04-29T10:00:11.325621-04:00 (ORCL(3))
file_watcher:: 2018-04-29 10:00:11.325:     Privilege check passed
file_watcher:: 2018-04-29 10:00:11.325:     Enqueuing message
*** 2018-04-29T10:00:12.947884-04:00 (ORCL(3))
file_watcher:: 2018-04-29 10:00:12.947: Executing statement: SELECT UNIQUE dbms_isched.normalize_host_name(X.DEST) FROM (SELECT A.DESTINATION DEST FROM DBA_SCHEDULER_FILE_WATCHERS A WHERE A.DESTINATION IS NOT NULL AND A.DESTINATION_OWNER IS NULL UNION ALL SELECT C.HOSTNAME || ':' || C.PORT FROM DBA_SCHEDULER_FILE_WATCHERS B, DBA_SCHEDULER_EXTERNAL_DESTS C WHERE B.DESTINATION_OWNER IS NOT NULL AND B.DESTINATION IS NOT NULL AND C.ENABLED = 'TRUE' AND B.DESTINATION = C.DESTINATION_NAME) X
*** 2018-04-29T10:00:13.152737-04:00 (ORCL(3))
file_watcher:: 2018-04-29 10:00:13.152: No remote file watchers
file_watcher:: 2018-04-29 10:00:13.152: Setting last run time to 29-APR-18 09.59.37.676900 AM -04:00
file_watcher:: 2018-04-29 10:00:13.166: Committing transaction

Please advice me how should I correct this.

Thanks a lot in advance and BR

Alexander

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 3 2018

Added on Apr 29 2018

#database-key-features, #scheduler

2 comments

494 views