topic Re: ORA-07445: exception encountered: in Operating System - HP-UX

ORA-07445: exception encountered:

Cara Tock — Tue, 16 Dec 2003 11:48:16 GMT

I am running HP-UX 11.0 and Oracle 8.1.6.3.
I am getting ORA-07445: exception encountered: core dump [10] [4286558904] [240] [0] [] [] errors in my alert log. Oracle is suggesting that I might have a physical memory problem. I disagree with Oracle as I do not see any signs on my HP that indicated a physical memory problem. Has anyone encountered this error before? Any suggestions? I am attaching a portion of the trace file. Any help would be greatly appreciated.
Thanks,
Damon

Re: ORA-07445: exception encountered:

Michael Schulte zur Sur — Tue, 16 Dec 2003 12:12:39 GMT

Hi Damon,

do you know, if any particular operations cause this exception?

greetings,

Michael

Re: ORA-07445: exception encountered:

Cara Tock — Tue, 16 Dec 2003 12:22:48 GMT

We think that the errors are being caused by sql that is using database links between our two different instances.

Re: ORA-07445: exception encountered:

Kent Ostby — Tue, 16 Dec 2003 13:16:26 GMT

I dont seen any cases of that Oracle error with 8.1.6.3 on HP in our HP database.

One other resource that you might want to check out is http://www.orafaq.net/ which has had some archived discussions on this error on their message board.

Best regards,

Kent M. Ostby

Re: ORA-07445: exception encountered:

RAC_1 — Tue, 16 Dec 2003 13:22:29 GMT

what file core says?

file core.

Re: ORA-07445: exception encountered:

James A. Donovan — Tue, 16 Dec 2003 15:49:38 GMT

If you have access to Metalink, I suggest you take a look at these links to try and do some self-diagnosis...

http://metalink.oracle.com/metalink/plsql/showdoc?db=Not&id=208922.1

http://metalink.oracle.com/metalink/plsql/ml2_documents.showDocument?p_database_id=NOT&p_id=211909.1

Re: ORA-07445: exception encountered:

Indira Aramandla — Tue, 16 Dec 2003 22:17:50 GMT

Hi Damon,

The error that your are experiencing ORA-07455 exception [4286558904] is due to this as metalink says:-

This looks like the problem was caused by bug 1381397. This bug is fixed in 8.1.7.2 and 9.0.1.

Refer to this note in Metalink 1381397.8 Support Description of Bug 1381397

Bug 1381397 PMON may crash the instance if RMAN backup processes are killed
This note gives a brief overview of bug 1381397.
Affects:
Product (Component) Oracle Server (RDBMS)
Range of versions believed to be affected Versions >= 8 but < 9.0
Versions confirmed as being affected Â· 8.1.7.1
Platforms affected Generic (all / most platforms affected)
Fixed:
This issue is fixed in Â· 8.1.7.2 (Server Patch Set) Â· 9.0.1.0 (Base Release)
Symptoms:
Â· Instance may crash
Â· Process may Dump / Abend / Abort
Related To:
Â· RMAN (Recovery Manager)
Description

If the RMAN backup processes die unexpectedly or are killed via "kill -9" then PMON may die with an ORA-7445 in ksfvfrmsg() or ksfvmchk() bringing down the ins