Home » RDBMS Server » Server Utilities » Export Hangs at 'exporting cluster definitions' (Oralce 9i,9.2.0.1.0,RHEL 2.1)
Export Hangs at 'exporting cluster definitions' [message #487098] Wed, 22 December 2010 12:36 Go to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Friends,

Sunddenly my exports hangs at 'exporting cluster definitions'. I had been using this database since last 4 years and it never cause a problem or hangs at this level. here i'm pasting my screen details. please suggest solution,it is my production db.

[oracle1@wbh_as1 smbshare]$ exp wb/wb

Export: Release 9.2.0.1.0 - Production on Thu Dec 23 00:02:44 2010

Copyright (c) 1982, 2002, Oracle Corporation.  All rights reserved.


Connected to: Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.1.0 - Production
Enter array fetch buffer size: 4096 >

Export file: expdat.dmp > wb

(2)U(sers), or (3)T(ables): (2)U >

Export grants (yes/no): yes >

Export table data (yes/no): yes >

Compress extents (yes/no): yes >

Export done in US7ASCII character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)
. exporting pre-schema procedural objects and actions
. exporting foreign function library names for user WB
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions for user WB
About to export WB's objects ...
. exporting database links
. exporting sequence numbers
. exporting cluster definitions


Regards

Jimit
Re: Export Hangs at 'exporting cluster definitions' [message #487099 is a reply to message #487098] Wed, 22 December 2010 12:38 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Query v$session to see on what your export session is waiting for.

Regards
Michel
Re: Export Hangs at 'exporting cluster definitions' [message #487102 is a reply to message #487099] Wed, 22 December 2010 12:41 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
While this should NOT be the case, do any clues exist within alert_SID.log file?
Re: Export Hangs at 'exporting cluster definitions' [message #487103 is a reply to message #487099] Wed, 22 December 2010 12:42 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

Restart of database can be the solution?

Regards

Re: Export Hangs at 'exporting cluster definitions' [message #487105 is a reply to message #487103] Wed, 22 December 2010 12:45 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Blackswan

There is no error in alertSID.ora file.

Regards

Jimit
Re: Export Hangs at 'exporting cluster definitions' [message #487106 is a reply to message #487103] Wed, 22 December 2010 12:46 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SELECT * FROM V$SESS_IO WHERE SID = <Session_ID of exp>;

issue SQL above multiple times with brief pause between them
If exp session is doing "work", one or more columns will be increasing.
If returned value never change then session is "stuck" & waiting for some other session to release object/lock/latch
Re: Export Hangs at 'exporting cluster definitions' [message #487107 is a reply to message #487103] Wed, 22 December 2010 12:47 Go to previous messageGo to next message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Restart of database can be the solution?

Or try to restart the server, or even the power station, who knows?
To know you have to investigate and the first step is to query v$session.

Regards
Michel
Re: Export Hangs at 'exporting cluster definitions' [message #487108 is a reply to message #487106] Wed, 22 December 2010 12:49 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Blackswan

Right now i'm trying to shutdown my database with
first 'normal shutdown' but it didn't work,then i try
with 'shutdown immediate' it also not working and i also
tried with 'shutdown transactional'. which is also not working.
Should i go for 'shutdown abort' and restart the database.

Regards

Jimit
Re: Export Hangs at 'exporting cluster definitions' [message #487109 is a reply to message #487108] Wed, 22 December 2010 12:51 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Michel

In hurry i've stopped my listner and now i'm waiting for database to shutdown, which is also halted.

Regards

Jimit
Re: Export Hangs at 'exporting cluster definitions' [message #487110 is a reply to message #487108] Wed, 22 December 2010 12:51 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
>Should i go for 'shutdown abort' and restart the database.
Sounds like SHUTDOWN ABORT is only way to clear out the log jam.
Re: Export Hangs at 'exporting cluster definitions' [message #487111 is a reply to message #487110] Wed, 22 December 2010 12:59 Go to previous messageGo to next message
jimit_shaili
Messages: 237
Registered: June 2006
Location: India, Ahmedabad
Senior Member
Dear Blackswan and Michel

As per your suggestion and moral support i shutdown the database with abort option and start it again. There is no errors in alertSID.log and my export started again. Many thanks for your late night support. It is 12:30 a.m. in india and still guys you supporting. Thanks a lot again.

Regards

Jimit
Re: Export Hangs at 'exporting cluster definitions' [message #487114 is a reply to message #487108] Wed, 22 December 2010 13:53 Go to previous message
Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...
Senior Member
Account Moderator
Quote:
Right now i'm trying to shutdown my database with
first 'normal shutdown' but it didn't work

Expected behaviour as some are waiting then can't halt by themselves.

By the way, "is not working" is not an Oracle error, so please ALWAYS copy and paste your SQL*Plus session.

Quote:
As per your suggestion and moral support i shutdown the database with abort option

I NEVER said that and won't say it before having the result of the investigation.
Now you lose the context and are no more able to know what happened and you can be sure it will happen in the future.

Regards
Michel
Previous Topic: sql*loader
Next Topic: multiple rows
Goto Forum:
  


Current Time: Mon Dec 23 11:43:08 CST 2024