OraFAQ Forum: Server Utilities » EXPDP getting error ORA-39002

Home » RDBMS Server » Server Utilities » EXPDP getting error ORA-39002 (Export: Release 10.1.0.3.0 - 64bit Production on Friday, 20 June, 2014 13:34)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

EXPDP getting error ORA-39002 [message #616804]

Fri, 20 June 2014 13:57

iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock

Junior Member

Hello ALL,

Looking for help getting started with expdp. Running on a Solaris box with Oracle 10g. I have created the directory object in Oracle and granted READ/Write to that object. I created the same directory under the OS. Then I run the following with these results:

expdp username@databasename PARFILE=dump.par

Export: Release 10.1.0.3.0 - 64bit Production on Friday, 20 June, 2014 13:34

Copyright (c) 2003, Oracle. All rights reserved.
Password:

Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.3.0 - 64bit Production
With the Partitioning and Data Mining 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 475
ORA-29283: invalid file operation

Here is what my PARFILE contains:
TABLES=user.t1,user.t2
VERSION=10.1
DIRECTORY=dumpdp
LOGFILE=dpumpt1.log
DUMPFILE=dpumpt1.dmp
CONTENT=DATA_ONLY

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616805 is a reply to message #616804]

Fri, 20 June 2014 14:01

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

Welcome to this forum.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/ and please read http://www.orafaq.com/forum/t/174502/102589/

my first guess would be that the current OS user does not have OS write permission on the current OS directory

issue following OS commands

id
ls -ld ./

COPY the results from above then PASTE all back here

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616806 is a reply to message #616805]

Fri, 20 June 2014 14:18

iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock

Junior Member

[host]: id
uid=1438(conv) gid=330(dsaqsep)
[host]: ls -ld ./
drwxrwxrw- 2 conv dsaqse 512 Jun 20 14:12 ./
[host]:

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616815 is a reply to message #616806]

Fri, 20 June 2014 14:49

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

usually expdb is run against local database and no "@databasename" is specified.

Are you purposefully trying to export from some remote database?

what results from following OS command

pwd

BTW V10.1 is obsoleted, unsupported & VERY buggy. IMO, it should be avoided at all costs.

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616817 is a reply to message #616815]

Fri, 20 June 2014 14:56

iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock

Junior Member

I am not exporting against a remote database. The database is on the same server as the expdp executable, but there are multiple databases on that same server, so I am telling the expdp command which database to log into.

The results of the pwd command:
I am sitting in the directory referenced by the Oracle directory object....

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616818 is a reply to message #616817]

Fri, 20 June 2014 15:02

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>The results of the pwd command:
>I am sitting in the directory referenced by the Oracle directory object....

do NOT tell us what you think you see.
SHOW US!

>The database is on the same server as the expdp executable
then do similar to below

export ORACLE_SID=EXPDP_DB

& do not include "@databasename" on the command line.

I still believe the lack of OS permission is what results in the UTL_FILE error

Report message to a moderator

Re: EXPDP getting error ORA-39002 [message #616823 is a reply to message #616818]

Fri, 20 June 2014 16:08

iufaninark
Messages: 4
Registered: June 2014
Location: Little Rock

Junior Member

You must be right in that it is an OS permission error. It appears that expdp is actually using the owner (OS owner) of that utility to write out the files (dump and log files). I tried the same command (but created another Oracle Directory object pointing to a directory that OS owner of the expdp utility also owned. I put my parfile (still owned by me) in that directory and it worked.

So the id issuing the expdp command does not need write access to the directory but the owner of the Oracle utility (Oracle itself) does.

Report message to a moderator

Previous Topic:	SQL Loader to fail in Warning and send email notifications
Next Topic:	EXPDP hangs

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Jan 10 12:09:14 CST 2025