Re: Oracle and nfs mounted devices.

IIRC, you will also need to change who is the running owner of the oracle process. In WinNT/2k, this defaults to SYSTEM. You need to create an ORACLE user on each system and change the instance owner to ORACLE. Then deal with the normal permissions stuff. There should be a note on metalink on how to accomplish this, along with a warning that this is not a supported configuration.

Daniel

Yechiel Adar wrote:

> I think that you need to check the sharing options on the remote computer.
>
> Make sure that the user that run the create database has full control on
> oracle in the remote server.
>
> Yechiel Adar
> Mehish
> ----- Original Message -----
> To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> Sent: Thursday, October 02, 2003 5:44 PM
>
> >
> > Hello Gurus:
> >
> > I have been asked to create datafiles (create tablespace) on disk drives
> > that are mapped ( internal disk - attached to remote servers)
> >
> > When I tried creating tablespace...I get the following error message:
> >
> >
> > ERROR at line 1:
> > ORA-01119: error in creating database file
> > 'd:\oracle\oradata\mmstest\test.dbf'
> > ORA-27040: skgfrcre: create error, unable to create file
> > OSD-04002: unable to open file
> > O/S-Error: (OS 3) The system cannot find the path specified.
> >
> >
> > My opinion is Oracle does not support this operation.
> >
> > However I do not fully understand the internals of it...Is oracle not able
> > to obtain locks on the device?
> >
> > Please Help.
> >
> > Thanks,
> > Murali.
> >
> >
> > --
> > Please see the official ORACLE-L FAQ: http://www.orafaq.net
> > --
> > Author:
> > INET: Murali_Pavuloori/Claritas_at_claritas.com
> >
> > Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> > San Diego, California -- Mailing list and web hosting services
> > ---------------------------------------------------------------------
> > 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.net
> --
> Author: Yechiel Adar
> INET: adar76_at_inter.net.il
>
> Fat City Network Services -- 858-538-5051 http://www.fatcity.com
> San Diego, California -- Mailing list and web hosting services
> ---------------------------------------------------------------------
> 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.net
-- 
Author: Daniel Fink
  INET: Daniel.Fink_at_Sun.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------
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).



text/x-vcard attachment: Card for Daniel Fink