Export Hangs at 'exporting cluster definitions' [message #487098] |
Wed, 22 December 2010 12:36 |
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 #487108 is a reply to message #487106] |
Wed, 22 December 2010 12:49 |
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 #487111 is a reply to message #487110] |
Wed, 22 December 2010 12:59 |
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 |
|
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
|
|
|