My Oracle Support Banner

EM12c: Scan Listener Shows Down Status in Enterprise Manager 12c Cloud Control after Relocation when Collection Directory is missing under <AGENT_BASE>/agent_inst/sysman/emd (Doc ID 1964303.1)

Last updated on JANUARY 16, 2021

Applies to:

Enterprise Manager for Oracle Database - Version 12.1.0.4.0 and later
Information in this document applies to any platform.

Symptoms

Enterprise Manager (EM) 12.1.0.4 Cloud Control
DB plugin 12.1.0.6

1) After scan listener is relocated from one node to another, it shows as down in EM console.

or

2) Modifying any Metric settings in the console and saving the changes results in internal error

 

The following error is observed from <AGENT_BASE>/gc_inst/em/EMGC_OMS1/sysman/log/emoms.trc file

2015-01-19 01:11:57,186 [RJob Step 49334848] ERROR em.jobs logp.251 - PropagateMetricsData Error while Saving Target Collection to emd. TargetCollection xml :
<!-- This file is generated by Collector at 2015-01-19 01:11:57 -->

<TargetCollection TYPE="oracle_listener" NAME="<SCAN LISTENER NAME>" INCLUDE_DEFAULT="TRUE">
    <CollectionItem NAME="Response" UPLOAD="YES">
        <Schedule>
            <IntervalSchedule INTERVAL="5" TIME_UNIT="Min"/>
        </Schedule>
        <MetricColl NAME="Response">
            <Condition COLUMN_NAME="tnsPing" CRITICAL="1000" WARNING="400" OPERATOR="GT" OCCURRENCES="1" MESSAGE="Listener response to a TNS ping is %value% msecs" MESSAGE_NLSID="Response_tnsping_alertmessage"/>
            <Condition COLUMN_NAME="Status" CRITICAL="0" WARNING="NotDefined" OPERATOR="EQ" OCCURRENCES="1" MESSAGE="The listener is down: %oraerr%." MESSAGE_NLSID="Response_Status_alertmessage" CLEAR_MESSAGE="The listener is up." CLEAR_MESSAGE_NLSID="Response_Status_clearmessage"/>
        </MetricColl>
    </CollectionItem>
    <CollectionItem NAME="TNS_ERRORS" UPLOAD="YES">
        <Schedule>
            <IntervalSchedule INTERVAL="1" TIME_UNIT="Hr"/>
        </Schedule>
        <MetricColl NAME="TNS_ERRORS">
            <Condition COLUMN_NAME="tnserrmsg" CRITICAL="NotDefined" WARNING="NotDefined" OPERATOR="MATCH" OCCURRENCES="1" MESSAGE="%tnserr% error occured.Please check log for details. " MESSAGE_NLSID="TNSERRORS_tnserr_alertmessage" NO_CLEAR_ON_NULL="TRUE" STATELESS_ALERT="TRUE" ALERT_CONTEXT="sys_occurrence_count;sys_first_occur_time;sys_last_occur_time"/>
        </MetricColl>
    </CollectionItem>

</TargetCollection>

 

 

 

 

Changes

 

Cause

To view full details, sign in with your My Oracle Support account.

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


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.