Oracle服务器启动一段时间后自动关机。急!!! 大家有没有遇到过这种情况:Oracle服务器启动一段时间后自己关机了。今天上午服务器自己关机,重新启动之后,下午服务器又自己关机了。是什么原因引起的呢?有没有解决的办法?急!老板过两天要检查,千万别出什么乱子。 解决方案 » 免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货 是重起还是关机?重起的话可能是window的自动更新造成的关机的话,除了病毒,会不会是cpu过热呢? oracle服务器装的是2003,不好意思.没有装杀毒软件,服务器操作系统win2003,还用不用装杀毒软件呢? Windows操作系统没的杀毒软件——悬 把alert_sid.log贴一下吧让大家一起来分析一下 是oracle服务关了还是操作系统也关了。 看看alert.log里面的报错信息是什么,贴出来看看 楼主说的是服务器down机了,而不是oracle的问题 现在Oracle有问题了,连不上数据库了,时断时续.Fri Feb 02 14:54:36 2007starting up 1 shared server(s) ...starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...Fri Feb 02 14:54:37 2007alter database mount exclusive Fri Feb 02 14:54:38 2007Errors in file d:\oracle\admin\hsrdb\udump\hsrdb_ora_796.trc:ORA-01033: ORACLE initialization or shutdown in progressFri Feb 02 14:54:47 2007Successful mount of redo thread 1, with mount id 3763368752.Fri Feb 02 14:54:48 2007Database mounted in Exclusive Mode.Completed: alter database mount exclusiveFri Feb 02 14:54:48 2007alter database openFri Feb 02 14:54:51 2007Beginning crash recovery of 1 threadsFri Feb 02 14:54:53 2007Started first pass scanFri Feb 02 14:54:56 2007Completed first pass scan 967 redo blocks read, 105 data blocks need recoveryFri Feb 02 14:54:57 2007Started recovery at Thread 1: logseq 391, block 51609, scn 0.0Recovery of Online Redo Log: Thread 1 Group 3 Seq 391 Reading mem 0 Mem# 0 errs 0: D:\DATABASE\HSRDB\REDO03.LOGFri Feb 02 14:55:01 2007Ended recovery at Thread 1: logseq 391, block 52576, scn 0.92260938 105 data blocks read, 105 data blocks written, 967 redo blocks readCrash recovery completed successfullyFri Feb 02 14:55:11 2007Thread 1 advanced to log sequence 392Thread 1 opened at log sequence 392 Current log# 1 seq# 392 mem# 0: D:\DATABASE\HSRDB\REDO01.LOGSuccessful open of redo thread 1.Fri Feb 02 14:55:13 2007SMON: enabling cache recoveryFri Feb 02 14:55:17 2007Undo Segment 1 OnlinedUndo Segment 2 OnlinedUndo Segment 3 OnlinedUndo Segment 4 OnlinedUndo Segment 5 OnlinedUndo Segment 6 OnlinedUndo Segment 7 OnlinedUndo Segment 8 OnlinedUndo Segment 9 OnlinedUndo Segment 10 OnlinedSuccessfully onlined Undo Tablespace 1.Fri Feb 02 14:55:19 2007SMON: enabling tx recoveryFri Feb 02 14:55:19 2007Database Characterset is ZHS16GBKFri Feb 02 14:55:31 2007replication_dependency_tracking turned off (no async multimaster replication found)Completed: alter database open 根据你贴出来的alert.log来看,Oracle本身没有问题,关键的问题可能出在服务器上. 给表空间扩容 dbms_output.put_line输出中文乱码 几道DBA面试题,大家可以做一做 怎样统计一个分区表中非空分区的个数? oracle9怎么建数据库 ORACLE 9I 卸载后重新安装问题 9i,PL/SQL中本地动态SQL执行DDL语句的问题 sql *plus的连接问题 如何根据年令计算出生日期? 请教: oracle中隐式光标如何使用? Oracle中,对如何对排序后的结果进行分页显示 迷惑,很简单的问题就是不知道为什么出错!
重起的话可能是window的自动更新造成的
关机的话,除了病毒,会不会是cpu过热呢?
没有装杀毒软件,服务器操作系统win2003,还用不用装杀毒软件呢?
让大家一起来分析一下
Fri Feb 02 14:54:36 2007
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Feb 02 14:54:37 2007
alter database mount exclusive
Fri Feb 02 14:54:38 2007
Errors in file d:\oracle\admin\hsrdb\udump\hsrdb_ora_796.trc:
ORA-01033: ORACLE initialization or shutdown in progressFri Feb 02 14:54:47 2007
Successful mount of redo thread 1, with mount id 3763368752.
Fri Feb 02 14:54:48 2007
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Feb 02 14:54:48 2007
alter database open
Fri Feb 02 14:54:51 2007
Beginning crash recovery of 1 threads
Fri Feb 02 14:54:53 2007
Started first pass scan
Fri Feb 02 14:54:56 2007
Completed first pass scan
967 redo blocks read, 105 data blocks need recovery
Fri Feb 02 14:54:57 2007
Started recovery at
Thread 1: logseq 391, block 51609, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 3 Seq 391 Reading mem 0
Mem# 0 errs 0: D:\DATABASE\HSRDB\REDO03.LOG
Fri Feb 02 14:55:01 2007
Ended recovery at
Thread 1: logseq 391, block 52576, scn 0.92260938
105 data blocks read, 105 data blocks written, 967 redo blocks read
Crash recovery completed successfully
Fri Feb 02 14:55:11 2007
Thread 1 advanced to log sequence 392
Thread 1 opened at log sequence 392
Current log# 1 seq# 392 mem# 0: D:\DATABASE\HSRDB\REDO01.LOG
Successful open of redo thread 1.
Fri Feb 02 14:55:13 2007
SMON: enabling cache recovery
Fri Feb 02 14:55:17 2007
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.
Fri Feb 02 14:55:19 2007
SMON: enabling tx recovery
Fri Feb 02 14:55:19 2007
Database Characterset is ZHS16GBK
Fri Feb 02 14:55:31 2007
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open