Re: File Watcher on Windows

From: John Thomas <jt2354_at_gmail.com>
Date: Wed, 13 Jan 2016 15:08:18 +0000
Message-ID: <CAOHpfbEvaf1Yit_ddjKb=OywbPKk9LC4gCH_0YH7=YsqONgSnw_at_mail.gmail.com>

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

Received on Wed Jan 13 2016 - 16:08:18 CET