the changes<\/a> in the date that Daylight Savings Time takes effect in North America.<\/p>\nIt’s not as though people didn’t know it was coming (although if you’re not based in North America or don’t have users across time zones it could be insignificant), but I think people have underestimated the impact. By that I don’t mean the true impact. A lot of sites will be unaffected if they never use timezones and time gap calculations and I can imagine a lot of systems will never be patched properly, no-one will notice and the problem will be solved by a future upgrade. I mean the impact on companies of all the patching they have to do to be sure. <\/p>\n
The extent of the patching? Try operating system, RDBMS, application servers, clients (they have timezone files, too), JVM, system management tools, ERP applications … the list goes on.<\/p>\n
For example, Metalink Note 402316.1 talks about the cascading effect for Enterprises with large numbers of Oracle servers and clients.<\/p>\n
“This means that if you apply new time zone files to database A, then
\nall clients that connect to database A (and use the affected
\ntimestamps) will need the same patch as well. Subsequently this also
\nmeans that if one of these clients also connects to database B, then
\ndatabase B will need the same patch as well, which means that all
\nclients that connect to database B need the patch, etc. etc.”<\/i><\/p>\n
Then you have to determine if your application code will be affected, which is perhaps straightforward for stored PL\/SQL, but what about the rest? <\/p>\n
Am I the only one who finds the Metalink documentation a shambolic nightmare? Everywhere I look there is a document I’ve not seen before with a new twist on the problem. It’s improved recently as Oracle have introduced a dedicated category in the Metalink knowledge browser, run webcasts and tried to point people towards a master document which looks like note 397281 to me. Still, I’m often asked questions that I realise I’m not sure<\/i> of the answers to and so I end up rooting through the documentation (again) for a definitive answer. I get even more worried when I see new or updated documents at this late stage in the process 🙁 <\/p>\n
I suppose I’ve been lucky so far in that I haven’t come across any data that needs to be backed up and restored, so life could be worse.<\/p>\n","protected":false},"excerpt":{"rendered":"
Three letters that I am positively sick of hearing. I remember reading about this first on Peter K’s blog and – shame on me – it registered but wasn’t top of my to do list. Well, it is now. Several other bloggers including Chris Foot have talked about the changes in the date that Daylight… Continue reading DST<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[],"class_list":["post-1207","post","type-post","status-publish","format-standard","hentry","category-uncategorized","entry"],"jetpack_featured_media_url":"","jetpack-related-posts":[{"id":956,"url":"http:\/\/orcldoug.com\/blog\/2005\/08\/15\/useful-site\/","url_meta":{"origin":1207,"position":0},"title":"Useful Site","date":"August 15, 2005","format":false,"excerpt":"I received an email from Andy Campbell, one of my ex-colleagues at Sun\"Just came across the following web page thatseems to contain a lot of well presented whitepapers etc on oracle and a lot of other technologiesMay be worth bookmarking ...http:\/\/www.akadia.com\/html\/publications.htmlThe one on locking is particularly good ...http:\/\/www.akadia.com\/services\/ora_locks_survival_guide.html\"","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1331,"url":"http:\/\/orcldoug.com\/blog\/2007\/10\/28\/openworld\/","url_meta":{"origin":1207,"position":1},"title":"Openworld","date":"October 28, 2007","format":false,"excerpt":"I finally got my act together enough last week to put my Openworld agenda together. That was difficult, not just because there were a lot of conflicts to resolve, but also because the interface could be a lot better as APC pointed out here. I was surprised just how many\u2026","rel":"","context":"With 3 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1377,"url":"http:\/\/orcldoug.com\/blog\/2008\/01\/16\/cpus-again\/","url_meta":{"origin":1207,"position":2},"title":"CPUs again …","date":"January 16, 2008","format":false,"excerpt":"I'm pleased to see a few posts debating the (non)-application of quarterly Critical Patch Updates. Here are a few examples ...Is Poor Security Hygiene Rampant?Do DBAs care about Oracle\u2019s latest Critical Patch Update?Survey finds that 66% of Oracle users never install critical patchesAll of which seem to have been kicked\u2026","rel":"","context":"With 6 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1362,"url":"http:\/\/orcldoug.com\/blog\/2007\/12\/04\/ukoug-blogger-meet-up-and-day-two\/","url_meta":{"origin":1207,"position":3},"title":"UKOUG Blogger Meet-up and Day Two","date":"December 4, 2007","format":false,"excerpt":"I managed to work on my presentation a bit yesterday afternoon. I was discussing this will Niall later on and there's a point when you know you are going to be finished and you've broken the back of it, but you still have a lot of work to do. That's\u2026","rel":"","context":"With 4 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":1622,"url":"http:\/\/orcldoug.com\/blog\/2010\/12\/22\/guest-post-gustavs-new-year-recommendations\/","url_meta":{"origin":1207,"position":4},"title":"Guest Post: Gustav’s New Year Recommendations","date":"December 22, 2010","format":false,"excerpt":"Over the past year or so I've had the pleasure of working with a development lead who is younger, more handsome and more switched on than I could ever hope to be. That's true of most young development leads of course, but Gustav Andersson excels in most areas. He is\u2026","rel":"","context":"With 11 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":852,"url":"http:\/\/orcldoug.com\/blog\/2006\/02\/27\/guest-animal-spot\/","url_meta":{"origin":1207,"position":5},"title":"Guest Animal Spot","date":"February 27, 2006","format":false,"excerpt":"This proves a couple of things ....1) I'm not the only one - you can blame Peter Robson for this one.2) Some animals are more adventurous than others. I can't imagine my lot posing in front of old Communist dictators in Hungary!","rel":"","context":"With 5 comments","img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"_links":{"self":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1207","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/comments?post=1207"}],"version-history":[{"count":0,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/posts\/1207\/revisions"}],"wp:attachment":[{"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/media?parent=1207"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/categories?post=1207"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/orcldoug.com\/blog\/wp-json\/wp\/v2\/tags?post=1207"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}