Ronan,
I think I checked this way back. The domain user is the user Log On As
owning the Oracle service for the database.
It has Full Control of everything up to the drive root.
What I really wanted from Oracle Support was some way of delving into more
detail of "Privilege check failed". But I suppose it's not their fault that
on Windows tracing is limited to 27401 inside Oracle.
Any other suggestions welcome.
Regards,
John
On Wed, 13 Jan 2016 at 15:38 John Thomas <jt2354@xxxxxxxxx> wrote:
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
