Home » RDBMS Server » Server Administration » changing time zone on solaris (oracle 11.2.0.1 RAC of two nodes,solaris10)
changing time zone on solaris [message #558144] Tue, 19 June 2012 12:21 Go to next message
janakors
Messages: 232
Registered: September 2009
Senior Member
hi ,
our system admin is changing the time zone on solaris system, how can it effect my DB or as DBA what should i check before he do that and after he change the time zone. he is changing the time zone because of an issue with the DST (Daylightsaving time).

kindly guide

regards

Report message to a moderator

Re: changing time zone on solaris [message #558146 is a reply to message #558144] Tue, 19 June 2012 12:34 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
SELECT SYSDATE FROM DUAL;
-- which is guaranteed to work (some value will be returned).

Report message to a moderator

Previous Topic: My boss needs a neutral outside opinion to decide the policy of management for these Databases
Next Topic: rowid issue of dumptree
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun Aug 24 14:43:26 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.