Search notes:
Troubleshooting Oracle file watcher problem
So, in order to troubleshoot problems with a file watcher setup, one might to simply call this procedure.
In order to enable debugging messages into the
trace file , the event 27401 can be set:
$ sqlplus / as sysdba
SQL> oradebug setmypid
SQL> oradebug tracefile_name
/path/to/tracfile.trc
SQL> alter system set events '27401 trace name context forever, level 262144';
SQL> exec dbms_ischedfw.file_watch_job
SQL> alter system set events '27401 trace name context off';
After executing this procedure, /path/to/tracfile.trc can be examined for the logging messages which hopefully assist in finding the cause of the problem.