- 论坛徽章:
- 0
|
连续几次,oracle当掉,客户端显示是tns失败,服务器没法重启oracle服务,只能重启机器。
系统日志:
2011-6-13 21:40:25 Service Control Manager 信息 无 7036 N/A YIWEBIMATI-2UV0 OracleDBConsoleorcl 服务处于 停止 状态。
2011-6-13 21:40:24 Service Control Manager 信息 无 7036 N/A YIWEBIMATI-2UV0 WMI Performance Adapter 服务处于 停止 状态。
2011-5-16 11:11:52 Service Control Manager 信息 无 7036 N/A YIWEBIMATI-2UV0 OracleOraDb10g_home1TNSListener 服务处于 停止 状态。
2011-5-16 11:11:52 Service Control Manager 信息 无 7035 YIWEBIMATI-2UV0\Administrator YIWEBIMATI-2UV0 OracleOraDb10g_home1TNSListener 服务成功发送一个 停止 控件。
2011-5-16 10:49:05 Service Control Manager 信息 无 7036 N/A YIWEBIMATI-2UV0 WMI Performance Adapter 服务处于 停止 状态。
2011-5-16 10:48:23 Service Control Manager 信息 无 7036 N/A YIWEBIMATI-2UV0 OracleDBConsoleorcl 服务处于 停止 状态。
alter.log
Mon May 16 09:46:57 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31370
Current log# 1 seq# 31370 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG
Mon May 16 09:55:49 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31371
Current log# 2 seq# 31371 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG
Mon May 16 10:01:57 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31372
Current log# 3 seq# 31372 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG
Mon May 16 10:09:29 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31373
Current log# 1 seq# 31373 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG
Mon May 16 10:18:44 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31374
Current log# 2 seq# 31374 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO02.LOG
Mon May 16 10:26:23 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31375
Current log# 3 seq# 31375 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO03.LOG
Mon May 16 10:44:45 2011
Private_strands 7 at log switch
Thread 1 advanced to log sequence 31376
Current log# 1 seq# 31376 mem# 0: E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\REDO01.LOG
Dump file e:\oracle\product\10.1.0\admin\orcl\bdump\alert_orcl.log
Mon May 16 11:20:09 2011
ORACLE V10.1.0.2.0 - Production vsnsta=0
vsnsql=13 vsnxtr=3
Windows Server 2003 Version V5.2
CPU : 2 - type 586, 1 Physical Cores
Process Affinity: 0x00000000
Memory (A/P) : PH:1596M/2046M, PG:3694M/3946M, VA:1957M/2047M
Mon May 16 11:20:09 2011
Starting ORACLE instance (normal)
LICENSE_MAX_SESSION = 0
LICENSE_SESSIONS_WARNING = 0
Picked latch-free SCN scheme 2
KCCDEBUG_LEVEL = 0
Using LOG_ARCHIVE_DEST_10 parameter default value as USE_DB_RECOVERY_FILE_DEST
Autotune of undo retention is turned on.
Dynamic strands is set to TRUE
Running with 2 shared and 18 private strand(s). Zero-copy redo is FALSE
IMODE=BR
ILAT =18
LICENSE_MAX_USERS = 0
SYS auditing is disabled
Starting up ORACLE RDBMS Version: 10.1.0.2.0.
System parameters with non-default values:
processes = 150
shared_pool_size = 83886080
large_pool_size = 8388608
java_pool_size = 50331648
control_files = E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL01.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL02.CTL, E:\ORACLE\PRODUCT\10.1.0\ORADATA\ORCL\CONTROL03.CTL |
|