zhouyuchen
2009-07-17 13:54 阅读 364
已采纳

oracle 服务自动关闭 alert.log

今天服务器的oracle服务自己关闭了,不知道是什么原因,下面是alert.log
哪位大哥看看下面的哪个地方有问题 谢谢 最好分析一下。

Fri Jul 17 01:56:08 2009
Thread 1 advanced to log sequence 14
Current log# 1 seq# 14 mem# 0: D:\ORACLE\ORADATA\BXXH\REDO01.LOG
Dump file d:\oracle\admin\bxxh\bdump\alert_bxxh.log
Fri Jul 17 11:20:05 2009
ORACLE V9.2.0.1.0 - Production vsnsta=0
vsnsql=12 vsnxtr=3
Windows 2000 Version 5.2 Service Pack 2, CPU type 586
Fri Jul 17 11:20:05 2009
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.1.0.
System parameters with non-default values:
processes = 570
timed_statistics = TRUE
shared_pool_size = 268435456
sga_max_size = 739319768
large_pool_size = 8388608
java_pool_size = 33554432
control_files = D:\oracle\oradata\bxxh\CONTROL01.CTL, D:\oracle\oradata\bxxh\CONTROL02.CTL, D:\oracle\oradata\bxxh\CONTROL03.CTL
db_block_size = 8192
db_cache_size = 377487360
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 = bxxh
dispatchers = (PROTOCOL=TCP) (SERVICE=bxxhXDB)
job_queue_processes = 10
hash_join_enabled = TRUE
background_dump_dest = D:\oracle\admin\bxxh\bdump
user_dump_dest = D:\oracle\admin\bxxh\udump
core_dump_dest = D:\oracle\admin\bxxh\cdump
sort_area_size = 524288
db_name = bxxh
open_cursors = 300
star_transformation_enabled= FALSE
query_rewrite_enabled = FALSE
pga_aggregate_target = 50331648
aq_tm_processes = 1
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
CJQ0 started with pid=8
QMN0 started with pid=9
Fri Jul 17 11:20:07 2009
starting up 1 shared server(s) ...
starting up 1 dispatcher(s) for network address '(ADDRESS=(PARTIAL=YES)(PROTOCOL=TCP))'...
Fri Jul 17 11:20:08 2009
alter database mount exclusive
Fri Jul 17 11:20:12 2009
Successful mount of redo thread 1, with mount id 3574894440.
Fri Jul 17 11:20:12 2009
Database mounted in Exclusive Mode.
Completed: alter database mount exclusive
Fri Jul 17 11:20:12 2009
alter database open
Fri Jul 17 11:20:13 2009
Beginning crash recovery of 1 threads
Fri Jul 17 11:20:13 2009
Started first pass scan
Fri Jul 17 11:20:13 2009
Completed first pass scan
3567 redo blocks read, 71 data blocks need recovery
Fri Jul 17 11:20:13 2009
Started recovery at
Thread 1: logseq 14, block 60299, scn 0.0
Recovery of Online Redo Log: Thread 1 Group 1 Seq 14 Reading mem 0
Mem# 0 errs 0: D:\ORACLE\ORADATA\BXXH\REDO01.LOG
Fri Jul 17 11:20:14 2009
Ended recovery at
Thread 1: logseq 14, block 63866, scn 0.1842871
71 data blocks read, 71 data blocks written, 3567 redo blocks read
Crash recovery completed successfully
Fri Jul 17 11:20:14 2009
Thread 1 advanced to log sequence 15
Thread 1 opened at log sequence 15
Current log# 2 seq# 15 mem# 0: D:\ORACLE\ORADATA\BXXH\REDO02.LOG
Successful open of redo thread 1.
Fri Jul 17 11:20:14 2009
SMON: enabling cache recovery
Fri Jul 17 11:20:15 2009
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 Jul 17 11:20:15 2009
SMON: enabling tx recovery
Fri Jul 17 11:20:15 2009
Database Characterset is ZHS16GBK
replication_dependency_tracking turned off (no async multimaster replication found)
Completed: alter database open

  • 点赞
  • 写回答
  • 关注问题
  • 收藏
  • 复制链接分享

3条回答 默认 最新

  • 已采纳
    weixin_42515006 天动 2009-07-19 23:20

    是如何确定自动关闭了呢?
    服务进程不在了?还是只是简单的应用程序没有响应了。

    使用processexplore之类的工具可以查看oracle.exe的进程/线程信息。

    看贴上来的日志,似乎不全,只到alter open,还是启动阶段。

    一般看alert日志,排查问题的话可以先关注一下有没有ORA-之类的错误编号。
    find ORA- alertSID.log

    listener的日志也可能会有一些帮助。
    1.通过sqlplus等工具是否可以连接。
    2.lsnrctl status看一下监听的状态信息,同时应该会告诉你日志的位置。

    点赞 评论 复制链接分享
  • wanghaolovezlq wanghaolovezlq 2009-07-17 14:03

    不至于吧,什么程序能这么把oracle服务都搞挂,。。。

    点赞 评论 复制链接分享
  • iteye_20589 iteye_20589 2009-07-17 15:12

    是哪个服务ORACLE监听服务吗?看看下面这个对你有帮助不
    [url]http://kalogen.iteye.com/blog/415102[/url]

    点赞 评论 复制链接分享

相关推荐