Change Time Zone
DBAsupport.com Forums - Powered by vBulletin
Results 1 to 3 of 3

Thread: Change Time Zone

  1. #1
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31

    Change Time Zone

    Hi

    The problem began when i change the time, time zone over production server.

    After of this, the enterprise manager didnt work. The agent and dbconsole didnt work. i read the logs, and tell that the problem is that the server time zone is different of database time zone. i ran emctl resetTZ agent and say:

    The agentTZRegion in:
    /oracle/prod/product/10.2.0/Db_1/bhspdbs00_PROD/sysman/config/emd.properties
    is not in agreement with what the agent thinks it should be.
    Fix your environment.
    Pick a TZ value that corresponds to time zone settings listed in:
    /oracle/prod/product/10.2.0/Db_1/sysman/admin/supportedtzs.lst

    After i run the select

    SELECT CURRENT_TIMESTAMP, LOCALTIMESTAMP, SYSTIMESTAMP FROM dual;

    Current_timestamp 03-ENE-08 11.25.07.554274 AM -03:00
    localtimestamp 03-ENE-08 11.25.07.554274 AM
    systimestamp 03-ENE-08 12.25.07.554256 PM -02:00

    Thanks for the help.

  2. #2
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,333
    did you do what it tells you?

  3. #3
    Join Date
    Dec 2007
    Location
    Buenos Aires - Argentina
    Posts
    31
    Yes, I do, but i dont know why the EM dont work after the change Time zone.
    How can i change the Time Zone over database???

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  


Click Here to Expand Forum to Full Width