Re: File Watcher on Windows

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_at_gmail.com> 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_at_gmail.com>
> wrote:
>
>> Hi John,
>>
>> Are you using a local account on the machine?
>>
>> Ronan
>> On 13 Jan 2016 15:08, "John Thomas" <jt2354_at_gmail.com> 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_at_gmail.com>
>>> 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_at_gmail.com> 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
>>>>>
>>>>

--
http://www.freelists.org/webpage/oracle-l