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).