Home » RDBMS Server » Server Utilities » Error while doing an expdp for a large datafile (Oracle 10g Express Edition)
Error while doing an expdp for a large datafile [message #341798] Wed, 20 August 2008 06:11 Go to next message
thunder44
Messages: 4
Registered: August 2008
Junior Member
Hello,

I tried an export using expdp in oracle 10g express edition. It was working perfectly until when the db size reached 2.1 gb. I got the following error message:

---------------- Start of error message ----------------
Connected to: Oracle Database 10g Express Edition Release 10.2.0.1.0 - Production
Starting "SERVICE_2_8"."SYS_EXPORT_SCHEMA_05": service_2_8/******** LOGFILE=3_export.log DIRECTORY=db_pump DUMPFILE=service_2_8.dmp CONTENT=all
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
ORA-39125: Worker unexpected fatal error in KUPW$WORKER.GET_TABLE_DATA_OBJECTS while calling DBMS_METADATA.FETCH_XML_CLOB []
ORA-01116: error in opening database file 5
ORA-01110: data file 5: '/usr/lib/oracle/xe/oradata/service_3_0.dbf'
ORA-27041: unable to open file
Linux Error: 13: Permission denied
Additional information: 3

ORA-06512: at "SYS.DBMS_SYS_ERROR", line 95
ORA-06512: at "SYS.KUPW$WORKER", line 6235

----- PL/SQL Call Stack -----
object line object
handle number name
0x3b3ce18c 14916 package body SYS.KUPW$WORKER
0x3b3ce18c 6300 package body SYS.KUPW$WORKER
0x3b3ce18c 9120 package body SYS.KUPW$WORKER
0x3b3ce18c 1880 package body SYS.KUPW$WORKER
0x3b3ce18c 6861 package body SYS.KUPW$WORKER
0x3b3ce18c 1262 package body SYS.KUPW$WORKER
0x3b0f9758 2 anonymous block

Job "SERVICE_2_8"."SYS_EXPORT_SCHEMA_05" stopped due to fatal error at 03:04:34
---------------- End of error message ----------------

Selinux was disabled completely and I have put the permission of 0777 to the appropriate datafile.
Still, it is not working.

Can you please tell me how to solve this problem or do you have any ideas or suggestions regarding this?

[Updated on: Wed, 20 August 2008 06:15]

Report message to a moderator

Re: Error while doing an expdp for a large datafile [message #341818 is a reply to message #341798] Wed, 20 August 2008 07:33 Go to previous messageGo to next message
Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE
Senior Member

Are you sure you have full permission on datafile?
and did your total database size reach/cross above 4gb limit?

Re: Error while doing an expdp for a large datafile [message #341831 is a reply to message #341818] Wed, 20 August 2008 08:40 Go to previous messageGo to next message
thunder44
Messages: 4
Registered: August 2008
Junior Member
Hello Mohammed,

The following are the datafiles:
-rw-r----- 1 oracle dba 8.8M Aug 20 08:34 control.dbf
-rw-r----- 1 oracle dba 21M Aug 20 06:10 service_2_8.dbf
-rwxrwxrwx 1 oracle dba 2.1G Aug 20 05:13 service_3_0.dbf
-rw-r----- 1 oracle dba 571M Aug 20 08:30 sysaux.dbf
-rw-r----- 1 oracle dba 361M Aug 20 08:30 system.dbf
-rw-r----- 1 oracle dba 116M Aug 18 22:01 temp.dbf
-rw-r----- 1 oracle dba 176M Aug 20 08:30 undo.dbf
-rw-r----- 1 oracle dba 101M Aug 20 05:13 users.dbf

Total size = Between 3.4gb and 3.5gb which is less than 4gb of Express edition's limit.
I have given 0777 Linux permission (full permission) to the datafile service_3_0.dbf

Re: Error while doing an expdp for a large datafile [message #341978 is a reply to message #341831] Thu, 21 August 2008 00:02 Go to previous messageGo to next message
thunder44
Messages: 4
Registered: August 2008
Junior Member
Hello,

Still it is not working.
Re: Error while doing an expdp for a large datafile [message #341980 is a reply to message #341978] Thu, 21 August 2008 00:04 Go to previous messageGo to next message
babuknb
Messages: 1734
Registered: December 2005
Location: NJ
Senior Member

Hello,

Quote:
Linux Error: 13: Permission denied


Check your OS level.

Babu
Re: Error while doing an expdp for a large datafile [message #341993 is a reply to message #341980] Thu, 21 August 2008 00:51 Go to previous message
thunder44
Messages: 4
Registered: August 2008
Junior Member
Hello Babu,

What do you mean by checking your OS level and how do you do it?

Previous Topic: Can I merge two or more exported dumps(*.dmp) ?
Next Topic: datapump impdb error
Goto Forum:
  


Current Time: Fri Dec 02 16:20:26 CST 2016

Total time taken to generate the page: 0.29707 seconds