RE: Oracle and nfs mounted devices.[Scanned]

From: Bob Metelsky <bmetelsky_at_cps92.com>
Date: Thu, 02 Oct 2003 08:09:33 -0800
Message-ID: <F001.005D1D2F.20031002080933@fatcity.com>

I am not a guru (as any one here can attest... <g> but

The last line tell you what the problem is " O/S-Error: (OS 3) The system cannot find the path specified."

Oracle cant find the path, you probably need to pass it something like

\\server_name\d$\oracle\oradata\mmstest\test.dbf providing the oracle on d is shared out

bob

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: Bob Metelsky
  INET: bmetelsky_at_cps92.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). Received on Thu Oct 02 2003 - 11:09:33 CDT