{"id":1284,"date":"2013-03-24T23:34:28","date_gmt":"2013-03-24T21:34:28","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=1284"},"modified":"2013-06-26T11:41:41","modified_gmt":"2013-06-26T08:41:41","slug":"oracle-sun-solaris-isletim-sisteminde-standalone-single-instance-oracle-veritabani-kurulumu","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=1284","title":{"rendered":"Oracle (Sun) Solaris \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu"},"content":{"rendered":"

\"OracleDbEnt\"Bu makalemizde Oracle Veritaban\u0131 Kurulumunu Grid Infrastructure olmadan inceleyece\u011fiz. Veritaban\u0131m\u0131z\u0131 dosya sistemine (File System) ASM olmadan kuraca\u011f\u0131z. Kurulum Oracle (Sun) Solaris 10 i\u015fletim sisteminde Oracle Database Enterprise Edition 11.2.0.3.0 \u00fczerine Patchset Update 11.2.0.3.5 uygulanarak yap\u0131lm\u0131\u015ft\u0131r. A\u015fa\u011f\u0131daki kurulum parametrelerinin do\u011frulu\u011fu ya da g\u00fcncelli\u011fi\u00a0“Oracle Tahiti”<\/a> sitesinden kontrol edilmelidir. Bu makale haz\u0131rland\u0131ktan sonra kurulum parametrelerinde bir g\u00fcncelleme yada de\u011fi\u015fiklik olmu\u015f olabilir.<\/span><\/p>\n

1. \u0130\u015fletim sistemimizi \u201cOracle (Sun) Solaris 10 \u0130\u015fletim Sistemi Kurulumu\u201d<\/a> makalemizde anlat\u0131ld\u0131\u011f\u0131 gibi kuruyoruz.<\/span><\/p>\n

2. Sunucumuzda Yerel isim \u00e7\u00f6z\u00fcmleme dosyas\u0131na sunucumuzun adresini ve ismini giriyoruz.<\/span><\/p>\n

-- Kurulumda komut sat\u0131r\u0131n\u0131 esnek kullanabilmek i\u00e7in \"Bash Shell\" yaz\u0131l\u0131m\u0131n\u0131<\/span>\r\n\u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n# bash<\/span>\r\n\r\nbash-3.2# vi \/etc\/hosts<\/span>\r\n\r\n<IP-address>  <fully-qualified-machine-name>  <machine-name><\/span>\r\n\r\n\u00d6rnek;\r\n<\/span>\r\n192.168.2.120   \tkoraykey-sl.localdomain koraykey-sl<\/span><\/pre>\n
3. Sunucumuza Oracle 11g R2 Veritaban\u0131 kurulumu yapabilmek i\u00e7in \u0130\u015fletim Sistemi versiyonumuzun Solaris 10 Update 6 ve sonras\u0131 olmas\u0131 gerekmektedir. Bunu a\u015fa\u011f\u0131daki komut ile kontrol ediyoruz.<\/span><\/p>\n
bash-3.2# cat \/etc\/release\r\n<\/span>\r\n                    Oracle Solaris 10 8\/11 s10x_u10wos_17b X86<\/span>\r\n  Copyright (c) 1983, 2011, Oracle and\/or its affiliates. All rights reserved.<\/span>\r\n                            Assembled 23 August 2011<\/span><\/pre>\n
4. Sunucumuzda kernel parametrelerini ayarlamak i\u00e7in “\/etc\/system” dosyas\u0131n\u0131n sonuna a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span><\/p>\n
bash-3.2# vi \/etc\/system<\/span>\r\n--Dosyas\u0131n\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span>\r\n\r\nset shmsys:shminfo_shmmax=4294967295<\/span>\r\nset shmsys:shminfo_shmmni=100<\/span>\r\nset shmsys:shminfo_shmseg=10<\/span>\r\nset semsys:seminfo_semmni=100<\/span>\r\nset semsys:seminfo_semmns=1024<\/span>\r\nset shmsys:shminfo_shmmin=1<\/span>\r\nset max_nprocs=30000<\/span>\r\nset maxuprc=16384<\/span><\/pre>\n
5. Sunucumuzda a\u015fa\u011f\u0131daki projadd sistemine oracle’\u0131 ekliyoruz.<\/span><\/p>\n
bash-3.2# projadd -U oracle user.oracle<\/span>\r\nbash-3.2# projmod -s -K \"project.max-sem-ids=(priv,100,deny)\" user.oracle<\/span>\r\nbash-3.2# projmod -s -K \"process.max-sem-nsems=(priv,256,deny)\" user.oracle<\/span>\r\nbash-3.2# projmod -s -K \"project.max-shm-memory=(priv,4294967295,deny)\" user.oracle<\/span>\r\nbash-3.2# projmod -s -K \"project.max-shm-ids=(priv,100,deny)\" user.oracle<\/span>\r\nbash-3.2# projmod -s -K \"process.max-file-descriptor=(priv,65536,deny)\" user.oracle<\/span><\/pre>\n
6. Sunucumuzda port aral\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in “\/etc\/inittab” dosyas\u0131na a\u015fa\u011f\u0131daki yap\u0131land\u0131rma de\u011ferlerini ekliyoruz.<\/span><\/p>\n
bash-3.2# vi \/etc\/inittab<\/span>\r\n-- <\/span>Dosyas\u0131n\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span>\r\n\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_smallest_anon_port 9000 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_largest_anon_port 65500 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_smallest_anon_port 9000 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_largest_anon_port 65500 > \/dev\/console<\/span><\/pre>\n
7. Sunucumuzda a\u015fa\u011f\u0131daki paketlerin durumunu sorguluyoruz.<\/span><\/p>\n
bash-3.2# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibC SUNWlibm SUNWlibms SUNWsprot \r\n\\ SUNWtoo SUNWi1of SUNWi1cs SUNWi15cs SUNWxwfnt SUNWcsl<\/span>\r\n\r\n-- Komutunu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda a\u015fa\u011f\u0131daki gibi bir \u00e7\u0131kt\u0131 al\u0131yoruz.\r\n(Komutu sistemimizde yan yana olacak \u015fekilde \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.)<\/span>\r\n\r\n-- Burada g\u00f6r\u00fcld\u00fc\u011f\u00fc gibi sistemimde gerekli olan 3 paketin<\/span>\r\nolmad\u0131\u011f\u0131n\u0131 g\u00f6r\u00fcyoruz. Bir sonraki a\u015famada bunlar\u0131 kuraca\u011f\u0131z.<\/span>\r\n\r\nsystem      SUNWarc   Lint Libraries (usr)<\/span>\r\nsystem      SUNWbtool CCS tools bundled with SunOS<\/span>\r\nsystem      SUNWcsl   Core Solaris, (Shared Libs)<\/span>\r\nsystem      SUNWhea   SunOS Header Files<\/span>\r\nsystem      SUNWi1of  ISO-8859-1 (Latin-1) Optional Fonts<\/span>\r\nsystem      SUNWlibC  Sun Workshop Compilers Bundled libC<\/span>\r\nsystem      SUNWlibm  Math & Microtasking Library Headers & Lint Files (Usr)<\/span>\r\nsystem      SUNWlibms Math & Microtasking Libraries (Usr)<\/span>\r\nsystem      SUNWsprot Solaris Bundled tools<\/span>\r\nsystem      SUNWxwfnt X Window System platform required fonts<\/span>\r\nERROR: information for \" SUNWtoo\" was not found<\/span>\r\nERROR: information for \"SUNWi1cs\" was not found<\/span>\r\nERROR: information for \"SUNWi15cs\" was not found<\/span><\/pre>\n
8. \u0130\u015fletim sistemimizdeki eksik paketleri kuruyoruz.<\/span><\/p>\n
-- Paketleri kurmak i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.\r\n\r\n-- Bize her paket i\u00e7in onay vermemizi istiyor \"y\" tu\u015funa basarak\r\nkurulumu onayl\u0131yoruz. Paketlerin ba\u015far\u0131l\u0131 olarak kuruldu\u011funu\r\ng\u00f6steren uyar\u0131 \u00e7\u0131k\u0131yor. Bu i\u015flem i\u00e7in sunucumuzda i\u015fletim sistemi\r\nkurulumu yapt\u0131\u011f\u0131m\u0131z DVD tak\u0131l\u0131 olmal\u0131d\u0131r.\r\n\r\nbash-3.2# pkgadd -d \/cdrom\/sol_10_811_x86\/Solaris_10\/Product SUNWtoo SUNWi1cs SUNWi15cs<\/span><\/span>\r\n\r\nDo you want to continue with the installation of <SUNWtoo> [y,n,?] y<\/span>\r\n\r\nDo you want to continue with the installation of <SUNWi1cs> [y,n,?] y<\/span>\r\n\r\nDo you want to continue with the installation of <SUNWi15cs> [y,n,?] y<\/span>\r\n\r\nInstallation of <packagename> was successful.<\/span><\/pre>\n
9. Sunucumuzda kullan\u0131c\u0131lar\u0131 ve gruplar\u0131 yarat\u0131yoruz.<\/span><\/p>\n
-- Kullan\u0131c\u0131 Gruplar\u0131n\u0131 olu\u015fturuyoruz.<\/span>\r\n\r\nbash-3.2# groupadd oinstall<\/span>\r\nbash-3.2# groupadd dba<\/span>\r\nbash-3.2# groupadd oper<\/span>\r\n\r\nbash-3.2# useradd -g oinstall -G dba -d \/export\/home\/oracle oracle<\/span>\r\nbash-3.2# mkdir \/export\/home\/oracle<\/span>\r\nbash-3.2# chown oracle:oinstall \/export\/home\/oracle<\/span>\r\n\r\n-- Oracle kullan\u0131c\u0131s\u0131 i\u00e7in parola belirliyoruz.<\/span>\r\n\r\n-- Burada dikkat edece\u011fimiz konu parolam\u0131z toplam 8 karakter olmal\u0131 <\/span>\r\nve en az 2 karakteri alfabetik olacak \u015fekilde olmal\u0131d\u0131r.<\/span>\r\n\r\nbash-3.2# passwd -r files oracle<\/span>\r\nNew Password: <\/span>\r\nRe-enter new Password: <\/span>\r\npasswd: password successfully changed for oracle<\/span>\r\n\r\n-- Oracle kullan\u0131c\u0131s\u0131 i\u00e7in parolam\u0131z atand\u0131.<\/span><\/pre>\n
10. Oracle kurulumlar\u0131n\u0131 yapabilmek, kurulum ve patch dosyalar\u0131m\u0131z\u0131 koyabilmek i\u00e7in gerekli olan dizinleri yarat\u0131p haklar\u0131 at\u0131yoruz.<\/span><\/p>\n
bash-3.2# mkdir -p \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\nbash-3.2# mkdir -p \/u01\/orainstall<\/span>\r\nbash-3.2# mkdir -p \/u01\/orainstall\/opatch<\/span>\r\nbash-3.2# mkdir -p \/u01\/orainstall\/patch<\/span>\r\nbash-3.2# mkdir -p \/export\/home\/oracle\/u01<\/span>\r\nbash-3.2# ln -s \/export\/home\/oracle\/u01 \/u01<\/span>\r\nbash-3.2# chown -R oracle:oinstall \/u01<\/span>\r\nbash-3.2# chmod -R 775 \/u01\/<\/span>\r\nbash-3.2# chown -R oracle:oinstall \/export\/home\/oracle\/<\/span>\r\n\r\n-- Oracle 11.2.0.2.0 versiyonundan sonra ayr\u0131 bir dizine kurulum<\/span>\r\nyap\u0131larak upgrade etme imkan\u0131 getirdi. Yani mevcut oracle dizinleri<\/span>\r\nharicinde bir dizine kurulum yap\u0131larak mevcut dizinleri bozmadan<\/span>\r\ny\u00fckseltme imkan\u0131m\u0131z oluyor bu y\u00fczden dizinler olu\u015fturulurken<\/span>\r\n\"\/u01\/app\/oracle\/product\/11.2.0.3\/db\" gibi versiyon isimlerinide koydum<\/span>\r\nyeni bir versiyon \u00e7\u0131kt\u0131\u011f\u0131nda y\u00fckseltme i\u015flemi yap\u0131l\u0131rken<\/span>\r\n\"\/u01\/app\/oracle\/product\/11.2.0.4\/db\" gibi dizin yaratarak mevcut<\/span>\r\ndizinlere dokunmadan upgrade i\u015flemini yapabiliriz.<\/span><\/pre>\n
11. Oracle Veritaban\u0131 i\u00e7in de\u011fi\u015fkenlerimizi shell profile dosyalar\u0131m\u0131za yaz\u0131yoruz.<\/span><\/p>\n
-- \u00d6ncelikle bash shell i\u00e7in veritaban\u0131 profile dosyam\u0131z\u0131 olu\u015fturuyoruz.<\/span>\r\n\r\n-- Oracle kullan\u0131c\u0131s\u0131na ge\u00e7iyoruz.<\/span>\r\n\r\nbash-3.2# su - oracle<\/span>\r\n$ bash<\/span>\r\n\r\nbash-3.2$ vi .db<\/span>\r\n\r\n-- Dosyam\u0131z\u0131 yaratarak a\u015fa\u011f\u0131daki sat\u0131rlar\u0131 kendi sistemimize g\u00f6re<\/span>\r\nuyarlay\u0131p ekliyoruz.<\/span>\r\n\r\n# Oracle Settings<\/span>\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\nORACLE_HOSTNAME=koraykey-sl.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nORACLE_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export ORACLE_HOME<\/span>\r\nORACLE_SID=orcl; export ORACLE_SID\r\nORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER\r\n<\/span>PATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span>\r\n\r\n-- Sonras\u0131nda bash shell komut sisteminden \u00e7\u0131karak varsay\u0131lan shell<\/span>\r\nsistemi i\u00e7in profile dosyam\u0131z\u0131 olu\u015fturuyoruz.<\/span>\r\n\r\nbash-3.2$ exit<\/span>\r\n\r\n$ vi .profile<\/span>\r\n\r\n# Oracle Settings<\/span>\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\nORACLE_HOSTNAME=koraykey-sl.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nORACLE_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export ORACLE_HOME<\/span>\r\nORACLE_SID=orcl; export ORACLE_SID\r\nORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER\r\n<\/span>PATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH\r\n\r\nGerekli d\u00fczenlemeyi yapt\u0131ktan sonra yeniden Bash Shell komut sistemine\r\nge\u00e7iyoruz.\r\n\r\n$ bash\r\nbash-3.2$ . .db\r\n\r\n-- Komutunu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda art\u0131k Veritaban\u0131 profile de\u011fi\u015fkenlerimiz\r\netkin durumdad\u0131r.<\/span><\/pre>\n
12. Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile oracle kullan\u0131c\u0131s\u0131 ile ba\u011fl\u0131yken kurulum dosyalar\u0131m\u0131z\u0131 olu\u015fturdu\u011fumuz \u201c\/u01\/orainstall\/\u201d dizini alt\u0131na at\u0131yoruz. Oracle kullan\u0131c\u0131s\u0131 ile kopyalama i\u015flemimiz bitti\u011finde kurulum dosyalar\u0131m\u0131z\u0131 kontrol ediyoruz ve gerekli haklar\u0131 veriyoruz.<\/span><\/p>\n
bash-3.2$ cd \/u01\/orainstall\/<\/span>\r\nbash-3.2$ ls<\/span>\r\np10404530_112030_Solaris86-64_1of6.zip<\/span>\r\np10404530_112030_Solaris86-64_2of6.zip<\/span>\r\n\r\n-- Dosyalar \u00fczerinde gerekli haklar\u0131 veriyoruz.<\/span>\r\n\r\nbash-3.2$ cd \/u01\/orainstall\/<\/span>\r\nbash-3.2$ chmod 775 *<\/span><\/pre>\n
13. Oracle Database kurulumu i\u00e7in ilk 2 .zip dosyas\u0131na ihtiyac\u0131m\u0131z var. Bu kurulum dosyalar\u0131m\u0131z\u0131 OTN veya MOS hesaplar\u0131m\u0131z ile indirebiliriz. E\u011fer son versiyon kurulumu yapabilmek istiyorsak (11.2.0.3.0 gibi) MOS dedi\u011fimiz Oracle Support \u00fcyeli\u011fimizin olmas\u0131 gerekmektedir. E\u011fer buna sahip de\u011filsek o zaman OTN hesab\u0131m\u0131z ile \u00e7\u0131km\u0131\u015f olan ilk versiyonu (11.2.0.1.0 gibi) indirebiliriz. \u015eimdi bu s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131m\u0131z\u0131 oracle kullan\u0131c\u0131s\u0131 ile s\u0131ras\u0131yla a\u00e7\u0131yoruz.<\/span><\/p>\n
bash-3.2 $unzip p10404530_112030_Solaris86-64_1of6.zip<\/span>\r\nbash-3.2 $unzip p10404530_112030_Solaris86-64_2of6.zip<\/span><\/pre>\n
14. Ay\u0131klama i\u015flemi tamamland\u0131\u011f\u0131nda yer kaplamamas\u0131 i\u00e7in istersek .zip dosyalar\u0131n\u0131 temizleyebiliriz. Ay\u0131klama i\u015fleminden sonra kuruluma ge\u00e7meden \u00f6nce sunucumuzu yeniden ba\u015flatmam\u0131z kurulum s\u0131ras\u0131nda sorun \u00e7\u0131karmamas\u0131 a\u00e7\u0131s\u0131ndan iyi olacakt\u0131r.<\/span><\/p>\n
bash-3.2$ rm p10404530_112030_Solaris86-64_1of6.zip<\/span>\r\nbash-3.2$ rm p10404530_112030_Solaris86-64_2of6.zip<\/span>\r\n\r\n-- A\u015fa\u011f\u0131daki komut ile \"database\" kurulum dizinimizi<\/span>\r\ng\u00f6rebiliriz.<\/span>\r\n\r\nbash-3.2$ ls<\/span>\r\ndatabase<\/span><\/pre>\n
15. Kurulum i\u015flemine ba\u015flamadan \u00f6nce sunucumuzu yeniden ba\u015flatarak de\u011fi\u015fikliklerin ge\u00e7erli oldu\u011fundan emin olmak faydal\u0131 olacakt\u0131r. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rmam\u0131z yeterli olacakt\u0131r.<\/span><\/p>\n
bash-3.2 $ init 6<\/span><\/pre>\n
16. Kurulum sunucu \u00fczerinde de\u011filde uzaktan kendi bilgisayarm\u0131zda yap\u0131lacaksa ekran\u0131 export edebiliriz. Bunun i\u00e7in \u201cXmanager\u201d 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. \u00d6nerilen kurulumu sunucu \u00fczerinden yapman\u0131z \u00e7\u00fcnk\u00fc kurulum a\u015famas\u0131nda network vb. kesintide kurulumunuz yar\u0131m kalabilir.<\/span><\/p>\n
-- \u00d6ncelikle Xmanager vb. Em\u00fclat\u00f6r program\u0131n\u0131 bilgisayar\u0131m\u0131zda <\/span>\r\n\u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.Ard\u0131ndan a\u015fa\u011f\u0131daki komut ile g\u00f6r\u00fcnt\u00fcy\u00fc export<\/span>\r\netmeliyiz.<\/span>\r\n\r\n-- Oracle kullan\u0131c\u0131s\u0131 ile a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.<\/span>\r\n\r\nbash-3.2$ DISPLAY=<machine-name>:0.0; export DISPLAY<\/span>\r\n\r\n\u00d6rnek;\r\n<\/span>\r\nbash-3.2 $DISPLAY=192.168.2.83:0.0; export DISPLAY<\/span>\r\n\r\nTest i\u00e7in;<\/span>\r\n\r\nbash-3.2$ echo $DISPLAY<\/span>\r\n\r\n192.168.2.83:0.0<\/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.<\/span>\r\nayarlar\u0131m\u0131z\u0131 kontrol etmeliyiz.<\/span><\/pre>\n
17. Bu i\u015flemlerin tamam\u0131 bitti\u011finde kuruluma ge\u00e7ebiliriz. \u00d6ncelikle \u201cOracle Database\u201d yaz\u0131l\u0131m\u0131n\u0131n kurulumuna ba\u015fl\u0131yoruz.<\/span><\/p>\n
-- Oracle kullan\u0131c\u0131s\u0131 ile sistemimize ba\u011fl\u0131yken<\/span>\r\n\r\nbash-3.2$ cd \/u01\/orainstall\/database<\/span>\r\n\r\nkurulum dizininde bulunan<\/span>\r\n\r\nbash-3.2$ .\/runInstaller<\/span>\r\n\r\nuygulamas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/pre>\n
18. 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
\"DB_Install_sl_1\"<\/a><\/p>\n
19. Kullan\u0131c\u0131 ad\u0131 ve Parola girmedi\u011fimiz i\u00e7in bizi uyar\u0131yor \u201cYes\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_2\"<\/a><\/p>\n
20. My Oracle Support (MOS) 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
\"DB_Install_sl_3\"<\/a><\/p>\n
21. Kurulum se\u00e7eneklerinde \u201cInstall database software only\u201d se\u00e7ene\u011fini se\u00e7erek devam ediyoruz. \u201cCreate and configure a database\u201d se\u00e7ene\u011fi ile ilerlersek kurulum a\u015famas\u0131nda veritaban\u0131da olu\u015fturabiliyoruz. Ancak biz veritaban\u0131m\u0131z\u0131 \u201cCustom\u201d olarak olu\u015fturaca\u011f\u0131m\u0131z ve veritaban\u0131 kurulumu yapmadan \u00f6nce \u00e7\u0131km\u0131\u015f olan son patchset update paketini uygulayaca\u011f\u0131m\u0131zdan yaln\u0131zca veritaban\u0131 yaz\u0131l\u0131m\u0131n\u0131 kuraca\u011f\u0131z. Sonras\u0131nda ise elle veritaban\u0131m\u0131z\u0131 kendimiz olu\u015fturaca\u011f\u0131z.<\/span><\/p>\n
\"DB_Install_sl_4\"<\/a><\/p>\n
22. Bu ekranda bir cluster ortam\u0131 kurmayaca\u011f\u0131m\u0131z i\u00e7in \u201cSingle Instance database installation\u201d se\u00e7ene\u011fini se\u00e7erek \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_5\"<\/a><\/p>\n
23. 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
\"DB_Install_sl_6\"<\/a><\/p>\n
24. 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 \u201cSelect Options\u201d d\u00fc\u011fmesine t\u0131klayarak kurmak istedi\u011fimiz opsiyonlar\u0131 se\u00e7iyoruz veya kald\u0131r\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_7\"<\/a>\"DB_Install_sl_8\"<\/a><\/p>\n
25. 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
\"DB_Install_sl_9\"<\/a><\/p>\n
26. Veritaban\u0131 i\u00e7in \u201cOracle Inventory\u201d ayar\u0131m\u0131z\u0131 a\u015fa\u011f\u0131daki gibi yap\u0131land\u0131r\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_10\"<\/a><\/p>\n
27. Veritaban\u0131 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
\"DB_Install_sl_11\"<\/a><\/p>\n
28. 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
\"DB_Install_sl_12\"<\/a><\/p>\n
29. Kurulum \u00f6zet ekran\u0131 \u00e7\u0131kt\u0131ktan sonra \u201cInstall\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_13\"<\/a><\/p>\n
30. Kurulum sihirbaz\u0131 kurulum a\u015famalar\u0131n\u0131 bize ad\u0131m ad\u0131m g\u00f6sterecektir. Bu i\u015flemler tamamlanana kadar bekliyoruz.<\/span><\/p>\n
\"DB_Install_sl_14\"<\/a><\/p>\n
31. 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. Gerekli script\u2019leri \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra \u201cOK\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz.<\/strong><\/span><\/p>\n
\"DB_Install_sl_15\"<\/a><\/p>\n
bash-3.2# cd \/u01\/app\/oraInventory\/<\/span>\r\nbash-3.2# .\/orainstRoot.sh <\/span>\r\nChanging permissions of \/u01\/app\/oraInventory.<\/span>\r\nAdding read,write permissions for group.<\/span>\r\nRemoving read,write,execute permissions for world.<\/span>\r\n\r\nChanging groupname of \/u01\/app\/oraInventory to oinstall.<\/span>\r\nThe execution of the script is complete.<\/span>\r\nbash-3.2# cd \/u01\/app\/oracle\/product\/11.2.0.3\/db\/ <\/span>\r\nbash-3.2# .\/root.sh <\/span>\r\nPerforming root user operation for Oracle 11g <\/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\/11.2.0.3\/db<\/span>\r\n\r\nEnter the full pathname of the local bin directory: [\/usr\/local\/bin]: <\/span>\r\nCreating \/usr\/local\/bin directory...<\/span>\r\n   Copying dbhome to \/usr\/local\/bin ...<\/span>\r\n   Copying oraenv to \/usr\/local\/bin ...<\/span>\r\n   Copying coraenv to \/usr\/local\/bin ...<\/span>\r\n\r\nCreating \/var\/opt\/oracle\/oratab file...<\/span>\r\nEntries will be added to the \/var\/opt\/oracle\/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>\r\nFinished product-specific root actions.<\/span><\/pre>\n
32. Kurulumumuz ba\u015far\u0131l\u0131 bir \u015fekilde tamamland\u0131 \u201cClose\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu sonland\u0131r\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_16\"<\/a><\/p>\n
33. Veritaban\u0131 yaz\u0131l\u0131m\u0131m\u0131z\u0131n kurulumu tamamland\u0131. \u015eimdi Oracle taraf\u0131ndan yay\u0131nlanm\u0131\u015f olan \u201cPatch Update 11.2.3.0.5 g\u00fcncellemesini kurup daha sonra veritaban\u0131m\u0131z\u0131 yarataca\u011f\u0131z. Bu \u015fekilde kurulum yapt\u0131\u011f\u0131m\u0131zda veritaban\u0131m\u0131z son g\u00fcncellemeler i\u015flenmi\u015f haliyle yarat\u0131lacakt\u0131r. Patch ge\u00e7ebilmemiz i\u00e7in \u201cOPatch\u201d yaz\u0131l\u0131m\u0131n\u0131n son versiyonunu Oracle Support (MOS) sitesinden indiriyoruz. \u0130ndirmi\u015f oldu\u011fum OPatch ve Patch update yaz\u0131l\u0131mlar\u0131n\u0131 \u201c\/u01\/orainstall\/\u201d klas\u00f6r\u00fc alt\u0131na koydum. \u015eimdi OPatch yaz\u0131l\u0131m\u0131z\u0131 g\u00fcnceleyip Patch Update ge\u00e7ece\u011fiz. E\u011fer veritaban\u0131m\u0131za herhangi bir patch ge\u00e7mek istemiyorsak bu ad\u0131m\u0131 atlay\u0131p direk veritaban\u0131 olu\u015fturma i\u015flemine ge\u00e7ebiliriz.<\/span><\/p>\n
-- \u00d6ncelikle OPatch yaz\u0131l\u0131m\u0131n\u0131 g\u00fcncelliyoruz.<\/span>\r\n\r\n-- OPatch dosyam\u0131z\u0131 koydu\u011fumuz dizine ge\u00e7iyoruz.<\/span>\r\n\r\nbash-3.2$ cd \/u01\/orainstall\/opatch<\/span>\r\n\r\n-- S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyam\u0131z\u0131 \"unzip\" komutu ile a\u00e7\u0131yoruz.<\/span>\r\n\r\nbash-3.2$ unzip p6880880_112000_Linux-x86-64.zip<\/span>\r\n\r\n-- Yetki sorunu ya\u015famamak i\u00e7in \"OPatch\" yaz\u0131l\u0131m\u0131n\u0131 \"root\"<\/span>\r\nkullan\u0131c\u0131s\u0131 ile g\u00fcncelliyoruz.<\/span>\r\n\r\nbash-3.2$ su - root<\/span>\r\n\r\nbash-3.2# cd \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\nbash-3.2# mv OPatch OPatch_x<\/span>\r\nbash-3.2# cd \/u01\/orainstall\/opatch<\/span>\r\nbash-3.2# mv OPatch\/ \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n\r\n-- Veritaban\u0131 Patch ge\u00e7me i\u015flemini yap\u0131yoruz.<\/span>\r\nOnun \u00f6ncesinde patch dosyas\u0131na gerekli haklar\u0131 veriyoruz.<\/span>\r\n\r\nbash-3.2# cd \/u01\/orainstall\/patch<\/span>\r\nbash-3.2# chmod 775 *<\/span>\r\n\r\n-- Bu i\u015flemi \"oracle\" kullan\u0131c\u0131s\u0131 ile yapmal\u0131y\u0131z.<\/span>\r\n\r\nbash-3.2# su - oracle<\/span>\r\n\r\n-- Patch dosyam\u0131z\u0131 koydu\u011fumuz dizine ge\u00e7iyoruz.<\/span>\r\n\r\nbash-3.2$ cd \/u01\/orainstall\/patch<\/span>\r\n\r\n-- S\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyam\u0131z\u0131 a\u00e7\u0131yoruz.<\/span>\r\n\r\nbash-3.2$ unzip p14727310_112030_Solaris86-64.zip<\/span>\r\n\r\n-- A\u00e7\u0131lm\u0131\u015f patch dizinimize ge\u00e7iyoruz.<\/span>\r\n\r\nbash-3.2$ cd 14727310\/<\/span>\r\n\r\n-- OPatch ge\u00e7me komutumuzu \u00e7al\u0131\u015ft\u0131r\u0131yoruz ve \"y\" tu\u015funa bas\u0131yoruz.<\/span>\r\n\"Email address\/User Name\" sorusunu \"enter\" tu\u015funa basarak ge\u00e7iyoruz.<\/span>\r\ndi\u011fer sorular\u0131 ise \"y\" tu\u015funa basarak yamalama i\u015flemine ba\u015fl\u0131yoruz.<\/span>\r\n\r\nbash-3.2$ opatch apply<\/span>\r\nOracle Interim Patch Installer version 11.2.0.3.3<\/span>\r\nCopyright (c) 2012, Oracle Corporation.  All rights reserved.<\/span>\r\n\r\nOracle Home       : \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\nCentral Inventory : \/u01\/app\/oraInventory<\/span>\r\n   from           : \/u01\/app\/oracle\/product\/11.2.0.3\/db\/oraInst.loc<\/span>\r\n\r\nOPatch version    : 11.2.0.3.3<\/span>\r\nOUI version       : 11.2.0.3.0<\/span>\r\nLog file location : \/u01\/app\/oracle\/product\/11.2.0.3\/db\/cfgtoollogs\/opatch\/opatch.log<\/span>\r\n\r\nVerifying environment and performing prerequisite checks...<\/span>\r\nOPatch continues with these patches: 13343438  13696216  13923374  14275605  14727310<\/span>\r\n\r\nDo you want to proceed? [y|n]<\/span>\r\n\r\nComposite patch 14727310 successfully applied.<\/span>\r\n\r\nOPatch succeeded.<\/span>\r\n\r\n-- Mesaj\u0131n\u0131 ald\u0131ktan sonra art\u0131k veritaban\u0131 yaratma i\u015flemine ge\u00e7ebiliriz.<\/span><\/pre>\n
34. Veritaban\u0131 yaratma i\u015flemine ba\u015flamadan \u00f6nce \u201cListener\u201d servisimizi olu\u015fturmam\u0131z gerekiyor. E\u011fer bu i\u015flemi yapmazsak veritaban\u0131 yaratma i\u015flemimiz ger\u00e7ekle\u015fmeyecektir. Bu i\u015flemi yapabilmek i\u00e7in \u201coracle\u201d kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f bir terminal penceresinde \u201dOracle Net Configuration Assistant\u201d yaz\u0131l\u0131m\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
bash-3.2$ cd<\/span>\r\nbash-3.2$ netca<\/span><\/pre>\n
35. Ho\u015f geldin ekran\u0131nda \u201cListener configuration\u201d se\u00e7ene\u011fi i\u015faretliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_17\"<\/a><\/p>\n
26. Yeni bir \u201cListener\u201d servisi olu\u015fturaca\u011f\u0131m\u0131z i\u00e7in \u201cAdd\u201d se\u00e7ene\u011fi i\u015faretliyken \u201cNext\u201d d\u00fc\u011fmesini t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_18\"<\/a><\/p>\n
27. Bizden \u201cListener\u201d servisi i\u00e7in bir isim istiyor bu ayar\u0131 varsay\u0131lan olarak \u201cLISTENER\u201d olarak b\u0131rakabiliriz. Sonras\u0131nda \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_19\"<\/a><\/p>\n
28. Servisimizin hangi protokolleri kullanaca\u011f\u0131n\u0131 se\u00e7iyoruz. E\u011fer \u00f6zel bir ayar\u0131m\u0131z yoksa varsay\u0131lan olarak \u201cTCP\u201d se\u00e7iliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_20\"<\/a><\/p>\n
29. Servisimizin hangi port numaras\u0131ndan \u00e7al\u0131\u015faca\u011f\u0131n\u0131 soruyor e\u011fer \u00f6zel bir ayar\u0131m\u0131z yoksa varsay\u0131lan olarak\u00a0 \u201c1521\u2033 portu se\u00e7iliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_21\"<\/a><\/p>\n
30. Ba\u015fka bir servis yap\u0131land\u0131rmayacaksak \u201cNo\u201d se\u00e7ene\u011fi i\u015faretliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_22\"<\/a><\/p>\n
31. Listener yap\u0131land\u0131rmam\u0131z\u0131n tamamland\u0131\u011f\u0131n\u0131 g\u00f6steren ekranda \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_23\"<\/a><\/p>\n
32.\u00a0Yeniden d\u00f6nd\u00fc\u011f\u00fcm\u00fcz \u201cHo\u015fgeldin\u201d ekran\u0131nda \u201cFinish\u201d d\u00fc\u011fmesini t\u0131klayarak yap\u0131land\u0131rmam\u0131z\u0131 tamaml\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_24\"<\/a><\/p>\n
33. Oracle kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f bir terminal penceresinde a\u015fa\u011f\u0131daki “Database Configuration Assistant” yaz\u0131l\u0131m\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
bash-3.2$ cd<\/span>\r\nbash-3.2$ dbca<\/span><\/pre>\n
34. Ho\u015fgeldiniz ekran\u0131n\u0131 \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_sl_25\"<\/a><\/p>\n
35. Yeni veritaban\u0131 olu\u015fturaca\u011f\u0131m\u0131z i\u00e7in \u201cCreate Database\u201d se\u00e7ene\u011fini se\u00e7erek \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_26\"<\/a><\/p>\n
36. Veritaban\u0131m\u0131z\u0131 \u00f6zelle\u015ftirilmi\u015f olarak kuraca\u011f\u0131m\u0131z i\u00e7in \u201cCustom Database\u201d se\u00e7ene\u011fi se\u00e7iliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_27\"<\/a><\/p>\n
37. Veritaban\u0131m\u0131z\u0131n \u201cGlobal Database Name\u201d ve \u201cSID\u201d isimlerini yaz\u0131yoruz. Ard\u0131ndan \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\u00a0\"DB_Install_sl_28\"<\/a><\/p>\n
38. 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. Ayr\u0131ca bir yedek alma i\u015flemi olu\u015fturacaksak bununla ilgili ayarlar\u0131da yap\u0131p di\u011fer sekmedeki ayara ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_sl_29\"<\/a><\/p>\n
39. Veritban\u0131m\u0131zda otomatik bak\u0131m \u00f6zelli\u011fini aktif edebilmek i\u00e7in \u201cAutomatic Maintenance Tasks\u201d sekmesine ge\u00e7erek \u201cEnable automatic maintenance tasks\u201d se\u00e7ene\u011fini i\u015faretliyoruz. Bu \u00f6zellik veritaban\u0131m\u0131zda g\u00fcnl\u00fck olarak belli iyile\u015ftirme bak\u0131mlar\u0131 yapacakt\u0131r. \u00d6rne\u011fin bir tablonun %10\u2032dan fazlas\u0131 de\u011fi\u015fmi\u015fse analiz edecektir. Bu \u00f6zellik sayesinde \u00e7ok de\u011fi\u015fen tablolarda elle istatistik toplama vb. i\u015flemleri yapmam\u0131za gerek kalmayacakt\u0131r. Gerekli se\u00e7imi yapt\u0131ktan sonra \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_30\"<\/a><\/p>\n
40. Veritanan\u0131m\u0131zda olu\u015fan kullan\u0131c\u0131lara parola atayaca\u011f\u0131z e\u011fer b\u00fct\u00fcn kullan\u0131c\u0131larda ayn\u0131 parolay\u0131 kullanacaksak \u201cUse the Same Administrative Password for All Accounts\u201d se\u00e7ene\u011fini se\u00e7ip sys, system vb. kullan\u0131c\u0131lar i\u00e7in tek bir parola yaz\u0131yoruz ve ard\u0131ndan \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_31\"<\/a><\/p>\n
41. Vermi\u015f oldu\u011fumuz parola oracle standartlar\u0131 d\u0131\u015f\u0131ndaysa bununla ilgili uyar\u0131 ekran\u0131 gelecektir. Bu ekranda \u201cYes\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_32\"<\/a><\/p>\n
42. Veritaban\u0131 veri dosyalar\u0131n\u0131n (datafile) nas\u0131l tutulaca\u011f\u0131 ile ilgili ayarlar\u0131 bu a\u015famada yap\u0131yoruz. Bizler i\u015fletim sistemi dosya sistemine (File System) kurulum yapt\u0131\u011f\u0131m\u0131z i\u00e7in ilgili men\u00fcden \u201cFile System\u201d se\u00e7ene\u011fini se\u00e7iyoruz. Veri dosyalar\u0131m\u0131z\u0131n oracle taraf\u0131ndan y\u00f6netilmesini istedi\u011fimiz i\u00e7in \u201cUse Oracle-Managed Files (OMF)\u201d se\u00e7ene\u011fini se\u00e7ip \u201cBrowse\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_33\"<\/a><\/p>\n
43. Bu ekranda bize FRA dedi\u011fimiz \u201cFast Recovery Area\u201d yap\u0131land\u0131rmam\u0131z\u0131 yapaca\u011f\u0131z. Bu alan yedekleme ve e\u011fer aktif edilmi\u015fse \u201cArchive Log\u201d dosyalar\u0131m\u0131z\u0131n tutulaca\u011f\u0131 aland\u0131r. \u201cFast Recovery Area Size\u201d olarak ihtiyac\u0131m\u0131z olan alan miktar at\u0131yoruz. Tabikide atayaca\u011f\u0131m\u0131z alan disk boyutumuzdan b\u00fcy\u00fck olmamal\u0131. Gerekli ayarlar\u0131 yapt\u0131ktan sonra \u201cNext\u201d d\u00fc\u011fmesini t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_34\"<\/a><\/p>\n
44. Veritaban\u0131m\u0131za kurulacak opsiyonlar\u0131 se\u00e7iyoruz. Burada kullanaca\u011f\u0131m\u0131z ya da daha sonra kullanmay\u0131 d\u00fc\u015f\u00fcnd\u00fc\u011f\u00fcm\u00fcz opsiyonlar\u0131 se\u00e7iyoruz. Burada dikkat edilmesi gerekenler bir opsiyon di\u011fer bir opsiyon ile ba\u011f\u0131ml\u0131 olabilir.<\/span><\/p>\n
\"DB_Install_sl_35\"<\/a><\/p>\n
45. Gerekli se\u00e7imleri yapt\u0131ktan sonra \u201cStandart Database Components\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz. Burada gerekli olan opsiyonlar\u0131 se\u00e7iyoruz. Dikkat etmemiz gereken bir opsiyon kurulurken Standart Database Components\u2019lerden birine ihtiya\u00e7 duyabilir. O y\u00fczden dikkatli bir \u015fekilde se\u00e7im yapmal\u0131y\u0131z. \u00d6rne\u011fin \u201cOracle Spatial\u201d kullanacaksak \u201cOracle Multimedia\u201d opsiyonunuda kurmam\u0131z gerekir. Bu se\u00e7imleri yapt\u0131ktan sonra \u201cOK\u201d d\u00fc\u011fmesini t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_36\"<\/a><\/p>\n
46. E\u011fer veritaban\u0131 kurulumumuzda bir script \u00e7al\u0131\u015ft\u0131racaksak \u201cCustom Script\u201d sekmesinden gerekli se\u00e7imleri ve ayarlar\u0131 yap\u0131yoruz e\u011fer \u00e7al\u0131\u015ft\u0131rmayacaksak hi\u00e7bir ayara dokunmadan \u201cNext\u201d d\u00fc\u011fmesini t\u0131klay\u0131p kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_37\"<\/a><\/p>\n
47. Bu a\u015famada art\u0131k veritaban\u0131m\u0131z\u0131n kullanaca\u011f\u0131 bellek boyutunu ve bu se\u00e7ene\u011fin nas\u0131l y\u00f6netilece\u011fi ile ilgili se\u00e7imleri yaz\u0131yoruz. K\u0131saca bahsetmek gerekirse atayaca\u011f\u0131m\u0131z bellek boyutu sistemin toplan bellek boyutunun 3\/2\u2032sini ge\u00e7meyecek \u015fekilde ayarlanmal\u0131d\u0131r. Birde \u00e7ok y\u00fcksek bellekli makinelerde data boyutu ihtiya\u00e7 olan bellek boyutu vb. tespitleri yaparak atama yapmal\u0131y\u0131z. Birde SGA ve PGA boyutunun oracle taraf\u0131ndan y\u00f6netilmesi i\u00e7in \u201cUse Automatic Memory Management\u201d se\u00e7ene\u011fini se\u00e7iyoruz. Bu se\u00e7enek ile atanacak bellek miktarlar\u0131n\u0131 oracle kendi mekan\u0131zmas\u0131 i\u00e7erisinde ayarl\u0131yor. Bu ayarlar\u0131m\u0131z\u0131 yapt\u0131ktan sonra \u201cSizing\u201d sekmesine ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_sl_38\"<\/a><\/p>\n
48. Veritaban\u0131 \u201cBlock Size\u201d boyutunu ayarl\u0131yoruz. Bu \u00f6zellik \u00e7ok \u00f6nemlidir. \u00c7\u00fcnk\u00fc veritaban\u0131 kurulum a\u015famas\u0131nda atand\u0131\u011f\u0131nda bir daha de\u011fi\u015ftirilememektedir. Sonras\u0131nda ancak di\u011fer \u201cBlock Size\u201dlarda tablespace\u2019ler yarat\u0131labilir. Bunlar i\u00e7inde Shared Pool\u2019da yarat\u0131lan \u201cBlock Size\u201d lar i\u00e7in ayarlamalar yap\u0131lmas\u0131 gerekmektedir. Yani veritaban\u0131 \u201cBlock Size\u201d ayar\u0131m\u0131z 8K ise istersek 16K tablespace yaratabiliriz. Bu ihtiyac\u0131 belirlerken veri boyutumuzu okuma ihtiyac\u0131m\u0131z\u0131 vb. durumlar\u0131 iyi analiz etmemiz gerekmektedir. E\u011fer bir veriambar\u0131 ortam\u0131 s\u00f6z konusu ise 16K ve daha y\u00fcksek miktarlar tercih edilebilir. Genelde kurulumlarda varsay\u0131lan olarak 8K Block Size tercih edilmektedir. Di\u011fer bir se\u00e7enek olan \u201cProceses\u201d ayar\u0131n\u0131 yap\u0131yoruz. Burada veritaban\u0131m\u0131za oturum a\u00e7acak \u201cSession\u201d say\u0131s\u0131na g\u00f6re ayarlamalar yap\u0131yoruz. Bu se\u00e7enek daha sonrada artt\u0131r\u0131l\u0131p azalt\u0131labilir.<\/span><\/p>\n
\"DB_Install_sl_39\"<\/a><\/p>\n
49. Veritaban\u0131 karakter ayar\u0131n\u0131 yap\u0131yoruz. T\u00fcrk\u00e7e i\u00e7in genelde \u201cW8ISO8859P9\u2033 karakter seti se\u00e7ilmelidir.\u00a0 Bu sekmedeki ayarlar\u0131 yapt\u0131ktan sonra ba\u011flant\u0131 t\u00fcr\u00fcn\u00fc belirlemek i\u00e7in \u201cConnection Mode\u201d sekmesine ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_sl_40\"<\/a><\/p>\n
50. Ba\u011fland\u0131 t\u00fcr\u00fcn\u00fc se\u00e7ece\u011fiz e\u011fer veritaban\u0131m\u0131zda her bir session dedicated olarak ba\u011flant\u0131 kuracaksa \u201cDedicated Server Mode\u201d se\u00e7ene\u011fini se\u00e7iyoruz. Burada varsay\u0131lan se\u00e7enek budur. Bu ayar\u0131 yapt\u0131ktan sonra e\u011fer veritaban\u0131 parametrelerinden kurulum a\u015famas\u0131nda ayarlamak istediklerimiz varsa \u201cAll Initialization Parameters\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_41\"<\/a><\/p>\n
51. Kurulum a\u015famas\u0131nda ayarlamak istedi\u011fimiz veritaban\u0131 parametrelerini a\u015fa\u011f\u0131daki ekrandandan ayarl\u0131yoruz ve sonras\u0131nda \u201cClose\u201d d\u00fc\u011fmesine bas\u0131yoruz. Bu ad\u0131mdaki ayarlar\u0131m\u0131z bitti \u015fimdi kuruluma devam etmek i\u00e7in \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_42\"<\/a><\/p>\n
52. Kurulumun bu a\u015famas\u0131nda sol taraftaki a\u011fa\u00e7 men\u00fcden Tablespace boyutlar\u0131m\u0131z\u0131 Redo Log boyutlar\u0131 ve say\u0131s\u0131 gibi se\u00e7enekleri ayarl\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_43\"<\/a><\/p>\n
53. \u00d6nerece\u011fim Redo Log dosyalar\u0131n\u0131n say\u0131s\u0131 ve boyutlar\u0131 kurulumdan sonra ayarlanmas\u0131 zor ya da zahmetli gelebilir bu a\u015famada Redo Log dosya say\u0131m\u0131z\u0131 ve alan boyutlar\u0131m\u0131z\u0131 belirleyebiliriz. Bu boyut yaz\u0131lan veri miktar\u0131 vb. durumlara g\u00f6re belirlenmelidir. Oracle varsay\u0131lan olarak 50 MB atamaktad\u0131r. biz ihtiyac\u0131m\u0131za g\u00f6re bu miktar\u0131 256, 512, 1024 MB gibi miktarlarda ayarlayabiliriz. Gerekli ayarlar\u0131 yapt\u0131ktan sonra \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_44\"<\/a><\/p>\n
54. Bu kurulum se\u00e7eneklerimizi daha sonra veritaban\u0131 yaratma i\u015flemlerinde kullanmak \u00fczere kaydedebiliriz. Ben bu se\u00e7eneklerimize \u201corcl\u201d ad\u0131n\u0131 verip kaydediyorum. Bu i\u015flemler bittikten sonra \u201cFinish\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_45\"<\/a><\/p>\n
55. Bu kurulum se\u00e7eneklerimizi daha sonra veritaban\u0131 yaratma i\u015flemlerinde kullanmak \u00fczere kaydedebiliriz. Ben bu se\u00e7eneklerimize \u201corcl\u201d ad\u0131n\u0131 verip kaydediyorum. Bu i\u015flemler bittikten sonra \u201cFinish\u201d d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_sl_46\"<\/a>56. Yapm\u0131\u015f oldu\u011fumuz tercihlerle ilgili \u00f6zet bilgi ekran\u0131 \u00e7\u0131k\u0131yor burada gerekli incelememiz bittikten sonra \u201cOK\u201d d\u00fc\u011fmesine t\u0131klayarak veritaban\u0131 olu\u015fturma i\u015flemimizi ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"DB_Install_sl_47\"<\/a><\/p>\n
57. Veritaban\u0131 olu\u015fturma 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 g\u00f6re biraz zaman alabilir.<\/span><\/p>\n
\"DB_Install_sl_48\"<\/a><\/p>\n
58. Kurulum tamamland\u0131\u011f\u0131nda \u00f6zet bilgi ekran\u0131 kar\u015f\u0131m\u0131za \u00e7\u0131kacakt\u0131r. Burada istersek veritaban\u0131nda yarat\u0131lan kullan\u0131c\u0131lar\u0131n parolalar\u0131n\u0131da belirleme imkan\u0131m\u0131z var bunun i\u00e7in \u201cPassword Management\u201d d\u00fc\u011fmesine t\u0131klayarak gerekli ayarlar\u0131 yapabiliyoruz. \u0130\u015flemimiz bittikten sonra \u201cExit\u201d d\u00fc\u011fmesine t\u0131klayarak veritaban\u0131 olu\u015fturma i\u015flemini bitiriyoruz.<\/span><\/p>\n
\"DB_Install_sl_49\"<\/a><\/p>\n
59. Veritaban\u0131 kurulum ve olu\u015fturma i\u015flemlerimiz tamamland\u0131 art\u0131k bir veritaban\u0131m\u0131z var \u015fimdi kurulum sonras\u0131 bir ka\u00e7 ayar\u0131 yapal\u0131m. \u00d6ncelikle sistemimiz a\u00e7\u0131ld\u0131\u011f\u0131nda veritaban\u0131m\u0131z\u0131nda a\u00e7\u0131lmas\u0131 i\u00e7in gerekli d\u00fczenlemeyi yapal\u0131m.<\/span><\/p>\n
bash-3.2# vi \/var\/opt\/oracle\/oratab<\/span>\r\n\r\n-- Dosyas\u0131ndaki a\u015fa\u011f\u0131daki sat\u0131rlar\u0131n sonundaki \"N\" se\u00e7ene\u011fini<\/span>\r\n\"Y\" se\u00e7ene\u011fi ile de\u011fi\u015ftiriyoruz.<\/span>\r\n\r\norcl:\/u01\/app\/oracle\/product\/11.2.0.3\/db:Y<\/span>\r\n\r\n-- \u0130\u015flemimiz bitti\u011finde art\u0131k sistem a\u00e7\u0131l\u0131\u015f\u0131nda veritaban\u0131m\u0131z<\/span>\r\notomatik olarak a\u00e7\u0131lacakt\u0131r.<\/span><\/pre>\n
60. Sunucu \u00fczerinden veritaban\u0131m\u0131za oturum a\u00e7arak ge\u00e7mi\u015f oldu\u011fumuz patchsetin olup olmad\u0131\u011f\u0131na bakal\u0131m.<\/span><\/p>\n
SQL> select * from dba_registry_history;<\/span><\/pre>\n
\"DB_Install_sl_50\"<\/a><\/p>\n
G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi Patchset Update 11.2.0.3.5 uygulanm\u0131\u015f \u015fekilde veritaban\u0131m\u0131z olu\u015fmu\u015f durumdad\u0131r.<\/span><\/p>\n
61. Veritaban\u0131m\u0131z kurulu ve haz\u0131r durumdad\u0131r. E\u011fer istersek web aray\u00fczl\u00fc y\u00f6netim konsolu olan \u201cEnterprise Manager\u201d \u0131 ba\u015flat\u0131p veritaban\u0131 ayar ve monit\u00f6r i\u015flemlerimizi yapabiliriz.<\/span><\/p>\n
bash-3.2$ emctl start dbconsole <\/span>\r\nOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 <\/span>\r\nCopyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.<\/span>\r\nhttps:\/\/koraykey-sl.localdomain:1158\/em\/console\/aboutApplication<\/span>\r\nStarting Oracle Enterprise Manager 11g Database Control ......... started. <\/span>\r\n------------------------------------------------------------------<\/span>\r\nLogs are generated in directory<\/span>\r\n\/u01\/app\/oracle\/product\/11.2.0.3\/db\/koraykey-sl.localdomain_orcl\/sysman\/log <\/span>\r\n\r\n-- G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi https:\/\/koraykey-sl.localdomain:1158\/em\/<\/span>\r\nadresinden Enterprise Manager konsolumuza eri\u015febiliriz.<\/span>\r\n\r\nbash-3.2$ sqlplus \/ as sysdba <\/span>\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 25 00:27:37 2013<\/span>\r\n\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\nConnected to:<\/span>\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\nSQL> select status from v$instance;<\/span>\r\n\r\nSTATUS<\/span>\r\n------------<\/span>\r\nOPEN<\/span>\r\n\r\n-- Art\u0131k veritaban\u0131m\u0131za oturum a\u00e7abilir istedi\u011fimiz i\u015flemleri yapabiliriz.<\/span><\/pre>\n
\"DB_Install_sl_51\"<\/a><\/p>\n
Bu makalemizde Solaris 10 64 Bit (x86_64) i\u015flemci mimarisi \u00fczerine Oracle Database 11.2.0.3.0 with Patchset Update 11.2.0.3.5 dahil kurulum yapmay\u0131 g\u00f6rd\u00fck.<\/span><\/p>\n
Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek dile\u011fiyle\u2026<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Bu makalemizde Oracle Veritaban\u0131 Kurulumunu Grid Infrastructure olmadan inceleyece\u011fiz. Veritaban\u0131m\u0131z\u0131 dosya sistemine (File System) ASM olmadan kuraca\u011f\u0131z. Kurulum Oracle (Sun) Solaris 10 i\u015fletim sisteminde Oracle Database Enterprise Edition 11.2.0.3.0 \u00fczerine Patchset Update 11.2.0.3.5 uygulanarak yap\u0131lm\u0131\u015ft\u0131r. A\u015fa\u011f\u0131daki kurulum parametrelerinin do\u011frulu\u011fu ya … 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,104,105,106,102,103],"class_list":["post-1284","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-solaris-oracle-11g","tag-oracle-solaris-oracle-11g-kurulumu","tag-sun-solaris-oracle","tag-sun-solaris-oracle-11g","tag-sun-solaris-oracle-11g-kurulumu"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1284","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=1284"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1284\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1284"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1284"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1284"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}