Skip to Main Content

Database Software

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!

expdp and network drive issue

603099Sep 13 2010 — edited Oct 1 2010
My 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
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 29 2010
Added on Sep 13 2010
1 comment
1,447 views