Oracle-L: Re: moving from unix to NT

From: Joe Testa <teci_at_the-testas.net>
Date: Tue, 26 Feb 2002 13:53:51 -0800
Message-ID: <F001.00419320.20020226135351@fatcity.com>

prior to 9i, you're stuck with utl_file_dir for logminer.

as for utl_file, it has its place just rarely and for those of us perl-impaired(and having no desire to learn it), it works :)

joe

Jared.Still_at_radisys.com wrote:

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

-- 
Joe Testa, Oracle DBA
Nothing new to put here, hmmmmmm






-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: Joe Testa
  INET: teci_at_the-testas.net

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:53:51 CST