1 2 Previous Next 24 Replies Latest reply: Oct 9, 2012 2:47 AM by sachinpawan RSS

    enterprise manager - Agent connection unavailable

    sachinpawan
      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
          Post the following :

          emctl status agent
          emctl status dbconsole
          • 2. Re: enterprise manager - Agent connection unavailable
            sachinpawan
            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
              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
                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
                  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
                    kuljeet singh -
                    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
                      thankyou

                      i am not using GRID!
                      so how can i resync agent?
                      • 8. Re: enterprise manager - Agent connection unavailable
                        sachinpawan
                        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
                          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
                            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
                            • 12. Re: enterprise manager - Agent connection unavailable
                              sachinpawan
                              oracle red hat linux 2.6.32-200.13.1.el5uek
                              • 13. Re: enterprise manager - Agent connection unavailable
                                Osama_Mustafa
                                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
                                  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