oracle9i for linux(AS3u9) 导入数据失败。

[zzxing]

请教达人，9.2.0.4 for as3u9 在导入数据（大约1G大小的dmp文件）时出现死机现象，与哪些参数有关？
环境如下：普通PC机，２G内存，320GHD，as3u9，oracle按官方默认参数安装好，这前曾成功导入600M大小的dmp文件，删除数据表之后再次导入总是失败（中途停顿卡死在数据量大的那张表那里），无任何反。反复操作都是如此。

[zzxing]

见图

[惜分飞-Tel:[phone]]

导入失败错误提示 alert日志错误提示

[惜分飞-Tel:[phone]]

看数据库等待事件和alert日志

[zzxing]

回达人，没有任何提示，就是停顿了，没有反应。

[zzxing]

starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Wed Dec 19 09:02:20 2012 /* OracleOEM */ ALTER DATABASE MOUNT Wed Dec 19 09:02:24 2012 Successful mount of redo thread 1, with mount id 1330217500. Wed Dec 19 09:02:24 2012 Database mounted in Exclusive Mode. Completed: /* OracleOEM */ ALTER DATABASE MOUNT Wed Dec 19 09:02:24 2012 /* OracleOEM */ ALTER DATABASE OPEN Wed Dec 19 09:02:24 2012 Beginning crash recovery of 1 threads Wed Dec 19 09:02:24 2012 Started first pass scan Wed Dec 19 09:02:24 2012 Completed first pass scan 0 redo blocks read, 0 data blocks need recovery Wed Dec 19 09:02:24 2012 Started recovery at Thread 1: logseq 453, block 204799, scn 0.90897103 Recovery of Online Redo Log: Thread 1 Group 2 Seq 453 Reading mem 0 Mem# 0 errs 0: /opt/oracle/oradata/orcl/redo02.log Wed Dec 19 09:02:24 2012 Completed redo application Wed Dec 19 09:02:24 2012 Ended recovery at Thread 1: logseq 453, block 204799, scn 0.90917104 0 data blocks read, 0 data blocks written, 0 redo blocks read Crash recovery completed successfully Wed Dec 19 09:02:24 2012 LGWR: Primary database is in CLUSTER CONSISTENT mode Wed Dec 19 09:02:24 2012 ARCH: Evaluating archive log 3 thread 1 sequence 451 ARCH: Beginning to archive log 3 thread 1 sequence 451 Creating archive destination LOG_ARCHIVE_DEST_1: '/opt/oracle/ora92/dbs/arch1_451.dbf' ARCH: Completed archiving log 3 thread 1 sequence 451 Wed Dec 19 09:02:28 2012 LGWR: Primary database is in CLUSTER CONSISTENT mode Thread 1 advanced to log sequence 454 Thread 1 opened at log sequence 454 Current log# 3 seq# 454 mem# 0: /opt/oracle/oradata/orcl/redo03.log Successful open of redo thread 1. Wed Dec 19 09:02:29 2012 SMON: enabling cache recovery Wed Dec 19 09:02:29 2012 Undo Segment 1 Onlined Undo Segment 2 Onlined Undo Segment 3 Onlined Undo Segment 4 Onlined Undo Segment 5 Onlined Undo Segment 6 Onlined Undo Segment 7 Onlined Undo Segment 8 Onlined Undo Segment 9 Onlined Undo Segment 10 Onlined Successfully onlined Undo Tablespace 1. Wed Dec 19 09:02:29 2012 SMON: enabling tx recovery Wed Dec 19 09:02:29 2012 Database Characterset is ZHS16GBK replication_dependency_tracking turned off (no async multimaster replication found) Completed: /* OracleOEM */ ALTER DATABASE OPEN Wed Dec 19 09:02:30 2012 SMON: Parallel transaction recovery tried Wed Dec 19 09:04:23 2012 ARCH: Possible network disconnect with primary database Wed Dec 19 12:55:45 2012 ORACLE Instance orcl - Can not allocate log, archival required Wed Dec 19 12:55:45 2012 ARCH: Connecting to console port... Thread 1 cannot allocate new log, sequence 455 All online logs needed archiving Current log# 3 seq# 454 mem# 0: /opt/oracle/oradata/orcl/redo03.log Wed Dec 19 13:04:49 2012 Shutting down instance: further logons disabled Shutting down instance (normal) License high water mark = 7 Wed Dec 19 13:06:49 2012 Starting ORACLE instance (normal) Wed Dec 19 13:10:01 2012 Active process 4561 user 'oracle' program 'oracle@localhost (QMN0)' Active process 4976 user 'oracle' program 'oracle@localhost (TNS V1-V3)' SHUTDOWN: waiting for logins to complete. Wed Dec 19 13:11:21 2012 Shutting down instance (abort) 不会看。

[iqlife]

删除数据表之后再次导入总是失败？ 如何删除的？删除后提交了？

[zzxing]

连表起删除的，所有用户对象一起删除了。再重新导入。

[zzxing]

机器重启了N回，也删除了N次（每次只能导入很小部分数据）。 今天测试：另建了一用户和表空间，试着导入一个大小为50M左右的dmp文件，成功。 再接着，重新导入正式库文件(1G左右)，进度还没达到上次导入那里就停顿了。