OraFAQ Forum: Server Utilities » Full DB Export Session Hanged

Home » RDBMS Server » Server Utilities » Full DB Export Session Hanged (Oracle 9.0.2.0.6 windows server 2003)

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

Full DB Export Session Hanged [message #288334]

Mon, 17 December 2007 02:18

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear All,

I am trying to export full db with the following script
C:\>EXP USERID=SYSTEM/**** FILE=D:\oracle\backup\dump\recent_most.dmp direct=y full=y log=D:\oracle\backup\dump\recent_most.log

Export: Release 9.2.0.6.0 - Production on Mon Dec 17 13:07:55 2007

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

Connected to: Oracle9i Enterprise Edition Release 9.2.0.6.0 - Production
With the Partitioning, OLAP and Oracle Data Mining options
JServer Release 9.2.0.6.0 - Production
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set

About to export the entire database ...
. exporting tablespace definitions
. exporting profiles
. exporting user definitions
. exporting roles
. exporting resource costs
. exporting rollback segment definitions
. exporting database links
. exporting sequence numbers
. exporting directory aliases
. exporting context namespaces
. exporting foreign function library names
. exporting PUBLIC type synonyms
. exporting private type synonyms
. exporting object type definitions

The export session got hanged for 4-5 hrs at
exporting object type definitions

what could be the reasons ?
please suggest!

[EDITED by LF: removed SYSTEM password]

[Updated on: Mon, 17 December 2007 04:10] by Moderator

Report message to a moderator

Re: Full DB Export Session Hanged [message #288337 is a reply to message #288334]

Mon, 17 December 2007 02:26

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Did you check alert<sid>.log file.
Trace export session and reexecute export command.

Report message to a moderator

Re: Full DB Export Session Hanged [message #288343 is a reply to message #288334]

Mon, 17 December 2007 02:40

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Check free disk space in D drive.

Report message to a moderator

Re: Full DB Export Session Hanged [message #288360 is a reply to message #288334]

Mon, 17 December 2007 04:19

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

there is nothing in alert log file

Report message to a moderator

Re: Full DB Export Session Hanged [message #288361 is a reply to message #288334]

Mon, 17 December 2007 04:25

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Have you checked about free space in drive D: ?

Report message to a moderator

Re: Full DB Export Session Hanged [message #288371 is a reply to message #288360]

Mon, 17 December 2007 04:54

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

Senior Member
Account Moderator

Otherwise the most important way to know what happens is:

Mohammad Taj wrote on Mon, 17 December 2007 09:26

Trace export session and reexecute export command.

Regards
Michel

Report message to a moderator

Re: Full DB Export Session Hanged [message #288374 is a reply to message #288334]

Mon, 17 December 2007 04:56

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Dear Arju

yes we have 113gb free space available in d:
and the max size of export file will be 60GB

Report message to a moderator

Re: Full DB Export Session Hanged [message #288376 is a reply to message #288374]

Mon, 17 December 2007 05:03

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

Senior Member
Account Moderator

So now your only solution is now to trace your export session.

Regards
Michel

Report message to a moderator

Re: Full DB Export Session Hanged [message #288388 is a reply to message #288334]

Mon, 17 December 2007 05:39

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

i traced the export session and found the session is being held while exporting object type definitions
and i got the following
ALTER TYPE "OE"."ORDER_TYP" COMPILE SPECIFICATION REUSE SETTINGS

and after a long time the session is terminated with the following

EXP-00090: cannot pin type "OE"."CUSTOMER_TYP"
EXP-00056: ORACLE error 22303 encountered
OCI-22303: type "OE"."CUSTOMER_TYP" not found
EXP-00056: ORACLE error 24323 encountered
ORA-24323: value not allowed
EXP-00000: Export terminated unsuccessfully

Report message to a moderator

Re: Full DB Export Session Hanged [message #288392 is a reply to message #288388]

Mon, 17 December 2007 05:53

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

Senior Member
Account Moderator

Getting the export log is not tracing.
I can see that you export did not hang as it terminates.

ORA-22303: type \"%s\".\"%s\" not found
  *Cause:  The user is trying to obtain information for a type that
           cannot be found.
  *Action: Check that the schema is correct and that the type has been
           created correctly.

ORA-24323: value not allowed
 *Cause:  A null value or a bogus value was passed in for a mandatory
          parameter.
 *Action: Verify that all mandatory parameters are properly initialized.

Regards
Michel

Report message to a moderator

Re: Full DB Export Session Hanged [message #288396 is a reply to message #288334]

Mon, 17 December 2007 06:31

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

Problem is being resolved by complinig all invalid objects
sql>@utlrp.sql

Report message to a moderator

Re: Full DB Export Session Hanged [message #288397 is a reply to message #288396]

Mon, 17 December 2007 06:33

Mohammad Taj
Messages: 2412
Registered: September 2006
Location: Dubai, UAE

Senior Member

Thank you for feedback.
Now tell me what is need to export full database instead of particular schemas/users.

Report message to a moderator

Re: Full DB Export Session Hanged [message #288530 is a reply to message #288397]

Mon, 17 December 2007 23:25

M.Shakeel Azeem
Messages: 226
Registered: September 2006

Senior Member

I have lots of schemas in my DB so i can't export schemas individualy
In my last post i said that the problem is resoloved but infact the problem is not resolved

At almost end of export i got the following

. exporting stored procedures
. exporting operators
. exporting indextypes
. exporting bitmap, functional and extensible indexes
. exporting posttables actions
. exporting triggers
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00056: ORACLE error 6550 encountered
ORA-06550: line 1, column 26:
PLS-00201: identifier 'XDB.DBMS_XDBUTIL_INT' must be declared
ORA-06550: line 1, column 14:
PL/SQL: Statement ignored
EXP-00000: Export terminated unsuccessfully

I already tried catexp.sql,catalog.sql,catproc.sql and utlrp.sql
but the problem is still there
please suggest!

Report message to a moderator

Re: Full DB Export Session Hanged [message #288552 is a reply to message #288334]

Tue, 18 December 2007 00:28

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Do you have any XML functionability in your any database schema. If no then delete XDB schema and XDB tablespace. Then try, hopefully your problem will go away.

Report message to a moderator

Re: Full DB Export Session Hanged [message #288555 is a reply to message #288334]

Tue, 18 December 2007 00:31

Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...

Senior Member

Also if you have any XML functionality then you can re-create the package XDB.DBMS_XDBUTIL_INT

To do it as a sysdba user run prvtxdb.plb

Report message to a moderator

Previous Topic:	Import 10i into 9i
Next Topic:	Doubt on import utility

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Tue Dec 24 23:39:59 CST 2024