John,
This had me tormented at the time. I found this, which suggested the
credential account also needed privileges on a java executable in Oracle
home. (Go to the end) Despite your account owning the service it may not
have this.
https://aychin.wordpress.com/2014/08/21/oracle-file_watcher-and-its-troubleshooting/
It only worked for me when I used my account with admin privileges,
privileges on the watched directory and privileges on Oracle home. In the
situation I was able to go with that but bear in mind when using a domain
account particularly, that the credentials are passed in plain text. The
above document shows this.
Ronan
No, a domain account, but one that has plenty of access to the location.
Now that you mention it, maybe I'll check it has access all the way up the
tree...
Regards,
John
On Wed, 13 Jan 2016 at 15:15 Ronan Merrick <merrickronan1@xxxxxxxxx> wrote:
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
