FAQ
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
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
wrote:
Try by increasing the sga size.

Good luck

Nisar Tareen
Chirag DBA 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...!!

- Chirag Majmundar
+919886169102

---------------------------------
Do you Yahoo!?
Yahoo! Mail - 250MB free storage. Do more. Manage less.
--
http://www.freelists.org/webpage/oracle-l

Search Discussions

  • Goulet, Dick at Feb 21, 2005 at 11:35 pm
    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 =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
    wrote:
    Try by increasing the sga size.
    =20
    Good luck
    =20
    Nisar Tareen
    Chirag DBA 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
  • Stephen Andert at Feb 22, 2005 at 1:42 am
    Sorry for the ot post, please reply off-list. I'm trying to build a
    little application in MySQL to dabble a bit and expand my horizons and
    I know there are MySQL folks out there.

    In MS Access, the IDE is easy to use to build a quick simple
    application, but with MySQL, the best thing I've found is Rekall.
    I've downloaded and gotten past a few install bugs, but II keep
    getting this error:

    checking for KDE... configure: error:
    in the prefix, you've chosen, are no KDE headers installed. This will fail.
    So, check this please and use another prefix!

    The RTFM README's with the download seem to indicate that I can
    install with just QT (which appears to be fully installed) so I think
    I'm just missing a setting somewhere.

    I'm using RedHat 9. Any pointers?

    Is there an IDE that would be easier to get installed or any other
    recommendations?

    Stephen
  • Rjamya at Feb 22, 2005 at 7:06 am
    TOAD has one for mysql ... but I am sure it won't work on RedHat ...

    Raj
    On Mon, 21 Feb 2005 23:39:09 -0700, Stephen Andert wrote:
    Sorry for the ot post, please reply off-list. I'm trying to build a
    little application in MySQL to dabble a bit and expand my horizons and
    I know there are MySQL folks out there.

    In MS Access, the IDE is easy to use to build a quick simple
    application, but with MySQL, the best thing I've found is Rekall.
    I've downloaded and gotten past a few install bugs, but II keep
    getting this error:

    checking for KDE... configure: error:
    in the prefix, you've chosen, are no KDE headers installed. This will fail.
    So, check this please and use another prefix!

    The RTFM README's with the download seem to indicate that I can
    install with just QT (which appears to be fully installed) so I think
    I'm just missing a setting somewhere.

    I'm using RedHat 9. Any pointers?

    Is there an IDE that would be easier to get installed or any other
    recommendations?

    Stephen
    --
    http://www.freelists.org/webpage/oracle-l
    --
    ------------------------------
    select standard_disclaimer from company_requirements where category =
    'MANDATORY';
    --
    http://www.freelists.org/webpage/oracle-l

Related Discussions

Discussion Navigation
viewthread | post
Discussion Overview
grouporacle-l @
categoriesoracle
postedFeb 21, '05 at 11:04p
activeFeb 22, '05 at 7:06a
posts4
users4
websiteoracle.com

People

Translate

site design / logo © 2023 Grokbase