Results 1 to 3 of 3
  1. #1
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21

    Question Unanswered: Agent Unreachable

    Hi all,

    I've got some problem with my oracle 11g.
    When I'm logging in to enterprise manager I'm getting following information:
    Status: Agent Unreachable
    Status Pending Since: 13-Apr-2012 13:17:44 o'clock CEST

    After restarting em console I've found entries in the log file (emagent.log):

    2012-04-17 11:58:11,363 Thread-1101707872 <HTTP Listener> Agent Signaled to EXIT by emctl (00800)
    2012-04-17 11:58:12,412 Thread-911101312 EMAgent normal shutdown (00703)
    2012-04-17 12:01:27,009 Thread-2886385024 Starting Agent 10.2.0.4.4 from /orasys/product/11.2.0/database (00701)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalONNECT_DATA in expression ((gc_cr_recv < _gc_cr_recv) ? 0 : (gc_cr_recv - _gc_cr_recv))/__intervalONNECT_DATA=(SID=%SID%)))
    (00104)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalCT_DATA in expression ((gc_cur_recv < _gc_cur_recv) ? 0 : (gc_cur_recv - _gc_cur_recv))/__intervalCT_DATA=(SID=%SID%)))
    (00104)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalrvalCT_DATA in expression ((gc_cr_serv < _gc_cr_serv) ? 0 : (gc_cr_serv - _gc_cr_serv))/__intervalrvalCT_DATA=(SID=%SID%)))
    (00104)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalCT_DATA in expression ((gc_cur_serv < _gc_cur_serv) ? 0 : (gc_cur_serv - _gc_cur_serv))/__intervalCT_DATA=(SID=%SID%)))
    (00104)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalATA in expression ((msg_sent_dir < _msg_sent_dir) ? 0 : (msg_sent_dir - _msg_sent_dir))/__intervalATA=(SID=%SID%)))
    (00104)
    2012-04-17 12:01:27,170 Thread-2886385024 Undefined column name __intervalinterval in expression ((msg_recv_act < _msg_recv_act) ? 0 : (msg_recv_act - _msg_recv_act))/__intervalinterval=%SID%)))
    (00104)
    2012-04-17 12:01:27,226 Thread-2886385024 [Load Balancer Switch] InstanceProperty (snmpTimeout) is marked OPTIONAL but is being used (00506)
    2012-04-17 12:01:34,156 Thread-2886385024 EMAgent started successfully (00702)
    2012-04-17 12:01:34,159 Thread-1107982944 <Upload Manager> Exceeded Max allowed Upload data - No of files: 2, Size of upload data: 0.051613MB, Pct(%) of Disk used: 99.26%, Disabling collections (00852)
    2012-04-17 12:01:34,159 Thread-1107982944 Disable collector (00406)

    When I'm running emctl status agent I'm getting info that Agent is Running and Ready.

    Oracle Enterprise Manager 11g Database Control Release 11.2.0.3.0
    Copyright (c) 1996, 2011 Oracle Corporation. All rights reserved.
    ---------------------------------------------------------------
    Agent Version : 10.2.0.4.4
    OMS Version : 10.2.0.4.4
    Protocol Version : 10.2.0.4.4
    Agent Home : /orasys/product/11.2.0/database/test.com_ES
    Agent binaries : /orasys/product/11.2.0/database
    Agent Process ID : 3297
    Parent Process ID : 3273
    Agent URL : https://test.com:3938/emd/main
    Repository URL : https://test.com:1158/em/upload/
    Started at : 2012-04-17 12:01:26
    Started by user : oracle
    Last Reload : 2012-04-17 12:01:26
    Last successful upload : 2012-04-17 12:02:38
    Total Megabytes of XML files uploaded so far : 0.05
    Number of XML files pending upload : 0
    Size of XML files pending upload(MB) : 0.00
    Available disk space on upload filesystem : 0.73%
    Data channel upload directory : /orasys/product/11.2.0/database/test.com_ES/sysman/recv
    Collection Status : Disabled by Upload Manager
    Last successful heartbeat to OMS : 2012-04-17 12:38:54
    ---------------------------------------------------------------
    Agent is Running and Ready


    Can anyone tell me how can I fix problem with agent status?
    Last edited by jackmazurek; 04-17-12 at 07:42.

  2. #2
    Join Date
    Jun 2003
    Location
    West Palm Beach, FL
    Posts
    2,713

    Cool

    2012-04-17 12:01:34,159 Thread-1107982944 <Upload Manager> Exceeded Max allowed Upload data - No of files: 2, Size of upload data: 0.051613MB, Pct(%) of Disk used: 99.26%, Disabling collections (00852)
    2012-04-17 12:01:34,159 Thread-1107982944 Disable collector (00406)
    Perhaps you are out of space...

    Also if you haven't, you may want to increase the size of the upload files in emd.properties:
    Code:
    UploadFileSize=4096
    Last edited by LKBrwn_DBA; 04-17-12 at 12:04.
    The person who says it can't be done should not interrupt the person doing it. -- Chinese proverb

  3. #3
    Join Date
    Mar 2011
    Location
    Poland
    Posts
    21
    Hi,

    Yes You're right. The disk device was full, all what was needed was remove some data from device and everything starts up after agent and em restart

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •