本帖最后由 jieyancai 于 2016-5-4 23:00 编辑
windows2003x86+oracle10.2.0.4 32位
数据库突然当掉,没人说在那个时间点干过啥。
alert日志报错:
Mon May 02 22:00:13 2016
Thread 1 advanced to log sequence 5315 (LGWR switch)
Current log# 2 seq# 5315 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BD\REDO02.LOG
Tue May 03 02:05:29 2016
Thread 1 advanced to log sequence 5316 (LGWR switch)
Current log# 3 seq# 5316 mem# 0: D:\ORACLE\PRODUCT\10.2.0\ORADATA\BD\REDO03.LOG
Tue May 03 10:04:22 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_psp0_12136.trc:
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
Tue May 03 10:04:22 2016
PSP0: terminating instance due to error 9314
Tue May 03 10:04:22 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_q003_58180.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:22 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_pmon_6616.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:23 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_mman_12148.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:23 2016
Error occured while spawning process J000; error = 9314
Tue May 03 10:04:23 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_dbw0_9772.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:24 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_ckpt_10744.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:25 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_lgwr_11020.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:51 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_reco_9860.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:51 2016
Errors in file d:\oracle\product\10.2.0\admin\bd\bdump\bd_smon_7636.trc:
ORA-09314: sltln: error translating logical name
Tue May 03 10:04:52 2016
Instance terminated by PSP0, pid = 12136
---trace文件如下:
Dump filed:\oracle\product\10.2.0\admin\bd\bdump\bd_psp0_12136.trc
Tue May 03 10:04:22 2016
ORACLE V10.2.0.4.0 - Production vsnsta=0
vsnsql=14 vsnxtr=3
Oracle Database 10g Enterprise EditionRelease 10.2.0.4.0 - Production
With the Partitioning, OLAP, Data Miningand Real Application Testing options
Windows Server 2003 Version V5.2 ServicePack 2
CPU : 8 - type 586, 2 PhysicalCores
Process Affinity : 0x00000000
Memory (Avail/Total): Ph:2634M/6143M,Ph+PgF:7399M/14773M, VA:1238M/2047M
Instance name: bd
Redo thread mounted by this instance: 1
Oracle process number: 3
Windows thread id: 12136, image: ORACLE.EXE(PSP0)
*** 2016-05-03 10:04:22.453
*** SERVICE NAME:(SYS$BACKGROUND)2016-05-03 10:04:22.406
*** SESSION ID:(444.1) 2016-05-0310:04:22.406
error 9314 detected in background process
ORA-09314: sltln: error translating logicalname
OSD-04503: Message 4503 not found; Nomessage file for product=RDBMS, facility=SOSD
*** 2016-05-03 10:04:28.421 ssthreadkillsafe:about to forcefully terminate tid=89120, dumping call stack:
------------------- Call Stack Trace---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- -------- ---------------- --------
7C9585EC 00000000 00000000 00000000 00000000 00000000
62652572 00000000 00000000 00000000 00000000 00000000
6265170A 6265250C 0000000000000000 00000000 00000000
609F467F 00000000 0a6388ac 0a63cac2 0a638a40 00000000
609BBE46 609F4514 0a638580 0acbce58 0a41eee0 00000000
609A6CB6 609BBDCC 0a6385800a41eee0 00000000 00000000
609A6875 609A68B4 0a41edc4 00000055 0a41eee0 00000000
6097A4AC 609A6860 0a41edc4 0a41eee0 0acbd944 00000000
__PGOSF121__opikndf2+781 00000000 00000000 00000000 00000000 00000000
_opitsk+559 00000000 00000000 00000000 00000000 00000000
_opiino+1087 _opitsk+0 00000000 00000000 00000000 00000000
_opiodr+1286 00000000 0000003c 00000004 0acbfc28 00000000
_opidrv+819 _opiodr+0 0000003c 00000004 0acbfc28 00000000
_sou2o+45 _opidrv+0 0000003c 00000004 0acbfc28 00000000
_opimai_real+112 _sou2o+0 0acbfc1c 0000003c 00000004 0acbfc28
_opimai+92 _opimai_real+0 00000002 0acbfc54 00000000 00000000
_OracleThreadStart@4+726 _opimai+0 00000000 00000000 00000000 00000000
7C824826 00000000 00000000 00000000 00000000 00000000
---------------- End of Call Stack Trace-----------------
Call stack acquisition performance stats:
setup time (lock acquis., memory alloc.): 0 ms
frame get time (time the target proc was suspended): 0 ms
symbol translation time: 62 ms
total time: 62 ms
当前数据库服务无法启动,监听服务也无法启动。
sysdba连接报错如下:
C:\Documents and Settings\Administrator>sqlplus /nolog
Error 6 initializing SQL*Plus
Message file sp1.msb not found
SP2-0750: You may need to set ORACLE_HOME to your Oracle software directory
C:\Documents and Settings\Administrator>set ORACLE_HOME=D:\oracle\product\10.2.0\db_1
C:\Documents and Settings\Administrator>set ORACLE_SID=bd
C:\Documents and Settings\Administrator>sqlplus /nolog
SQL*Plus: Release 10.2.0.4.0 - Production on Wed May 4 22:52:44 2016
Copyright (c) 1982, 2007, Oracle. All Rights Reserved.
SQL> conn /as sysdba
ERROR:
ORA-01031: Message 1031 not found; No message file for product=RDBMS,
facility=ORA
SQL> exit