expdp and network drive issue
603099Sep 13 2010 — edited Oct 1 2010My database on windows 2003 server is on 10.2.0.4 . Basicallly the export dumps from this windows box need to be transferred to linux box and a platform migration done on Linux. To avoid creating local dump files in windows and then transferring them to linux, we are trying to place the dump files directly on network share
I followed all points in note Running UTL_FILE on Windows NT [ID 45172.1] but still I see issue when doing the expdp over netwok drive
This is what was done
a)The n/w drive share was added to utl file dir in init.ora and db restarted.this was again UNC format
b)A directory object was created using the UNC format
c)The oracle service as well as listener was started as oracle user rather then local system user.
The error seen is :
E:\temp\expimp>expdp "'/ as sysdba'" parfile=test.dat
Export: Release 10.2.0.4.0 - Production on Monday, 13 September, 2010 13:49:17
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - Produc
tion
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39002: invalid operation
ORA-39070: Unable to open the log file.
ORA-29283: invalid file operation
ORA-06512: at "SYS.UTL_FILE", line 488
ORA-29283: invalid file operation
What I have noticed is that when I try to map the network drive as Y: , it asks me for user name and password. So my question is should I be starting the oracle service and listener as this user ie user xxx which I used to map the network drive
But when i tried this, I was able to start the oracle service but it didnt start listener service
Also one more thing is that am using a remote desktop connection to access the windows server and a metalink note says the error can occur when using remote desktop
Not able to access mapped drive when using Windows Terminal Service [ID 271495.1]
Thanks