Hello
We had a database crash last night with this in the alert log:
Errors in file c:\oracle\diag\rdbms\vtrack11\vtrack11\trace\vtrack11_psp0_2204.trc:
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
PSP0 (ospid: 2204): terminating the instance due to error 9314
It's on ORACLE V11.2.0.1.0 on Windows 2008 server 32 bit with IncreaseUserVa set to 3072
The trace file content is listed below. It looks like the most important part is:
Symbol file %ORACLE_HOME%\BIN\orageneric11.SYM does not match binary.
Symbol TimeStamp=4bb5eb10, Module TimeStamp=0 are different
I see no "orageneric11.SYM" file in the BIN directory - only a orageneric11.DLL file
I do however see one in the RDBMS\ADMIN directory
The two files have the exact same timestamp
A simple database restart got the databasse up and running again (after automatic crash recovery)
Can anybody tell me why this happened, and what I should do to prevent it from happening again?
Trace file content:
Trace file c:\oracle\diag\rdbms\vtrack11\vtrack11\trace\vtrack11_psp0_2204.trc
Oracle Database 11g Release 11.2.0.1.0 - Production
Windows NT Version V6.0 Service Pack 2
CPU : 4 - type 586, 4 Physical Cores
Process Affinity : 0x0x00000000
Memory (Avail/Total): Ph:5383M/8179M, Ph+PgF:17289M/20360M, VA:328M/3071M
Instance name: vtrack11
Redo thread mounted by this instance: 1
Oracle process number: 7
Windows thread id: 2204, image: ORACLE.EXE (PSP0)
*** 2016-03-10 21:00:31.520
*** SESSION ID:(357.1) 2016-03-10 21:00:31.520
*** CLIENT ID:() 2016-03-10 21:00:31.520
*** SERVICE NAME:(SYS$BACKGROUND) 2016-03-10 21:00:31.520
*** MODULE NAME:() 2016-03-10 21:00:31.520
*** ACTION NAME:() 2016-03-10 21:00:31.520
error 9314 detected in background process
ORA-09314: sltln: error translating logical name
OSD-04503: Message 4503 not found; No message file for product=RDBMS, facility=SOSD
*** 2016-03-10 21:00:31.535
PSP0 (ospid: 2204): terminating the instance due to error 9314
Symbol file %ORACLE_HOME%\BIN\orageneric11.SYM does not match binary.
Symbol TimeStamp=4bb5eb10, Module TimeStamp=0 are different
EnumerateLoadedModules64 failed with error -1073741819
Symbol file orageneric11.SYM does not match binary.
Symbol TimeStamp=4bb5eb10, Module TimeStamp=0 are different
*** 2016-03-10 21:00:43.578
Symbol file %ORACLE_HOME%\BIN\orageneric11.SYM does not match binary.
Symbol TimeStamp=4bb5eb10, Module TimeStamp=0 are different
EnumerateLoadedModules64 failed with error -1073741819
Symbol file orageneric11.SYM does not match binary.
Symbol TimeStamp=4bb5eb10, Module TimeStamp=0 are different
Dump file c:\oracle\diag\rdbms\vtrack11\vtrack11\trace\vtrack11_psp0_2204.trc
Thu Mar 10 21:00:43 2016
ORACLE V11.2.0.1.0 - Production vsnsta=0
vsnsql=16 vsnxtr=3
*** 2016-03-10 21:00:43.594 ssthreadkillsafe: about to forcefully terminate tid=3200, dumping call stack:
------------------- Call Stack Trace ---------------------
calling location entry point arg #1 arg #2 arg #3 arg #4
------------------------------------------- ------------------------------------------- -------- -------- -------- --------
__tls_end()+127120041 00000000 00000000 00000000 00000000 00000000
_ksuitm()+701 00000000 000003e8 00000001 00000000 00000000
__VInfreq__kslwaitctx()+4734 _ksuitm() 00000000 00002462 00000000 00000000
_kslwaitctx()+154 _ksliwat() bc563f2c bc563f2c 000001f4 00000000
_kslwait()+159 _kslwaitctx() 5da2edbc 000001f4 5da2edbc 00009ba2
_ksarcv()+159 _kslwait() 000001f4 00000007 00000000 000001f4
_ksbabs()+343 _ksarcv() 5da2f248 5da2f1c0 000001f4 00000001
_ksbrdp()+980 00000000 069998b8 00000000 00000000 00000000
_opirip()+716 _ksbrdp() 00000000 00000000 00000000 00000000
_opidrv()+1237 _opirip() 00000032 00000004 5da2fe44 00000000
_sou2o()+55 _opidrv() 00000032 00000004 5da2fe44 00000000
_opimai_real()+245 _sou2o() 5da2fe54 00000032 00000004 5da2fe44
_opimai()+125 _opimai_real() 00000003 5da2fe7c 00000000 00000000
_BackgroundThreadStart@4()+550 _opimai() 00000003 5da2ff18 00000000 00000000
__tls_end()+107686233 00000000 08794950 5da2ffd4 77aa1603 08794950
__tls_end()+126970774 00000000 08794950 2a1194aa 00000000 00000000
__tls_end()+126970726 __tls_end()+126970737 0040171e 08794950 ffffffff 77b07b76
00000000 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: 0 ms
total time: 0 ms