Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Export hangs with: "exporting cluster definitions"

Export hangs with: "exporting cluster definitions"

From: tomtom <abcd_at_europe.com>
Date: Tue, 20 Sep 2005 15:00:37 +0200
Message-ID: <433007f6$0$2865$4d4ef98e@read.news.ch.uu.net> 





Export hangs on "exporting cluster definitions"



Summary:


Export hangs, the terminal-output shows "exporting cluster definitions".
The exp session does not request any lock.
The DB has no lock-request at all (i.e. no blocking).
The exp session holds a "library cache pin"
Killing the exp session will not remove that session.
After some time the DB gets f... up more and more.
After a while SELECT on some v$ tables will not return.
Finally logon to the DB becomes impossible.
RIP.



Occasionally other databases, even on different servers do the same.
Occasionally a previous export had some errors:
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized



***



Here comes the details:



Windows 2003 Server / Windows 2000



Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options



Exporting like:


exp system/xxxxx_at_yyyy file=file.dmp owner=zzzz consistent=y 
statistics=none log=file.log



***



A previous export might have failed as follows:



Export: Release 10.1.0.2.0 - Production on Di Sep 20 02:00:02 2005
Connected to: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 
- Produc


tion


With the Partitioning, OLAP and Data Mining options
Export done in WE8MSWIN1252 character set and AL16UTF16 NCHAR character set
server uses WE8ISO8859P1 character set (possible charset conversion)



About to export specified users ...


. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user FACTS

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user FACTS

About to export FACTS's objects ...


. exporting database links

. exporting sequence numbers

. exporting cluster definitions


EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00056: ORACLE error 24324 encountered
ORA-24324: service handle not initialized
EXP-00000: Export terminated unsuccessfully

******************************************


The export that hangs:



About to export specified users ...


. exporting pre-schema procedural objects and actions

. exporting foreign function library names for user CASH

. exporting PUBLIC type synonyms

. exporting private type synonyms

. exporting object type definitions for user CASH

About to export CASH's objects ...


. exporting database links

. exporting sequence numbers

. exporting cluster definitions





Our Session is SID=79


SELECT * FROM v$lock;


ADDR	 KADDR		 SID TY        ID1	  ID2	   LMODE    REQUEST	 CTIME	    BLOCK

-------- -------- ---------- -- ---------- ---------- ---------- 
---------- ---------- ----------

7DE5E1DC 7DE5E1F0	  79 CU 1941021348 1941021348	       6	  0	 42151		0
7DE5E23C 7DE5E250	 165 TS 	 3	    1	       3	  0	340313		0
7DE5E17C 7DE5E190	 166 RS 	25	    1	       2	  0	340317		0
7DE5E0BC 7DE5E0D0	 166 CF 	 0	    0	       2	  0	340322		0
7DE5E05C 7DE5E070	 166 XR 	 4	    0	       1	  0	340322		0
7DE5E29C 7DE5E2B0	 167 RT 	 1	    0	       6	  0	340317		0
7DE5E5FC 7DE5E610	 168 MR        201	    0	       4	  0	340314		0
7DE5E59C 7DE5E5B0	 168 MR 	 6	    0	       4	  0	340317		0
7DE5E53C 7DE5E550	 168 MR 	 5	    0	       4	  0	340317		0
7DE5E4DC 7DE5E4F0	 168 MR 	 4	    0	       4	  0	340317		0
7DE5E47C 7DE5E490	 168 MR 	 3	    0	       4	  0	340317		0
7DE5E41C 7DE5E430	 168 MR 	 2	    0	       4	  0	340317		0
7DE5E3BC 7DE5E3D0	 168 MR 	 1	    0	       4	  0	340317		0


SELECT * FROM v$session WHERE sid=79;
SADDR		SID    SERIAL#	   AUDSID PADDR 	USER# USERNAME


-------- ---------- ---------- ---------- -------- ---------- 




    COMMAND    OWNERID TADDR    LOCKWAIT STATUS	 SERVER       SCHEMA# 

SCHEMANAME



---------- ---------- -------- -------- -------- --------- ---------- 




OSUSER			       PROCESS


------------------------------ ------------
MACHINE 							 TERMINAL
---------------------------------------------------------------- 
----------------
PROGRAM 							 TYPE	    SQL_ADDR SQL_HASH_VALUE
---------------------------------------------------------------- 
---------- -------- --------------
SQL_ID	      SQL_CHILD_NUMBER PREV_SQL PREV_HASH_VALUE PREV_SQL_ID 


PREV_CHILD_NUMBER


------------- ---------------- -------- --------------- ------------- 
-----------------
MODULE						 MODULE_HASH ACTION
------------------------------------------------ ----------- 
--------------------------------
ACTION_HASH CLIENT_INFO 						     FIXED_TABLE_SEQUENCE
----------- 
---------------------------------------------------------------- 
--------------------
ROW_WAIT_OBJ# ROW_WAIT_FILE# ROW_WAIT_BLOCK# ROW_WAIT_ROW# LOGON_TIME	 
      LAST_CALL_ET PDM




------------- -------------- --------------- ------------- 

------------------- ------------ ---
FAILOVER_TYPE FAILOVER_M FAI RESOURCE_CONSUMER_GROUP	      PDML_STA 


PDDL_STA PQ_STATU


------------- ---------- --- -------------------------------- -------- 
-------- --------
CURRENT_QUEUE_DURATION CLIENT_IDENTIFIER						BLOCKING_SE
---------------------- 
---------------------------------------------------------------- -----------
BLOCKING_SESSION       SEQ#	EVENT#
---------------- ---------- ----------




EVENT





P1TEXT									 P1 P1RAW







column p1raw new_value p1raw


SELECT sid, event, p1raw, seconds_in_wait, wait_time


    FROM sys.v_$session_wait


    WHERE sid = 79;



        SID EVENT			  P1RAW    SECONDS_IN_WAIT  WAIT_TIME


---------- ------------------------------ -------- --------------- 
----------
	79 library cache pin		  73CBA6F4	     42760	  243

***************************




SELECT kglnaown AS owner, kglnaobj as Object,kglhdadr


    FROM sys.x$kglob


   WHERE kglhdadr='&p1raw';



OWNER





OBJECT





KGLHDADR





~


SELECT /*+rule*/ SYS_XMLGEN(VALUE(KU$), 
XMLFORMAT.createFormat2('XMLSCHEMA_T', '7')), 0 FROM 
SYS.KU$_XMLSCHEMA_VIEW KU$ WHERE KU$.OWNER_NAME=:

SCHEMA1



73CBA6F4


Please advise
Received on Tue Sep 20 2005 - 08:00:37 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US