imp异常情况！

显示全部楼层 · 2005-10-30 17:05:33

在用exp/imp做数据迁移时遇到的，把源库的用户下的数据先exp成dmp，顺利，然后在imp时出现异常，在imp的时候，大部分的表都没有问题，但是经常到一张的时候，就停顿了，这个时候进数据库中可以看到，在这张表上面有一个lock。在trc信息中没有什么信息，就只有一个dump信息
下面是trc信息：
——————————————
Oracle9i Enterprise Edition Release 9.2.0.1.0 - Production
Process Id: 0x000003f0Thread Id : 0x00001684Time : Tue Oct 24 09:28:23
Excp. Code: 0xc0000005Excp. Type: ACCESS_VIOFlags: 0x00000000
------------------- Registers ----------------------------
eip = 7c966d0b esp = 055fb7e0 ebp = 055fb9fc edi = 00000004 esi = fffffff7
eax = 00360198 ebx = 00360000 ecx = 7ff94000 edx = 00360608
ecs = 0000001b eds = 00000023 ees = 00000023 ess = 00000023
egs = 00000000 efs = 0000003b
eflags = 00010282
------------------- End of Registers ---------------------
------------------- Instruction Disassembly --------------
------------------- End of Disassembly -------------------
------------------- Call Stack Trace ---------------------
Frameptr RetAddrParam#1Param#2Param#3Param#4Function Name
0x055fb9fc 77b8d08c 00360000 00000000 00000018 00000006 0x7c966d0b

0x055fba1c 615a9e76 00000018 0568f6e4 615ca5eb 00000018 0x77b8d08c

0x055fba28 615ca5eb 00000018 0568f6e4 00000005 00000014 0x615a9e76

0x0568f6e4 00000000 00000000 00000001 00000000 00000000 0x615ca5eb

------------------- End of Stack Trace -------------------
------------------- Raw Stack Dump -----------------------
AddressDump of bytes
0x055fb7e0 18 00 00 00 00 00 00 00 - fd f9 95 7c 65 5c 6f 72 ...........|e\or
0x055fb7f0 61 39 32 5c 44 41 54 41 - 42 41 53 45 5c 50 57 44 a92\DATABASE\PWD
0x055fb800 6f 72 61 64 62 2e 4f 52 - 41 00 00 00 00 00 00 00 oradb.ORA.......
0x055fb810 20 b8 5f 05 01 00 00 00 - b3 02 96 7c 10 ef 36 00._........|..6.
0x055fb820 00 b9 5f 05 c1 f9 95 7c - 18 07 36 00 dd f9 95 7c .._....|..6....|
0x055fb830 68 04 00 00 18 ef 36 00 - 80 f1 92 1c 20 00 00 00 h.....6..... ...
0x055fb840 08 74 2b 06 00 00 14 00 - 00 70 2b 06 00 00 00 00 .t+......p+.....
0x055fb850 00 00 00 00 00 00 14 00 - 38 b9 5f 05 c6 00 96 7c ........8._....|
0x055fb860 08 06 14 00 dd f9 95 7c - 00 00 00 00 00 00 00 00 .......|........
0x055fb870 84 1b 95 7c 8d 19 80 7c - 68 04 00 00 00 00 00 00 ...|...|h.......
0x055fb880 00 00 00 00 08 b9 5f 05 - 08 b9 5f 05 00 82 6a 05 ......_..._...j.
0x055fb890 00 02 00 00 a8 b8 5f 05 - c2 18 80 7c 00 82 6a 05 ......_....|..j.
0x055fb8a0 00 00 00 00 00 02 00 00 - 00 02 00 00 00 00 00 00 ................
0x055fb8b0 00 00 00 00 78 01 14 00 - c0 17 bc 77 00 02 00 00 ....x......w....
0x055fb8c0 9c b8 5f 05 e0 b8 5f 05 - 44 de 5f 05 d0 b7 82 7c .._..._.D._....|
0x055fb8d0 00 00 36 00 00 00 00 00 - 24 7c 9d 1c 03 00 00 00 ..6.....$|......
0x055fb8e0 00 b9 5f 05 bd 37 9a 00 - 04 a9 9d 1c 94 6e 22 1d .._..7.......n".
0x055fb8f0 24 7c 9d 1c 00 00 00 00 - 00 34 31 06 1c b9 5f 05 $|.......41..._.
0x055fb900 48 7a 43 00 e8 b0 9d 1c - 94 6e 22 1d 00 00 00 00 HzC......n".....
0x055fb910 0c 7c 9d 1c ac 6c 22 1d - 00 00 00 00 54 b9 5f 05 .|...l".....T._.
0x055fb920 c3 78 43 00 2c 7c fe 01 - 00 00 00 00 4c 02 00 00 .xC.,|......L...
0x055fb930 d8 2c 5b 02 31 50 31 06 - 06 00 00 00 00 f1 92 1c .,[.1P1.........
0x055fb940 00 34 31 06 e8 b0 9d 1c - 06 00 00 00 38 f1 92 1c .41.........8...
0x055fb950 7c b9 5f 05 84 3f 7f 00 - 88 7b fe 01 e8 b0 9d 1c |._..?...{......
0x055fb960 00 00 00 00 88 7b fe 01 - 01 00 00 00 e8 b0 9d 1c .....{..........
0x055fb970 84 00 00 00 00 34 31 06 - e8 b0 9d 1c 24 ba 5f 05 .....41.....$._.
0x055fb980 fc 73 44 00 e8 b0 9d 1c - 00 00 00 00 00 00 00 00 .sD.............
0x055fb990 30 83 6a 05 6c de 5f 05 - bc 0e 67 05 88 ba 5f 05 0.j.l._...g..._.
0x055fb9a0 00 82 6a 05 74 ba 5f 05 - d4 b9 5f 05 d4 b9 5f 05 ..j.t._..._..._.
0x055fb9b0 74 f1 92 1c 04 00 00 00 - 01 00 00 00 00 82 6a 05 t.............j.
0x055fb9c0 65 65 65 65 00 00 00 00 - f7 ff ff ff 00 00 00 00 eeee............
0x055fb9d0 98 01 36 00 65 65 65 65 - 20 00 00 00 65 65 01 65 ..6.eeee ...ee.e
0x055fb9e0 00 00 36 00 e0 b7 5f 05 - 0c b4 5f 05 44 de 5f 05 ..6..._..._.D._.
0x055fb9f0 80 f6 95 7c 28 fb 95 7c - 00 00 00 00 1c ba 5f 05 ...|(..|......_.
0x055fba00 8c d0 b8 77 00 00 36 00 - 00 00 00 00 18 00 00 00 ...w..6.........
0x055fba10 06 00 00 00 14 00 00 00 - e4 f6 68 05 28 ba 5f 05 ..........h.(._.
0x055fba20 76 9e 5a 61 18 00 00 00 - e4 f6 68 05 eb a5 5c 61 v.Za......h...\a
0x055fba30 18 00 00 00 e4 f6 68 05 - 05 00 00 00 14 00 00 00 ......h.........
0x055fba40 9f a1 5c 61 06 00 00 00 - e4 f6 68 05 80 f6 68 05 ..\a......h...h.
0x055fba50 cc ba 5f 05 01 00 00 00 - 05 00 00 00 c6 27 5a 61 .._..........'Za
0x055fba60 8c c0 61 61 14 00 00 00 - e4 f6 68 05 e4 f6 68 05 ..aa......h...h.
0x055fba70 80 f6 68 05 00 00 00 00 - 80 00 00 00 ec ba 5f 05 ..h..........._.
0x055fba80 00 00 00 00 cc ba 5f 05 - 00 00 00 00 bc 01 00 00 ......_.........
0x055fba90 00 00 00 00 8c 33 4e 61 - 80 f6 68 05 00 00 00 00 .....3Na..h.....
0x055fbaa0 09 93 b5 01 6c de 5f 05 - d8 96 31 06 1d 43 c6 4f ....l._...1..C.O
0x055fbab0 10 5e 64 c0 93 d8 c0 34 - 0f 7f 94 f9 31 b2 7a 85 .^d....4....1.z.
0x055fbac0 c9 50 fb c8 44 a1 2c d5 - 6f 02 02 3b f4 ba 5f 05 .P..D.,.o..;.._.
0x055fbad0 f2 a2 4e 61 38 dd 5f 05 - 10 00 00 00 00 00 00 00 ..Na8._.........
0x055fbae0 ec ba 5f 05 d8 96 31 06 - 09 93 b5 01 00 00 00 00 .._...1.........
0x055fbaf0 80 f6 68 05 4c dd 5f 05 - 95 8c f5 00 60 98 31 06 ..h.L._.....`.1.
0x055fbb00 9a 03 00 00 38 dd 5f 05 - 10 00 00 00 6c de 5f 05 ....8._.....l._.
0x055fbb10 00 00 00 00 00 00 00 00 - 40 bd 5f 05 df fa 95 7c ........@._....|
0x055fbb20 23 fb 95 7c cc c3 5f 05 - f8 4b f9 7f ac 02 00 00 #..|.._..K......
0x055fbb30 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbb40 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbb50 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbb60 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbb70 80 bb 5f 05 00 00 14 00 - e7 02 96 7c 18 07 14 00 .._........|....
0x055fbb80 a8 bd 5f 05 df fa 95 7c - 23 fb 95 7c f4 bd 5f 05 .._....|#..|.._.
0x055fbb90 fc bd 5f 05 00 00 00 00 - 00 00 00 00 00 00 00 00 .._.............
0x055fbba0 08 04 00 00 20 00 00 00 - 08 70 2b 06 d4 bd 5f 05 .... ....p+..._.
0x055fbbb0 a6 fd 95 7c 23 fb 95 7c - 00 00 00 00 fd f9 95 7c ...|#..|.......|
0x055fbbc0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbbd0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbbe0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbbf0 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbc00 00 00 00 00 00 00 00 00 - 00 00 00 00 00 00 00 00 ................
0x055fbc10 00 00 00 00 08 74 2b 06 - 00 00 00 00 00 00 00 00 .....t+.........
0x055fbc20 f8 4b f9 7f 18 1b 95 7c - a0 bc 5f 05 5c bc 5f 05 .K.....|.._.\._.
0x055fbc30 dc 15 96 7c e1 15 96 7c - a0 bc 5f 05 18 1b 95 7c ...|...|.._....|
0x055fbc40 f8 4b f9 7f 38 bc 5f 05 - 24 1b 95 7c 88 dd 5f 05 .K..8._.$..|.._.
0x055fbc50 80 f6 95 7c 64 bc 5f 05 - 01 00 00 00 b3 02 96 7c ...|d._........|
0x055fbc60 b8 be 2a 06 44 bd 5f 05 - c1 f9 95 7c 78 07 14 00 ..*.D._....|x...
0x055fbc70 dd f9 95 7c cc c3 5f 05 - 00 00 00 00 58 d4 5f 05 ...|.._.....X._.
0x055fbc80 2c 00 00 00 88 bd 5f 05 - 00 00 00 00 ac 02 00 00 ,....._.........
0x055fbc90 00 00 00 00 c0 be 2a 06 - a0 bc 5f 05 00 00 00 00 ......*..._.....
0x055fbca0 00 00 00 00 01 00 00 00 - 20 00 00 00 44 00 3a 00 ........ ...D.:.
0x055fbcb0 5c 00 6f 00 72 00 61 00 - 63 00 6c 00 65 00 5c 00 \.o.r.a.c.l.e.\.
0x055fbcc0 6f 00 72 00 61 00 39 00 - 32 00 00 00 ad 15 96 7c o.r.a.9.2......|
0x055fbcd0 88 bd 5f 05 00 00 00 00 - 08 bd 5f 05 dc 15 96 7c .._......._....|
------------------- End of Raw Stack Dump ----------------
上面的信息我看不懂。
然后过了几分钟后，连数据库都连不上了，连库是报错信息是：
ora-12500:TNS:监听程序无法启动服务器进程
ORA-12560: TNS: 协议适配器错误
这个时候的数据库基本上无法操作，
此过程的中数据库的版本都是一样的，都是9.2.0.1.0，应该不存在字符集的问题。

千问 · 2005-10-30 17:05:33

很奇怪

千问 · 2005-10-30 17:05:33

是很奇怪，我把这个dmp文件imp到其他服务器的同一个用户里时，是没有问题的，唯独是这台服务器上不行，而且我看了一下那几张导致异常的表时，感觉不出这张表的异常情况，每次imp异常后，数据库就处在宕机状态，什么用户都两不上，我只用靠停止oracleservice才能把数据库停了，服务器os是2003。

千问 · 2005-10-30 17:05:33

这张表的具体的结构是什么样的？有多少数据量？

千问 · 2005-10-30 17:05:33

可能是有其他用户的相同表和它有冲突，imp用户只能用它的表空间看？

千问 · 2005-10-30 17:05:33

你看到的lock是在堵塞你的imp进程？

千问 · 2005-10-30 17:05:33

最初由 mychary 发布
[B]可能是有其他用户的相同表和它有冲突，imp用户只能用它的表空间看？ [/B]
应该不是这个的应该不是这个原因，目标库的用户和表空间都是新建的，不会有表冲突的问题。

另外lock应该就是阻碍imp的问题，可是我就不明白为什么在那几张表上会产生lock，上面也没有trigger，而且表结构很正常，没有长字段

千问 · 2005-10-30 17:05:33

表的数据很少，不到5w条，谁能告诉我trc中的dump信息是什么意思？

千问 · 2005-10-30 17:05:33

刚刚再exp一次，这次就把table导出来，index\trigger等都没有要，我怀疑是index的原因，因为在这几张table上面都有好几个index，会不会是index引起的。
然后把目标用户删掉重建，重新imp，很遗憾，异常依旧，imp又停在那张表，lock信息中有三个lock，一个是在obj$上，一个是出异常的table上，还有一个不知道是什么lock，
现在数据库又死了，oracleservice也停不掉，情况跟前面一样。
求救！

千问 · 2005-10-30 17:05:33

再顶一下，
想不明白，怎么会出现这种问题