| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Oracle and nfs mounted devices.
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|
| | <BranimirP_at_cpas.c|
| | om> |
| | Sent by: |
| | ml-errors_at_fatcity|
| | .com |
| | |
| | |
| | 10/02/2003 12:39 |
| | PM |
| | Please respond to|
| | ORACLE-L |
| | |
|---------+----------------------------> >--------------------------------------------------------------------------------------------------------------| | | | To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com> | | 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
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: BranimirP_at_cpas.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: 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).Received on Thu Oct 02 2003 - 13:19:32 CDT
 |
 |