Export hangs with: "exporting cluster definitions"
in [Oracle]
|
Prev: SQLLDR fixed format and number format
Next: ora: 1033 : Oracle intialization or shutdown in progress
From: tomtom on 20 Sep 2005 09:00 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(a)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 ---------------------------------------------------------------- ---------- -------- P2TEXT P2 P2RAW ---------------------------------------------------------------- ---------- -------- P3TEXT P3 P3RAW WAIT_CLASS_ID ---------------------------------------------------------------- ---------- -------- ------------- WAIT_CLASS# WAIT_CLASS WAIT_TIME ----------- ---------------------------------------------------------------- ---------- SECONDS_IN_WAIT STATE SERVICE_NAME --------------- ------------------- ---------------------------------------------------------------- 7DD6DC30 79 12923 187105 7DCF9F98 5 SYSTEM 3 2147483644 6722B458 ~ ACTIVE DEDICATED 0 SYS DIRECTOR\Administrator 964:488 IW-SHS\DIRECTOR DIRECTOR EXP.EXE USER 66FA5C84 3954397746 b6p28grpv6njk 1 73FDB41C 3063492612 9c3hdhkv9kc04 0 EXP.EXE 0 ~ 0 ~ 501049 -1 0 0 0 2005-09-20T02:00:16 42391 NO NONE NONE NO ~ DISABLED ENABLED ENABLED 0 ~ NOT IN WAIT ~ 696 500 library cache pin handle address 1942726388 73CBA6F4 pin address 1927957032 72EA4A28 100*mode+namespace 200 000000C8 3875070507 4 Concurrency 243 42391 WAITED KNOWN TIME SYS$USERS ************************** 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 |