2 Replies Latest reply: Aug 11, 2004 1:52 AM by 46111 RSS

    EM 10g Database Control - Status: Agent Unreachable

    422210
      Hi,

      OS: AIX 5L
      Database: Oracle Database 10g Enterprise Edition Release 10.1.0.2.0 - 64bit

      We have installed 2 instances with EM 10g database control option.
      At the end EM was running over the second database.
      Then we switch it to look over the first one by reconfiguring these files:
      $ORACLE_HOME/sysman/config/emd.properties;
      $ORACLE_HOME/sysman/config/pref/dbastudio-oradba.crd.

      Now EM seems to work fine except for this error: Agent Unreachable.

      oradba@aix09(:SIGP)/u01/apps/oradba/product/10.1.0/aix09_SIGP/sysman/log > emctl status agent
      Oracle Enterprise Manager 10g Database Control Release 10.1.0.2.0
      Copyright (c) 1996, 2004 Oracle Corporation. All rights reserved.
      ---------------------------------------------------------------
      Agent Version : 10.1.0.2.0
      OMS Version : 10.1.0.2.0
      Protocol Version : 10.1.0.2.0
      Agent Home : /u01/apps/oradba/product/10.1.0/aix09_SIGP
      Agent binaries : /u01/apps/oradba/product/10.1.0
      Agent Process ID : 4284428
      Parent Process ID : 3399760
      Agent URL : http://aix09:1830/emd/main
      Started at : 2004-08-09 12:24:29
      Started by user : oradba
      Last Reload : 2004-08-09 12:24:29
      Last successful upload : (none)
      Last attempted upload : 2004-08-09 14:29:51
      Total Megabytes of XML files uploaded so far : 0.00
      Number of XML files pending upload : 1955
      Size of XML files pending upload(MB) : 50.12
      Available disk space on upload filesystem : 4.60%
      ---------------------------------------------------------------
      Agent is Running and Ready

      /aix09_SIGP/sysman/log/ emagent.trc:
      2004-08-09 14:31:53 Thread-1910 ERROR upload: Failed to upload file A0000001.xml, ret = -2
      2004-08-09 14:31:53 Thread-1910 WARN upload: FxferSend: received http error in header from repository: http:/
      /aix09:5500/em/upload/
      ERROR-400|ORA-04020: deadlock detected while trying to lock object 30x700000021709BF80x700000021B01D200x700000
      0267473A8

      2004-08-09 14:31:53 Thread-1910 ERROR upload: Failed to upload file A0000001.xml, ret = -2
      2004-08-09 14:31:53 Thread-1910 ERROR upload: 3 Failures in a row for A0000001.xml, we give up
      2004-08-09 14:31:53 Thread-1910 ERROR upload: Error in uploadXMLFiles. Trying again in 300.00 seconds.

      After connecting as sysman I’ve ran these statements:
      SQL> SELECT emd_url
      2 FROM mgmt_targets t
      3 WHERE t.target_name = 'aix09'
      4 AND t.target_type = 'host';

      EMD_URL
      ----------------------------------------------------------------------------------------------------
      http://aix09:1830/emd/main

      SQL> SELECT t.target_name, t.target_type,
      2 TO_CHAR(t.load_timestamp,'DD-MON-YYYY HH24:MI:SS') "discovery_time
      ",
      3 TO_CHAR(t.last_updated_time,'DD-MON-YYYY HH24:MI:SS') "last_metada
      ta_load",
      4 TO_CHAR(a.marker_timestamp,'DD-MON-YYYY HH24:MI:SS') "last_severit
      y_load",
      5 TO_CHAR(t.last_load_time,'DD-MON-YYYY HH24:MI:SS') "last_metric_lo
      ad"
      6 FROM mgmt_targets t, mgmt_availability_marker a
      7 WHERE t.target_guid = a.target_guid
      8 AND t.target_name = 'aix09'
      9 AND t.target_type = 'host';

      TARGET_NAME
      ----------------------------------------------------------------------------------------------------
      TARGET_TYPE discovery_time
      ---------------------------------------------------------------- --------------------
      last_metadata_load last_severity_load last_metric_load
      -------------------- -------------------- --------------------
      aix09
      host 03-AUG-2004 14:47:55
      05-AUG-2004 18:28:45 05-AUG-2004 18:30:42 05-AUG-2004 17:13:55

      Does any one know what do I have to do to solve this problem ?


      Thanks in advance,
      Vitor