I am using TOAD for Oracle 126.96.36.199. I have been at my job since 11/2016, and have used TOAD for Windows based 11g and 12c databases. My group recently switched our 12c version to use the Linux OS. I was able to successfully connect to it and use all the functionality I have on Windows databases, until today.
We have a procedure that gathers information from the database, produces a file, then sends that file to another server. On Windows, we just created the file on the Oracle server and sent it on. With Linux, the tool we use to send the file, will not work. Therefore, the idea of a staging server was brought up. We did so and did a proof of concept by creating the file and saving it on a share on the staging server. It worked great. To do so, I added the path of the shared drive (\servername\directory) in Oracle Directories (for the database user). I connected to the Linux database in TOAD and changed the shared drive path to //servername/directory. When I run the procedure to build and send the file, I get an ORA-29283. I had the SysAdmin do the following:
mount -t cifs -o username=(domain user),domain= //servername/foldername /mnt/cifs/sharename
I can now see the drive on the Linux box, but cannot use the simple //servername/directory in Oracle Directories.
My colleagues and I have come to the conclusion that I am running TOAD on a Windows 7 box, connecting to a Linux 7 database, trying to access a share on a Windows Server 2012 R2 box... something is getting lost in translation. I can't find anyone that has a similar problem. Before I waste much more time on this, is what we want to do even possible? If so, how do I need to enter the directory path in Oracle Directories? Thank you in advance.