- 最后登录
- 2017-5-4
- 在线时间
- 81 小时
- 威望
- 999
- 金钱
- 2391
- 注册时间
- 2013-9-11
- 阅读权限
- 150
- 帖子
- 1124
- 精华
- 5
- 积分
- 999
- UID
- 1220
|
1#
发表于 2017-4-13 14:54:41
|
查看: 1230 |
回复: 0
【求助】oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced
oracle 启动不了了ORA-01092: ORACLE instance terminated. Disconnection forced
redhat linux 下安装oracle9i。一直正常使用。由于服务器内存较小,今天把他用vmare迁移到新服务器的虚拟机上。结果oracle打不开了。
报
ORA-01092: ORACLE instance terminated. Disconnection forced错误
还有我原来服务器内存是1G的。新服务器的虚拟机我分配了8G内存。不知道是什么参数要调整不?
目前我原有数据库服务器还在正常运行着。可以随时导出数据来,但我不知道该怎么把它迁移过来了。
是我需要重新迁移吗还是怎么,如果需要重新迁移,请问下需要注意些什么。
当然如果能够直接解决数据库启动的问题就更好了
请教各位大大,这是什么原因,我该怎么办呢?。急急急啊。
日志如下:
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 |
|