Re: moving from unix to NT

Jared,

On NT oracle.exe runs as "OracleService<SID>" service. Hence UTL_FILE will be executed under whatever OS account "OracleService<SID>" service runs.
And I was not able to make it running properly under any other than SYSTEM account.
Remember, on NT Oracle is one big (though multithreaded) process, unlike it is on UNIX.

Igor Neyman, OCP DBA
ineyman_at_perceptron.com

• Original Message ----- To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com> Sent: Thursday, February 28, 2002 1:03 PM

> I don't have any experience with UTL_FILE on NT. I've used it a little
> on unix. Don't know why it wouldn't work on NT. As stated by others,
> it might be a problem if writing to network drives, as the SYSTEM user
> does not have access to those when run as a service.
>
> This doesn't seem reasonable though, as the instance itself does not
> run as a service. The VOS runs as a service, but not the instance.
>
> Best bet is to try it.
>
> The biggest problem will likely be your code. If you have paths hard
> coded in it, you will have to rewrite. If they are stored in a table,
> just
> change the data.
>
> If you're interested in Perl, I can send you the same email I sent
> Dave Farnsworth. I can do that tonight from home if you like.
>
> Jared
>
>
>
>
>
>
> John Dunn <john.dunn_at_sefas.co.uk>
> Sent by: root_at_fatcity.com
> 02/28/02 02:08 AM
> Please respond to ORACLE-L
>
>
> To: Multiple recipients of list ORACLE-L
<ORACLE-L_at_fatcity.com>
> cc:
> Subject: RE: moving from unix to NT
>
>
> Jared
>
> It would be useful if you could point me in the right direction.
>
> I guess the real question for me is will UTL_FILE work properly when I
> move
> to NT, including on Network drives?. There seems to be some doubt amongst
> the listers as to whether it does.
>
>
>
> John.
>
>
> > -----Original Message-----
> > From: Jared.Still_at_radisys.com [SMTP:Jared.Still_at_radisys.com]
> > Sent: 27 February 2002 18:35
> > To: Multiple recipients of list ORACLE-L
> > Subject: RE: moving from unix to NT
> >
> > Perl is *much* more flexible than UTL_FILE for flat file operations.
> >
> > There is simply no basis for comparison.
> >
> > The question in your case is this: Can you easily replace the PL/SQL
> > procedures that are using UTL_FILE with a process that runs outside
> > of the database?
> >
> > If so, myself and others on this list can point you in the right
> > direction, as
> > basics in Perl/Oracle/DBI are really not too hard.
> >
> > If your PL/SQL is part of a larger application and not easily removed,
> you
> > may just have to deal with modifying the PL/SQL.
> >
> > Of course, if you had made this stuff data driven ( meta data, if you
> will
> >
> > ),
> > this would be a non-issue. :)
> >
> > Jared
> >
> >
> >
> >
> >
> >
> > John Dunn <john.dunn_at_sefas.co.uk>
> > Sent by: root_at_fatcity.com
> > 02/27/02 01:53 AM
> > Please respond to ORACLE-L
> >
> >
> > To: Multiple recipients of list ORACLE-L
> > <ORACLE-L_at_fatcity.com>
> > cc:
> > Subject: RE: moving from unix to NT
> >
> >
> > Thanks to everyone for their input into this. The only real issue seems
> to
> > be UTL_FILE on network drives.
> >
> > 1. I was interested in the many references to Perl as an alternative to
> > using UTL_FILE. Could any of you provide more detail. I know nothing
> about
> > Perl so would be interested in how to replace the use of UTL_FILE in
> > PL/SQL
> > with Perl. We use UTL_FILE quite a lot for reading and writing flat
> files.
> >
> >
> >
> > 2. With regard to external procedures, On Unix we currently use this to
> > call
> > a C routine that calls the system command to run Unix commands and
> > scripts(Korn Shell). I presume we will need to amend these commands to
> > their
> > NT equivalents(or can I call Windows API directly from PL/SQL? on NT)
> and
> > re-write the scripts...presumably in Perl?
> >
> >
> > It will probbably be Oracle 9i on NT.
> >
> >
> > John
> >
> >
> > > -----Original Message-----
> > > From: Jared.Still_at_radisys.com [SMTP:Jared.Still_at_radisys.com]
> > > Sent: 26 February 2002 21:37
> > > To: Multiple recipients of list ORACLE-L
> > > Subject: Re: moving from unix to NT
> > >
> > > I haven't tried to do this with Oracle, I just knew that you could.
> > >
> > > My use has been to change the account that is used for some of my
> > > monitors that need to see network drives. I've never had a need
> > > to make Oracle run as other than System.
> > >
> > > As for UTL_FILE, I avoid it like the plague. Perl is much cleaner
> > > and easier to use.
> > >
> > > Jared
> > >
> > >
> > >
> > >
> > >
> > >
> > > "Igor Neyman" <ineyman_at_perceptron.com>
> > > Sent by: root_at_fatcity.com
> > > 02/26/02 10:53 AM
> > > Please respond to ORACLE-L
> > >
> > >
> > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > cc:
> > > Subject: Re: moving from unix to NT
> > >
> > >
> > > Well, I was having all kinds of problems, when I was playing with this
> > > option, trying to make oracle service on nt to run under other then
> > SYSTEM
> > > account. And yes, I granted this account any possible NT privilege
> > (like
> > > ability to run/logon as a service), still didn't work.
> > >
> > > Jared,
> > >
> > > Could you share some details on this issue, if you still remember how
> > you
> > > managed to make this working?
> > >
> > > Igor Neyman, OCP DBA
> > > ineyman_at_perceptron.com
> > >
> > >
> > > ----- Original Message -----
> > > To: <ORACLE-L_at_fatcity.com>
> > > Cc: <ineyman_at_perceptron.com>
> > > Sent: Tuesday, February 26, 2002 1:14 PM
> > >
> > >
> > > > > Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM
> > > > account,
> > > > > which does not have privileges to access network drives.
> > > >
> > > > You can change that if you're so inclined.
> > > >
> > > > ( I can't believe I'm defending Windoze. shudder )
> > > >
> > > > Jared
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > >
> > > > "Igor Neyman" <ineyman_at_perceptron.com>
> > > > Sent by: root_at_fatcity.com
> > > > 02/26/02 06:23 AM
> > > > Please respond to ORACLE-L
> > > >
> > > >
> > > > To: Multiple recipients of list ORACLE-L
> > > <ORACLE-L_at_fatcity.com>
> > > > cc:
> > > > Subject: Re: moving from unix to NT
> > > >
> > > >
> > > > Well, you shouldn't:)
> > > >
> > > > Because Oracle on NT runs (hence executes UTL_FILE) under SYSTEM
> > > account,
> > > > which does not have privileges to access network drives.
> > > >
> > > > Igor Neyman, OCP DBA
> > > > ineyman_at_perceptron.com
> > > >
> > > >
> > > > ----- Original Message -----
> > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > > Sent: Monday, February 25, 2002 9:38 PM
> > > >
> > > >
> > > > > On UTL_FILE, I've never had much luck using network mounted files.
> > > > >
> > > > >
> > > > >
> > > > > Igor Neyman
> > > > > <ineyman To: Multiple
> recipients
> >
> >
> > > of
> > > > list ORACLE-L
> > > > > @perceptron.c <ORACLE-L_at_fatcity.com>
> > > > > om> cc:
> > > > > Sent by: root Subject: Re: moving
> > from
> > > > unix
> > > > to NT
> > > > >
> > > > >
> > > > > 02/25/2002
> > > > > 12:18 PM
> > > > > Please
> > > > > respond to
> > > > > ORACLE-L
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > >
> > > > > For external procedures just follow the rules for creating DLLs on
>
> > NT,
> > > > > works
> > > > > fine.
> > > > >
> > > > > DBMS_JOB works fine.
> > > > >
> > > > > For UTL_FILE make sure, you are following NT conventions, when
> > > > specifying
> > > > > file path(use back slash '\', not front slash '/').
> > > > >
> > > > > Igor Neyman, OCP DBA
> > > > > ineyman_at_perceptron.com
> > > > >
> > > > >
> > > > > ----- Original Message -----
> > > > > To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> > > > > Sent: Monday, February 25, 2002 11:43 AM
> > > > >
> > > > >
> > > > > > We are contemplating moving our application from Unix to NT. The
>
> > > main
> > > > > things
> > > > > > that concerm me are where our application interfaces with the
> OS,
> > > via
> > > > a
> > > > > C
> > > > > > external procedure, and also via UTL_FILE. Also, can I expect
> > > DBMS_JOB
> > > > to
> > > > > > work OK?
> > > > > >
> > > > > > Anyone got experience of porting this sort of functionality to
> NT?
> > > > > >
> > > > > > John
> > > > > >
> > > > > > --
> > > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > > --
> > > > > > Author: John Dunn
> > > > > > INET: john.dunn_at_sefas.co.uk
> > > > > >
> > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> > 538-5051
> > > > > > San Diego, California -- Public Internet access / Mailing
>
> > > Lists
> > > > > >
> > --------------------------------------------------------------------
> > > > > > To REMOVE yourself from this mailing list, send an E-Mail
> message
> > > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
>
> > in
> > > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > > (or the name of mailing list you want to be removed from). You
> > may
> > > > > > also send the HELP command for other information (like
> > subscribing).
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author: Igor Neyman
> > > > > INET: ineyman_at_perceptron.com
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > > > > San Diego, California -- Public Internet access / Mailing
> > Lists
> > > > >
> --------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from). You
> may
> > > > > also send the HELP command for other information (like
> subscribing).
> > > > >
> > > > >
> > > > > --
> > > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > > --
> > > > > Author:
> > > > > INET: tday6_at_csc.com
> > > > >
> > > > > Fat City Network Services -- (858) 538-5051 FAX: (858)
> 538-5051
> > > > > San Diego, California -- Public Internet access / Mailing
> > Lists
> > > > >
> --------------------------------------------------------------------
> > > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and
> in
> > > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > > (or the name of mailing list you want to be removed from). You
> may
> > > > > also send the HELP command for other information (like
> subscribing).
> > > >
> > > > --
> > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > > --
> > > > Author: Igor Neyman
> > > > INET: ineyman_at_perceptron.com
> > > >
> > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > > San Diego, California -- Public Internet access / Mailing
> Lists
> > > > --------------------------------------------------------------------
> > > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > > (or the name of mailing list you want to be removed from). You may
> > > > also send the HELP command for other information (like subscribing).
> > > >
> > > >
> > > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author: Igor Neyman
> > > INET: ineyman_at_perceptron.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > >
> > >
> > >
> > > --
> > > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > > --
> > > Author:
> > > INET: Jared.Still_at_radisys.com
> > >
> > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > > San Diego, California -- Public Internet access / Mailing Lists
> > > --------------------------------------------------------------------
> > > To REMOVE yourself from this mailing list, send an E-Mail message
> > > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > > the message BODY, include a line containing: UNSUB ORACLE-L
> > > (or the name of mailing list you want to be removed from). You may
> > > also send the HELP command for other information (like subscribing).
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author: John Dunn
> > INET: john.dunn_at_sefas.co.uk
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> >
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.com
> > --
> > Author:
> > INET: Jared.Still_at_radisys.com
> >
> > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> > San Diego, California -- Public Internet access / Mailing Lists
> > --------------------------------------------------------------------
> > To REMOVE yourself from this mailing list, send an E-Mail message
> > to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> > the message BODY, include a line containing: UNSUB ORACLE-L
> > (or the name of mailing list you want to be removed from). You may
> > also send the HELP command for other information (like subscribing).
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author: John Dunn
> INET: john.dunn_at_sefas.co.uk
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
>
>
>
> --
> Please see the official ORACLE-L FAQ: http://www.orafaq.com
> --
> Author:
> INET: Jared.Still_at_radisys.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Igor Neyman
  INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from).  You may
also send the HELP command for other information (like subscribing).