2 Replies Latest reply: Oct 25, 2013 3:21 AM by Adnan Ahmad Khan Branched from an earlier discussion. RSS

    Re: Error Starting Dbconsole, Oracle 11g R2

    Adnan Ahmad Khan

      ok.... but how ??? I don't know how to do it.... Please if you Know ...or anyone know ... Please tell me how to fix this issue.

       

      here is a little bit more info

       

      Microsoft Windows [Version 6.1.7600]

      Copyright (c) 2009 Microsoft Corporation.  All rights reserved.

       

       

      C:\Windows\system32>emctl config agent getTZ

      Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

      Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

      America/Rio_Branco

       

       

       

       

      and my System Tz is UTC+5 Karachi/Islamabad,

       

      how to make them compitable?

       

      Thanks in Advance

       

      Message was edited by: AdnanAhmadKhan

        • 2. Re: Error Starting Dbconsole, Oracle 11g R2
          Adnan Ahmad Khan

          My Problem Resolved , It is Possible in Two Ways:

           

          1) Find your Oracle 11 G time zone in my case it was

           

          C:\Windows\system32>emctl config agent getTZ

          Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

          Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

          America/Rio_Branco

           

          Then Set your System Time Zone to a compitable time Zone,

          As I have mine to America/Santiago

          and then Restart your System.

           

          After Restart, Check your dbconsole, it should be in Working State

           

           

           

          2) Use ResetTZ command

           

          C:\Users\Ahmad>emctl resetTZ agent

          Oracle Enterprise Manager 11g Database Control Release 11.2.0.1.0

          Copyright (c) 1996, 2010 Oracle Corporation.  All rights reserved.

          Updating C:\app\Ahmad\product\11.2.0\dbhome_1/localhost_orcl/sysman/config/emd.p

          roperties...

          Successfully updated C:\app\Ahmad\product\11.2.0\dbhome_1/localhost_orcl/sysman/

          config/emd.properties.

          Login as the em repository user and run the  script:

          exec mgmt_target.set_agent_tzrgn('localhost:3938','America/Santiago')

          and commit the changes

          This can be done for example by logging into sqlplus and doing

          SQL> exec mgmt_target.set_agent_tzrgn('localhost:3938','America/Santiago')

          SQL> commit

           

          It will Pick Up your System Time Zone and Then You have to To Do a little more Job,

           

          C:\>Sqlplus/nolog

           

           

          SQL*Plus: Release 11.2.0.1.0 Production on Fri Oct 25 13:02:36 2013

           

           

          Copyright (c) 1982, 2010, Oracle.  All rights reserved.

           

           

          SQL> connect / as sysdba

          Connected.

          SQL> exec mgmt_target.set_agent_tzrgn('localhost:3938','America/Santiago')

           

           

          PL/SQL procedure successfully completed.

           

           

          SQL> commit

            2

           

           

          Now Yout TZ is Set

           

          you Can Start Your Dbconsole by Issuing Start Command