Grid Control Agent Fails to Monitor 9.2 Databases With ORA-3113 in Emagent.trc And ORA-7445 in Alert.log File of Target Database (Doc ID 828464.1)

Last updated on FEBRUARY 02, 2015

Applies to:

Enterprise Manager Base Platform - Version 10.2.0.5 to 11.1.0.1 [Release 10.2 to 11.1]
Information in this document applies to any platform.
Checked for relevance on 09-Sep-2013

Goal

Unable to monitor the 9.2.0.1.0 to 9.2.0.7.0 Database Version with 10.2.0.5 or 11.1.0.1 Agent Version.

The following errors are recorded  in agent logs files:

From emagent.trc :
~~~~~~~~~~~~~~~~
    2009-05-15 11:14:17,848 Thread-5584 WARN  vpxoci: Login 0x35c0ee8 failed, error=ORA-03113:
    end-of-file on communication channel
    2009-05-15 11:14:17,848 Thread-5584 WARN  TargetManager: Exception in computing dynamic properties
    of {EPPROD, oracle_database },GetDumpDestination::ORA-03113: end-of-file on communication channel
    2009-05-15 11:14:19,801 Thread-5584 WARN  vpxoci: vpxoci_CtxLogin: Breaking out of
    OCISessionGet/OCIPing loop after 7 tries
    2009-05-15 11:14:19,801 Thread-5584 ERROR vpxoci: ORA-03113: end-of-file on communication channel
    2009-05-15 11:14:19,801 Thread-5584 WARN  vpxoci: Login 0x35c0ee8 failed, error=ORA-03113:
    end-of-file on communication channel
    2009-05-15 11:14:19,801 Thread-5584 WARN  TargetManager: Exception in computing dynamic properties
    of {EPPROD, oracle_database },GetArchiveDestination::ORA-03113: end-of-file on communication channel
    2009-05-15 11:14:19,801 Thread-5584 WARN  engine: Missing Properties : [background_dump_dest]
    2009-05-15 11:14:19,801 Thread-5584 WARN  TargetManager: Exception in computing dynamic properties
    of {EPPROD, oracle_database },DeduceAlertLogFile::Missing Properties : [background_dump_dest]
    2009-05-15 11:14:21,723 Thread-5584 WARN  vpxoci: vpxoci_CtxLogin: Breaking out of
    OCISessionGet/OCIPing loop after 7 tries

The alert log will show

ORA-07445: exception encountered: core dump [0x5012414E53414354] [SIGSEGV] [unknown code] [0x8000000014BE4328] [] [

The issue was investigated by development via the following bugs.

<Bug.8501576> 9I DATABASES COREDUMPS IF 10.2.05. AGENT MONITORING
<Bug.8460336> AGENT 10.2.0.5 IS UNABLE TO MONITOR 9.2.0.6 DB WITH ORA-03113
<Bug.8407759> ORA-03113 WHEN AGENT IS CONNECTING TO A 9I DATABASE 
Unpublished bug:   9206 DATABASE CRASHES WHEN MONITORED BY 10205 AGENT

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms