DBAsupport.com Forums - Powered by vBulletin
Page 1 of 2 12 LastLast
Results 1 to 10 of 18

Thread: Changing local time

  1. 03-31-2005, 05:58 AM #1
    nir_s
    nir_s is offline Oracle DBA
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233

    Changing local time

    Hi falks,

    We are going to change the local due to Daylight Savings Time.
    Is there a way to change the local time in the OS without restarting the database?
    OS : Sun Solaris
    DB : 10g

    Thanks in advance,
    Nir
    Reply With Quote Reply With Quote
  2. 03-31-2005, 06:16 AM #2
    kris123's Avatar
    kris123
    kris123 is offline Banned
    Join Date
    Aug 2000
    Location
    Jolo, Sulu
    Posts
    639
    hi hun....
    u may use date command in os
    Reply With Quote Reply With Quote
  3. 03-31-2005, 06:25 AM #3
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334

    Re: Changing local time

    Originally posted by nir_s
    Hi falks,

    We are going to change the local due to Daylight Savings Time.
    Is there a way to change the local time in the OS without restarting the database?
    OS : Sun Solaris
    DB : 10g

    Thanks in advance,
    Nir
    why doesnt your OS do it for you automatically?
    Reply With Quote Reply With Quote
  4. 03-31-2005, 06:53 AM #4
    nir_s
    nir_s is offline Oracle DBA
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    The time in OS is changed ,but my question is regarding the database:
    Should we restart the database in any case due to the OS time changing?
    Reply With Quote Reply With Quote
  5. 03-31-2005, 07:16 AM #5
    davey23uk
    davey23uk is offline Senior Advisor
    Join Date
    Sep 2002
    Location
    England
    Posts
    7,334
    nope, you are safe there in terms of the database
    Reply With Quote Reply With Quote
  6. 03-31-2005, 08:50 AM #6
    nir_s
    nir_s is offline Oracle DBA
    Join Date
    Dec 2001
    Location
    Tel-Aviv,Israel
    Posts
    233
    Thanks!
    Reply With Quote Reply With Quote
  7. 04-01-2005, 03:45 AM #7
    Aljaz
    Aljaz is offline Junior Member
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    I have a problem with sysdate in OS time...they don't match.

    Sysdate is one hour behind the OS time. If I change OS time the change is reflcted immmediate in the database to, but again the difference is one hour.

    Localtimestamp gives me the correct time, set time on gives me correct time,...


    Metalink :
    Sysdate is just a system call to the
    Operating System to get the time
    (a "gettimeofday" call).

    Sysdate does NOT use the timezones in
    the database

    Metalink :
    After you change the timezone on a
    Windows machine you have to restart
    the oracle service.


    I did bounce the database but still the same result.



    OS : Windows 2000 SP2
    Database : 9.2.0.1.0


    Regards,
    Aljaz
    Reply With Quote Reply With Quote
  8. 04-01-2005, 04:45 AM #8
    DaPi's Avatar
    DaPi
    DaPi is offline Old Cranky Philosopher
    Join Date
    Nov 2002
    Location
    Geneva Switzerland
    Posts
    3,142
    Have you set "Automatically adjust . . . for DST" in the Windows Date/Time properties? That works fine for me.
    After you change the timezone on a Windows machine you have to restart the oracle service.

    I did bounce the database but still the same result.
    Note: shutdown/startup is NOT the same as restarting the Windows service.
    Reply With Quote Reply With Quote
  9. 04-01-2005, 04:51 AM #9
    abhaysk's Avatar
    abhaysk
    abhaysk is offline Krishna
    Join Date
    Dec 2002
    Location
    Bangalore ( India )
    Posts
    2,434
    Originally posted by DaPi
    Note: shutdown/startup is NOT the same as restarting the Windows service.
    funky...

    "I Dont Want To Follow A Path, I would Rather Go Where There Is No Path And Leave A Trail."

    "Ego is the worst thing many have, try to overcome it & you will be the best, if not good, person on this earth"
    Reply With Quote Reply With Quote
  10. 04-01-2005, 04:55 AM #10
    Aljaz
    Aljaz is offline Junior Member
    Join Date
    Dec 2001
    Location
    Slovenia, Kranj
    Posts
    82
    Automatically adjust is/was set

    I have restared service.

    Still the same result.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

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

Forum Rules

Click Here to Expand Forum to Full Width