RE: help on UTL

From: <Yosi_at_comhill.com>
Date: Mon, 31 Jul 2000 16:54:12 -0400
Message-Id: <10575.113417@fatcity.com>

This message is in MIME format. Since your mail reader does not understand this format, some or all of this message may not be legible.

------_=_NextPart_001_01BFFB31.7ACF3092

Content-Type: text/plain;

charset="iso-8859-1"

The Oracle service runs as the system account (unless you've changed it). Often, someone will inadvertently replace permissions on the utl_file directories so that System has no access.

To verify, run an AT command to run c:\winnt\system32\cmd.exe, in interactive mode. I think syntax is:

at hh24:mi c:\winnt\system32\cmd.exe /interactive

or something like that. That should open a command window, AS SYSTEM. Then, try changing to the utl_file directory in that command window. If it says access denied, there's your answer. Ask your sysadmins to help you grant access back to system on the utl_file dirs. Tip: use the cacls utility to do the permission thing, the GUI does unexpected things, which is how you (may have) got(ten) messed up in the first place.

HTH, Yosi

-----Original Message-----

From: Makarand Natu [mailto:Makarand.Natu_at_originindia.com] Sent: Monday, July 31, 2000 12:32 PM
To: Multiple recipients of list ORACLE-L Subject: RE: help on UTL_FILE..

Yes, I have modified the init<SID>.ora file to include the parameter ULT_FILE_DIR pointing to the mapped dir. But the problem is still there.

-----Original Message-----
From: Dave Drienhuizen [SMTP:nldrien1_at_ey.nl] Sent: Monday, July 31, 2000 8:01 PM

To:     Multiple recipients of list ORACLE-L 
Subject:        Re: help on UTL_FILE.. 



	Did you specifiy your directory in the UTL_FILE_DIR parameter in the

init.ora ?

Makarand Natu <Makarand.Natu_at_originindia.com> on 31-07-2000 14:25:40

Please respond to ORACLE-L_at_fatcity.com

To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc: (bcc: Dave Drienhuizen/nldrien1/External/MEY/NL)

Hi Gurus,

I'm running Oracle 8.0.5 on NT-4 (SP3) on Server 1. Server 1 has a mapping E:\ pointing to Server 2\share directory. I'm trying to read a file on E:\ by using UTL_FILE package. But is is raising an
INVALID_OPERATION
exception.
I have checked the file access and that is fine. Also the paths specified in

UTL_FILE.FOPEN call are correct.
Help requested..

TIA, Makarand Natu

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

The information contained in this communication is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying, distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt.

--
Author: Dave Drienhuizen
INET: nldrien1_at_ey.nl

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

------_=_NextPart_001_01BFFB31.7ACF3092

Content-Type: text/html;

charset="iso-8859-1"

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<TITLE>RE: help on UTL_FILE..</TITLE>

<META content="MSHTML 5.00.2919.6307" name=GENERATOR></HEAD>

<BODY>
<DIV>The Oracle service runs as the system account (unless you've changed it). Often, someone will inadvertently replace permissions on the utl_file directories so that System has no access. </DIV> <DIV> </DIV> <DIV>To verify, run an AT command to run c:\winnt\system32\cmd.exe, in interactive mode. I think syntax is:</DIV> <DIV> </DIV> <DIV>    at hh24:mi c:\winnt\system32\cmd.exe /interactive</DIV>
<DIV> </DIV> <DIV>or something like that. That should open a command window, AS SYSTEM. Then, try changing to the utl_file directory in that command window. If it says access denied, there's your answer. Ask your sysadmins to help you grant access back to system on the utl_file dirs. Tip: use the cacls utility to do the permission thing, the GUI does unexpected things, which is how you (may have) got(ten) messed up  in the first place.</DIV>
<DIV> </DIV>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=611045820-31072000>HTH,</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=611045820-31072000> </DIV>

<DIV><FONT color=#0000ff face=Arial size=2><SPAN 
class=611045820-31072000>Yosi</SPAN></FONT></DIV>
<DIV><FONT color=#0000ff face=Arial size=2><SPAN

class=611045820-31072000> </DIV> <BLOCKQUOTE
style="BORDER-LEFT: #0000ff 2px solid; MARGIN-LEFT: 5px; PADDING-LEFT: 5px"> <DIV align=left class=OutlookMessageHeader dir=ltr>-----Original Message----- From: Makarand Natu [mailto:Makarand.Natu_at_originindia.com] Sent: Monday, July 31, 2000 12:32 PM To: Multiple recipients of list ORACLE-L Subject: RE: help on UTL_FILE.. </DIV> Yes, I have modified the init<SID>.ora file to include the parameter ULT_FILE_DIR pointing to the mapped dir. But the problem is still there. 
 <UL>
 -----Original Message----- From:   Dave Drienhuizen [SMTP:nldrien1_at_ey.nl] Sent:   Monday, July 31, 2000 8:01 PM <FONT face=Arial

    size=1>To:&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT face=Arial 
    size=1>Multiple recipients of list ORACLE-L</FONT> <BR><B><FONT face=Arial 
    size=1>Subject:&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;</FONT></B> <FONT 
    face=Arial size=1>Re: help on UTL_FILE..</FONT> </P><BR><BR>

Did you specifiy your directory in the UTL_FILE_DIR parameter in the init.ora ? Makarand Natu <Makarand.Natu_at_originindia.com> on 31-07-2000 14:25:40 Please respond to ORACLE-L_at_fatcity.com

To:   Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> cc:    (bcc: Dave Drienhuizen/nldrien1/External/MEY/NL)

    <P><FONT face=Arial size=2>Hi Gurus,</FONT> </P><BR>
    <P><FONT face=Arial size=2>I'm running Oracle 8.0.5 on NT-4 (SP3) on Server 
    1.</FONT> <BR><FONT face=Arial size=2>Server 1 has a mapping E:\&nbsp;&nbsp;

pointing to Server 2\share directory. I'm trying to read a file on E:\ by using UTL_FILE package. But is is raising an INVALID_OPERATION exception. I have checked the file access and that is fine. Also the paths specified in

    <BR><FONT face=Arial size=2>UTL_FILE.FOPEN call are correct.</FONT> 
    <BR><FONT face=Arial size=2>Help requested..</FONT> </P><BR>
    <P><FONT face=Arial size=2>TIA,</FONT> </P><BR>
    <P><FONT face=Arial size=2>Makarand Natu</FONT> 
    </P><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR><BR>
    <P><FONT face=Arial 
    size=2>===================================================================</FONT>

De informatie verzonden met dit E-mail bericht is uitsluitend bestemd voor de geadresseerde. Gebruik van deze informatie door anderen dan de geadresseerde is verboden. Openbaarmaking, vermenigvuldiging, verspreiding en/of verstrekking van deze informatie aan derden is niet toegestaan. Ernst & Young staat niet in voor de juiste en volledige overbrenging van de inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.

    <BR><FONT face=Arial 
    size=2>===================================================================</FONT> 
    <BR><FONT face=Arial size=2>The information contained in this communication

is confidential and may be legally privileged. It is intended solely for the use of the individual or entity to whom it is addressed and others authorised to receive it. If you are not the intended recipient you are hereby notified that any disclosure, copying,  distribution or taking any action in reliance on the contents of this information is strictly prohibited and may be unlawful. Ernst & Young is neither liable  for the proper and complete transmission of the information contained in this communication nor for any delay in its receipt. <FONT face=Arial

    size=2>===================================================================</FONT>

-- Author: Dave Drienhuizen   INET: nldrien1_at_ey.nl 
 Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists <FONT face=Arial

    size=2>--------------------------------------------------------------------</FONT>

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 Received on Mon Jul 31 2000 - 15:54:12 CDT