Search notes:

Troubleshooting Oracle file watcher problem

The entry point for the work of a file watcher is dbms_ischedfw.file_watch_job.

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.

Index