OraFAQ Forum: Server Utilities » Expdp Hangs in Oracle 11g

Home » RDBMS Server » Server Utilities » Expdp Hangs in Oracle 11g (Oracle11g(11.1.0.6.0), Windows 2003 Server)

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

Expdp Hangs in Oracle 11g [message #509277]

Fri, 27 May 2011 00:25

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

I am trying to export Schema using expdp command. but its going hang after few minutes. it seems that it stucks any where. Even I am trying with normal scott schema it is also hanging.

Can someone tell me why this is happening and what is the solution for this.

Attachment of exp log files

Regards
Pradeep

Attachment: xyz.log
(Size: 1.08KB, Downloaded 2308 times)

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509287 is a reply to message #509277]

Fri, 27 May 2011 01:12

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

I can't download file so I will try to guess, next time post inline the APPROPRIATE part of the file.

Lack of space in file system?
Query v$session to know on what the expdp session is waiting.

Regards
Michel

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509289 is a reply to message #509287]

Fri, 27 May 2011 01:17

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Here you are:

Export: Release 11.1.0.6.0 - 64bit Production on Thursday, 26 May, 2011 11:37:49

Copyright (c) 2003, 2007, Oracle.  All rights reserved.
;;; 
Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "IDEADB"."SYS_EXPORT_SCHEMA_19":  ideadb/******** dumpfile=xyz.dmp logfile=xyz.log directory=data_pump_dir 
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 11.28 GB
Processing object type SCHEMA_EXPORT/USER
Processing object type SCHEMA_EXPORT/SYSTEM_GRANT
Processing object type SCHEMA_EXPORT/ROLE_GRANT
Processing object type SCHEMA_EXPORT/DEFAULT_ROLE
Processing object type SCHEMA_EXPORT/TABLESPACE_QUOTA
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
Processing object type SCHEMA_EXPORT/TYPE/TYPE_SPEC
Processing object type SCHEMA_EXPORT/SEQUENCE/SEQUENCE
;;; Export> kill_job
Job "IDEADB"."SYS_EXPORT_SCHEMA_19" stopped due to fatal error at 13:31:20

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509296 is a reply to message #509289]

Fri, 27 May 2011 01:29

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Oh oh! So now impossible to know why it "hangs". Wink

Wink

Regards
Michel

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509302 is a reply to message #509289]

Fri, 27 May 2011 01:44

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

It does think it is going to write out 11G of data. That will take a while. If you query v$session_longops you will get some information on the progress. What about the dump file? Is it growing?

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509306 is a reply to message #509296]

Fri, 27 May 2011 01:53

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

Much more amount of space is there is datapump directory. Even I m trying to exp a normal scott schema it's going hang.

What should I do for this now. As you commented

""Oh oh! So now impossible to know why it "hangs". "" Confused

Confused

I am re running Scott Schema export using expdp and tell me what should I Do solve this issue.

Scott should not take this much of time... to complete the export.
=================================================
C:\Documents and Settings\Administrator>expdp scott/tiger dumpfile=scott_new.dmp
logfile=scott.log directory=exp_dump

Export: Release 11.1.0.6.0 - 64bit Production on Friday, 27 May, 2011 12:23:15

Copyright (c) 2003, 2007, Oracle. All rights reserved.

Connected to: Oracle Database 11g Enterprise Edition Release 11.1.0.6.0 - 64bit
Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Starting "SCOTT"."SYS_EXPORT_SCHEMA_01": scott/******** dumpfile=scott_new.dmp
logfile=scott.log directory=exp_dump
Estimate in progress using BLOCKS method...
Processing object type SCHEMA_EXPORT/TABLE/TABLE_DATA
Total estimation using BLOCKS method: 192 KB
Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA
=============================================================

Already 10 mins... Its hangs here .... should I wait for some time or else what should I do??

Regards

Pradeep

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509312 is a reply to message #509306]

Fri, 27 May 2011 02:21

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Quote:

Query v$session to know on what the expdp session is waiting.

Regards
Michel

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509315 is a reply to message #509312]

Fri, 27 May 2011 02:28

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

select event,seconds_in_wait,status from v$session where program like '%DW%';

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509316 is a reply to message #509315]

Fri, 27 May 2011 02:34

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

Query Output is

=============================
SQL> select event,seconds_in_wait,status from v$session where program like '%DW%
';
XDB SGA initialization , 3
,ACTIVE
==================================================

Dump file is not increasing. it is still 4KB. and at the same line in log file

Processing object type SCHEMA_EXPORT/PRE_SCHEMA/PROCACT_SCHEMA

Regards

Pradeep

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509320 is a reply to message #509316]

Fri, 27 May 2011 02:38

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

Please read OraFAQ Forum Guide and How to use [code] tags and make your code easier to read.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code, use code tags and align the columns in result.
Use the "Preview Message" button to verify.

Regards
Michel

[Updated on: Fri, 27 May 2011 02:40]

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509328 is a reply to message #509320]

Fri, 27 May 2011 03:35

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi,

SQL> select event,seconds_in_wait,status from v$session where program like '%DW%';
event Seconds_in_ Status
---------------------- ------------ ------
XDB SGA initialization 3 ACTIVE

Now it will be readable to you ....... Smile

Smile

Pradeep

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509332 is a reply to message #509328]

Fri, 27 May 2011 04:30

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

No it is not, I bet you did not use the Preview button. Sad

Sad

Regards
Michel

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509335 is a reply to message #509332]

Fri, 27 May 2011 04:46

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi

When I m copying this into area it is fine but when I am checking preview its not. how can i set this.

event Seconds_in_ Status
---------------------- ------------ ------
XDB SGA initialization 3 ACTIVE

Reagrds

Pradeep

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509336 is a reply to message #509335]

Fri, 27 May 2011 04:52

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

pradies

how can i set this

Michel posted 2 links here. I guess you didn't read what they say, did you?

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509338 is a reply to message #509332]

Fri, 27 May 2011 04:56

pradies
Messages: 250
Registered: May 2008

Senior Member

Hi

event			Seconds_in_ Status
---------------------- ------------ ------
XDB SGA initialization		  3 ACTIVE

Regards

Pradeep

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #509340 is a reply to message #509335]

Fri, 27 May 2011 04:56

John Watson
Messages: 8962
Registered: January 2010
Location: Global Village

Senior Member

Pradeep, it is the use of code tags. Look at this :
http://www.orafaq.com/forum/?t=rview&goto=509334#msg_509334
his first ever post, and he used them, no problem.

Report message to a moderator

Re: Expdp Hangs in Oracle 11g [message #539333 is a reply to message #509340]

Fri, 13 January 2012 07:59

fabi88
Messages: 112
Registered: November 2011

Senior Member

Same problem here.

Finally resolved it by executing expdp directly on the server, instead of doing it from my local machine.

Maybe due to a compatibility problem between my Oracle client (10.2) and server versions (11.2) ?!?.

--Frosty

Report message to a moderator

Previous Topic:	EXPDP problem
Next Topic:	Datapump and index building

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Dec 23 07:19:58 CST 2024