The trouble with Ora-7445s is that they are even less specific than
ORA-600s. It's looking like the cause of the problem in our case is
something that a priori could not be happening to you, since our problem is
an event trigger which fires when Oracle encounters an Ora-600 error (a new
8i feature) and you're running 8.0.5. The trigger sure was a great idea, but
it's brand new and I've just dropped it. Hopefully this will be fixed in
8.1.6, though since Oracle just determined that it is a bug it may not have
been caught. Also, I don't have all the ramifications of this bug yet; I'm
just so happy to have progress on this TAR that I want the world to know
about it.
> -----Original Message-----
> From: Jack van Zanen [mailto:nlzanen1_at_ey.nl]
> Sent: Monday, May 08, 2000 6:43 AM
> To: Multiple recipients of list ORACLE-L
> Subject: RE: Core dump with ora 7445
>
>
>
> Hi Christopher,
>
>
> I'm running Oracle 8.0.5 on AIX 4.3.3 with win95
> I logged this error with Oracle WWS last thursday but no
> reply yet (we had
> holiday here on friday).
> Personally I feel it's a bug since the insert crashes as
> table owner, but the
> exact same insert works like a charm as another user with all
> the grants on the
> tables involved (ORA-00001 unique constraint violated message
> send to client
> instead of ORA-3113).
> I send Oracle WWS the tables involved and the user
> definitions and the exact
> scenario and hope they'll be able to duplicate the problem.
> However I wouldn't at all be surprised if they say upgrade to
> 8.0.5.1.2 first.
>
> Jack
>
>
>
>
> "Gait, Christopher" <cgait_at_condor.nrl.navy.mil>@fatcity.com
> on 05/05/2000
> 07:18:42 PM
>
> Please respond to ORACLE-L_at_fatcity.com
>
> Sent by: root_at_fatcity.com
>
>
> To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> cc:
>
>
> Can you fill me in on your setup? We are getting very similar
> behavior (a
> core dump on constraint violation was one of several
> triggering events) on
> our Digital 4.0d server running 8.1.5. Are you on similar
> hardware? If so we
> should go off-list and share notes on my currently opened TAR on this
> (12833964.600). We get core dumps from any unhandled user
> exception from
> some, but not all, client applications. This seems like
> either an Oracle bug
> or a client setup issue, because the same piece of code can cause an
> ORA-7445 & core dump & end of file on communications channel on SQL
> Worksheet or TOAD, but not on SQL*Plus, all running on the same client
> against the same server/instance. I'm looking into kernel
> settings right now
> (signal 11 is a segmentation fault, after all), and Oracle
> has issued bug
> 1282252 on the issue.
>
> I'll be out in Anaheim at IOUG-A if anyone wants to share
> notes on the joys
> of ORA-7445's with me. Also won't have access to my regular
> email the whole
> time, so please send to cjgait_at_yahoo.com if you want to talk
> about it this
> coming week.
>
> Christopher Gait
> Software Technology, Inc.
> An Exigent Company
> _________________________________________
> "Expedience is the mother of convention."
>
>
> > -----Original Message-----
> > From: Jack van Zanen [mailto:nlzanen1_at_ey.nl]
> > Sent: Wednesday, May 03, 2000 10:58 AM
> > To: Multiple recipients of list ORACLE-L
> > Subject: Core dump with ora 7445
> >
> >
> >
> >
> >
> >
> > Hi All,
> >
> >
> > We had some coredumps while running an insert statement with
> > following message
> >
> > ******************************
> >
> > Errors in file
> > /data/oracle8/disk1/PIVT/admin/udump/ora_25466_pivt.trc:
> > ORA-07445: exception encountered: core dump [11] [0] [0] [] [] []
> > ORA-00001: unique constraint (CABS.PKY_C_SECURITY_RLSHP) violated
> >
> > ******************************
> > we received a message on the client with the catch all
> > message 'end of file on
> > communication channel ........' and a coredump on UNIX.
> >
> > I know that Oracle did/does not like the unique key
> > violation, but is it normal
> > behaviour to coredump on it??
> > I would expect a message to the client saying it is a unique
> > key violation.
> >
> > Can anybody shed some light as to why this would happen
> > (Later on we ran the
> > proces as a different user and had no problems,
> > oracle just returned the violation error to the client)
> >
> > The only reason I can think of for now is that Oracle generated the
> > message ORA-00001 and had problems delivering it to the client so
> > decided to coredump instead but that is just guessing
> >
> > TIA
> >
> >
> > Jack
> >
> >
> >
> >
> >
> > ===================================================================
> > De informatie verzonden met dit E-mail bericht is uitsluitend
> > bestemd voor
> > de geadresseerde. Gebruik van deze informatie door anderen dan de
> > geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
> > verspreiding
> > en/of verstrekking van deze informatie aan derden is niet
> toegestaan.
> > Ernst & Young staat niet in voor de juiste en volledige
> > overbrenging van de
> > inhoud van een verzonden E-mail, noch voor tijdige
> ontvangst daarvan.
> > ===================================================================
> > The information contained in this communication is
> > confidential and may be
> > legally privileged. It is intended solely for the use of the
> > individual or
> > entity to whom it is addressed and others authorised to
> > receive it. If you
> > are not the intended recipient you are hereby notified that
> > any disclosure,
> > copying, distribution or taking any action in reliance on
> > the contents of
> > this information is strictly prohibited and may be unlawful. Ernst &
> > Young is neither liable for the proper and complete
> > transmission of the
> > information contained in this communication nor for any delay in its
> > receipt.
> > ===================================================================
> >
> >
> >
> > --
> > Author: Jack van Zanen
> > INET: nlzanen1_at_ey.nl
> >
> > 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: ListGuru_at_fatcity.com (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).
> >
> --
> Author: Gait, Christopher
> INET: cgait_at_condor.nrl.navy.mil
>
> 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: ListGuru_at_fatcity.com (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).
>
>
>
>
>
> ===================================================================
> De informatie verzonden met dit E-mail bericht is uitsluitend
> bestemd voor
> de geadresseerde. Gebruik van deze informatie door anderen dan de
> geadresseerde is verboden. Openbaarmaking, vermenigvuldiging,
> verspreiding
> en/of verstrekking van deze informatie aan derden is niet toegestaan.
> Ernst & Young staat niet in voor de juiste en volledige
> overbrenging van de
> inhoud van een verzonden E-mail, noch voor tijdige ontvangst daarvan.
> ===================================================================
> The information contained in this communication is
> confidential and may be
> legally privileged. It is intended solely for the use of the
> individual or
> entity to whom it is addressed and others authorised to
> receive it. If you
> are not the intended recipient you are hereby notified that
> any disclosure,
> copying, distribution or taking any action in reliance on
> the contents of
> this information is strictly prohibited and may be unlawful. Ernst &
> Young is neither liable for the proper and complete
> transmission of the
> information contained in this communication nor for any delay in its
> receipt.
> ===================================================================
>
>
>
> --
> Author: Jack van Zanen
> INET: nlzanen1_at_ey.nl
>
> 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: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
Received on Wed May 17 2000 - 09:15:21 CDT
