Home » RDBMS Server » Server Utilities » Full DB Export Session Hanged (Oracle 9.0.2.0.6 windows server 2003)
Full DB Export Session Hanged [message #288334] Mon, 17 December 2007 02:18 Go to next message
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 Go to previous messageGo to next message
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.
Re: Full DB Export Session Hanged [message #288343 is a reply to message #288334] Mon, 17 December 2007 02:40 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Check free disk space in D drive.
Re: Full DB Export Session Hanged [message #288360 is a reply to message #288334] Mon, 17 December 2007 04:19 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
there is nothing in alert log file
Re: Full DB Export Session Hanged [message #288361 is a reply to message #288334] Mon, 17 December 2007 04:25 Go to previous messageGo to next message
Arju
Messages: 1554
Registered: June 2007
Location: Dhaka,Bangladesh. Mobile:...
Senior Member

Have you checked about free space in drive D: ?
Re: Full DB Export Session Hanged [message #288371 is a reply to message #288360] Mon, 17 December 2007 04:54 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
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


Re: Full DB Export Session Hanged [message #288374 is a reply to message #288334] Mon, 17 December 2007 04:56 Go to previous messageGo to next message
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

Re: Full DB Export Session Hanged [message #288376 is a reply to message #288374] Mon, 17 December 2007 05:03 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
So now your only solution is now to trace your export session.

Regards
Michel
Re: Full DB Export Session Hanged [message #288388 is a reply to message #288334] Mon, 17 December 2007 05:39 Go to previous messageGo to next message
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
Re: Full DB Export Session Hanged [message #288392 is a reply to message #288388] Mon, 17 December 2007 05:53 Go to previous messageGo to next message
Michel Cadot
Messages: 68707
Registered: March 2007
Location: Nanterre, France, http://...
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
Re: Full DB Export Session Hanged [message #288396 is a reply to message #288334] Mon, 17 December 2007 06:31 Go to previous messageGo to next message
M.Shakeel Azeem
Messages: 226
Registered: September 2006
Senior Member
Problem is being resolved by complinig all invalid objects
sql>@utlrp.sql
Re: Full DB Export Session Hanged [message #288397 is a reply to message #288396] Mon, 17 December 2007 06:33 Go to previous messageGo to next message
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.
Re: Full DB Export Session Hanged [message #288530 is a reply to message #288397] Mon, 17 December 2007 23:25 Go to previous messageGo to next message
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!
Re: Full DB Export Session Hanged [message #288552 is a reply to message #288334] Tue, 18 December 2007 00:28 Go to previous messageGo to next message
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.
Re: Full DB Export Session Hanged [message #288555 is a reply to message #288334] Tue, 18 December 2007 00:31 Go to previous message
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
Previous Topic: Import 10i into 9i
Next Topic: Doubt on import utility
Goto Forum:
  


Current Time: Thu Nov 07 23:23:47 CST 2024