oracle9i ora-07445 error
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 4 of 4

Thread: oracle9i ora-07445 error

  1. #1
    Join Date
    Jan 2002
    Posts
    26

    Angry

    I install oracle9i in RedHat7.1 ,but every time i start oracle instance ,I can find a lot of error messages like :
    " Errors in file /work/oracle/9i/admin/olapp/udump/ora_23517.trc:
    ORA-07445: core dump [zllcini()+186] [SIGSEGV] [Address not mapped to o
    bject] [0xC] [] [] ".


    And after about a few hours later ,the system halt and i have to restart server.

    Anyone can help me?

  2. #2
    Join Date
    Jun 2000
    Posts
    117

    Unhappy

    Your not going to like this answer . . .
    But, I looked up the error using Instant Messages from Quest Software and its says:

    Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.

    Action: Contact Oracle Support Services

    Sorry but its like a ora-00600 . . . contact Oracle Support because you screwed.
    E. Yen
    OCP DBA 8, 8i, 9i

  3. #3
    Join Date
    Aug 2001
    Posts
    75
    Here is some detail from Metalink.

    Problem Description
    -------------------

    You are receiving an ORA-7445 error when creating a trigger in version 9.0.1.1,
    possibly using a third-party tool such as Toad. The error appears similar to
    the following:

    ORA-07445: exception encountered: core dump [0000000101B6D1FC] [SIGSEGV]
    [Address not mapped to object] [0x000000010] [] []

    Solution Description
    --------------------

    1. Try dropping and recreating the trigger, which often resolves the problem.

    2. Make sure you are using SQL*Plus and *not* Toad to compile the problem
    trigger.

    If these suggestions fail, do the following:

    1. ANALYZE all tables and indexes associated with this trigger with a
    VALIDATE STRUCTURE.

    2. Shutdown the database and relink all of Oracle, including SQL*Plus.

    3. Upgrade to the latest Oracle9i patchset.



    Originally posted by eyen
    Your not going to like this answer . . .
    But, I looked up the error using Instant Messages from Quest Software and its says:

    Cause: An operating system exception occurred which should result in the creation of a core file. This is an internal error.

    Action: Contact Oracle Support Services

    Sorry but its like a ora-00600 . . . contact Oracle Support because you screwed.
    OCP 8i

  4. #4
    Join Date
    Jun 2000
    Posts
    117
    I looked up that metalink answer
    Doc ID: Note:182707.1

    What does it have to do with 9i not working properly on Red Hat?

    The metalink answer has to do with creation of triggers using a third party tool.


    E. Yen
    OCP DBA 8, 8i, 9i

Posting Permissions

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



Click Here to Expand Forum to Full Width