oracle database error ORA-07445: exception encountered: core dump [snstimsane()+36] [SIGSEGV] [Address

Posted on 2004-11-21
Last Modified: 2011-08-18
following error is comming from my oracle database

Sun Nov 21 15:01:25 2004
Errors in file /u01/app/oracle/admin/ittest/udump/ittest_ora_2806.trc:
ORA-07445: exception encountered: core dump [snstimsane()+36] [SIGSEGV] [Address
 not mapped to object] [0] [] []
Sun Nov 21 16:16:25 2004
Errors in file /u01/app/oracle/admin/ittest/udump/ittest_ora_16960.trc:
ORA-07445: exception encountered: core dump [snstimsane()+36] [SIGSEGV] [Address
 not mapped to object] [0] [] []
Sun Nov 21 16:24:48 2004
Thread 1 advanced to log sequence 31516
  Current log# 1 seq# 31516 mem# 0: /u06/oradata/ittest/redo/redo01.log
  Current log# 1 seq# 31516 mem# 1: /u05/oradata/ittest/redo/redo01a.log
Sun Nov 21 17:47:44 2004
Thread 1 advanced to log sequence 31517
  Current log# 2 seq# 31517 mem# 0: /u06/oradata/ittest/redo/redo02.log
  Current log# 2 seq# 31517 mem# 1: /u05/oradata/ittest/redo/redo02a.log
Sun Nov 21 19:11:21 2004
Thread 1 advanced to log sequence 31518
  Current log# 3 seq# 31518 mem# 0: /u06/oradata/ittest/redo/redo03.log
Question by:Roshanw4
    LVL 6

    Expert Comment


    Pl. check out if you have sufficient disk space on /u01

    u can use the df command for this.

    LVL 7

    Expert Comment

    In your sqlnet.ora file on the server, set the following to prevent the error



    Author Comment


    if i put the in my sqlnet.ora is there any after effects to the database or the system



    Expert Comment


    On most platforms the failing function can be identified by the error message in the alert.log. The error might look like this:
      ORA-07445: exception encountered: core dump [snstimsane()+44] [SIGSEGV] [Address not mapped to object]

    in which case the failing function is "snstimsane()". But on some platforms you will have to look in the tracefile for the "Call Stack Trace" and locate the first function that is not part of the error handling routines (see <Note:211909.1> for details). If the failing function is known either from the message reported in the alert.log or by looking at the call stack trace you can use the following to search for similar issues.


    velu n.
    LVL 7

    Accepted Solution

    sqlnet.expire_time=0 will disable dead connection detection.
    There are several bugs relating to this features causing core dumps / GPFs.

    It shouldnt affect your database in any way, unless you have lots of connections that are aborted (network errors, or users turning PC off etc)
    LVL 25

    Expert Comment

    No comment has been added to this question in more than 21 days, so it is now classified as abandoned..
    I will leave the following recommendation for this question in the Cleanup topic area:
       Split: Roshanw4 {http:#12661584}, BobMc {http:#12775318}

    Any objections should be posted here in the next 4 days. After that time, the question will be closed.

    John Bush
    EE Cleanup Volunteer

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    This article describes some very basic things about SQL Server filegroups.
    Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
    Video by: Steve
    Using examples as well as descriptions, step through each of the common simple join types, explaining differences in syntax, differences in expected outputs and showing how the queries run along with the actual outputs based upon a simple set of dem…
    Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    21 Experts available now in Live!

    Get 1:1 Help Now