Home » RDBMS Server » Server Utilities » Expdp Hangs in Oracle 11g (Oracle11g(11.1.0.6.0), Windows 2003 Server)
Expdp Hangs in Oracle 11g [message #509277] Fri, 27 May 2011 00:25 Go to next message
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 1928 times)
Re: Expdp Hangs in Oracle 11g [message #509287 is a reply to message #509277] Fri, 27 May 2011 01:12 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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

Re: Expdp Hangs in Oracle 11g [message #509289 is a reply to message #509287] Fri, 27 May 2011 01:17 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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
Re: Expdp Hangs in Oracle 11g [message #509296 is a reply to message #509289] Fri, 27 May 2011 01:29 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Oh oh! So now impossible to know why it "hangs". Wink

Regards
Michel
Re: Expdp Hangs in Oracle 11g [message #509302 is a reply to message #509289] Fri, 27 May 2011 01:44 Go to previous messageGo to next message
John Watson
Messages: 8922
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?
Re: Expdp Hangs in Oracle 11g [message #509306 is a reply to message #509296] Fri, 27 May 2011 01:53 Go to previous messageGo to next message
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

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
Re: Expdp Hangs in Oracle 11g [message #509312 is a reply to message #509306] Fri, 27 May 2011 02:21 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
Query v$session to know on what the expdp session is waiting.


Regards
Michel
Re: Expdp Hangs in Oracle 11g [message #509315 is a reply to message #509312] Fri, 27 May 2011 02:28 Go to previous messageGo to next message
John Watson
Messages: 8922
Registered: January 2010
Location: Global Village
Senior Member
select event,seconds_in_wait,status from v$session where program like '%DW%';
Re: Expdp Hangs in Oracle 11g [message #509316 is a reply to message #509315] Fri, 27 May 2011 02:34 Go to previous messageGo to next message
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
Re: Expdp Hangs in Oracle 11g [message #509320 is a reply to message #509316] Fri, 27 May 2011 02:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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

Pradeep
Re: Expdp Hangs in Oracle 11g [message #509332 is a reply to message #509328] Fri, 27 May 2011 04:30 Go to previous messageGo to next message
Michel Cadot
Messages: 68624
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
No it is not, I bet you did not use the Preview button. Sad

Regards
Michel
Re: Expdp Hangs in Oracle 11g [message #509335 is a reply to message #509332] Fri, 27 May 2011 04:46 Go to previous messageGo to next message
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
Re: Expdp Hangs in Oracle 11g [message #509336 is a reply to message #509335] Fri, 27 May 2011 04:52 Go to previous messageGo to next message
Littlefoot
Messages: 21806
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?
Re: Expdp Hangs in Oracle 11g [message #509338 is a reply to message #509332] Fri, 27 May 2011 04:56 Go to previous messageGo to next message
pradies
Messages: 250
Registered: May 2008
Senior Member
Hi

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




Regards

Pradeep
Re: Expdp Hangs in Oracle 11g [message #509340 is a reply to message #509335] Fri, 27 May 2011 04:56 Go to previous messageGo to next message
John Watson
Messages: 8922
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.
Re: Expdp Hangs in Oracle 11g [message #539333 is a reply to message #509340] Fri, 13 January 2012 07:59 Go to previous message
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
Previous Topic: EXPDP problem
Next Topic: Datapump and index building
Goto Forum:
  


Current Time: Thu Mar 28 10:42:42 CDT 2024