Thank you guys. I was finally able to create the tablespace on the mapped
drive.
I do realize that placing datafiles on network devices is not the right
thing and is not supported by oracle.
Thanks again for the help. You are the best!
Murali.
|---------+---------------------------->
| | Branimir Petrovic|
| | <[EMAIL PROTECTED]|
| | om> |
| | Sent by: |
| | [EMAIL PROTECTED]|
| | .com |
| | |
| | |
| | 10/02/2003 12:39 |
| | PM |
| | Please respond to|
| | ORACLE-L |
| | |
|---------+---------------------------->
>--------------------------------------------------------------------------------------------------------------|
|
|
| To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]>
|
| cc:
|
| Subject: RE: Oracle and nfs mounted devices.
|
>--------------------------------------------------------------------------------------------------------------|
>
> 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.
>
I firmly believe that placing database files across the network is
one very bad idea indeed, however your problem most likely comes
from the fact that Oracle service runs as local (Windows) system
account and as such across the network it has exactly the level
of rights it deserves - none whatsoever. If you set the Oracle
service to run as recognized network user that have read/right
permissions on mapped drive - it might work, but it would still
be a bad-bad idea to go ahead and actually do so (teeny tiny
network 'hick up', and find yourself practicing recovery scenarios).
Branimir
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: Branimir Petrovic
INET: [EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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:
INET: Murali_Pavuloori/[EMAIL PROTECTED]
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: [EMAIL PROTECTED] (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).
