This discussion is archived
1 2 Previous Next 24 Replies Latest reply: Oct 9, 2012 12:47 AM by sachinpawan RSS

enterprise manager - Agent connection unavailable

sachinpawan Newbie
Currently Being Moderated
hi,

when i tried to open Enterprise manager, i got blank home page stating that, Enterprise Manager is not able to connect to the database instance. The state of the components are listed below. Listener unavailable etc.

but my listener is up and emctl status also running.....

help in this regard, hiighly appreciated!!!

thankyou
pa1
  • 1. Re: enterprise manager - Agent connection unavailable
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    Post the following :

    emctl status agent
    emctl status dbconsole
  • 2. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    thank you for your response
    $ emctl status agent
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
    Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
    ---------------------------------------------------------------
    Agent Version     : 10.2.0.4.2
    OMS Version       : 10.2.0.4.2
    Protocol Version  : 10.2.0.4.2
    Agent Home        : /u01/app/oracle/product/11.2.0/dbhome_1/BMLBSARCHSRV_icbsarch
    Agent binaries    : /u01/app/oracle/product/11.2.0/dbhome_1
    Agent Process ID  : 13762
    Parent Process ID : 13725
    Agent URL         : https://BMLBSARCHSRV:3938/emd/main
    Repository URL    : https://BMLBSARCHSRV:1158/em/upload/
    Started at        : 2012-10-08 07:51:51
    Started by user   : oracle
    Last Reload       : 2012-10-08 08:52:57
    Last successful upload                       : (none)
    Last attempted upload                        : (none)
    Total Megabytes of XML files uploaded so far :     0.00
    Number of XML files pending upload           :      390
    Size of XML files pending upload(MB)         :   150.17
    Available disk space on upload filesystem    :    63.59%
    Data channel upload directory                : /u01/app/oracle/product/11.2.0/dbhome_1/BMLBSARCHSRV_icbsarch/sysman/recv
    Collection Status                            : Disabled by Upload Manager
    Last attempted heartbeat to OMS              : 2012-10-09 09:22:31
    Last successful heartbeat to OMS             : unknown
    ---------------------------------------------------------------
    Agent is Running and Ready
    
    $ emctl status dbconsole
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
    Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
    https://BMLBSARCHSRV:1158/em/console/aboutApplication
    Oracle Enterprise Manager 11g is running.
    ------------------------------------------------------------------
    Logs are generated in directory /u01/app/oracle/product/11.2.0/dbhome_1/BMLBSARCHSRV_icbsarch/sysman/log
  • 3. Re: enterprise manager - Agent connection unavailable
    Shivananda Rao Guru
    Currently Being Moderated
    Try to reload the agent, also do check the status of OMS and the grid control database.

    If possible try to bounce OMS.
  • 4. Re: enterprise manager - Agent connection unavailable
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    seems everything is Ok , Restart console again
    -emctl stop agent
    -emctl stop dbconsole
    -emctl start agent
    -emctl start dbconsole
    and use the below link to check
    https://BMLBSARCHSRV:1158/em/
  • 5. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    thankyou for your response!
    i reloaded agent
    $ emctl status oms
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
    Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
       Oracle Enterprise Manager 10g Database Control commands:
            emctl start | stop dbconsole
            emctl status | secure | setpasswd dbconsole
            emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
           emctl status agent
           emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
           emctl getversion
           emctl reload | upload | clearstate | getversion agent
           emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
           emctl config agent <options>
           emctl config agent updateTZ
           emctl config agent getTZ
           emctl resetTZ agent
           emctl config agent credentials [<Target_name>[:<Target_Type>]]
           emctl gensudoprops
           emctl clearsudoprops
     Blackout Usage :
           emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
           emctl stop blackout <Blackoutname>
           emctl status blackout [<Target_name>[:<Target_Type>]]....
    
    The following are valid options for blackouts
    <Target_name:Target_type> defaults to local node target if not specified.
    If -nodeLevel is specified after <Blackoutname>,the blackout will be applied to all targets and any target list that follows will be ignored.
     Duration is specified in [days] hh:mm
    
            emctl getemhome
            emctl ilint
    Em Key Commands Usage :
    emctl config emkey -emkeyfile <emkey.ora path> [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -emkey [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -repos [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -remove_from_repos [-sysman_pwd <sysman password>]
    emctl config emkey -copy_to_repos [-sysman_pwd <sysman password>]
    emctl status emkey [-sysman_pwd <sysman password>]
    
    Secure DBConsole Usage :
    emctl secure dbconsole -sysman_pwd <sysman password> [-passwd_file <abs file loc>]
            [-host <slb hostname>] [-sid <service name>] [-reset] [-secure_port <secure_port>]
            [-root_dc <root_dc>] [-root_country <root_country>] [-root_state <root_state>] [-root_loc <root_loc>]
            [-root_org <root_org>] [-root_unit <root_unit>] [-root_email <root_email>]
            [-wallet <wallet loc>] [-wallet_pwd <wallet pwd>] [-trust_certs_loc <certs loc>]
    emctl secure status dbconsole
     Register Targettype Usage :
    emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep host> <rep port> <rep sid> OR
    emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep connect descriptor>
  • 6. Re: enterprise manager - Agent connection unavailable
    KuljeetPalSingh Guru
    Currently Being Moderated
    Size of XML files pending upload(MB) : 150.17
    Data pending to upload at OMS.
    Try to resync agent from gridconsole
    Go to target-> all target-> agent->choose agent and press Agent Resynchronization.
    or unblock it if its blocked.
  • 7. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    thankyou

    i am not using GRID!
    so how can i resync agent?
  • 8. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    when i issue

    emctl stop agent, its throwing error
     emctl stop agent
    Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
    Copyright (c) 1996, 2009 Oracle Corporation.  All rights reserved.
       Oracle Enterprise Manager 10g Database Control commands:
            emctl start | stop dbconsole
            emctl status | secure | setpasswd dbconsole
            emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
           emctl status agent
           emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
           emctl getversion
           emctl reload | upload | clearstate | getversion agent
           emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
           emctl config agent <options>
           emctl config agent updateTZ
           emctl config agent getTZ
           emctl resetTZ agent
           emctl config agent credentials [<Target_name>[:<Target_Type>]]
           emctl gensudoprops
           emctl clearsudoprops
     Blackout Usage :
           emctl start blackout <Blackoutname> [-nodeLevel] [<Target_name>[:<Target_Type>]].... [-d <Duration>]
           emctl stop blackout <Blackoutname>
           emctl status blackout [<Target_name>[:<Target_Type>]]....
    
    The following are valid options for blackouts
    <Target_name:Target_type> defaults to local node target if not specified.
    If -nodeLevel is specified after <Blackoutname>,the blackout will be applied to all targets and any target list that follows will be ignored.
     Duration is specified in [days] hh:mm
    
            emctl getemhome
            emctl ilint
    Em Key Commands Usage :
    emctl config emkey -emkeyfile <emkey.ora path> [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -emkey [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -repos [-emkeyfile <emkey.ora path>] [-force] [-sysman_pwd <sysman password>]
    emctl config emkey -remove_from_repos [-sysman_pwd <sysman password>]
    emctl config emkey -copy_to_repos [-sysman_pwd <sysman password>]
    emctl status emkey [-sysman_pwd <sysman password>]
    
    Secure DBConsole Usage :
    emctl secure dbconsole -sysman_pwd <sysman password> [-passwd_file <abs file loc>]
            [-host <slb hostname>] [-sid <service name>] [-reset] [-secure_port <secure_port>]
            [-root_dc <root_dc>] [-root_country <root_country>] [-root_state <root_state>] [-root_loc <root_loc>]
            [-root_org <root_org>] [-root_unit <root_unit>] [-root_email <root_email>]
            [-wallet <wallet loc>] [-wallet_pwd <wallet pwd>] [-trust_certs_loc <certs loc>]
    emctl secure status dbconsole
     Register Targettype Usage :
    emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep host> <rep port> <rep sid> OR
    emctl register oms targettype [-o <Output filename>] <XML filename> <rep user> <rep passwd> <rep connect descriptor>
  • 9. Re: enterprise manager - Agent connection unavailable
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    did you set/export Oracle_home , Oracle SID , and in linux check also PATH if they are Correctly ?
  • 10. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    Yes!
    [oracle@BMLBSARCHSRV dbs]$ echo $ORACLE_HOME
    /u01/app/oracle/product/11.2.0/dbhome_1
    [oracle@BMLBSARCHSRV dbs]$ echo $ORACLE_BASE
    /u01/app/oracle
    [oracle@BMLBSARCHSRV dbs]$ echo $ORACLE_SID
    icbsarch
    [oracle@BMLBSARCHSRV dbs]$
    i could start/status/stop dbconsole command!

    i could see the status of the agent!

    but i cant start/stop agent!

    i am not using grid controller
    i am using EM database controller

    thank you
  • 11. Re: enterprise manager - Agent connection unavailable
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    what is your OS ?
  • 12. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    oracle red hat linux 2.6.32-200.13.1.el5uek
  • 13. Re: enterprise manager - Agent connection unavailable
    Osama_Mustafa Oracle ACE
    Currently Being Moderated
    try to cd $ORACLE_HOME/bin

    before do that
    echo $ORACLE_SID
    echo $ORACLE_HOME
    make sure they are correctly

    ./emctl stop agent
    ./emctl start agent

    and post output
  • 14. Re: enterprise manager - Agent connection unavailable
    sachinpawan Newbie
    Currently Being Moderated
    yes they are appropriate!

    still except stop/start , i could start all other commands like reload/upload/get version
     emctl start | stop dbconsole
            emctl status | secure | setpasswd dbconsole
            emctl config dbconsole -heap_size <size_value> -max_perm_size <size_value>
           emctl status agent
           emctl status agent -secure [-omsurl <http://<oms-hostname>:<oms-unsecure-port>/em/*>]
           emctl getversion
           emctl reload | upload | clearstate | getversion agent
           emctl reload agent dynamicproperties [<Target_name>:<Target_Type>]....
           emctl config agent <options>
           emctl config agent updateTZ
           emctl config agent getTZ
           emctl resetTZ agent
           emctl config agent credentials [<Target_name>[:<Target_Type>]]
           emctl gensudoprops
           emctl clearsudoprops
1 2 Previous Next

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points