Re: File Watcher on Windows

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