Results 1 to 2 of 2

Thread: Oracle crashed!

  1. #1
    Join Date
    Aug 2004
    Posts
    9

    Unanswered: Oracle crashed!

    This morning our Oracle server crashed. We were able to just start it up again, but nonetheless it's pretty odd. This is an Oracle 10g install on a Red Hat ES 3.0 system -- 2GB's memory and plenty of diskspace. Here's the error from the alert log:

    Thu Aug 26 12:36:31 2004
    DBW0: terminating instance due to error 472
    Instance terminated by DBW0, pid = 19328

    Browsing through the rest of the log, I see a lot of errors like this:

    found dead shared server 'S002', pid = (16, 209)
    found dead shared server 'S004', pid = (22, 120)
    found dead shared server 'S005', pid = (26, 221)
    found dead shared server 'S006', pid = (27, 101)
    found dead shared server 'S009', pid = (30, 248)
    found dead dispatcher 'D000', pid = (17, 236)
    found dead dispatcher 'D001', pid = (43, 30)

    Here's the top portion of one of the trace files:

    ORACLE_HOME = /u01/app/oracle/product/10.1.0/db_1
    System name: Linux
    Node name: oracle10g
    Release: 2.4.21-15.0.4.ELsmp
    Version: #1 SMP Sat Jul 31 01:25:25 EDT 2004
    Machine: i686
    Instance name: dpndb
    Redo thread mounted by this instance: 1
    Oracle process number: 10
    Unix process pid: 8891, image: oracle@oracle10g (S002)

    *** SERVICE NAMEdpndb) 2004-08-26 12:36:22.336
    *** SESSION ID536.46481) 2004-08-26 12:36:22.336
    Exception signal: 11 (SIGSEGV), code: 1 (Address not mapped to object), addr: 0x10104, PC: [0xa479a45, kghpih()+99]
    Registers:
    %eax: 0x00010100 %ebx: 0x0bf24418 %ecx: 0x00000001
    %edx: 0x00010100 %edi: 0x8ca5db28 %esi: 0x00000000
    %esp: 0xbfff3184 %ebp: 0xbfff3190 %eip: 0x0a479a45
    %efl: 0x00010206
    kghpih()+90 (0xa479a3c) test %eax,%eax
    kghpih()+92 (0xa479a3e) je 0xa479a4c
    kghpih()+94 (0xa479a40) mov 0x4(%edx),%eax
    kghpih()+97 (0xa479a43) mov %eax,%edx
    > kghpih()+99 (0xa479a45) mov 0x4(%eax),%eax
    kghpih()+102 (0xa479a48) test %eax,%eax
    kghpih()+104 (0xa479a4a) jne 0xa479a43
    kghpih()+106 (0xa479a4c) mov 0xffffffe4(%edx),%eax
    kghpih()+109 (0xa479a4f) lea 0xffffffe4(%edx),%ebx
    *** 2004-08-26 12:36:22.351
    ksedmp: internal or fatal error
    ORA-07445: exception encountered: core dump [kghpih()+99] [SIGSEGV] [Address not mapped to object] [0x10104] [] []
    Current SQL statement for this session:
    SELECT PARAMETER_VALUE FROM MGMT_PARAMETERS WHERE PARAMETER_NAME = :B1

    I'm not sure how to track down what's causing the problem... should we consider turning off shared servers / dispatchers?

    One thing I've noticed is that our TEMP tablespace grows very quickly and when we gave it more space (up to 10GB) it immediately filled it all the way up. Maybe this is a problem?

    Anyways, hoping someone can get me started diagnosing this.

  2. #2
    Join Date
    Aug 2003
    Location
    Where the Surf Meets the Turf @Del Mar, CA
    Posts
    7,776
    Provided Answers: 1
    Submit an iTAR. Only Oracle support can assist you.
    You can lead some folks to knowledge, but you can not make them think.
    The average person thinks he's above average!
    For most folks, they don't know, what they don't know.
    Good judgement comes from experience. Experience comes from bad judgement.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •