Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> Re: moving from unix to NT

Re: moving from unix to NT

From: <Jared.Still_at_radisys.com>
Date: Tue, 26 Feb 2002 13:36:58 -0800
Message-ID: <F001.0041929D.20020226133658@fatcity.com>


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

> > 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).
Received on Tue Feb 26 2002 - 15:36:58 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US