Database Software

Hello.

I've followed all the required steps in order to start using expdp on a database.

0 - Set the sid name using ". oraenv"
1 - create user dpuser identified by dpuser;
2 - create or replace directory datapump AS '/u02/expdp/dbname';
3 - grant exp_full_database,connect, resource to dpuser;
4 - grant read, write on directory datapump to dpuser;

This is the content of the directory.

/u02/expdp/dbname> ls -la
drwxrwxr-x 3 oracle dba 4096 Apr 22 14:14 .
drwxrwxr-x 6 oracle dba 4096 Apr 22 09:12 ..

It's empty.

Then, i've tried to run the expdp for the whole database from that directory.

expdp dpuser/dpuser full=y DIRECTORY=datapump DUMPFILE=datapump:test.dmp logfile=datapump:test.log;

This is the error I got.

Export: Release 10.2.0.4.0 - 64bit Production on Wednesday, 22 April, 2009 14:18:32
Copyright (c) 2003, 2007, Oracle. All rights reserved.
Connected to: Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/u02/expdp/dbname/test.dmp"
ORA-27086: unable to lock file - already in use
Linux-x86_64 Error: 13: Permission denied
Additional information: 9
Additional information: 13

And finally, this is the directory again.

/u02/expdp/dbname> ls -la
drwxrwxr-x 3 oracle dba 4096 Apr 22 14:16 .
drwxrwxr-x 6 oracle dba 4096 Apr 22 09:12 ..
-rw-rw---- 1 oracle dba 4096 Apr 22 14:16 test.dmp
-rw-rw-r-- 1 oracle dba 592 Apr 22 14:16 test.log

ARGGGGGGGHHHHH!!!!.

Who is using the file? There wasn't any file there and I've just created the files (test.dmp and test.log)

Oracle should be more descriptive with the error messages :P

Thanks for any help you can provide me.
Alex.

Edited by: Actitud on Apr 22, 2009 5:36 PM