Next time do sqlplus "/ as sysdba", then "oradebug setmypid", then
"oradebug dump systemstate 10" and then "oradebug tracefile_name" to find
out the name of the generated trace file. That is good enough for oracle.
If your platform is 64 bit HP-UX 11.0, then you need an OS patch. Included
is the note about it from the mighty and all-knowing oracle:
Article-ID: <Note:73835.1>
Circulation: PUBLISHED (EXTERNAL)
Folder: server.DBA.Admin
Topic: Alerts
Title: ALERT:HP-UX: ORA-7445 and Core Dump Generating Oracle
Stack
Trace
Document-Type: ALERT
Impact: MEDIUM
Skill-Level: NOVICE
Updated-Date: 03-MAY-2001 06:19:51
ORA-7445 and Core Dump Generating Oracle Stack Trace
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Versions Affected
~~~~~~~~~~~~~~~~~
Oracle 8.X (64 bit only)
Platforms Affected
~~~~~~~~~~~~~~~~~~
HP-UX 11.00 (64 bit only)
Description
~~~~~~~~~~~
Whenever an Oracle stack trace is required, the shadow process will core
dump.
The stack trace in the corresponding trace file will be incomplete.
Likelihood of Occurrence
~~~~~~~~~~~~~~~~~~~~~~~~
Every time an Oracle stack trace is required. Some examples are:
1. an event has been set, and a stack trace is required in the trace file
2. some Oracle error requires a stack trace to be generated
Possible Symptoms
~~~~~~~~~~~~~~~~~
The alert.log will show something like:
ORA-07445: exception encountered: core dump [11] [4286564440] [240] [0]
[] []
The corresponding trace file will include the following in the stack:
_doprnt
_fprintf
U_get_previous_frame
skdstgframe
Error from U_get_previous_frame_x is 1
Stack is not Windable
Stack has no Unwind_descriptor
Workaround
~~~~~~~~~~
No workarounds available.
Patches
~~~~~~~
This problem is fixed by a HP patch. The first patch to include the
fix is:
PHSS_16849: s700_800 11.0 LIBCL patch
This patch will be superceeded; please contact HP Support for detailed
patch
information.
Oracle must be relinked after applying this patch, as follows:
%cd $ORACLE_HOME/rdbms/lib
%make -f ins_rdbms.mk ioracle
The instance needs to be shutdown when relinking.
References
~~~~~~~~~~
bug 939745 : ERRORSTACK EVENT CRASHES FOR 64 BIT ORACLE ON HPUX 11.0
Note 43507.1 : ALERT: HP-UX Patch Levels Advised
____________________________________________________________________________
__
Oracle WorldWide Customer
Support
> -----Original Message-----
> From: Jamadagni, Rajendra [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, May 21, 2002 4:00 PM
> To: Multiple recipients of list ORACLE-L
> Subject: DB Freeze
>
>
> Last Friday, our 9012 database froze, I mean the only way we
> could get in
> was through sqlplus, no other tool would connect. We needed
> to bring the
> other side up as soon as possible so didn't spend any time running any
> queries to see what was the problem. The other side (of the cluster)
> wouldn't come up because it reported that some resource it needed was
> locked. So we had to shot the pmon process.
>
> When analyzing the situation later, we found that Oracle didn't dump a
> single useful trace file, so contacting OWS was pretty much
> useless. OS logs
> were clean, no alarms raised there.
>
> Has anyone encountered this situation that Oracle freezes and crashes
> without any trace files? How does one collect useful
> information in such
> cases? Are there any tools that we could use to gather at-lease some
> information before the DB crashes?
>
> Thanks in advance for any ideas and tips.
> Raj
> ______________________________________________________
> Rajendra Jamadagni MIS, ESPN Inc.
> Rajendra dot Jamadagni at ESPN dot com
> Any opinion expressed here is personal and doesn't reflect
> that of ESPN Inc.
>
> QOTD: Any clod can have facts, but having an opinion is an art!
>
>
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Gogala, Mladen
INET: [EMAIL PROTECTED]
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
San Diego, California -- Public Internet access / Mailing Lists
--------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
