My group has a 2 node RAC, Oracle 12.2.0 database on an Oracle Linux 7 server. We are trying to perform a Data Pump schema export to an external Windows 2012R2 folder. The following is the result of running the script:
Export: Release 12.2.0.1.0 - Production on Wed Sep 4 11:39:43 2019
Copyright (c) 1982, 2017, Oracle and/or its affiliates. All rights reserved.
Connected to: Oracle Database 12c Enterprise Edition Release 12.2.0.1.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-29283: invalid file operation
Here is the shell script. I have replaced identifying names, but the format remains.
expdp DBA_UserID@DB_SID/DBA_password DIRECTORY=DAILYEXP DUMPFILE=export_$(date +\%Y\%m\%d).dmp SCHEMAS=<all schemas we want to export> COMPRESSION=ALL logfile=DAILYEXP:export$(date +\%Y\%m\%d).log
The DAILYEXP has been declared as a DIRECTORY for the main schema, owned by SYS, with READ, WRITE, EXECUTE for the DBA_UserID in the script. We recently migrated the database from a Windows 2012R2 server to a Linux 7 server. This script used to work in Windows, but my limited Linux experience (HP/UX from 1987) prevents me from figuring it out myself. The SysAdmin assured me the Windows server and folder have the proper permissions for Linux/Unix to READ and WRITE to the folder.
Any help would be greatly appreciated.