Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Database crash - orageneric11.SYM does not match binary

KlausMogensenMar 11 2016 — edited Mar 11 2016

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

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 8 2016
Added on Mar 11 2016
3 comments
1,948 views