【求助】oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced

[jhkwolf]

oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced
redhat linux 下安装oracle9i。一直正常使用。由于服务器内存较小，今天把他用vmare迁移到新服务器的虚拟机上。结果oracle打不开了。
报
ORA-01092: ORACLE instance terminated. Disconnection forced错误




日志是这样的.字数超限了。我分成两节

Starting ORACLE instance (normal)
Shutting down instance: further logons disabled
Shutting down instance (normal)
License high water mark = 1
Waiting for shared server 'S000' to die
All dispatchers and shared servers shutdown
Mon May 25 23:37:37 2015
ALTER DATABASE CLOSE NORMAL
ORA-1109 signalled during: ALTER DATABASE CLOSE NORMAL...
Mon May 25 23:37:37 2015
ALTER DATABASE DISMOUNT
Completed: ALTER DATABASE DISMOUNT
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
ARCH: Archiving is disabled
Shutting down archive processes
Archiving is disabled
Archive process shutdown avoided: 0 active
Mon May 25 23:37:47 2015
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
SCN scheme 2
Using log_archive_dest parameter default value
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 9.2.0.4.0.
System parameters with non-default values:
processes = 150
timed_statistics = TRUE
shared_pool_size = 100663296
large_pool_size = 67108864
java_pool_size = 33554432
control_files = /var/data/oracle/oradata/ora8i/control01.ctl, /var/data/oracle/oradata/ora8i/control02.ctl, /var/data/oracle/oradata/ora8i/control03.ctl
db_block_size = 8192
db_cache_size = 268435456
compatible = 9.2.0.0.0
db_file_multiblock_read_count= 16
fast_start_mttr_target = 300
undo_management = AUTO
undo_tablespace = UNDOTBS1
undo_retention = 10800
remote_login_passwordfile= EXCLUSIVE
db_domain =
instance_name = ora8i
dispatchers = (PROTOCOL=TCP) (SERVICE=ora8iXDB)
hash_join_enabled = TRUE
background_dump_dest = /opt/oracle/admin/ora8i/bdump
user_dump_dest = /opt/oracle/admin/ora8i/udump
core_dump_dest = /opt/oracle/admin/ora8i/cdump
sort_area_size = 524288
db_name = ora8i
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 239075328
PMON started with pid=2
DBW0 started with pid=3
LGWR started with pid=4
CKPT started with pid=5
SMON started with pid=6
RECO started with pid=7
Mon May 25 23:37:49 2015
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Mon May 25 23:37:49 2015
ALTER DATABASE MOUNT
Mon May 25 23:37:53 2015
Successful mount of redo thread 1, with mount id 302487309.
Mon May 25 23:37:53 2015
Database mounted in Exclusive Mode.
Completed: ALTER DATABASE MOUNT
Mon May 25 23:37:53 2015
ALTER DATABASE OPEN
Mon May 25 23:37:53 2015
Beginning crash recovery of 1 threads
Mon May 25 23:37:53 2015
Started first pass scan
Mon May 25 23:37:53 2015
Completed first pass scan
64 redo blocks read, 4 data blocks need recovery
Mon May 25 23:37:53 2015
Started recovery at
Thread 1: logseq 350, block 2, scn 0.117739564
Recovery of Online Redo Log: Thread 1 Group 2 Seq 350 Reading mem 0
Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo02.log
Mon May 25 23:37:53 2015
Completed redo application
Mon May 25 23:37:53 2015
Ended recovery at
Thread 1: logseq 350, block 66, scn 0.117759659
4 data blocks read, 4 data blocks written, 64 redo blocks read
Crash recovery completed successfully
Mon May 25 23:37:53 2015
Thread 1 advanced to log sequence 351
Thread 1 opened at log sequence 351
Current log# 3 seq# 351 mem# 0: /var/data/oracle/oradata/ora8i/redo03.log
Successful open of redo thread 1.
Mon May 25 23:37:53 2015
SMON: enabling cache recovery
Mon May 25 23:37:53 2015
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.
Mon May 25 23:37:53 2015
SMON: enabling tx recovery
Mon May 25 23:37:53 2015
Database Characterset is ZHS16GBK
Mon May 25 23:37:53 2015
Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_6990.trc:
ORA-00600: internal error code, arguments: [4194], [25], [39], [], [], [], [], []
Mon May 25 23:37:54 2015
Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_6982.trc:
ORA-00600: internal error code, arguments: [4194], [25], [39], [], [], [], [], []
Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0
Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log
Mon May 25 23:37:59 2015
Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0
Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log
Mon May 25 23:38:00 2015
Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0
Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log
Mon May 25 23:38:00 2015
Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0
Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log
Mon May 25 23:38:00 2015
Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_6990.trc:
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [25], [39], [], [], [], [], []
Mon May 25 23:38:00 2015
Error 607 happened during db open, shutting down database
USER: terminating instance due to error 607
Mon May 25 23:38:00 2015
Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_6982.trc:
ORA-00604: error occurred at recursive SQL level 1
ORA-00607: Internal error occurred while making a change to a data block
ORA-00600: internal error code, arguments: [4194], [25], [39], [], [], [], [], []
Instance terminated by USER, pid = 6990
ORA-1092 signalled during: ALTER DATABASE OPEN...

请教各位大大,这是什么原因，我该怎么办呢？。急急急啊。

[jhkwolf]

这是后面一节日志 Mon May 25 23:55:49 2015 Starting ORACLE instance (normal) LICENSE_MAX_SESSION = 0 LICENSE_SESSIONS_WARNING = 0 SCN scheme 2 Using log_archive_dest parameter default value LICENSE_MAX_USERS = 0 SYS auditing is disabled Starting up ORACLE RDBMS Version: 9.2.0.4.0. System parameters with non-default values: processes = 150 timed_statistics = TRUE shared_pool_size = 100663296 large_pool_size = 67108864 java_pool_size = 33554432 control_files = /var/data/oracle/oradata/ora8i/control01.ctl, /var/data/oracle/oradata/ora8i/control02.ctl, /var/data/oracle/oradata/ora8i/control03.ctl db_block_size = 8192 db_cache_size = 268435456 compatible = 9.2.0.0.0 db_file_multiblock_read_count= 16 fast_start_mttr_target = 300 undo_management = AUTO undo_tablespace = UNDOTBS1 undo_retention = 10800 remote_login_passwordfile= EXCLUSIVE db_domain = instance_name = ora8i dispatchers = (PROTOCOL=TCP) (SERVICE=ora8iXDB) hash_join_enabled = TRUE background_dump_dest = /opt/oracle/admin/ora8i/bdump user_dump_dest = /opt/oracle/admin/ora8i/udump core_dump_dest = /opt/oracle/admin/ora8i/cdump sort_area_size = 524288 db_name = ora8i open_cursors = 300 star_transformation_enabled= FALSE query_rewrite_enabled = FALSE pga_aggregate_target = 239075328 PMON started with pid=2 DBW0 started with pid=3 LGWR started with pid=4 CKPT started with pid=5 SMON started with pid=6 RECO started with pid=7 Mon May 25 23:55:50 2015 starting up 1 shared server(s) ... starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'... Mon May 25 23:55:51 2015 ALTER DATABASE MOUNT Mon May 25 23:55:55 2015 Successful mount of redo thread 1, with mount id 302528071. Mon May 25 23:55:55 2015 Database mounted in Exclusive Mode. Completed: ALTER DATABASE MOUNT Mon May 25 23:56:44 2015 alter database clear logfile group 4 Mon May 25 23:56:44 2015 ORA-359 signalled during: alter database clear logfile group 4... Mon May 25 23:57:52 2015 alter database clear unarchived logfile group 4 Mon May 25 23:57:52 2015 ORA-359 signalled during: alter database clear unarchived logfile group 4... Tue May 26 00:00:39 2015 alter database open Tue May 26 00:00:39 2015 Beginning crash recovery of 1 threads Tue May 26 00:00:39 2015 Started first pass scan Tue May 26 00:00:40 2015 Completed first pass scan 54 redo blocks read, 4 data blocks need recovery Tue May 26 00:00:40 2015 Started recovery at Thread 1: logseq 351, block 3, scn 0.0 Recovery of Online Redo Log: Thread 1 Group 3 Seq 351 Reading mem 0 Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo03.log Tue May 26 00:00:40 2015 Completed redo application Tue May 26 00:00:40 2015 Ended recovery at Thread 1: logseq 351, block 57, scn 0.117779741 4 data blocks read, 4 data blocks written, 54 redo blocks read Crash recovery completed successfully Tue May 26 00:00:40 2015 Thread 1 advanced to log sequence 352 Thread 1 opened at log sequence 352 Current log# 1 seq# 352 mem# 0: /var/data/oracle/oradata/ora8i/redo01.log Successful open of redo thread 1. Tue May 26 00:00:40 2015 SMON: enabling cache recovery Tue May 26 00:00:40 2015 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. Tue May 26 00:00:40 2015 SMON: enabling tx recovery Tue May 26 00:00:40 2015 Database Characterset is ZHS16GBK Tue May 26 00:00:40 2015 Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_7044.trc: ORA-00600: internal error code, arguments: [4194], [54], [51], [], [], [], [], [] Tue May 26 00:00:40 2015 Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_7036.trc: ORA-00600: internal error code, arguments: [4194], [

33], [38], [], [], [], [], [] Tue May 26 00:00:46 2015 Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0 Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0 Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log Tue May 26 00:00:46 2015 Errors in file /opt/oracle/admin/ora8i/bdump/ora8i_smon_7036.trc: ORA-00604: error occurred at recursive SQL level 1 ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [33], [38], [], [], [], [], [] Tue May 26 00:00:47 2015 Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0 Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log Recovery of Online Redo Log: Thread 1 Group 1 Seq 352 Reading mem 0 Mem# 0 errs 0: /var/data/oracle/oradata/ora8i/redo01.log Tue May 26 00:00:47 2015 Errors in file /opt/oracle/admin/ora8i/udump/ora8i_ora_7044.trc: ORA-00607: Internal error occurred while making a change to a data block ORA-00600: internal error code, arguments: [4194], [54], [51], [], [], [], [], [] Error 607 happened during db open, shutting down database USER: terminating instance due to error 607 Instance terminated by USER, pid = 7044 ORA-1092 signalled during: alter database open ...

[jhkwolf]

对了。我有exp导出来的完整数据。

[jhkwolf]

还有我原来服务器内存是1G的。新服务器的虚拟机我分配了8G内存。不知道是什么参数要调整不？