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