Hi John,
Are you using a local account on the machine?
Ronan
On 13 Jan 2016 15:08, "John Thomas" <jt2354@xxxxxxxxx> wrote:
Oh , thanks Ronan.
Now I wonder what I have wrong, or if there's some configuration/patch
issue.
I have created credentials and tested they work elsewhere, created the
file watcher, the program pointing to a small test procedure REPORT_FILE,
created the job with queue spec TEST_FILE_WATCHER.
I've also run dbms_isched.file_watch_job manually after setting a 27401
trace, level 262144.
The tracefile shows that File Watcher has detected the file but apparently
doesn't call my test procedure which should just return the file details on
a DBMS_DEBUG pipe.
file_watcher:: 2015-12-23 09:27:47.659: Iteration 1
file_watcher:: 2015-12-23 09:27:47.659: Dir Path:
F:\DEVF04\FOS\TRX\TRIRESOLVE\EXTERNAL_TABLES
file_watcher:: 2015-12-23 09:27:47.659: File Name:
ICON_TRIRESOLVE_TT_EXTRACT.CSV
file_watcher:: 2015-12-23 09:27:47.659: File Size: 70121
file_watcher:: 2015-12-23 09:27:47.659: File Tstamp: 23-DEC-15
09.26.57.815000 AM +00:00
file_watcher:: 2015-12-23 09:27:47.659: Matching Requests:
file_watcher:: 2015-12-23 09:27:47.659: Request: SYS.TEST_FILE_WATCHER
file_watcher:: 2015-12-23 09:27:47.862: Privilege check failed
file_watcher:: 2015-12-23 09:27:47.862: No
Any thoughts? Oracle Support have spent three weeks to come up with
nothing so far.
Regards,
John
On Wed, 13 Jan 2016 at 14:45 Ronan Merrick <merrickronan1@xxxxxxxxx>
wrote:
Hi John,
Yes, I was able to get it working on 11.2.0.4/ R2 2008.
Ronan
On 13 Jan 2016 14:28, "John Thomas" <jt2354@xxxxxxxxx> wrote:
Has anyone got this to work on Oracle 11.2 running on MS Windows 2008 R2
or any other version of Windows?
If you have, please let me know. Our version is 11.2.0.4.
Regards,
JT
