Home » Infrastructure » Linux » Data Pump expdp to root directory (OEL 5.5 , Oracle 11.2.0.2.0)
Data Pump expdp to root directory [message #524113] Wed, 21 September 2011 21:46 Go to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

Test server expdp is ok, real server has many ora error, can you see help about this?

In my test server I had directory NFS_EXPORTS /home/oracle/exports, DATA_PUMP_DIR /home/oracle/admin/filtdb/dpdump/

drwxr-x--- 2 oracle oinstall 4096 9월 22 10:21 dpdump
drwxrwxrwx 2 root root 4096 9월 22 10:19 exports

and running expdp
export ORACLE_BASE=/home/oracle
export ORACLE_HOME=$ORACLE_BASE/app/product/11.2.0
export ORACLE_SID=filtdb
export PATH=$PATH:/usr/kerberos/bin:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/home/oracle/bin:/home/oracle/app/product/11.2.0/bin:/home/timesten/TimesTen/sfs/bin
expdp ***/****@** dumpfile=TM-`date '+%d%m%Y_%H%M%S'`.dmp directory=nfs_exports logfile=DATA_PUMP_DIR:TM-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TM_EXPDP_FILTDB tables=TM_SFS_STUDY_INFO_JOB
. . exported "ORAASFS"."TO_SFS_STUDY_INFO_JOB"               0 KB       0 rows
Master table "ORAASFS"."TO_EXPDP_FILTDB" successfully loaded/unloaded
******************************************************************************
Dump file set for ORAASFS.TO_EXPDP_FILTDB is:
  /home/oracle/exports/TO-22092011_111912.dmp
Job "ORAASFS"."TO_EXPDP_FILTDB" successfully completed at 11:20:08

In the real server
NFS_EXPORTS /home/oracle/exports DATA_PUMP_DIR /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/
drwxrwxrwx 2 root root 4096 Sep 22 11:08 exports
drwxrwxrwx 2 oracle oinstall 4096 Aug 9 02:00 log
and running expdp
export ORACLE_BASE=/u01/app/oracle
export ORACLE_HOME=/u01/app/oracle/product/11.2.0/dbhome_1
export ORACLE_SID=filtdb1
export PATH=$PATH:/usr/local/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/11.2.0/grid/bin:/u01/app/oracle/product/11.2.0/dbhome_1/jdk/bin:/bin:/usr/bin:/home/oracle/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch:/u01/app/11.2.0/grid/bin:/opt/oracle.SupportTools:/opt/oracle.SupportTools/ibdiagtools:/opt/oracle.SupportTools/onecommand:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin:/u01/app/oracle/product/11.2.0/dbhome_1/lib:/usr/local/sbin:/usr/local/bin:/sbin:/bin:/usr/sbin:/usr/bin:/root/bin:/bin:/usr/bin:/root/bin:/u01/app/oracle/product/11.2.0/dbhome_1/bin:/u01/app/oracle/product/11.2.0/dbhome_1/OPatch:/u01/app/11.2.0/grid/bin:/opt/oracle.SupportTools:/opt/oracle.SupportTools/ibdiagtools:/opt/oracle.SupportTools/onecommand:/usr/local/bin:/bin:/usr/bin:/usr/X11R6/bin:/usr/kerberos/bin
expdp ***/***/@***/ dumpfile=CUST-`date '+%d%m%Y_%H%M%S'`.dmp directory=asmexpdir logfile=DATA_PUMP_DIR:CUST-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TM_EXPDP_FILTDB tables=TM_STUDY_INFO_JOB
ORA-39001: invalid argument value
ORA-39000: bad dump file specification
ORA-31641: unable to create dump file "/home/oracle/exports/CONFIG-22092011_114326.dmp"
ORA-27040: file create error, unable to create file
Linux-x86_64 Error: 2: No such file or directory




[EDITED by LF: masked login credentials]

[Updated on: Thu, 22 September 2011 00:04] by Moderator

Report message to a moderator

Re: Data Pump expdp to root directory [message #524116 is a reply to message #524113] Wed, 21 September 2011 22:24 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
ls -l /home/oracle/exports/CONFIG-22092011_114326.dmp
ls -ltr /home/oracle/exports/*
ls -ld /home/oracle/exports/
ls -ld /home/oracle/
ls -ld /home/

post formatted results from above
Re: Data Pump expdp to root directory [message #524121 is a reply to message #524116] Wed, 21 September 2011 23:12 Go to previous messageGo to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

In Test server
[oracle@testdb exports]$ ls -l CONFIG-22092011_110506.dmp
-rw-r----- 1 oracle dba 1589248  9월 22 11:03 CONFIG-22092011_110506.dmp
[oracle@testdb exports]$ ls -ltr /home/oracle/exports/*
-rw-r--r-- 1 oracle oinstall         0  9월 19 13:08 /home/oracle/exports/test.txt
-rw-r--r-- 1 oracle oinstall       103  9월 19 13:14 /home/oracle/exports/export.sh
-rw-r--r-- 1 oracle oinstall     16384  9월 19 13:14 /home/oracle/exports/oraasfs_exp.dmp
-rw-r--r-- 1 oracle oinstall       538  9월 19 13:14 /home/oracle/exports/oraasfs_Exp.log
-rw-r--r-- 1 oracle oinstall         0  9월 20 17:27 /home/oracle/exports/test2.txt
-rw-r----- 1 oracle dba           4096  9월 20 17:37 /home/oracle/exports/CUST-20092011_173855.dmp
-rw-r----- 1 oracle dba           4096  9월 20 17:39 /home/oracle/exports/FILTER-20092011_174036.dmp
-rw-r----- 1 oracle dba           4096  9월 20 17:41 /home/oracle/exports/CONFIG-20092011_174208.dmp
-rw-r----- 1 oracle dba      589332480  9월 22 10:19 /home/oracle/exports/CUST-22092011_101442.dmp
-rw-r----- 1 oracle dba        1789952  9월 22 10:19 /home/oracle/exports/FILTER-22092011_102119.dmp
-rw-r----- 1 oracle dba        1589248  9월 22 10:20 /home/oracle/exports/CONFIG-22092011_102130.dmp
-rw-r----- 1 oracle dba      589332480  9월 22 11:03 /home/oracle/exports/CUST-22092011_105826.dmp
-rw-r----- 1 oracle dba        1789952  9월 22 11:03 /home/oracle/exports/TAIC-22092011_110418.dmp
-rw-r----- 1 oracle dba        1589248  9월 22 11:03 /home/oracle/exports/CONFIG-22092011_110506.dmp
-rw-r----- 1 oracle dba        1789952  9월 22 11:10 /home/oracle/exports/TAIC-22092011_111043.dmp
-rw-r----- 1 oracle dba        1703936  9월 22 11:11 /home/oracle/exports/TO-22092011_111240.dmp
-rw-r----- 1 oracle dba      667422720  9월 22 11:12 /home/oracle/exports/TM-22092011_110647.dmp
-rw-r----- 1 oracle dba        1703936  9월 22 11:18 /home/oracle/exports/TO-22092011_111912.dmp
-rw-r----- 1 oracle dba      667422720  9월 22 11:22 /home/oracle/exports/TM-22092011_111656.dmp
-rw-r----- 1 oracle dba        1789952  9월 22 11:22 /home/oracle/exports/TAIC-22092011_112420.dmp
-rw-r----- 1 oracle dba        1703936  9월 22 11:23 /home/oracle/exports/TO-22092011_112430.dmp
-rw-r----- 1 oracle dba      667422720  9월 22 11:43 /home/oracle/exports/TM-22092011_113700.dmp
[oracle@testdb exports]$ ls -ld /home/oracle/exports/
drwxrwxrwx 2 root root 4096  9월 22 11:35 /home/oracle/exports/
[oracle@testdb exports]$ ls -ld /home/oracle/
drwxr-xr-x 37 oracle oinstall 57344  9월 22 11:06 /home/oracle/
[oracle@testdb exports]$ ls -ld /home/
drwxr-xr-x 11 oracle oinstall 4096  9월 21 17:21 /home/


In real server
[oracle@filtdb01 exports]$ ls -l CONFIG-22092011_110506.dmp
ls: CONFIG-22092011_110506.dmp: No such file or directory
[oracle@filtdb01 exports]$ ls -ltr /home/oracle/exports/*
-rw-r--r-- 1 root root 0 Sep 22 10:10 /home/oracle/exports/test.txt
[oracle@filtdb01 exports]$ ls -ld /home/oracle/exports/
drwxrwxrwx 2 root root 4096 Sep 22 13:07 /home/oracle/exports/
[oracle@filtdb01 exports]$ ls -ld /home/oracle/
drwx------ 16 oracle oinstall 4096 Sep 22 11:27 /home/oracle/
[oracle@filtdb01 exports]$  ls -ld /home/
drwxr-xr-x 3 oracle oinstall 4096 Aug  3 02:31 /home/


Regards
Re: Data Pump expdp to root directory [message #524122 is a reply to message #524113] Wed, 21 September 2011 23:18 Go to previous messageGo to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

difference can be
ls -ld /home/oracle/

but after I change real server chmod 755 /home/oracle/
same error message comming.

[Updated on: Wed, 21 September 2011 23:23]

Report message to a moderator

Re: Data Pump expdp to root directory [message #524124 is a reply to message #524122] Wed, 21 September 2011 23:26 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
chmod 775 /home/oracle/


does above change anything?
Re: Data Pump expdp to root directory [message #524127 is a reply to message #524124] Wed, 21 September 2011 23:45 Go to previous messageGo to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

chmod 775 /home/oracle/
resulted same error.

I may try to other directory, or use normal export option. expdp little complicated.
Re: Data Pump expdp to root directory [message #524128 is a reply to message #524127] Wed, 21 September 2011 23:47 Go to previous messageGo to next message
BlackSwan
Messages: 26275
Registered: January 2009
Location: SoCal
Senior Member
>I may try to other directory, or use normal export option. expdp little complicated.
It appears to be OS permissions issue
/tmp is useful for testing.
Re: Data Pump expdp to root directory [message #524321 is a reply to message #524128] Thu, 22 September 2011 23:49 Go to previous messageGo to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

drwxrwxrwt 7 root root 8192 Sep 23 13:47 tmp

to the real server temp was ok. permission is same except rwt, rwx difference.
I still can't fount out error point.

Starting "ORAASFS"."CUST_EXPDP_FILTDB": ****/********@**** dumpfile=CUST-23092011_134653.dmp directory=exp_temp logfile=DATA_PUMP_DIR:CUST-23092011_134653.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=CUST_EXPDP_FILTDB tables=TM_SFS_CUST_01
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 2.406 GB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/COMMENT
. . exported "ORAASFS"."TM_SFS_CUST_01" 140.5 MB 1078144 rows
Master table "ORAASFS"."CUST_EXPDP_FILTDB" successfully loaded/unloaded
******************************************************************************
Dump file set for ORAASFS.CUST_EXPDP_FILTDB is:
/tmp/CUST-23092011_134653.dmp
Job "ORAASFS"."CUST_EXPDP_FILTDB" successfully completed at 13:47:01

Re: Data Pump expdp to root directory [message #524349 is a reply to message #524321] Fri, 23 September 2011 03:50 Go to previous messageGo to next message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

I succeed with same log directory of default oracle log directory to my dumpfile directory.
expdp need more consistency to me, because last time I couldn't expdp and leave log file to other directory other than DATA_PUMP_DIR.
I still can't figure out why I can't expdp to /home/oracle/exports NFS_EXPORTS directory.

[oracle@fS]$ expdp ****/****@*****dumpfile=TAIC-`date '+%d%m%Y_%H%M%S'`.dmp directory=DATA_PUMP_DIR logfile=DATA_PUMP_DIR:TAIC-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TAIC_EXPDP_FILTDB tables=TA_S6T_ALM_CD

Export: Release 11.2.0.2.0 - Production on Fri Sep 23 17:43:47 2011

Copyright (c) 1982, 2009, Oracle and/or its affiliates.  All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
Starting "****"."TAIC_EXPDP_FILTDB":  ****/********@****dumpfile=TAIC-23092011_174347.dmp directory=DATA_PUMP_DIR logfile=DATA_PUMP_DIR:TAIC-23092011_174347.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TAIC_EXPDP_FILTDB tables=TA_S6T_ALM_CD
Estimate in progress using BLOCKS method...
Processing object type TABLE_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 3 MB
Processing object type TABLE_EXPORT/TABLE/TABLE
Processing object type TABLE_EXPORT/TABLE/INDEX/INDEX
Processing object type TABLE_EXPORT/TABLE/CONSTRAINT/CONSTRAINT
Processing object type TABLE_EXPORT/TABLE/COMMENT
. . exported "****"."TA_S6T_ALM_CD"                   13.34 KB     116 rows
Master table "****"."TAIC_EXPDP_FILTDB" successfully loaded/unloaded
******************************************************************************
Dump file set for ****.TAIC_EXPDP_FILTDB is:
  /u01/app/oracle/product/11.2.0/dbhome_1/rdbms/log/TAIC-23092011_174347.dmp
Job "****"."TAIC_EXPDP_FILTDB" successfully completed at 17:43:50

[Updated on: Fri, 23 September 2011 04:01]

Report message to a moderator

Re: Data Pump expdp to root directory [message #524802 is a reply to message #524349] Mon, 26 September 2011 21:42 Go to previous message
s197oo302
Messages: 50
Registered: January 2011
Location: seoul
Member

To DATA_PUMP_DIR is unsuccesful also. I can't find any file on /home/oracle/exports

I succeded with another method, I have to do expdp with sysdba, that time everything was fine with (service nfslock start).

[code]
expdp \"/ as sysdba\" dumpfile=TM-`date '+%d%m%Y_%H%M%S'`.dmp directory=NFS_EXPORTS logfile=NFS_EXPORTS:TM-`date '+%d%m%Y_%H%M%S'`.log EXCLUDE=STATISTICS CONTENT=ALL JOB_NAME=TM_EXPDP_FILTDB tables=oraasfs.TM_SFS_CUST_01

Previous Topic: Enterprise Manager error
Next Topic: DB creation with dbca command line
Goto Forum:
  


Current Time: Mon Nov 19 03:55:23 CST 2018