{"id":4543,"date":"2013-06-28T12:37:21","date_gmt":"2013-06-28T09:37:21","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=4543"},"modified":"2013-07-24T22:43:44","modified_gmt":"2013-07-24T19:43:44","slug":"oracle-real-application-cluster-rac-veritabanini-11g-r2%e2%80%b2den-12c-r1%e2%80%b2e-yukseltme-islemi","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=4543","title":{"rendered":"Oracle Real Application Cluster (RAC) Veritaban\u0131n\u0131 11g R2\u2032den 12c R1\u2032e Y\u00fckseltme \u0130\u015flemi"},"content":{"rendered":"

\"Oracle12c\"<\/a>Bu makalemizde “Oracle Real Application Cluster (RAC) Veritaban\u0131n\u0131 11g R2\u2032den 12c R1\u2032e Y\u00fckseltme \u0130\u015flemi”ni inceleyece\u011fiz. Y\u00fckseltme i\u015flemini Oracle 11g R2 (11.2.0.3.0)’den Oracle 12c R1 (12.1.0.1.0)’e yapaca\u011f\u0131z. Veritaban\u0131m\u0131z\u0131 Oracle 12c y\u00fckseltme i\u015flemi yapabilmek i\u00e7in versiyonlar\u0131m\u0131z\u0131n a\u015fa\u011f\u0131daki gibi olmas\u0131 gerekmektedir. Aksi takdirde y\u00fckseltme i\u015flemi m\u00fcmk\u00fcn olmayacakt\u0131r.<\/span><\/p>\n

Oracle 10g R2’den Oracle 12c R1’e\u00a0y\u00fckseltme i\u015flemi i\u00e7in Oracle 10g R2 10.2.0.5 versiyonu\u00a0veya \u00fczeri,<\/span><\/p>\n

Oracle 11g R1’den Oracle 12c R1’e y\u00fckseltme i\u015flemi i\u00e7in Oracle 11g R1 11.1.0.7 versiyonu veya \u00fczeri,<\/span><\/p>\n

Oracle 11g R2’den Oracle 12c R1’e y\u00fckseltme i\u015flemi i\u00e7in Oracle 11g R2 11.2.0.2 versiyonu veya \u00fczeri olmas\u0131 gerekmektedir. E\u011fer veritaban\u0131 versiyonlar\u0131m\u0131z bu \u015fekilde de\u011filse \u00f6nce bu versiyonlara y\u00fckseltme i\u015flemi yapmal\u0131 daha sonra Oracle 12c R1’e y\u00fckseltme i\u015flemi ger\u00e7ekle\u015ftirmeliyiz.<\/span><\/p>\n

Mevcut veritaban\u0131m\u0131z “Oracle Enterprise Linux \u0130\u015fletim Sisteminde Oracle Real Application Cluster (Rac) 11g R2 Veritaban\u0131 Kurulumu”<\/a> yaz\u0131m\u0131zda anlat\u0131ld\u0131\u011f\u0131 ad\u0131mlarla yap\u0131lm\u0131\u015ft\u0131r.<\/span><\/p>\n

Y\u00fckseltme i\u015flemi \u00f6ncesi sunucumuz internete \u00e7\u0131k\u0131yorsa \u00f6ncelikle i\u015fletim sistemi g\u00fcncellememizi yapabiliriz. E\u011fer internete \u00e7\u0131km\u0131yorsa veya herhangi bir g\u00fcncelleme yapmayacaksak bu ad\u0131m\u0131 atlayabiliriz. Bu i\u015flem zorunlu bir Oracle gereksinimi de\u011fildir. \u00a0A\u011f ortam\u0131m\u0131zda bir “proxy” sunucu arac\u0131l\u0131\u011f\u0131 ile internete \u00e7\u0131k\u0131l\u0131yorsa “Linux \u0130\u015fletim Sistemlerinde Yum Repository i\u00e7in Proxy Yap\u0131land\u0131rmas\u0131”<\/a> ve “Oracle Enterprise Linux \u0130\u015fletim Sistemlerinde Public Yum Repository Yap\u0131land\u0131rmas\u0131”<\/a> yaz\u0131lar\u0131m\u0131z\u0131 inceleyebilirsiniz. Ayr\u0131ca a\u015fa\u011f\u0131daki paketlerinde kurulu oldu\u011fundan emin olmal\u0131y\u0131z.<\/span><\/p>\n

-- \u0130\u015fletim sistemimizi g\u00fcncellemek i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rabiliriz.\r\n\r\n# yum -y update\r\n\r\n-- Oracle 12c versiyonumuz i\u00e7in \u00f6ngereksinim paketimizi kuruyoruz.\r\n<\/span>\r\n# yum -y install oracle-rdbms-server-12cR1-preinstall<\/span><\/pre>\n
A-) Grid Infrastracture Y\u00fckseltme \u0130\u015flemi<\/span><\/strong><\/p>\n
1. Y\u00fckseltme i\u015flemi \u00f6ncesi Cluster servisimizin sa\u011fl\u0131kl\u0131 bir \u015fekilde ayakta olmas\u0131 gerekmektedir. Kontrol i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uyguluyoruz.
\n<\/span><\/p>\n
-- Servisimizin durumunu g\u00f6rmek i\u00e7in her iki \u00fcyede a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.\r\n-- OFFLINE olanlar kullan\u0131lmayan servislerdir. (GNS)\r\n\r\n-- Her iki \u00fcyede a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.\r\n\r\n# crs_stat -t<\/span>\r\n\r\nName           Type           Target    State     Host        <\/span>\r\n------------------------------------------------------------<\/span>\r\nora.DATA.dg    ora....up.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.FRA.dg     ora....up.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ER.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....N1.lsnr ora....er.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora....N2.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....N3.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.asm        ora.asm.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora.cvu        ora.cvu.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora.gsd        ora.gsd.type   OFFLINE   OFFLINE               <\/span>\r\nora....SM1.asm application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....C1.lsnr application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ac1.gsd application    OFFLINE   OFFLINE               <\/span>\r\nora....ac1.ons application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ac1.vip ora....t1.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....SM2.asm application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....C2.lsnr application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....ac2.gsd application    OFFLINE   OFFLINE               <\/span>\r\nora....ac2.ons application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....ac2.vip ora....t1.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora....network ora....rk.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.oc4j       ora.oc4j.type  ONLINE    ONLINE    kryrac1     <\/span>\r\nora.ons        ora.ons.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora.rac.db     ora....se.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.scan1.vip  ora....ip.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora.scan2.vip  ora....ip.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.scan3.vip  ora....ip.type ONLINE    ONLINE    kryrac1<\/span>\r\n\r\n-- E\u011fer servisimiz ayakta de\u011filse a\u015fa\u011f\u0131daki komut ile ba\u015flatabiliriz.<\/span>\r\n-- Her iki \u00fcyede a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.\r\n<\/span>\r\n# crsctl start crs<\/span><\/pre>\n
2. Dikkatli bir \u015fekilde yeni kuraca\u011f\u0131m\u0131z “Grid” ve “Database” yaz\u0131l\u0131mlar\u0131 i\u00e7in gerekli dizinlerimizi olu\u015fturuyoruz. Oracle 11g R2 (11.2.0.2.0) sonras\u0131nda y\u00fckseltme (upgrade) i\u015flemleri i\u00e7in ayr\u0131 dizine kurma \u00f6zelli\u011fi geldi. Bu \u00f6zellik sayesinde mevcut dizinlere dokunmadan ayr\u0131 bir dizine kurulum yap\u0131labilir ve sonras\u0131nda eski dizinler kald\u0131r\u0131labilir. Yaz\u0131m\u0131zda bu ad\u0131mlar\u0131 uygulayaca\u011f\u0131z.<\/span><\/p>\n
-- Yeni \"Grid\" ve \"Database\" kurulumu i\u00e7in dizinlerimizi olu\u015fturuyoruz.<\/span>\r\n\r\n-- Bu i\u015flemi her iki \u00fcyede yap\u0131yoruz.<\/span>\r\n\r\n# mkdir -p \/u01\/app\/12.1.0.1.0\/grid<\/span>\r\n# mkdir -p \/u01\/app\/oracle\/product\/12.1.0.1.0\/db<\/span>\r\n# chown -R oracle:oinstall \/u01\/app\/12.1.0.1.0\/grid<\/span>\r\n# chown -R oracle:oinstall \/u01\/app\/oracle\/product\/12.1.0.1.0\/db<\/span>\r\n# chmod -R 775 \/u01\/app\/12.1.0.1.0\/grid<\/span>\r\n# chmod -R 775 \/u01\/app\/oracle\/product\/12.1.0.1.0\/db<\/span>\r\n\r\n-- Kurulum dosyalar\u0131m\u0131z\u0131 koymak i\u00e7in dizinimizi olu\u015fturuyoruz.<\/span>\r\n\r\n-- Bu i\u015flemi sadece 1. \u00fcyede yapmam\u0131z yeterlidir.<\/span>\r\n\r\n# mkdir -p \/u01\/orainstall<\/span>\r\n# chown -R oracle:oinstall \/u01\/orainstall<\/span>\r\n# chmod -R 775 \/u01\/orainstall<\/span><\/pre>\n
3. Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile “grid” ve “database” kurulum dosyalar\u0131m\u0131z\u0131 olu\u015fturdu\u011fumuz \u201c\/u01\/orainstall\/\u201d dizini alt\u0131na at\u0131yoruz. E\u011fer sunucumuzda ftp server \u00f6zelli\u011fi aktif edilmemi\u015fse \u201cLinux \u0130\u015fletim Sistemlerinde FTP Server Yap\u0131land\u0131rmas\u0131\u201d<\/a> makalemizden faydalanarak gerekli ayarlar\u0131 yapabiliriz. Kurulum tek bir \u00fcye \u00fczerinden her iki \u00fcyeyede yap\u0131laca\u011f\u0131ndan kurulum dosyalar\u0131n\u0131 bir \u00fcye \u00fczerine koyman\u0131z yeterli olacakt\u0131r.<\/span><\/p>\n
-- Kurulum i\u00e7in dosyalar\u0131m\u0131z\u0131 kontrol ediyoruz.<\/span>\r\n\r\n$ cd \/u01\/orainstall\/<\/span>\r\n$ ls<\/span>\r\nV38500-01_1of2.zip  V38500-01_2of2.zip  V38501-01_1of2.zip  V38501-01_2of2.zip<\/span>\r\n\r\n-- Dosyalar\u0131m\u0131z \u00fczerinde gerekli izinleri veriyoruz.<\/span>\r\n\r\n$ cd \/u01\/orainstall\/<\/span>\r\n$ chmod 777 *<\/span>\r\n\r\n-- S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131m\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n\r\n$ unzip V38500-01_1of2.zip<\/span>\r\n$ unzip V38500-01_2of2.zip<\/span>\r\n$ unzip V38501-01_1of2.zip<\/span>\r\n$ unzip V38501-01_2of2.zip<\/span>\r\n\r\n-- Ay\u0131klama i\u015flemi tamamland\u0131\u011f\u0131nda yer kaplamamas\u0131 i\u00e7in istersek .zip dosyalar\u0131n\u0131\r\ntemizleyebiliriz.<\/span>\r\n\r\n$ rm -f V3850*<\/span>\r\n\r\n-- Dosyalar\u0131m\u0131z a\u00e7\u0131ld\u0131\u011f\u0131nda \"grid\" ve \"database\" kurulum dosyalar\u0131m\u0131z olu\u015fuyor.<\/span>\r\n\r\n$ ls<\/span>\r\ndatabase  grid<\/span><\/pre>\n
4. Kurulum \u00f6ncesi herhangi bir sorun \u00e7\u0131kmamas\u0131 i\u00e7in sunucular\u0131m\u0131z\u0131n birbirleriyle “oracle” kullan\u0131c\u0131s\u0131 ile SSH \u00fczerinden \u015fifresiz konu\u015fabildi\u011fini kontrol ediyoruz.<\/span><\/p>\n
-- 1. \u00dcyeden 2. \u00dcyeye ba\u011flant\u0131 kuruyoruz.<\/span>\r\n\r\n$ ssh kryrac2<\/span>\r\nLast login: Thu Jun 27 23:07:03 2013 from kryrac1.localdomain<\/span>\r\n\r\n$ exit<\/span>\r\n\r\n-- 2. \u00dcyeden 1. \u00dcyeye ba\u011flant\u0131 kuruyoruz.<\/span>\r\n\r\n$ ssh kryrac1<\/span>\r\nLast login: Thu Jun 27 23:07:13 2013 from kryrac2.localdomain<\/span>\r\n\r\n$ exit<\/span><\/pre>\n
5. Kurulum sunucu \u00fczerinde de\u011filde uzaktan kendi bilgisayarm\u0131zda yap\u0131lacaksa ekran\u0131 export edebiliriz. Bunun i\u00e7in \u201cXmanager\u201d<\/a> vb. em\u00fclat\u00f6r yaz\u0131l\u0131mlar\u0131 kullan\u0131labilir. Bu yaz\u0131l\u0131m\u0131 bilgisayar\u0131m\u0131za kurdu\u011fumuzda \u201cXmanager \u2013 Passive\u201d program\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z. G\u00f6rev \u00e7ubu\u011funda yaz\u0131l\u0131m \u00e7al\u0131\u015facak ve export etti\u011fimiz ekran\u0131 kendi bilgisayar\u0131m\u0131zdan y\u00f6netebilece\u011fiz. Bununla beraber \u201cVNC Server\u201d arac\u0131l\u0131\u011f\u0131 ile de sunucuya ba\u011flanabilir ve kurulumu direk sunucu \u00fczerinden yapabiliriz. Bunun i\u00e7in \u201cLinux \u0130\u015fletim Sistemlerinde VNC Server Yap\u0131land\u0131rmas\u0131\u201d<\/a> makalemizden yararlanabilirsiniz. \u00d6nerilen e\u011fer i\u015fletim sistemimizde masa\u00fcst\u00fc yaz\u0131l\u0131m\u0131 (KDE, Gnome vb) varsa kurulumu VNC Server veya sunucu \u00fczerinden yapman\u0131z \u00e7\u00fcnk\u00fc kurulum a\u015famas\u0131nda network vb. kesintisinde kurulumunuz yar\u0131m kalabilir.<\/span><\/p>\n
-- \u00d6ncelikle Xmanager vb. Em\u00fclat\u00f6r program\u0131n\u0131 bilgisayar\u0131m\u0131zda <\/span>\u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.\r\nArd\u0131ndan a\u015fa\u011f\u0131daki komut ile g\u00f6r\u00fcnt\u00fcy\u00fc export <\/span>etmeliyiz. A\u015fa\u011f\u0131daki i\u015flemi \"oracle\"\r\nkullan\u0131c\u0131 ile yap\u0131yoruz.<\/span>\r\n\r\n$ DISPLAY=<machine-name>:0.0; export DISPLAY<\/span>\r\n\r\n\u00d6rnek;<\/span>\r\n\r\n$ DISPLAY=192.168.2.83:0.0; export DISPLAY<\/span>\r\n\r\nTest i\u00e7in;<\/span>\r\n\r\n$ xclock<\/span>\r\n\r\n-- Yazd\u0131\u011f\u0131m\u0131zda ekran\u0131m\u0131zda bir saat yaz\u0131l\u0131m\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rmeliyiz.<\/span>\r\nE\u011fer a\u00e7\u0131lm\u0131yorsa ayarlarda bir sorun var demektir. Firewall vb. ayarlar\u0131m\u0131z\u0131<\/span>\r\nkontrol etmeliyiz.<\/span><\/pre>\n
6. Grid Infrastracture yaz\u0131l\u0131m\u0131m\u0131z\u0131 “11g R2″den “12c R1″e y\u00fckseltme i\u015flemine ba\u015fl\u0131yoruz.<\/span><\/p>\n
-- Oracle kullan\u0131c\u0131s\u0131 ile sistemimize ba\u011fl\u0131yken<\/span>\r\n\r\n$ cd \/u01\/orainstall\/grid\/<\/span>\r\n$ .\/runInstaller<\/span><\/pre>\n
\"OelRac11gto12c_1\"<\/a><\/p>\n
7. A\u00e7\u0131lan kar\u015f\u0131lama ekran\u0131nda g\u00fcncellemeler i\u00e7in bizden \u201cOracle Support MOS\u201d hesab\u0131n\u0131 istiyor bu ad\u0131m\u0131 \u201cSkip software updates\u201d se\u00e7ene\u011fini se\u00e7erek \u201cNext\u201d\u00a0d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_2\"<\/a><\/p>\n
8. Mevcut “Grid” yaz\u0131l\u0131m\u0131m\u0131z\u0131 y\u00fckseltece\u011fimiz i\u00e7in “Upgrade Oracle Grid Infrastructure or Oracle Automatic Storage Management” se\u00e7ene\u011fi i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_3\"<\/a><\/p>\n
9. Dil se\u00e7ene\u011fimizi varsay\u0131lan olarak \u201cEnglish\u201d olarak se\u00e7ili b\u0131rak\u0131yoruz ve \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_4\"<\/a><\/p>\n
10. Y\u00fcksetme i\u015fleminin uygulanaca\u011f\u0131 “Cluster” ortam\u0131na dahil sunucular\u0131m\u0131z otomatik geliyor. Kar\u015f\u0131m\u0131za \u00e7\u0131kan bilgilerde herhangi bir sorun yoksa “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_5\"<\/a><\/p>\n
11. Kurulum sihirbaz\u0131m\u0131z SSH ba\u011flant\u0131m\u0131z\u0131 kontrol ederken bekliyor herhangi bir sorun \u00e7\u0131kmazsa bir sonraki ad\u0131ma otomatik ge\u00e7ecektir.<\/span><\/p>\n
\"OelRac11gto12c_6\"<\/a><\/p>\n
12. Grid Infrastructure repository se\u00e7ene\u011fini \u015fimdi yap\u0131land\u0131raca\u011f\u0131m\u0131z i\u00e7in \u201cYes\u201d se\u00e7ene\u011fini se\u00e7iliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz. Oracle 12c ile gelen bu \u00f6zellikte istenilirse veritaban\u0131 y\u00fckseltme i\u015fleminde de\u00a0 yap\u0131land\u0131r\u0131labilir.<\/span><\/p>\n
\"OelRac11gto12c_7\"<\/a><\/p>\n
13. Kurulumlar\u0131n ve y\u00f6netimin hangi i\u015fletim sistemi gruplar\u0131 ile yap\u0131laca\u011f\u0131n\u0131 soruyor burada \u201coinstall\u201d veya \u201cdba\u201d gruplar\u0131 se\u00e7ilerek kurulum yap\u0131labilir. Tek olmas\u0131 d\u00fc\u015f\u00fcncesiyle \u201cdba\u201d olarak se\u00e7iyoruz ve \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_8\"<\/a><\/p>\n
14. Kurulum sihirbaz\u0131 bu se\u00e7imlerinde standart d\u0131\u015f\u0131 oldu\u011funu s\u00f6yl\u00fcyor burada verdi\u011fi uyar\u0131ya ekran\u0131na \u201dYes\u201d d\u00fc\u011fmesini t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"OelRac11gto12c_9\"<\/a><\/p>\n
15. Oracle grid kurulumunun yap\u0131laca\u011f\u0131 dizinleri se\u00e7iyoruz. Dizinleri a\u015fa\u011f\u0131daki ekran g\u00f6r\u00fcnt\u00fcs\u00fcndeki gibi se\u00e7iyoruz ve daha \u00f6nce yaratt\u0131\u011f\u0131m\u0131z dizinlere kurulumun yap\u0131lmas\u0131n\u0131 sa\u011fl\u0131yoruz.\u00a0Bu dizinleri daha \u00f6nceki a\u015famalar\u0131m\u0131zda olu\u015fturmu\u015f gerekli haklar\u0131 vermi\u015ftik.<\/span><\/p>\n
\"OelRac11gto12c_10\"<\/a><\/p>\n
16. Ayn\u0131 dizinlerin di\u011fer \u00fcyemizde de olup olmad\u0131\u011f\u0131 kontrol ediliyor.<\/span><\/p>\n
\"OelRac11gto12c_11\"<\/a><\/p>\n
17. Oracle 12c ile gelen yeni \u00f6zelliklerden biride Grid kurulumunda \u201croot\u201d kullan\u0131c\u0131s\u0131 ile \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131z scriptleri otomatik \u00e7al\u0131\u015ft\u0131rmas\u0131n\u0131 ayarlayabiliyoruz. Bu a\u015famadan \u201croot\u201d kullan\u0131c\u0131m\u0131z\u0131n parolas\u0131n\u0131 girerek kurulum sonuna do\u011fru scriptlerin otomatik \u00e7al\u0131\u015fmas\u0131n\u0131 sa\u011flayabiliriz. Gerekli ayarlar\u0131 yapt\u0131ktan sonra \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_12\"<\/a><\/p>\n
18. Sunucular\u0131m\u0131zda \u00e7al\u0131\u015facak batch dosyalar\u0131n\u0131 bu a\u015famada g\u00f6rebiliyoruz. Birinci \u00fcyede 1 ikinci \u00fcyede 3 batch dosyam\u0131z mevcuttur. “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz ve i\u015flemimize devam ediyoruz.<\/span><\/p>\n
\"OelRac11gto12c_13\"<\/a><\/p>\n
19. Kurulum sihirbaz\u0131 sunucular\u0131m\u0131z\u0131 kontrol ederek \u00f6ngereksimin olarak bir eksiklik olup olmad\u0131\u011f\u0131yla ilgili kontrolleri yap\u0131yor.<\/span><\/p>\n
\"OelRac11gto12c_14\"<\/a><\/p>\n
20. Kurulumumuzda herhangi bir sorun yoksa \u00f6ngereksinimlerin tamam\u0131 uygunsa kurulum i\u00e7in \u00f6zet bilgi ekran\u0131 kar\u015f\u0131m\u0131za gelecektir. Kuruluma ba\u015flamak i\u00e7in \u201cInstall\u201d d\u00fc\u011fmesini t\u0131kl\u0131yoruz. Herhangi bir sorun varsa oradaki maddeleri inceliyoruz ve kritiklik durumuna g\u00f6re gidermeye \u00e7al\u0131\u015f\u0131yoruz. \u201cWarning\u201d konular ignore edilebilir ancak ba\u015fka bir uyar\u0131 varsa onu gidererek kuruluma devam etmek sorunsuz kurulum a\u00e7\u0131s\u0131ndan \u00f6nemlidir. Aksi takdirde kurulum i\u015flemi belli bir a\u015famaya geldi\u011finde hata verebilir.<\/span><\/p>\n
\"OelRac11gto12c_15\"<\/a><\/p>\n
21. Kurulum a\u015famalar\u0131n\u0131 a\u015fa\u011f\u0131daki ekrandan takip edebiliriz.<\/span><\/p>\n
\"OelRac11gto12c_16\"<\/a><\/p>\n
22. Kurulum sonuna do\u011fru bizden \u201croot\u201d kullan\u0131c\u0131s\u0131 ile \u00e7al\u0131\u015ft\u0131raca\u011f\u0131m\u0131z scriptler i\u00e7in bizden onay istiyor. Bunun i\u00e7in \u00f6nceki ad\u0131mda \u201croot\u201d kullan\u0131c\u0131s\u0131n\u0131n parolas\u0131n\u0131 girerek yap\u0131land\u0131rm\u0131\u015ft\u0131k. Bu a\u015famada \u201cYes\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz. Scriptleri elle \u00e7al\u0131\u015ft\u0131racaksak \u201droot\u201d kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f bir terminal penceresinden \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z. Scriptleri \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki gibi \u00e7\u0131kt\u0131lar olu\u015facakt\u0131r. Scriptleri \u00f6nce 1. \u00fcyede burada bittikten sonra 2. \u00fcyede \u00e7al\u0131\u015ft\u0131raca\u011f\u0131z. Ayn\u0131 anda \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda kurulumumuz hata verebilir. Gerekli script\u2019leri \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra \u201cOK\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz. <\/strong><\/span><\/p>\n
\"OelRac11gto12c_17\"<\/a><\/p>\n
23. Kurulum i\u015fleminin kalan a\u015fmas\u0131 devam ediyor. Bu i\u015flemler tamamlanana kadar bekliyoruz.<\/span><\/p>\n
\"OelRac11gto12c_18\"<\/a><\/p>\n
24. Kurulum ba\u015far\u0131l\u0131 bir \u015fekilde tamamland\u0131ktan sonra \u201cClose\u201d d\u00fc\u011fmesine basarak kurulumu bitiriyoruz.<\/span><\/p>\n
\"OelRac11gto12c_19\"<\/a><\/p>\n
“Grid Infrastracture” y\u00fckseltme \u0130\u015flemimiz tamamland\u0131. \u015eimdi “Database” y\u00fckseltme i\u015flemine ge\u00e7iyoruz.<\/span><\/p>\n
B-) Database Y\u00fckseltme \u0130\u015flemi<\/span><\/strong><\/p>\n
25. Veritaban\u0131 (Database) yaz\u0131l\u0131m\u0131m\u0131z\u0131 “11g R2″den “12c R1″e y\u00fckseltme i\u015flemine ba\u015fl\u0131yoruz.<\/span><\/p>\n
-- Oracle kullan\u0131c\u0131s\u0131 ile sistemimize ba\u011fl\u0131yken<\/span>\r\n\r\n$ cd \/u01\/orainstall\/database\/<\/span>\r\n\r\n$ .\/runInstaller<\/span><\/pre>\n
26. Bizden Oracle Support (MOS) hesab\u0131m\u0131z\u0131n e-posta adresimizi ve parolam\u0131z\u0131 istiyor. Bu ad\u0131mda kutucuktaki i\u015fareti kald\u0131r\u0131yoruz ve \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
27. Oracle Support (MOS) Kullan\u0131c\u0131 ad\u0131 ve Parolas\u0131n\u0131 girmedi\u011fimiz i\u00e7in bizi uyar\u0131yor \u201cYes\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"OelRac11gto12c_21\"<\/a><\/p>\n
28. My Oracle Support arac\u0131l\u0131\u011f\u0131 ile otomatik olarak g\u00fcncelleme indirme ayar\u0131n\u0131 yapmam\u0131z\u0131 istiyor bu ad\u0131mda \u201cSkip software updates\u201d se\u00e7ene\u011fini se\u00e7erek \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_22\"<\/a><\/p>\n
29. Kurulum se\u00e7eneklerimizden y\u00fckseltme i\u015flemi yapaca\u011f\u0131m\u0131z i\u00e7in “Upgrade an existing Database” se\u00e7ene\u011fini se\u00e7iyoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_23\"<\/a><\/p>\n
30. Bu ekranda bir cluster ortam\u0131 kuraca\u011f\u0131m\u0131zdan \u201cOracle Real Application Cluster database installation\u201d se\u00e7ene\u011fini se\u00e7ip k\u00fcmeye \u00fcye yapaca\u011f\u0131m\u0131z sunucular\u0131m\u0131z\u0131 i\u015faretliyoruz.<\/span><\/p>\n
\"OelRac11gto12c_24\"<\/a>\"OelRac11gto12c_25\"<\/a><\/p>\n
31. Kurulum sihirbaz\u0131m\u0131z SSH ba\u011flant\u0131m\u0131z\u0131 kontrol ederken bekliyor herhangi bir sorun \u00e7\u0131kmazsa bir sonraki ad\u0131ma otomatik ge\u00e7ecektir.<\/span><\/p>\n
\"OelRac11gto12c_26\"<\/a><\/p>\n
32. Veritaban\u0131m\u0131z\u0131n kurulumunda varsay\u0131lan olarak \u201cEnglish\u201d se\u00e7ene\u011fini se\u00e7ili b\u0131rak\u0131yoruz ve \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"OelRac11gto12c_27\"<\/a><\/p>\n
33. Lisans se\u00e7ene\u011fimize g\u00f6re kurulum yapaca\u011f\u0131m\u0131z opsiyonu se\u00e7iyoruz. Bu kurulumda \u201cEnterprise Edition\u201d se\u00e7ene\u011fini se\u00e7iyoruz ve \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_28\"<\/a><\/p>\n
34. Oracle Veritaban\u0131 yaz\u0131l\u0131m\u0131n\u0131 kuraca\u011f\u0131m\u0131z dizinleri a\u015fa\u011f\u0131daki gibi yaz\u0131p ard\u0131ndan \u201cNext\u201d d\u00fc\u011fmesini t\u0131kl\u0131yoruz. Bu dizinleri daha \u00f6nceki kurulum a\u015famalar\u0131m\u0131zda olu\u015fturmu\u015f gerekli haklar\u0131 vermi\u015ftik.<\/span><\/p>\n
\"OelRac11gto12c_29\"<\/a><\/p>\n
35. Ayn\u0131 dizinlerin di\u011fer \u00fcyemizde de olup olmad\u0131\u011f\u0131 kontrol ediliyor.<\/span><\/p>\n
\"OelRac11gto12c_30\"<\/a><\/p>\n
36. Veritaban\u0131 kurulumu ve y\u00f6netimi i\u00e7in i\u015fletim sistemi gruplar\u0131n\u0131 se\u00e7iyoruz. \u00d6zel bir yetki yap\u0131land\u0131rmam\u0131z yoksa a\u015fa\u011f\u0131da g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi \u201cdba\u201d gruplar\u0131 atayarak \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_31\"<\/a><\/p>\n
37. Kurulum sihirbaz\u0131 Veritaban\u0131 kurulumumuz i\u00e7in sistemimizin uygunlu\u011funu kurulum \u00f6ncesi denetleyecektir. E\u011fer bir sorun varsa bizi uyaracak ve bu sorun giderildikten sonra kuruluma devam etmemizi tavsiye edecektir. Bizim sistemimizde herhangi bir eksik olmad\u0131\u011f\u0131 i\u00e7in otomatik olarak di\u011fer ad\u0131ma ge\u00e7ecektir.<\/span><\/p>\n
\"OelRac11gto12c_32\"<\/a><\/p>\n
38. Kurulum \u00f6zet ekran\u0131 \u00e7\u0131kt\u0131ktan sonra \u201cInstall\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_33\"<\/a><\/p>\n
39. Kurulum sihirbaz\u0131 kurulum a\u015famalar\u0131n\u0131 bize ad\u0131m ad\u0131m g\u00f6sterecektir. Bu i\u015flemler tamamlanana kadar bekliyoruz.<\/span><\/p>\n
\"OelRac11gto12c_34\"<\/a><\/p>\n
40. Kurulumun sonuna do\u011fru daha \u00f6nce oldu\u011fu gibi bizden bir scriptin \u201croot\u201d kullan\u0131c\u0131s\u0131 ile \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131n\u0131 isteyecektir. \u201croot\u201d kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f bir terminal ekran\u0131nda a\u015fa\u011f\u0131daki gibi komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_35\"<\/a><\/p>\n
# \/u01\/app\/oracle\/product\/12.1.0.1.0\/db\/root.sh<\/span>\r\nPerforming root user operation for Oracle 12c <\/span>\r\n\r\nThe following environment variables are set as:<\/span>\r\n    ORACLE_OWNER= oracle<\/span>\r\n    ORACLE_HOME=  \/u01\/app\/oracle\/product\/12.1.0.1.0\/db<\/span>\r\n\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]: <\/span>\r\nThe contents of \"dbhome\" have not changed. No need to overwrite.<\/span>\r\nThe contents of \"oraenv\" have not changed. No need to overwrite.<\/span>\r\nThe contents of \"coraenv\" have not changed. No need to overwrite.<\/span>\r\n\r\nEntries will be added to the \/etc\/oratab file as needed by<\/span>\r\nDatabase Configuration Assistant when a database is created<\/span>\r\nFinished running generic part of root script.<\/span>\r\nNow product-specific root actions will be performed.<\/span><\/pre>\n
41. Kurulum i\u015fleminin kalan a\u015fmas\u0131 devam ediyor. Bu i\u015flemler tamamlanana kadar bekliyoruz.<\/span><\/p>\n
\"OelRac11gto12c_36\"<\/a><\/p>\n
42. Kurulum i\u015flemi tamamland\u0131\u011f\u0131nda ikinci bir pencerede “Database Upgrade Assistant” arac\u0131 a\u00e7\u0131lacakt\u0131r. A\u00e7\u0131lan “DBUA” arac\u0131m\u0131zda “Upgrade Oracle Database” se\u00e7ene\u011fi i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_37\"<\/a><\/p>\n
43. Y\u00fckseltme i\u015fleminin yap\u0131laca\u011f\u0131 veritabanlar\u0131m\u0131z\u0131, kaynak dizin ve hedef dizinlerimizi se\u00e7iyoruz. Buradaki se\u00e7imlerimizi \u00e7ok dikkatli yapmal\u0131y\u0131z. Gerekli ayarlar\u0131m\u0131z\u0131 yapt\u0131ktan sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_38\"<\/a><\/p>\n
44. Kurulum i\u00e7in gerekli denetimler yap\u0131l\u0131rken bekliyoruz.<\/span><\/p>\n
\"OelRac11gto12c_39\"<\/a>\"OelRac11gto12c_40\"<\/a><\/p>\n
45. Kurulum gereksiminlerimiz tamamland\u0131 sadece “Enterprise Manager Repository” mevcut oldu\u011fu ve bunun kald\u0131r\u0131laca\u011f\u0131 ve yenisinin kurulaca\u011f\u0131 ile ilgili uyar\u0131 al\u0131yoruz. Kuruluma devam etmek i\u00e7in “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_41\"<\/a><\/p>\n
46. Y\u00fckseltme se\u00e7eneklerimizi belirliyoruz. Bu a\u015famada y\u00fckseltme i\u015fleminin ka\u00e7 paralellikle yap\u0131laca\u011f\u0131, y\u00fckseltme i\u015flemi sonras\u0131 “Invalid Objects”lerin ka\u00e7 paralellikle yeniden derlenece\u011fi, vb. se\u00e7eneklerimizi yap\u0131land\u0131r\u0131yoruz. “Time Zone” kolay kolay de\u011fi\u015fmez ancak Upgrade i\u015flemi sonras\u0131 istatistik toplanmas\u0131 \u00f6nemlidir. Burada veri boyutumuz b\u00fcy\u00fckse upgrade i\u015flemimiz olduk\u00e7a uzayacakt\u0131r. T\u00fcm veritaban\u0131m\u0131z\u0131n ne kadar zamanda istatistik toplad\u0131\u011f\u0131n\u0131 g\u00f6z \u00f6n\u00fcnde bulundurarak tercih yapmam\u0131z isabetli olacakt\u0131r. Ayr\u0131ca y\u00fckseltme i\u015flemi s\u00fcresinde “User tablespace”si “Read Only” tutmakta fayda olacakt\u0131r. Bu sayede y\u00fckseltme i\u015flemi s\u0131ras\u0131nda bir kullanc\u0131 veya servis ba\u011flan\u0131p bir de\u011fi\u015fiklik yapamayacak ve sorun \u00e7\u0131kmas\u0131n\u0131 engeleyecektir. Gerekli se\u00e7imleri yapt\u0131ktan sonra “Custom SQL Script” sekmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_42\"<\/a><\/p>\n
47. “Custom SQL Script” sekmemizde y\u00fckseltme i\u015flemi \u00f6ncesi ve sonras\u0131nda \u00e7al\u0131\u015ft\u0131rmas\u0131n\u0131 istedi\u011fimiz \u00f6zel scriptlerimiz varsa bunlar\u0131 belirliyoruz. Gerekli i\u015flemleri yapt\u0131ktan sonra kuruluma devam etmek i\u00e7in “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_43\"<\/a><\/p>\n
48. Veritaban\u0131m\u0131z\u0131n web aray\u00fcz\u00fcnden y\u00f6netimi i\u00e7in gerekli olan \u201cEnterprise Manager\u201d konsolunu kuracaksak \u201cConfigure Enterprise Manager\u201d se\u00e7ene\u011fini i\u015faretliyoruz veya ortam\u0131m\u0131zda \u201cEnterprise Manager 12c\u201d gibi y\u00f6netim arac\u0131m\u0131z varsa bu a\u015famadan onunda kurulumunu sa\u011flayabiliriz.<\/span><\/p>\n
\"OelRac11gto12c_44\"<\/a><\/p>\n
49. Veritaban\u0131m\u0131z\u0131n y\u00fckseltme i\u015flemi \u00f6ncesinde yede\u011fini almak i\u00e7in a\u015fa\u011f\u0131daki ekran\u0131 kullanabiliriz. Burada upgrade i\u015fleminde bir problem olmas\u0131 durumunda “recover” i\u015flemini yapaca\u011f\u0131 bir “RMAN” backup’\u0131 gereklidir. E\u011fer geri d\u00f6nme i\u015flemi i\u00e7in kendi y\u00f6ntemimiz varsa “I have my own backup and restore strategy” se\u00e7ene\u011fini i\u015faretliyoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_45\"<\/a><\/p>\n
50. Yapm\u0131\u015f oldu\u011fumuz tercihlerle ilgili \u00f6zet bilgi ekran\u0131 \u00e7\u0131k\u0131yor burada gerekli incelememiz bittikten sonra \u201cFinish\u201d d\u00fc\u011fmesine t\u0131klayarak veritaban\u0131 y\u00fckseltme i\u015flemimizi ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_46\"<\/a><\/p>\n
51. Veritaban\u0131 y\u00fckseltme i\u015fleminin a\u015famalar\u0131n\u0131 a\u015fa\u011f\u0131daki bilgi ekran\u0131ndan takip ediyoruz. Bu i\u015flem se\u00e7mi\u015f oldu\u011fumuz se\u00e7enekler ve sunucumuzun \u00f6zelliklerine\u00a0g\u00f6re biraz zaman alabilir.<\/span><\/p>\n
\"OelRac11gto12c_47\"<\/a><\/p>\n
52. Kurulum i\u015flemimiz ba\u015far\u0131yla tamamland\u0131. Kurulum ekran\u0131m\u0131z\u0131 kapatmak i\u00e7in \u201cUpgrade Results\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OelRac11gto12c_48\"<\/a><\/p>\n
53. Y\u00fckseltme i\u015flemimizin sonu\u00e7lar\u0131n\u0131 “Upgrade Results”\u00a0 bilgi ekran\u0131nda inceleyebiliriz. burada gerekli incelememiz bittikten sonra \u201cClose\u201d d\u00fc\u011fmesine t\u0131klayarak veritaban\u0131 y\u00fckseltme i\u015flemimizi bitiriyoruz.<\/span><\/p>\n
\"OelRac11gto12c_49\"<\/a>\"OelRac11gto12c_50\"<\/a><\/p>\n
54. Y\u00fckseltme i\u015flemimizin son a\u015famas\u0131 olarak eski (11g R2) “Oracle Home” dizinlerimizi kald\u0131rmam\u0131z gerekmektedir. Ayr\u0131ca “bash_profile” dosyalar\u0131m\u0131zda yeni “Oracle Home” dizinine g\u00f6re ayarlamalar\u0131 yapmal\u0131y\u0131z. Bunun i\u00e7in a\u015fa\u011f\u0131daki ad\u0131mlar\u0131 uyguluyoruz.<\/span><\/p>\n
-- Oracle 12c DeInstall Arac\u0131 ile bu i\u015flemi yapabiliriz.<\/span>\r\n\r\n-- Eski \"Oracle Home\" dizinlerimizi kald\u0131r\u0131yoruz.<\/span>\r\n\r\n# chown -R oracle \/u01\/app\/11.2.0.3<\/span>\r\n# chown -R oracle \/u01\/app\/oracle\/product\/11.2.0.3<\/span>\r\n# chmod -R 775 \/u01\/app\/11.2.0.3<\/span>\r\n# chmod -R 775 \/u01\/app\/oracle\/product\/11.2.0.3<\/span>\r\n# su - oracle<\/span>\r\n\r\n-- Eski \"Grid Home\" Kald\u0131rma<\/span>\r\n\r\n$ cd \/u01\/orainstall\/grid\/<\/span>\r\n$ .\/runInstaller -deinstall -home \/u01\/app\/11.2.0.3\/grid<\/span>\r\n\r\n-- Eski \"Database Home\" Kald\u0131rma<\/span>\r\n\r\n$ cd \/u01\/orainstall\/database\/<\/span>\r\n$ .\/runInstaller -deinstall -home \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n\r\n$ su - root<\/span>\r\n# rm -rf \/u01\/app\/11.2.0.3<\/span>\r\n# rm -rf \/u01\/app\/oracle\/product\/11.2.0.3<\/span>\r\n\r\n-- bash_profile dosyalar\u0131m\u0131z\u0131 d\u00fczenliyoruz.<\/span>\r\n\r\n-- Her iki \u00fcyede root kullan\u0131c\u0131s\u0131n\u0131n \".bash_profile\" dosyas\u0131n\u0131 d\u00fczenliyoruz.<\/span>\r\n\r\n# vim .bash_profile<\/span>\r\n\r\nORACLE_HOME=\/u01\/app\/12.1.0.1.0\/grid; export ORACLE_HOME<\/span>\r\nPATH=$PATH:$HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$PATH:$ORACLE_HOME\/bin export PATH<\/span>\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib export LD_LIBRARY_PATH<\/span>\r\n\r\n-- \u00dcye'1 de bulunan .bash_profile dosyas\u0131na a\u015fa\u011f\u0131dakileri yaz\u0131yoruz.\r\n\r\n# vim \/home\/oracle\/.bash_profile\r\n\r\n# Oracle Settings<\/span>\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\n\r\nORACLE_HOSTNAME=kryrac1.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=rac; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nGRID_HOME=\/u01\/app\/12.1.0.1.0\/grid; export GRID_HOME<\/span>\r\nDB_HOME=$ORACLE_BASE\/product\/12.1.0.1.0\/db; export DB_HOME<\/span>\r\nORACLE_HOME=$DB_HOME; export ORACLE_HOME<\/span>\r\nORACLE_SID=rac1; export ORACLE_SID<\/span>\r\nORACLE_TERM=xterm; export ORACLE_TERM<\/span>\r\nBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/span>\r\nPATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span>\r\n\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<\/span>\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n<\/span>\r\nif [ $USER = \"oracle\" ]; then<\/span>\r\n  if [ $SHELL = \"\/bin\/ksh\" ]; then<\/span>\r\n    ulimit -p 16384<\/span>\r\n    ulimit -n 65536<\/span>\r\n  else<\/span>\r\n    ulimit -u 16384 -n 65536<\/span>\r\n  fi<\/span>\r\nfi<\/span>\r\n\r\nalias grid='. \/home\/oracle\/.grid'<\/span>\r\nalias db='. \/home\/oracle\/.db'<\/span>\r\n\r\n-- \u00dcye 2'de bulunan .bash_profile dosyas\u0131na a\u015fa\u011f\u0131dakileri yaz\u0131yoruz.<\/span>\r\n\r\n# vim \/home\/oracle\/.bash_profile\r\n\r\n# Oracle Settings<\/span>\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\n\r\nORACLE_HOSTNAME=kryrac2.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=rac; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nGRID_HOME=\/u01\/app\/12.1.0.1.0\/grid; export GRID_HOME<\/span>\r\nDB_HOME=$ORACLE_BASE\/product\/12.1.0.1.0\/db; export DB_HOME<\/span>\r\nORACLE_HOME=$DB_HOME; export ORACLE_HOME<\/span>\r\nORACLE_SID=rac2; export ORACLE_SID<\/span>\r\nORACLE_TERM=xterm; export ORACLE_TERM<\/span>\r\nBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/span>\r\nPATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span>\r\n\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<\/span>\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH\r\n<\/span>\r\nif [ $USER = \"oracle\" ]; then<\/span>\r\n  if [ $SHELL = \"\/bin\/ksh\" ]; then<\/span>\r\n    ulimit -p 16384<\/span>\r\n    ulimit -n 65536<\/span>\r\n  else<\/span>\r\n    ulimit -u 16384 -n 65536<\/span>\r\n  fi<\/span>\r\nfi<\/span>\r\n\r\nalias grid='. \/home\/oracle\/.grid'<\/span>\r\nalias db='. \/home\/oracle\/.db'<\/span><\/pre>\n
55. Veritban\u0131m\u0131z 11g R2’den 12c R1’e y\u00fckseltilmi\u015f ve haz\u0131r durumdad\u0131r. E\u011fer istersek web aray\u00fczl\u00fc y\u00f6netim konsolu olan \u201cEnterprise Manager\u201d a ba\u011flan\u0131p veritaban\u0131 ayar ve monit\u00f6r i\u015flemlerimizi yapabiliriz.<\/span><\/p>\n
-- Enterprise Manager konsolumuza eri\u015febiliriz.\r\n\r\nhttps:\/\/kryrac1.localdomain:5500\/em\/ adresinden<\/span>\r\n\r\n-- Art\u0131k veritaban\u0131m\u0131za oturum a\u00e7abilir istedi\u011fimiz i\u015flemleri yapabiliriz.<\/span>\r\n\r\n$ sqlplus \/ as sysdba <\/span>\r\n\r\nSQL*Plus: Release 12.1.0.1.0 Production on Thu Jun 27 15:18:43 2013<\/span>\r\n\r\nCopyright (c) 1982, 2013, Oracle.  All rights reserved.<\/span>\r\n\r\nConnected to:<\/span>\r\nOracle Database 12c Enterprise Edition Release 12.1.0.1.0 - 64bit Production<\/span>\r\nWith the Partitioning, Real Application Clusters, Automatic Storage Management,<\/span>\r\nOLAP,<\/span>\r\nAdvanced Analytics and Real Application Testing options<\/span>\r\n\r\nSQL> select inst_name FROM v$active_instances;<\/span>\r\n\r\nINST_NAME<\/span>\r\n------------------------------------------------------------<\/span>\r\nkryrac1.localdomain:rac1<\/span>\r\nkryrac2.localdomain:rac2<\/span>\r\n\r\n-- RAC veritaban\u0131n\u0131n ve k\u00fcme servislerin sa\u011fl\u0131kl\u0131 \u00e7al\u0131\u015f\u0131p \u00e7al\u0131\u015fmad\u0131\u011f\u0131n\u0131n<\/span>\r\nkontrol\u00fcn\u00fc yapmak i\u00e7in \"oracle kullan\u0131c\u0131s\u0131yla a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131rabiliriz.<\/span>\r\n\r\n$ srvctl config database -d RAC<\/span>\r\nDatabase unique name: rac<\/span>\r\nDatabase name: rac<\/span>\r\nOracle home: \/u01\/app\/oracle\/product\/12.1.0.1.0\/db<\/span>\r\nOracle user: oracle<\/span>\r\nSpfile: +DATA\/rac\/spfilerac.ora<\/span>\r\nPassword file: +DATA\/rac\/orapwrac<\/span>\r\nDomain: <\/span>\r\nStart options: open<\/span>\r\nStop options: immediate<\/span>\r\nDatabase role: PRIMARY<\/span>\r\nManagement policy: AUTOMATIC<\/span>\r\nServer pools: rac<\/span>\r\nDatabase instances: rac1,rac2<\/span>\r\nDisk Groups: DATA,FRA<\/span>\r\nMount point paths: <\/span>\r\nServices: <\/span>\r\nType: RAC<\/span>\r\nStart concurrency: <\/span>\r\nStop concurrency: <\/span>\r\nDatabase is administrator managed<\/span>\r\n\r\n$ srvctl status database -d RAC<\/span>\r\n\r\nInstance rac1 is running on node kryrac1<\/span>\r\nInstance rac2 is running on node kryrac2<\/span>\r\n\r\n-- Grid ile ilgili komutlar\u0131m\u0131z\u0131 kullanaca\u011f\u0131m\u0131zda bu de\u011fi\u015fkenleri kullanmak i\u00e7in<\/span>\r\n\r\n$ cd<\/span>\r\n$ . .grid<\/span>\r\n\r\n-- Database ile ilgili komutlar\u0131m\u0131z\u0131 kullanaca\u011f\u0131m\u0131zda bu de\u011fi\u015fkenleri kullanmak i\u00e7in<\/span>\r\n\r\n$ cd<\/span>\r\n$ . .db<\/span>\r\n\r\n-- \"Root\" kullan\u0131c\u0131s\u0131 ile Cluster Servislerimizi kontrol edelim.<\/span>\r\n\r\n# cd<\/span>\r\n# . .bash_profile<\/span>\r\n\r\n# crs_stat -t<\/span>\r\n\r\nName           Type           Target    State     Host        <\/span>\r\n------------------------------------------------------------<\/span>\r\nora.DATA.dg    ora....up.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.FRA.dg     ora....up.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ER.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....N1.lsnr ora....er.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora....N2.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....N3.lsnr ora....er.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.MGMTLSNR   ora....nr.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.asm        ora.asm.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora.cvu        ora.cvu.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora....SM1.asm application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....C1.lsnr application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ac1.ons application    ONLINE    ONLINE    kryrac1     <\/span>\r\nora....ac1.vip ora....t1.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....SM2.asm application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....C2.lsnr application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....ac2.ons application    ONLINE    ONLINE    kryrac2     <\/span>\r\nora....ac2.vip ora....t1.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora.mgmtdb     ora....db.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora....network ora....rk.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.oc4j       ora.oc4j.type  ONLINE    ONLINE    kryrac1     <\/span>\r\nora.ons        ora.ons.type   ONLINE    ONLINE    kryrac1     <\/span>\r\nora.rac.db     ora....se.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.scan1.vip  ora....ip.type ONLINE    ONLINE    kryrac2     <\/span>\r\nora.scan2.vip  ora....ip.type ONLINE    ONLINE    kryrac1     <\/span>\r\nora.scan3.vip  ora....ip.type ONLINE    ONLINE    kryrac1<\/span><\/pre>\n
\"OelRac11gto12c_51\"<\/a>\"OelRac11gto12c_52\"<\/a><\/p>\n
56. Oracle Real Application Cluster (RAC) sisteminde sunucumuz a\u00e7\u0131ld\u0131\u011f\u0131nda \u201ccluster\u201d ve\u00a0\u201ddatabase\u201d servislerimiz otomatik olarak ba\u015flamaktad\u0131r. Sunucumuzu kapatmak istedi\u011fimizde bu servislerimizi durdurup sistemi kapatabiliriz. A\u015fa\u011f\u0131daki komutlarla kapatt\u0131\u011f\u0131m\u0131zda sunucumuz a\u00e7\u0131ld\u0131\u011f\u0131nda otomatik yeniden ba\u015flayacakt\u0131r.<\/span><\/p>\n
-- Cluster ve Veritaban\u0131 Servislerimizi Durdurma<\/span>\r\n\r\n-- A\u015fa\u011f\u0131daki i\u015flemleri \"root\" kullan\u0131c\u0131s\u0131 ile yap\u0131yoruz.<\/span>\r\n\r\n# crsctl stop has<\/span>\r\n\r\n-- Bu komut her iki \u00fcyede \u00e7al\u0131\u015ft\u0131r\u0131lacakt\u0131r. Bu komut sonras\u0131 sistemimizi <\/span>\r\nkapat\u0131p a\u00e7t\u0131\u011f\u0131m\u0131zda otomatik a\u00e7\u0131lacakt\u0131r. Bu i\u015flem sonras\u0131 sistemimize<\/span>\r\n\"reboot\" veya \"shutdown\" komutu verilebilir.<\/span>\r\n\r\n-- Cluster ve Veritaban\u0131 Servislerimizi sunucumuzu yeniden ba\u015flatmadan a\u00e7mak<\/span>\r\ni\u00e7in a\u015fa\u011f\u0131daki komutu kullan\u0131yoruz.<\/span>\r\n\r\n# crsctl start has<\/span><\/pre>\n
Bu makalemizde Oracle Enterprise Linux 6.4 64 Bit \u00fczerine \u00e7al\u0131\u015fan Oracle Real Application Cluster Database 11g R2 (11.2.0.3.0)’den Oracle Real Application Cluster Database 12c R1 (12.1.0.1.0)’e y\u00fckseltme (upgrade) i\u015flemini inceledik.<\/span><\/p>\n
Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek dile\u011fiyle\u2026<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Bu makalemizde “Oracle Real Application Cluster (RAC) Veritaban\u0131n\u0131 11g R2\u2032den 12c R1\u2032e Y\u00fckseltme \u0130\u015flemi”ni inceleyece\u011fiz. Y\u00fckseltme i\u015flemini Oracle 11g R2 (11.2.0.3.0)’den Oracle 12c R1 (12.1.0.1.0)’e yapaca\u011f\u0131z. Veritaban\u0131m\u0131z\u0131 Oracle 12c y\u00fckseltme i\u015flemi yapabilmek i\u00e7in versiyonlar\u0131m\u0131z\u0131n a\u015fa\u011f\u0131daki gibi olmas\u0131 gerekmektedir. Aksi takdirde … Okumaya devam et →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[21,290,20,19,634,632,639,624,626,643,631,621,617,619,637,641,635,633,638,625,627,642,628,618,620,636,640,629,630,623,622],"class_list":["post-4543","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-oracle-11g-database-upgrade-etme","tag-oracle-11g-grid-upgrade","tag-oracle-11g-grid-upgrade-etme","tag-oracle-11g-rac-upgrade-etme","tag-oracle-11g-rac-upgrade-islemi","tag-oracle-11g-rac-veritabani-yukseltme","tag-oracle-11g-to-12c-upgrade","tag-oracle-11g-to-oracle-12c-upgrade","tag-oracle-11g-upgrade-etme","tag-oracle-11g-upgrade-islemi","tag-oracle-11g-veritabani-upgrade-etme","tag-oracle-11g-veritabani-yukseltme","tag-oracle-12c-database-upgrade-etme","tag-oracle-12c-grid-upgrade","tag-oracle-12c-grid-upgrade-etme","tag-oracle-12c-rac-upgrade-etme","tag-oracle-12c-rac-upgrade-islemi","tag-oracle-12c-rac-veritabani-yukseltme","tag-oracle-12c-upgrade","tag-oracle-12c-upgrade-etme","tag-oracle-12c-upgrade-islemi","tag-oracle-12c-veritabani-upgrade-etme","tag-oracle-12c-veritabani-yukseltme","tag-oracle-rac-11-2-0-3-to-12-1-0-1-0-upgrade","tag-oracle-rac-11g-to-12c-upgrade","tag-oracle-rac-upgrade-etme","tag-oracle-rac-upgrade-islemi"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/4543","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=4543"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/4543\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=4543"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=4543"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=4543"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}
\"OelRac11gto12c_20\"<\/a><\/p>\n