Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Failed for Windows Oracle create data file into Samba Share from UNIX

kimcheeMar 19 2020 — edited Mar 20 2020

Hi,

Recently, one of my Windows server for Oracle UAT is not enough harddisk space.

So, developer suggest to use the "space" from another UNIX server.

I had successful using SAMBA share from UNIX server and map to Windows server as E:

But when come to create database file, it return errors:-

create tablespace DATA1 datafile 'E:\oradata\ubiuat15\DATA1.DBF' size 10M

*

ERROR at line 1:

ORA-01119: error in creating database file 'E:\oradata\ubiuat15\DATA1.DBF'

ORA-27040: file create error, unable to create file

OSD-04002: unable to open file

O/S-Error: (OS 3) The system cannot find the path specified.

Windows Server:-

01. Windows Server 2008 R2 Standard SP1

02. No Domain.

03. Oracle 11g R2 Enterprise Edition

04. Map Network Drive E: \\UNIX_IP_Address\u04 with local user "oracle".

05. Login as administrator, able to create folder, rename file, delete file, modify file content.

06. Use SQLPLUS, able to spool but when try to create data file, return errors as above.

UNIX Server:-

01. SunOS 5.10

02. tail -10 /etc/samba/smb.conf

[u04]

   comment = CPAM stuff

   path = /u04

   force users = oracle

   public = no

   writable = yes

   printable = no

   create mask = 0765

   force group = oinstall

03. Unix user "oracle" added into samba as smbuseradd

Any idea for me to fix ?

This post has been answered by Mathias Zarick on Mar 20 2020
Jump to Answer
Comments
Post Details
Added on Mar 19 2020
11 comments
476 views