oracle 错误 04020,IMP时出现 ORA-04020 死锁问题

oracle8.1.6.3 WINDOWS2000 daoru

IMP-00003: ORACLE 错误4020出现

ORA-04020: 在尝试锁定对象 EBILLS_RUN_HANGZHOU.TT_HRHKJLB 时检测到死锁

IMP-00017: 由于 ORACLE 错误4043，以下的语句失败

数据库日志中只有检查点未完成的信息应该和这没关系吧

Thread 1 cannot allocate new log, sequence 129038

Checkpoint not complete

Current log# 2 seq# 129037 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129038

Current log# 3 seq# 129038 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Tue Dec 20 16:03:28 2005

Thread 1 advanced to log sequence 129039

Current log# 1 seq# 129039 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129040

Current log# 2 seq# 129040 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129041

Current log# 3 seq# 129041 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129042

Current log# 1 seq# 129042 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129043

Current log# 2 seq# 129043 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129044

Current log# 3 seq# 129044 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129045

Current log# 1 seq# 129045 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129046

Current log# 2 seq# 129046 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129047

Current log# 3 seq# 129047 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129048

Current log# 1 seq# 129048 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129049

Current log# 2 seq# 129049 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129050

Current log# 3 seq# 129050 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129051

Current log# 1 seq# 129051 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129052

Current log# 2 seq# 129052 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129053

Current log# 3 seq# 129053 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129054

Current log# 1 seq# 129054 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129055

Current log# 2 seq# 129055 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO02.LOG

Thread 1 advanced to log sequence 129056

Current log# 3 seq# 129056 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO03.LOG

Thread 1 advanced to log sequence 129057

Current log# 1 seq# 129057 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 cannot allocate new log, sequence 129058

Checkpoint not complete

Current log# 1 seq# 129057 mem# 0: D:\ORACLE\ORADATA\HZGFDB\REDO01.LOG

Thread 1 advanced to log sequence 129058