{"id":21765,"date":"2010-04-19T01:09:03","date_gmt":"2010-04-18T22:09:03","guid":{"rendered":"http:\/\/www.korhanyilmaz.com\/?p=21765"},"modified":"2010-04-19T01:09:03","modified_gmt":"2010-04-18T22:09:03","slug":"o-bilgisayarlar-neden-kapatildi","status":"publish","type":"post","link":"http:\/\/www.korhanyilmaz.com\/?p=21765","title":{"rendered":"O Bilgisayarlar Neden Kapat\u0131ld\u0131?"},"content":{"rendered":"

\"\"<\/a><\/p>\n

Son d\u00f6nemde se\u00e7im sistemine dikkatleri \u00e7eken cesur yaz\u0131lar yazan Son Sayfa\u2019dan Neval Kavcar yine \u00f6nemli bir yaz\u0131 kaleme ald\u0131. Kavcar yaz\u0131s\u0131nda 29 Mart se\u00e7imlerinde YSK\u2019da ya\u015fanan \u015f\u00fcpheli bir olay\u0131 anlatt\u0131. <\/p>\n

\u0130\u015fte Kavcar\u2019\u0131n yaz\u0131s\u0131n\u0131n o b\u00f6l\u00fcm\u00fc: <\/em><\/p>\n

“29 Mart 2009 yerel se\u00e7iminde, merkezler neticeleri girmeye ba\u015flad\u0131ktan sonra neler oldu hat\u0131rlayal\u0131m.<\/p>\n

\u201cY\u00fcksek Se\u00e7im Kurulu (YSK)’nun bilgisayar sisteminde olu\u015fan ar\u0131zalar nedeniyle baz\u0131 b\u00f6lgelerde sisteme veri giri\u015fleri kesintiye u\u011frad\u0131. Al\u0131nan bilgiye g\u00f6re, \u0130zmir, \u0130stanbul, Hatay, \u00c7anakkale, K\u00fctahya ba\u015fta olmak \u00fczere baz\u0131 b\u00f6lgelerde YSK’n\u0131n bilgisayar sisteminde olu\u015fan ar\u0131zalar nedeniyle veri giri\u015fleri yap\u0131lam\u0131yor. A\u015f\u0131r\u0131 y\u00fcklenme nedeniyle sistemde sorunlar ya\u015fand\u0131\u011f\u0131 \u00f6\u011frenildi. YSK yetkilileri, veri aktar\u0131m\u0131nda yo\u011funluktan kaynaklanan sorunlar oldu\u011funu, problemin giderilmesi i\u00e7in \u00e7al\u0131\u015ft\u0131klar\u0131n\u0131 kaydediyor.<\/span>\u201d ( Mart 2009 – Bas\u0131n)<\/p>\n

Bu haberi her halde hat\u0131rl\u0131yorsunuz. Sand\u0131k \u00e7al\u0131nmas\u0131, elektrik kesintileri vs de var.<\/p>\n

\u0130\u015fte tam o konuda, bak\u0131n ne diyor sistemden anlayan birisi. Verilen bilgi teknik de olsa dikkatle okuyun.<\/span><\/p>\n

\u201cSon belediye se\u00e7imlerinde sistemin \u00e7\u00f6kmesiyle ilgili akl\u0131m\u0131 kurcalayan bir tak\u0131m sorular var; Bilgilerin tutuldu\u011fu database ORACLE, Bu database\u2019ler kay\u0131t yaparken sistemi “RECOVERY<\/strong>” yapabilmek amac\u0131yla online log\u2019lar tutup daha sonra bunlar\u0131 “ARCHIVE LOG<\/strong>” olarak saklarlar.<\/p>\n

1<\/strong>– Sistemin \u00e7\u00f6kt\u00fc\u011f\u00fc saat aral\u0131\u011f\u0131nda ORACLE<\/strong> database\u2019inin “ONLINE LOG<\/strong>“lar\u0131 (kay\u0131tlar\u0131) incelendi mi?<\/p>\n

2<\/strong>– Sistemde bu saat aral\u0131\u011f\u0131nda sadece “INSERT<\/strong>” kay\u0131tlar\u0131 m\u0131 var yoksa “UPDATE<\/strong>” ve “DELETE<\/strong>” kay\u0131tlar\u0131 da mevcut mu?<\/p>\n

3<\/strong>– Sistem database\u2019inde o aral\u0131kta \u00e7al\u0131\u015fan herhangi bir “TRIGGER<\/strong>” set edilmi\u015f mi? O anda sistemde hangi “USER”lar \u00e7al\u0131\u015fm\u0131\u015f ve “IP” numaralar\u0131” nelerdir?<\/p>\n

Kafam\u0131 kurcalayan ba\u015fka bir \u015f\u00fcphe, se\u00e7im sisteminin yo\u011funluktan dolay\u0131 t\u0131kanmas\u0131 ve gece 22.00 civarlar\u0131nda kapat\u0131l\u0131p a\u00e7\u0131lmas\u0131 <\/span>(YSK n\u0131n kendi a\u00e7\u0131klamas\u0131). Hayat\u0131m\u0131n \u00f6nemli bir k\u0131sm\u0131 bu sistemleri ayarlamak ve optimize etmekle ge\u00e7ti\u011fi i\u00e7in ihtimalleri d\u00fc\u015f\u00fcn\u00fcyorum.<\/p>\n

Birinci ihtimal network\u2019te bir s\u0131k\u0131\u015fma ya\u015fanmas\u0131. Ama sistem donan\u0131mlar\u0131n\u0131n yeterince kapasiteye sahip oldu\u011fundan, memory, i\/o alt yap\u0131s\u0131, gigabyte Ethernet kartlar\u0131 ile bir s\u0131k\u0131\u015f\u0131kl\u0131k ihtimalini \u00e7ok az g\u00f6r\u00fcyorum.<\/p>\n

B\u00fcy\u00fck ihtimalle database\u2019de baz\u0131 “DEADLOCK<\/strong>“lar olu\u015fmu\u015f olmal\u0131. \u00c7\u00fcnk\u00fc sadece data insert eden bir ORACLE<\/strong> sisteminin “\u015e\u0130\u015eMES\u0130<\/strong>” neredeyse imkans\u0131zd\u0131r.<\/p>\n

4<\/strong>– En b\u00fcy\u00fck ihtimal ba\u015fka bir user\u2019\u0131n ya da program\u0131n o anda “READ<\/strong>” ya da “UPDATE<\/strong>” ediyor olmas\u0131 laz\u0131m. O saatte se\u00e7im sisteminde kim olabilir? Kim datalara “READ” veya “UPDATE” ama\u00e7l\u0131 eri\u015fmek ister?<\/p>\n

5<\/strong>– Daha da vahim olan\u0131 o anda sistem ba\u015f\u0131nda n\u00f6bet tutan \u015firket ve YSK teknik personelinin bile vak\u0131f olamad\u0131\u011f\u0131 bir ba\u015fka durum mu mevcuttu da sistem a\u00e7\u0131l\u0131p kapat\u0131lmak zorunda kal\u0131nd\u0131?”<\/p>\n

Odatv.com<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

\n

Son d\u00f6nemde se\u00e7im sistemine dikkatleri \u00e7eken cesur yaz\u0131lar yazan Son Sayfa\u2019dan Neval Kavcar yine \u00f6nemli bir yaz\u0131 kaleme ald\u0131. Kavcar yaz\u0131s\u0131nda 29 Mart se\u00e7imlerinde YSK\u2019da ya\u015fanan \u015f\u00fcpheli bir olay\u0131 anlatt\u0131. <\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[105],"tags":[],"class_list":["post-21765","post","type-post","status-publish","format-standard","hentry","category-gundem","odd"],"_links":{"self":[{"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=\/wp\/v2\/posts\/21765","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=21765"}],"version-history":[{"count":0,"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=\/wp\/v2\/posts\/21765\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=21765"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=21765"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.korhanyilmaz.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=21765"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}