Oracle 11.2.0.4 SE One 64-bit
Windows 2012
Overall project is to move database from 32-bit Windows 2008 to 64-bit Windows 2012
Using expdp/impdp to move selected schemas into pre-created new database.
Movement of the schemas is working fine but having issue with some follow-up work.
One of the scripts (.cmd file) to be moved executes expdp on selected schemas. On execution it returns
Connected to: Oracle Database 11g Release 11.2.0.4.0 - 64bit Production
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-39087: directory name DPUMP_SCHEMA is invalid
The directory object in the db does exist:
SQL> select * from dba_directories where directory_name='DPUMP_SCHEMA';
OWNER DIRECTORY_NAME DIRECTORY_PATH
---------- ------------------------------ ------------------------------
SYS DPUMP_SCHEMA G:\orcl\dpump
And the specified directory does exist:
SQL> host dir G:\orcl\dpump
Volume in drive G is Oracle Backup and Archlogs
Volume Serial Number is 1C9C-1F4D
Directory of G:\orcl\dpump
12/16/2015 10:00 AM <DIR> .
12/16/2015 10:00 AM <DIR> ..
0 File(s) 0 bytes
2 Dir(s) 108,017,045,504 bytes free
As far as I can tell the only thing not accounted for is possibly permissions on the directory. Looking at those, they APPEAR to be good, but we are dealing with Windows here, and permissions on Windows have always been a bit of a mystery to me.
FWIW, there is also a directory "G:\orcl\rman" where the rman backups and runtime logs go, and there is no problem with those jobs. I can find no differentiation between permissions on g:\orcl\rman and g:\orcl\dpump but again, with Windows Security, I'm not sure what I'm looking at/for.
The database software was installed by a domain account (<domain>\OraAdmin) and all of these directories were created by the same account. That domain account is a member of the local Administrators group.