RE: [askdba] Re: ORA-07445: exception encountered: core dump [kpoclsa()+28] [SIGSEGV] [Address not mapped to object] [0] [] []

From: Goulet, Dick <DGoulet_at_vicr.com>
Date: Mon, 21 Feb 2005 23:32:38 -0500
Message-ID: <4001DEAF7DF9BD498B58B45051FBEA65022E0051@25exch1.vicorpower.vicr.com>

I've also queried Oracle on this and come to the exact same end. PMON is trying to clean up a user process where the user's terminal/PC/whatever is gone. Since PMON is trying to send the appropriate message to the client who's connection is no longer mapped this is the error you get. Simple test for you, start a SQL*Plus session to a database. Find your PID or Process ID in the V$Process table. Now at the OS level issue a kill -3 or kill -9 on that process id. Result is the error you saw in your alert.log. This is one that is very safe to ignore.

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA=20

-----Original Message-----
From: Chirag DBA [mailto:chiragdba_at_gmail.com]=20 Sent: Monday, February 21, 2005 11:01 PM To: askdba_at_freelists.org
Cc: Oracle-L; dba gurus
Subject: Re: [askdba] Re: ORA-07445: exception encountered: core dump [kpoclsa()+28] [SIGSEGV] [Address not mapped to object] [0] [] []

This is the problem with the Oracle backgroud processes.

Talked to Oracle. I have to find which iTAR it was, but as per discussion and results he shown to me, clearly telling that this was the PMON Process.

When user logs off, All the processes completed properly.. i.e. Closing of cursors n all. but finally while cleaning up the resources=20 it was giving error.

Oracle told that, nothing to worry, yr data and Database both are up and running as well as nothing has mishapped with memory structure. This is only because ORACLE BPs DIDN FUNCTION THE WAY THEY SHOULD BE.

So Oracle Technical Expert has asked to IGNORE THIS ERROR. I am still keeping watch and asked him to take this to further lever if the same error we encounter again.

Thank you,

• Chirag Majmundar

On Mon, 21 Feb 2005 18:52:00 -0800 (PST), Nisar Tareen <ntareen_at_yahoo.com> wrote:
> Try by increasing the sga size.

>=20

> Good luck

>=20

> Nisar Tareen
> Chirag DBA <chiragdba_at_gmail.com> wrote:
> We got this error on one of the Production DB.
> Nothing special on Metalink.
> DB is 8.1.7.2 and OS is SOLARIS 5.9 64 bit.
> Any one have gone through this error? Any solution...!!

>=20

> - Chirag Majmundar
> +919886169102

>=20


> ---------------------------------

> Do you Yahoo!?
> Yahoo! Mail - 250MB free storage. Do more. Manage less.
>=20
>

--
http://www.freelists.org/webpage/oracle-l
--
http://www.freelists.org/webpage/oracle-l

Received on Mon Feb 21 2005 - 23:35:47 CST