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

Re: Error Starting Dbconsole, Oracle 11g R2

Adnan Ahmad Khan Newbie
Currently Being Moderated

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 Newbie
    Currently Being Moderated

    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

Legend

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