Re: File Watcher on Windows
From: MJ Mody <emjay.mody_at_gmail.com>
Date: Wed, 13 Jan 2016 10:15:52 -0600
Message-Id: <EB6F3A56-EE43-43A7-BB5B-C24047CF8A80_at_gmail.com>
Asking a tangent question to file-watcher in general.. Can the scheduled job be configured to create a stub file on the file-system (Windows)? My apps team has a one-size fits all application that services multiple clients. The rub is some clients send 10 files while others send 15 and external tables are used to process incoming data. Moreover an issue we have is the stats job choked when it does not see a file in the directory. Hence if file-watcher could be configured to place a stub file, this database environment can be peachier. Wishful thinking maybe..
>>>> 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
>>>>
>>>>
Date: Wed, 13 Jan 2016 10:15:52 -0600
Message-Id: <EB6F3A56-EE43-43A7-BB5B-C24047CF8A80_at_gmail.com>
Asking a tangent question to file-watcher in general.. Can the scheduled job be configured to create a stub file on the file-system (Windows)? My apps team has a one-size fits all application that services multiple clients. The rub is some clients send 10 files while others send 15 and external tables are used to process incoming data. Moreover an issue we have is the stats job choked when it does not see a file in the directory. Hence if file-watcher could be configured to place a stub file, this database environment can be peachier. Wishful thinking maybe..
> On Jan 13, 2016, at 9:43 AM, John Thomas <jt2354_at_gmail.com> wrote: > > 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_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-lReceived on Wed Jan 13 2016 - 17:15:52 CET