12 Replies Latest reply on Nov 9, 2010 8:29 AM by 811569

    Agent unreachable

    Eduardo Legatti
      Using 10g database control (10.1.0.2).
      When i enter http://instance.domain:5505/em
      i log in and the first page says 'Agent unreachable'
      On the machine i enter
      emctl status agent and it says the agent is running and ready.
      Where do i look to find out why EM is showing that 'Agent unreachable'?

      oracle@icaro:~> emctl status agent
      TZ set to Brazil/East
      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/app/oracle/product/10.1.0/bdrps/icaro.intranet_BDRPS
      Agent binaries : /u01/app/oracle/product/10.1.0/bdrps
      Agent Process ID : 4746
      Parent Process ID : 3901
      Agent URL : http://icaro.intranet:1830/emd/main
      Started at : 2006-01-20 07:21:11
      Started by user : oracle
      Last Reload : 2006-01-20 07:21:11
      Last successful upload : 2006-01-20 17:58:02
      Total Megabytes of XML files uploaded so far : 17.29
      Number of XML files pending upload : 0
      Size of XML files pending upload(MB) : 0.00
      Available disk space on upload filesystem : 44.78%
      ---------------------------------------------------------------
      Agent is Running and Ready
        • 1. Re: Agent unreachable
          277993
          Have you recently upgraded?

          Check emd.properties files to see if the EMD main servlet URL is pointing to the correct port (i.e the correct Agent is in port 1830.)
          • 2. Re: Agent unreachable
            Eduardo Legatti
            My EMD entry:
            #
            # EMD main servlet URL
            #
            EMD_URL=http://icaro.intranet:1830/emd/main


            My server contains only one ORACLE_HOME and I don´t upgraded my database.
            A two weeks ago all was working fine.

            When i type this adress http://icaro.intranet:1830/emd/main the browser respond:
            EMAgent10.1.0.2.0 Congratulations, EMAgent is working!

            What's happen?

            Tank's
            • 3. Re: Agent unreachable
              277993
              Do you have any proxy settings in your config file (emoms.properties) set for Metalink Refresh jobs?

              proxyHost=
              proxyPort=
              dontProxyFor=

              If yes, ensure that you have specified the correct values especially for dontProxyFor

              e.g Correct entry should be

              dontProxyFor=.icaro.intranet

              instead of

              dontProxyFor=icaro.intranet

              note the "." (dot) after the equal sign

              if possible, disable dis by commenting them out to test it. Then restart EM
              • 4. Re: Agent unreachable
                Eduardo Legatti
                the proxy parameters are working!!

                look at for this errors:

                Agent Ping     N/A     Jan 18, 2006 7:17:24 AM     Error     Error while updating timestamps for ping tables.ORA-00060: conflito detectado ao aguardar recurso
                     Purge Policies     N/A     Jan 19, 2006 12:09:05 AM     Error     Error caught processing purge policy MGMT_SEVERITY ORA-20000: Error executing purge proc EM_SEVERITY.SEVERITY_PURGE for purge policy MGMT_SEVERITY for target E2D1F77A233AFEB445E96391BB6E1953 ERROR = ORA-01652: não é possível estender o segmento temp. em 128 no tablespace TEMP
                     Loader     http://icaro.intranet:1830/emd/main     Jan 20, 2006 2:07:25 PM     Error     Thread: SeverityLoad http://icaro.intranet:1830/emd/main java.sql.SQLException: ORA-20612: Internal error processing severity. Severity received out of time sequence. (target_guid = 5AA29684566684426713F09C83AFFDB6)(marker_ts = 2006-01-20 14:07:04)(new collection_ts = 2006-01-20 14:07:02)(severity_code =CLEAR)(marker_avail_status =UP) ORA-06512: em "SYSMAN.METRICS_SEVERITY_DUPLICATES", line 396 ORA-04088: erro durante a execução do gatilho 'SYSMAN.METRICS_SEVERITY_DUPLICATES' Error occured at line : 71, File name:Severity
                     Loader     http://icaro.intranet:1830/emd/main     Jan 20, 2006 2:07:25 PM     Error     Thread: SeverityLoad http://icaro.intranet:1830/emd/main java.sql.SQLException: ORA-20612: Internal error processing severity. Severity received out of time sequence. (target_guid = E2D1F77A233AFEB445E96391BB6E1953)(marker_ts = 2006-01-20 14:07:04)(new collection_ts = 2006-01-20 14:07:03)(severity_code =CLEAR)(marker_avail_status =UNREACHABLE) ORA-06512: em "SYSMAN.METRICS_SEVERITY_DUPLICATES", line 396 ORA-04088: erro durante a execução do gatilho 'SYSMAN.METRICS_SEVERITY_DUPLICATES' Error occured at line : 61, File name:Severity
                     Loader     http://icaro.intranet:1830/emd/main     Jan 20, 2006 2:35:55 PM     Error     Thread: XMLLoader0 40000000213.xml java.sql.SQLException: ORA-20601: Duplicate record. The last error message is the same as this error message for : (target guid = E2D1F77A233AFEB445E96391BB6E1953)(metric guid = 435F6A6508C3984387D8FE6512BA450E)(error_msg = ) ORA-06512: em "SYSMAN.METRIC_ERRORS_CUR_AND_DUPES", line 160 ORA-04088: erro durante a execução do gatilho 'SYSMAN.METRIC_ERRORS_CUR_AND_DUPES' Error occured at line : 2509, File name:/u01/app/oracle/product/10.1.0/bdrps/icaro.intranet_BDRPS/sysman/recv/40000000213.xml
                     Loader     N/A     Jan 20, 2006 2:35:55 PM     Error     Thread: XMLLoader0 40000000213.xml Failed to load 40000000213.xml; moving to errors directory, File name:/u01/app/oracle/product/10.1.0/bdrps/icaro.intranet_BDRPS/sysman/recv/40000000213.xml
                     Loader http://icaro.intranet:1830/emd/main     Jan 23, 2006 7:42:40 AM     Error     Thread: XMLLoader0 40000000021.xml java.sql.SQLException: ORA-20601: Duplicate record. The last error message is the same as this error message for : (target guid = E2D1F77A233AFEB445E96391BB6E1953)(metric guid = 435F6A6508C3984387D8FE6512BA450E)(error_msg = ) ORA-06512: em "SYSMAN.METRIC_ERRORS_CUR_AND_DUPES", line 160 ORA-04088: erro durante a execução do gatilho 'SYSMAN.METRIC_ERRORS_CUR_AND_DUPES' Error occured at line : 2509, File name:/u01/app/oracle/product/10.1.0/bdrps/icaro.intranet_BDRPS/sysman/recv/40000000021.xml
                     Loader     N/A     Jan 23, 2006 7:42:40 AM     Error     Thread: XMLLoader0 40000000021.xml Failed to load 40000000021.xml; moving to errors directory, File name:/u01/app/oracle/product/10.1.0/bdrps/icaro.intranet_BDRPS/sysman/recv/40000000021.xml
                     Loader http://icaro.intranet:1830/emd/main     Jan 23, 2006 8:35:13 AM     Error     Thread: SeverityLoad http://icaro.intranet:1830/emd/main java.sql.SQLException: ORA-20612: Internal error processing severity. Severity received out of time sequence. (target_guid = EAFB66F72C8B865C1F7B5C6153EE5AB8)(marker_ts = 2006-01-23 08:19:55)(new collection_ts = 2005-12-22 11:10:48)(severity_code =CRITICAL)(marker_avail_status =UP) ORA-06512: em "SYSMAN.METRICS_SEVERITY_DUPLICATES", line 396 ORA-04088: erro durante a execução do gatilho 'SYSMAN.METRICS_SEVERITY_DUPLICATES' Error occured at line : 13, File name:Severity
                • 5. Re: Agent unreachable
                  mnazim-Oracle
                  Could you please tell about your environment like (machine version)

                  Try this workaround
                  1 stop the dbconsole

                  2. Set this environment variable to the hostname :
                  $ set EMHOSTNAME=<hostname>
                  3. Start the dbconsole .
                  • 6. Re: Agent unreachable
                    Eduardo Legatti
                    I'm would try drop the repository and recreate again!! (I guess)
                    Thanks.

                    SUSE LINUX 10, 2GB RAM

                    env
                    LESSKEY=/etc/lesskey.bin
                    NNTPSERVER=news
                    INFODIR=/usr/local/info:/usr/share/info:/usr/info
                    MANPATH=/usr/local/man:/usr/share/man:/usr/X11R6/man:/opt/gnome/share/man
                    HOSTNAME=icaro
                    GNOME2_PATH=/usr/local:/opt/gnome:/usr
                    XKEYSYMDB=/usr/X11R6/lib/X11/XKeysymDB
                    HOST=icaro
                    TERM=xterm
                    SHELL=/bin/bash
                    PROFILEREAD=true
                    HISTSIZE=1000
                    TMPDIR=/tmp
                    SSH_CLIENT=::ffff:200.238.251.9 1060 22
                    QTDIR=/usr/lib/qt3
                    SSH_TTY=/dev/pts/0
                    http_proxy=http://200.238.251.102:3128
                    JRE_HOME=/usr/lib/java/jre
                    USER=oracle
                    LD_LIBRARY_PATH=:/u01/app/oracle/product/10.1.0/bdrps/ctx/lib:/u01/app/oracle/product/10.1.0/bdrps/lib
                    TEMP=/tmp
                    LS_COLORS=no=00:fi=00:di=01;34:ln=00;36:pi=40;33:so=01;35:do=01;35:bd=40;33;01:cd=40;33;01:or=40;31:ex=00;32:*.cmd=00;32:*.exe=01;32:*.com=01;32:*.bat=01;32:*.btm=01;32:*.dll=01;32:*.tar=00;31:*.tbz=00;31:*.tgz=00;31:*.rpm=00;31:*.deb=00;31:*.arj=00;31:*.taz=00;31:*.lzh=00;31:*.zip=00;31:*.zoo=00;31:*.z=00;31:*.Z=00;31:*.gz=00;31:*.bz2=00;31:*.tb2=00;31:*.tz2=00;31:*.tbz2=00;31:*.avi=01;35:*.bmp=01;35:*.fli=01;35:*.gif=01;35:*.jpg=01;35:*.jpeg=01;35:*.mng=01;35:*.mov=01;35:*.mpg=01;35:*.pcx=01;35:*.pbm=01;35:*.pgm=01;35:*.png=01;35:*.ppm=01;35:*.tga=01;35:*.tif=01;35:*.xbm=01;35:*.xpm=01;35:*.dl=01;35:*.gl=01;35:*.aiff=00;32:*.au=00;32:*.mid=00;32:*.mp3=00;32:*.ogg=00;32:*.voc=00;32:*.wav=00;32:
                    ORACLE_SID=BDRPS
                    XNLSPATH=/usr/X11R6/lib/X11/nls
                    ORACLE_BASE=/u01/app/oracle
                    HOSTTYPE=i386
                    ftp_proxy=http://200.238.251.102:3128
                    PAGER=less
                    MINICOM=-c on
                    MAIL=/var/mail/oracle
                    PATH=/usr/local/bin:/usr/bin:/usr/X11R6/bin:/bin:/usr/games:/opt/gnome/bin:/opt/kde3/bin:/usr/lib/java/jre/bin:/u01/app/oracle/product/10.1.0/bdrps/bin:/u01/app/oracle/product/10.1.0/bdrps/ctx/bin
                    CPU=i686
                    JAVA_BINDIR=/usr/lib/java/jre/bin
                    INPUTRC=/etc/inputrc
                    PWD=/home/oracle
                    JAVA_HOME=/usr/lib/java/jre
                    LANG=en_US.UTF-8
                    TEXINPUTS=:/home/oracle/.TeX:/usr/share/doc/.TeX:/usr/doc/.TeX
                    SHLVL=1
                    HOME=/home/oracle
                    LESS_ADVANCED_PREPROCESSOR=no
                    OSTYPE=linux
                    LS_OPTIONS=-N --color=tty -T 0
                    no_proxy=localhost
                    XCURSOR_THEME=crystalwhite
                    WINDOWMANAGER=/usr/X11R6/bin/kde
                    GTK_PATH=/usr/local/lib/gtk-2.0:/opt/gnome/lib/gtk-2.0:/usr/lib/gtk-2.0
                    LESS=-M -I
                    MACHTYPE=i686-suse-linux
                    LOGNAME=oracle
                    SSH_CONNECTION=::ffff:200.238.251.9 1060 ::ffff:200.238.251.104 22
                    PKG_CONFIG_PATH=/opt/gnome/lib/pkgconfig
                    LESSOPEN=lessopen.sh %s
                    ACLOCAL_PATH=/opt/gnome/share/aclocal
                    INFOPATH=/usr/local/info:/usr/share/info:/usr/info:/opt/gnome/share/info
                    ORACLE_HOME=/u01/app/oracle/product/10.1.0/bdrps
                    LESSCLOSE=lessclose.sh %s %s
                    G_BROKEN_FILENAMES=1
                    JAVA_ROOT=/usr/lib/java
                    COLORTERM=1
                    • 7. Re: Agent unreachable
                      mnazim-Oracle
                      Have you tried workaround mention above ? what was the result
                      why you want to drpop the respostory , The problem is not releated with repostory
                      some environment setting is missing .
                      • 8. Re: Agent unreachable
                        Eduardo Legatti
                        Yes, I set de variable but no effects.
                        I realized that the host machine name is "icaro" and the domain machine name is "icaro.intranet.rps" and my configuration files emd.properties , emoms.properties are using "icaro.intranet"

                        I would try to do some more tests.

                        Tanks
                        • 9. Re: Agent unreachable
                          329796
                          How to drop an existing repository database when there are two repository databases in an system.

                          Thanks
                          • 10. Re: Agent unreachable
                            277993
                            Use the Repository Manager and specify the Repository SID you want to drop.

                            $ORACLE_HOME\sysman\admin\emdrep\bin\RepManager.

                            Just type RepManger without any option to get the listing of options or check the rewuired documentation for usage.
                            • 11. Re: Agent unreachable
                              211257
                              "Agent unreachable" status in some cases means; after configuration EM grid is assuming that the database dbsnmp password is default, try and manually configure the database with the correct dbsnmp database passwd-Or change this password in the database capture it then attempt to manually configure the database so U can see the proper performance data.
                              Happy DBA'ing
                              • 12. Re: Agent unreachable
                                811569
                                Hey,

                                I also faced the same issue with the EM db console.
                                I had solved the issue by resetting the TimeZone of the em.
                                Following are the steps:
                                1. Stop the db console

                                [oracle@db0 oracle]$ emctl stop dbconsole
                                ----------------------------
                                Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                                Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
                                https://db0.qadr.qa:1158/em/console/aboutApplication
                                Stopping Oracle Enterprise Manager 11g Database Control ...
                                ... Stopped.

                                2. Check whether the ORACLE_SID and ORACLE_HOME of the database have set properly

                                3. Execute the following command to reset the emagent timezone:

                                [oracle@db0 oracle]$ emctl resetTZ agent
                                ----------------------------------------------------------
                                Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                                Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
                                Updating /u01/app/oracle/product/11.1.0/db_1/db0.qadr.qa_orcl/sysman/config/emd.properties...
                                Successfully updated /u01/app/oracle/product/11.1.0/db_1/db0.qadr.qa_orcl/sysman/config/emd.properties.
                                Login as the em repository user and run the script:
                                exec mgmt_target.set_agent_tzrgn('db0.qadr.qa:3938','*ur_coninent_name/country_name*')
                                and commit the changes
                                This can be done for example by logging into sqlplus and doing
                                SQL> exec mgmt_target.set_agent_tzrgn('db0.qadr.qa:3938','*ur_coninent_name/country_name*')
                                SQL> commit

                                4. Perform the above two steps in SQL prompt after connecting to the database as a privileged user.

                                5. Perform a clean start of the db console:

                                [oracle@db0 oracle]$ emctl start dbconsole
                                Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0
                                Copyright (c) 1996, 2009 Oracle Corporation. All rights reserved.
                                https://db0.qadr.qa:1158/em/console/aboutApplication
                                Starting Oracle Enterprise Manager 11g Database Control ......... started.
                                ------------------------------------------------------------------
                                Logs are generated in directory /u01/app/oracle/product/11.1.0/db_1/db0.qadr.qa_orcl/sysman/log

                                6. Check the Agent's status in the EM home page.

                                Hope this helps and good luck.

                                Regards
                                Shamseer
                                shamsmail@gmail.com