{"id":1971,"date":"2013-04-01T21:20:34","date_gmt":"2013-04-01T18:20:34","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=1971"},"modified":"2013-06-26T11:43:46","modified_gmt":"2013-06-26T08:43:46","slug":"suse-enterprise-linux-isletim-sisteminde-standalone-single-instance-oracle-veritabani-kurulumu","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=1971","title":{"rendered":"Suse Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu"},"content":{"rendered":"

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

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 SuSe Enterprise Linux 11 SP2 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. Hat\u0131rlatmak istedi\u011fim bir konuda SuSe Enterprise Linux 11 SP2 i\u015fletim sisteminde sertifikaland\u0131r\u0131lm\u0131\u015f bir kurulumdur. Kurulum i\u015flemleri ayn\u0131 zamanda openSUSE Linux \u0130\u015fletim Sistemlerinde ge\u00e7erlidir. Ancak\u00a0sertifikaland\u0131r\u0131lm\u0131\u015f bir kurulum de\u011fildir. Sistemimizde herhangi bir sorun oldu\u011funda Oracle Support ekibine SR (Service Request) iste\u011fi a\u00e7t\u0131\u011f\u0131m\u0131zda Oracle bu i\u015fletim sisteminde veritaban\u0131 deste\u011fi sa\u011flam\u0131yor gibi bir uyar\u0131 alabiliriz. OpenSUSE i\u015fletim sistemlerinde kurulumu veya \u00e7al\u0131\u015fmas\u0131nda herhangi bir sorun yoktur.<\/span><\/p>\n

1. \u0130\u015fletim sistemimizi \u201cSuse Enterprise Linux \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.
\n<\/span><\/p>\n

# vim \/etc\/hosts<\/span>\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki gibi<\/span> d\u00fczenliyoruz.<\/span>\r\n\r\n127.0.0.1       \tlocalhost.localdomain \tlocalhost<\/span>\r\n192.168.2.120\u00a0\u00a0 \tkoraykey-ss.localdomain \tkoraykey-ss\r\n<\/span>\r\n<\/span><\/pre>\n
3. Kurulum a\u015famas\u0131nda Oracle Paketimizi kurmad\u0131ysak a\u015fa\u011f\u0131daki ad\u0131mlarla kuruyoruz. Ayr\u0131ca gerekli olan iki paketi daha kuruyoruz. Kurulum yapabilmek i\u00e7in i\u015fletim sistemi dvd’miz sunucumuzda tak\u0131l\u0131 ve dvdrom s\u00fcr\u00fcc\u00fcs\u00fc “mount” durumda olmal\u0131d\u0131r. E\u011fer bu paketler sistemde mevcut uyar\u0131s\u0131 al\u0131rsak bu ad\u0131m\u0131 atlayabiliriz. Oracle kurulum a\u015famas\u0131nda paket mevcut olmas\u0131na ra\u011fmen yeni versiyolar\u0131 kurulu oldu\u011fu i\u00e7in \u00f6ngereksinim kontrol\u00fcnde hata verebilir bunlar\u0131 “Ignore” ederek ge\u00e7ebiliriz.
\n<\/span><\/p>\n
# cd \/media\/SLES-11-SP2-DVD-x86_6407551\/suse\/x86_64<\/span>\r\n# rpm -ivh orarun-1.9-172.20.21.54.x86_64.rpm\r\n# rpm -ivh libstdc++43-devel-4.3.4_20091019-0.22.17.x86_64.rpm\r\n# rpm -ivh gcc43-4.3.4_20091019-0.22.17.x86_64.rpm\r\n<\/span><\/pre>\n
4. Oracle kullan\u0131c\u0131m\u0131z varsay\u0131lan olarak kapal\u0131 geldi\u011finden onu aktif hale getiriyoruz.<\/span><\/p>\n
# vim \/etc\/passwd<\/span>\r\n-- Dosyas\u0131n\u0131 a\u00e7\u0131yoruz<\/span>\r\n\r\n-- A\u015fa\u011f\u0131daki sat\u0131r\u0131<\/span>\r\noracle:x:104:107:Oracle user:\/opt\/oracle:\/bin\/false<\/span>\r\n\r\n-- Buradaki gibi d\u00fczenliyoruz.<\/span>\r\noracle:x:104:107:Oracle user:\/opt\/oracle:\/bin\/bash<\/span><\/pre>\n
5. Oracle kullan\u0131c\u0131m\u0131z i\u00e7in parola belirliyoruz.<\/span><\/p>\n
# passwd oracle<\/span>\r\nChanging password for oracle.<\/span>\r\nNew Password: <\/span>\r\nReenter New Password: <\/span>\r\nPassword changed.<\/span><\/pre>\n
6. Oracle “Home” dizini ve de\u011fi\u015fkenlerin tan\u0131mlanabilmesi i\u00e7in “\/etc\/profile.d\/oracle.sh” dosyam\u0131z\u0131 kendi ayarlar\u0131m\u0131za g\u00f6re d\u00fczenleyip \u00e7al\u0131\u015ft\u0131r\u0131yoruz. Ayr\u0131ca Oracle RAC kurulumu yapmad\u0131\u011f\u0131m\u0131z i\u00e7in bununla ilgili de\u011fi\u015fkenlerin \u00f6n\u00fcne “#” i\u015fareti koyarak devreden \u00e7\u0131kar\u0131yoruz.
\n<\/span><\/p>\n
-- \u00d6ncelikle dosyam\u0131z\u0131n g\u00fcvenli\u011fini ayarl\u0131yoruz.<\/span>\r\n# chmod 775 \/etc\/profile.d\/oracle.sh<\/span>\r\n\r\n# vim \/etc\/profile.d\/oracle.sh<\/span>\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki sat\u0131rlar\u0131 d\u00fczenliyoruz.<\/span>\r\n\r\n# Set your ORACLE environment variable here <\/span>\r\n# ORACLE_HOME - Used here and in \/etc\/init.d\/oracle (ora_environment())<\/span>\r\n# ORACLE_SID - Your Oracle System Identifier <\/span>\r\n#<\/span>\r\n\u00a0 ORACLE_BASE=\/u01\/app\/oracle\/<\/span>\r\n\u00a0 ORACLE_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db<\/span>\r\n\u00a0 ORACLE_SID=orcl<\/span>\r\n  ORACLE_HOME_LISTNER=$ORACLE_HOME<\/span>\r\n\u00a0 export ORACLE_BASE ORACLE_HOME ORACLE_SID ORACLE_HOME_LISTNER\r\n<\/span>\r\n# For RAC<\/span>\r\n# export ORA_CRS_HOME=$ORACLE_BASE\/product\/11gR1\/crs<\/span>\r\n# export ORA_ASM_HOME=$ORACLE_BASE\/product\/11gR1\/asm\r\n\r\n# Grid Control Agent Home\r\n# AGENT_HOME=$ORACLE_BASE\/product\/10.2\/agent\r\n<\/span>\r\n# RAC (cluster) component GSD commands don't run when this is<\/span>\r\n# set - which it is if a SuSE Java package is installed.<\/span>\r\n# unset JAVA_BINDIR JAVA_HOME<\/span>\r\n\r\n-- Sonras\u0131nda scriptimizi \u00e7al\u0131\u015ft\u0131yoruz.<\/span>\r\n# cd \/etc\/profile.d\/<\/span>\r\n# .\/oracle.sh\r\n\r\n-- E\u011fer bir yanl\u0131\u015fl\u0131k olmu\u015fsa d\u00fczeltme i\u015flemi i\u00e7in a\u015fa\u011f\u0131daki dosyalarda\r\nde\u011fi\u015fkenlerimizi bulup de\u011fi\u015ftiriyoruz. Kurulum \u00f6ncesi a\u015fa\u011f\u0131daki dosyalarda\r\nde\u011fi\u015fkenlerimizi kontrol etmekte fayda var.\r\n\r\n# vim \/etc\/sysconfig\/oracle\r\n# vim \/etc\/profile.d\/oracle.sh\r\n# vim \/etc\/profile.d\/oracle.csh<\/span><\/pre>\n
7. Kernel Parametrelerimizi a\u015fa\u011f\u0131daki komutlarla ayarl\u0131yoruz.
\n<\/span><\/p>\n
# sysctl -w fs.file-max=6815744\r\n# sysctl -w kernel.sem=\"250 32000 100 128\"\r\n# sysctl -w kernel.shmmni=4096\r\n# sysctl -w kernel.shmall=1073741824\r\n# sysctl -w kernel.shmmax=4398046511104\r\n# sysctl -w net.core.rmem_default=262144\r\n# sysctl -w net.core.rmem_max=4194304\r\n# sysctl -w net.core.wmem_default=262144\r\n# sysctl -w net.core.wmem_max=1048576\r\n# sysctl -w fs.aio-max-nr=1048576\r\n# sysctl -w net.ipv4.ip_local_port_range=\"9000 65500\"\r\n\r\n-- Bu parametreleri girdikten sonra de\u011fi\u015fikliklerin uygulanabilmesi i\u00e7in\r\n\r\n# \/sbin\/sysctl -p\r\n\r\nkomutunu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.\r\n<\/span><\/pre>\n
8. Yine kurulum a\u015famas\u0131nda veya y\u00fcksek miktarda \u201cmemory_target\u201d parametresi atand\u0131\u011f\u0131nda \u201cORA-00845 : MEMORY_TARGET\u201d hatas\u0131 almaktay\u0131z bu sorunu engellemek i\u00e7in a\u015fa\u011f\u0131daki \u201cshmfs\u201d parametresi ayarlanmal\u0131d\u0131r. Bu dosyada yap\u0131lan de\u011fi\u015fiklikler bir sonraki yeniden ba\u015flatma s\u0131ras\u0131nda ge\u00e7erli olacakt\u0131r. Hemen devreye almak i\u00e7in a\u015fa\u011f\u0131daki \u201cmount\u201d komutu \u00e7al\u0131\u015ft\u0131r\u0131lmal\u0131d\u0131r.<\/span><\/p>\n
# vim \/etc\/fstab<\/span>\r\n-- Dosyas\u0131nda tmpfs sat\u0131r\u0131n\u0131n alt\u0131na a\u015fa\u011f\u0131daki gibi bir sat\u0131r eklenmelidir.<\/span>\r\nBurada belirtilen \"size=16g\" boyutu en az atayaca\u011f\u0131m\u0131z \"memory_target\"<\/span>\r\nparametresi kadar olmal\u0131d\u0131r.<\/span>\r\n\r\n-- \u00d6rne\u011fin \"memory_target\" parametremiz 16 GB olacaksa burada atayaca\u011f\u0131m\u0131z<\/span>\r\nde\u011fer a\u015fa\u011f\u0131daki gibi olmal\u0131d\u0131r. Fazla atanmas\u0131 sorun de\u011fildir. \u00d6nemli<\/span>\r\nolan \"memory_target\" de\u011ferinden d\u00fc\u015f\u00fck olmamas\u0131d\u0131r.<\/span>\r\n\r\nshmfs             \t\/dev\/shm                tmpfs   size=16g         0<\/span>\r\n\r\n-- De\u011fi\u015fikli\u011fi hemen devreye almak i\u00e7in<\/span>\r\n\r\n# mount \/dev\/shm\/<\/span>\r\n\r\nkomutunu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/pre>\n
9. 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
# mkdir -p \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n# mkdir -p \/u01\/orainstall<\/span>\r\n# mkdir -p \/u01\/orainstall\/opatch<\/span>\r\n# mkdir -p \/u01\/orainstall\/patch<\/span>\r\n# chown -R oracle:oinstall \/u01<\/span>\r\n# chmod -R 775 \/u01\/<\/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
10. Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile 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 HTTP ve FTP Server Yap\u0131land\u0131rmas\u0131\u201d<\/a> makalemizden faydalanarak gerekli ayarlar\u0131 yapabiliriz.<\/span><\/p>\n
11. Oracle kullan\u0131c\u0131s\u0131 ile kopyalama i\u015flemimiz bitti\u011finde kurulum dosyalar\u0131m\u0131z\u0131 kontrol ediyoruz.<\/span><\/p>\n
~> cd \/u01\/orainstall\/<\/span>\r\n~> ls<\/span>\r\np10404530_112030_Linux-x86-64_1of7.zip<\/span>\r\np10404530_112030_Linux-x86-64_2of7.zip<\/span>\r\n\r\n-- Dosyalar \u00fczerinde gerekli haklar\u0131 veriyoruz.<\/span>\r\n~> cd \/u01\/orainstall\/<\/span>\r\n~> chmod 775 *<\/span><\/pre>\n
12. 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
~> <\/span>unzip p10404530_112030_Linux-x86-64_1of7.zip<\/span>\r\n~> <\/span>unzip p10404530_112030_Linux-x86-64_2of7.zip<\/span><\/pre>\n
13. 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
~> <\/span>rm p10404530_112030_Linux-x86-64_1of7.zip<\/span>\r\n~> <\/span>rm p10404530_112030_Linux-x86-64_2of7.zip<\/span>\r\n\r\n-- A\u015fa\u011f\u0131daki komut ile \"database\" kurulum dizinimizi<\/span>\r\ng\u00f6rebiliriz.<\/span>\r\n\r\n~> <\/span>ls<\/span>\r\ndatabase<\/span><\/pre>\n
14. Kuruluma ba\u015flamadan \u00f6nce Oracle kullan\u0131c\u0131yla sistemimizin baz\u0131 \u00f6zelliklerini kontrol edebiliriz.<\/span><\/p>\n
~> id<\/span>\r\nuid=104(oracle) gid=107(oinstall) groups=107(oinstall),108(dba)<\/span>\r\noracle@localhost:~> cat \/etc\/SuSE-release<\/span>\r\nSUSE Linux Enterprise Server 11 (x86_64)<\/span>\r\nVERSION = 11<\/span>\r\nPATCHLEVEL = 2<\/span>\r\n\r\n~> uname -a<\/span>\r\nLinux localhost 3.0.13-0.27-default #1 SMP Wed Feb 15 13:33:49 UTC 2012\r\n(d73692b) x86_64 x86_64 x86_64 GNU\/Linux<\/span>\r\n\r\n~> env | grep ORAC<\/span>\r\nORACLE_SID=orcl<\/span>\r\nORACLE_BASE=\/opt\/oracle<\/span>\r\nORACLE_HOME=\/u01\/app\/oracle\/\/product\/11.2.0.3\/db<\/span><\/pre>\n
15. Kurulum sunucu \u00fczerinde de\u011filde uzaktan kendi bilgisayar\u0131m\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. Kurulum a\u015famas\u0131nda VNC Server \u00f6zelli\u011fini a\u00e7m\u0131\u015ft\u0131k bu ad\u0131m\u0131 atalayanlar olduysa \u201cLinux \u0130\u015fletim Sistemlerinde VNC Server Yap\u0131land\u0131rmas\u0131\u201d<\/a> makalemizden yararlanabilirsiniz. \u00d6nerilen kurulumu VNC Server veya 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~> DISPLAY=<machine-name>:0.0; export DISPLAY<\/span>\r\n\r\n\u00d6rnek;\r\n<\/span>\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.<\/span>\r\nayarlar\u0131m\u0131z\u0131 kontrol etmeliyiz.<\/span><\/pre>\n
16. 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\n~>cd \/u01\/orainstall\/database<\/span>\r\n\r\nkurulum dizininde bulunan<\/span>\r\n\r\n~> .\/runInstaller<\/span>\r\n\r\nuygulamas\u0131n\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/pre>\n
17. 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_ss_1\"<\/a><\/p>\n
18. 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_ss_2\"<\/a><\/p>\n
19. 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_ss_3\"<\/a><\/p>\n
20. 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_ss_4\"<\/a><\/p>\n
21. 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_ss_5\"<\/a><\/p>\n
22. 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_ss_6\"<\/a><\/p>\n
23. 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_ss_7\"<\/a>\"DB_Install_ss_8\"<\/a><\/p>\n
24. 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_ss_9\"<\/a><\/p>\n
25. 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_ss_10\"<\/a><\/p>\n
26. 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_ss_11\"<\/a><\/p>\n
27. 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.<\/span><\/p>\n
\"DB_Install_ss_12\"<\/a><\/p>\n
Kurulum a\u015famas\u0131nda baz\u0131 paketlerin olmad\u0131\u011f\u0131 konusunda bizi uyar\u0131yor bu paketlerin daha yeni s\u00fcr\u00fcmleri sistemimizde kurulu oldu\u011fu bu uyar\u0131y\u0131 yoksay\u0131p kurulum i\u015flemine devam edebiliriz. Kurmaya \u00e7al\u0131\u015ft\u0131\u011f\u0131m\u0131zda paketlerin kurulu oldu\u011fu ile ilgili uyar\u0131 alaca\u011f\u0131z. “Ignore” se\u00e7ene\u011fi i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz. Bize bununla ilgili uyar\u0131 verdi\u011fi ekran\u0131da onaylay\u0131p kuruluma ge\u00e7ece\u011fiz.<\/span><\/p>\n
# cd \/media\/SLES-11-SP2-DVD-x86_6407551\/suse\/x86_64<\/span>\r\n# rpm -ivh libstdc++43-devel-4.3.4_20091019-0.22.17.x86_64.rpm<\/span>\r\n# rpm -ivh gcc43-4.3.4_20091019-0.22.17.x86_64.rpm<\/span>\r\n\r\nPreparing...                ########################################### [100%]<\/span>\r\npackage already installed<\/span><\/pre>\n
\"DB_Install_ss_13\"<\/a><\/p>\n
28. Kurulum \u00f6zet ekran\u0131 \u00e7\u0131kt\u0131ktan sonra \u201cInstall\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"DB_Install_ss_14\"<\/a><\/p>\n
29. 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_ss_15\"<\/a><\/p>\n
30. 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_ss_16\"<\/a><\/p>\n
# \/u01\/app\/oraInventory\/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\nlocalhost:~ # \/u01\/app\/oracle\/product\/11.2.0.3\/db\/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\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 \/etc\/oratab file...<\/span>\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>\r\nFinished product-specific root actions.<\/span><\/pre>\n
31. 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_ss_17\"<\/a><\/p>\n
32. 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\n~> 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\n~> 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\n~> su - root<\/span>\r\n\r\n# cd \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n# mv OPatch OPatch_x<\/span>\r\n# cd \/u01\/orainstall\/opatch<\/span>\r\n# 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\n\r\n-- Bu i\u015flemi \"oracle\" kullan\u0131c\u0131s\u0131 ile yapmal\u0131y\u0131z.<\/span>\r\n\r\n# su - oracle<\/span>\r\n\r\n-- Patch dosyam\u0131z\u0131 koydu\u011fumuz dizine ge\u00e7iyoruz.<\/span>\r\n\r\n~> 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\n~> unzip p14727310_112030_Linux-x86-64.zip<\/span>\r\n\r\n-- A\u00e7\u0131lm\u0131\u015f patch dizinimize ge\u00e7iyoruz ve OPatch dizinini export ediyoruz.<\/span>\r\n\r\n~> cd 14727310\/<\/span>\r\n~> PATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/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\n~> opatch apply<\/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\nOPatch version    : 11.2.0.3.3<\/span>\r\nOUI version       : 11.2.0.3.0<\/span>\r\nLog file location : <\/span>\r\n\/u01\/app\/oracle\/product\/11.2.0.3\/db\/cfgtoollogs\/opatch\/opatch2013-04-01_18-23-08PM_1.log<\/span>\r\n\r\nVerifying environment and performing prerequisite checks...<\/span>\r\nOPatch continues with these patches:   13343438  13696216  13923374  14275605  14727310<\/span><\/span>\r\nDo you want to proceed? [y|n]<\/span>\r\n\r\nComposite patch 14727310 successfully applied.<\/span>\r\n\r\n-- Mesaj\u0131n\u0131 ald\u0131ktan sonra art\u0131k veritaban\u0131 yaratma i\u015flemine ge\u00e7ebiliriz.<\/span>\r\nBaz\u0131 durumlarda uyar\u0131larla bitti gibi mesajda alabiliriz.<\/span><\/pre>\n
33. 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
~> cd<\/span>\r\n~> netca<\/span>\r\n\r\n-- Bu a\u015famada a\u015fa\u011f\u0131daki gibi bir hata al\u0131rsak d\u00fczeltme <\/span>i\u015fleminin nas\u0131l\r\nolaca\u011f\u0131 anlat\u0131lm\u0131\u015ft\u0131r.<\/span>\r\n\r\n-- Hata;<\/span>\r\nOracle Net Services Configuration:<\/span>\r\n#<\/span>\r\n# An unexpected error has been detected by HotSpot Virtual Machine:<\/span>\r\n#<\/span>\r\n#  SIGSEGV (0xb) at pc=0x00007fb5fb17c41a, pid=3495, tid=140420058535680<\/span>\r\n#<\/span>\r\n# Java VM: Java HotSpot(TM) 64-Bit Server VM (1.5.0_30-b03 mixed mode)<\/span>\r\n# Problematic frame:<\/span>\r\n# C  [libclntsh.so.11.1+0x6e541a]  snlinGetAddrInfo+0x92e<\/span>\r\n#<\/span>\r\n# An error report file with more information is saved as hs_err_pid3495.log<\/span>\r\n#<\/span>\r\n# If you would like to submit a bug report, please visit:<\/span>\r\n#   http:\/\/java.sun.com\/webapps\/bugreport\/crash.jsp<\/span>\r\n#<\/span>\r\n\/u01\/app\/oracle\/product\/11.2.0.3\/db\/bin\/netca: line 181:  3495 Aborted<\/span>\r\noracle@localhost:~> java -version<\/span>\r\nIf 'java' is not a typo you can run the following command to lookup the<\/span>\r\npackage that contains the binary:<\/span>\r\n    command-not-found java<\/span>\r\n-bash: java: command not found<\/span>\r\n\r\n-- D\u00fczeltmek i\u015flemi;\r\n<\/span>\r\n1. \"root\" kullan\u0131c\u0131s\u0131yla bir terminal penceresi a\u00e7\u0131yoruz.<\/span>\r\nhostname machinename\r\n2. \"\/etc\/hosts\" dosyam\u0131zdaki de\u011ferlerin do\u011frulu\u011funu kontrol ediyoruz.<\/span>\r\n\r\n\u00d6rnek;<\/span>\r\nhostname koraykey-ss<\/span>\r\n\r\n-- Ard\u0131ndan komutumuzu yeniden \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/pre>\n
34. 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_ss_18\"<\/a><\/p>\n
35. 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_ss_19\"<\/a><\/p>\n
36. 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_ss_20\"<\/a><\/p>\n
37. 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_ss_21\"<\/a><\/p>\n
38. 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_ss_22\"<\/a><\/p>\n
39. Ba\u015fka bir servis yap\u0131land\u0131rmayacaksak \u201cNo\u201d se\u00e7ene\u011fi i\u015faretliyken \u201cNext\u201d d\u00fc\u011fmesine t\u0131kl\u0131yoruz.
\n<\/span><\/p>\n
\"DB_Install_ol_22\"<\/a><\/p>\n
40. 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_ss_23\"<\/a><\/p>\n
41. Yeniden d\u00f6nd\u00fc\u011f\u00fcm\u00fcz \u201cHo\u015fgeldiniz\u201d ekran\u0131nda \u201cFinish\u201d d\u00fc\u011fmesini t\u0131klayarak yap\u0131land\u0131rmam\u0131z\u0131 tamaml\u0131yoruz.<\/span><\/p>\n
\"DB_Install_ss_24\"<\/a><\/p>\n
42. 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
~> dbca<\/span><\/pre>\n
43. Ho\u015fgeldiniz ekran\u0131n\u0131 \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_ss_25\"<\/a><\/p>\n
44. 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_ss_26\"<\/a><\/p>\n
45. 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_ss_27\"<\/a><\/p>\n
46. 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
\"DB_Install_ss_28\"<\/a><\/p>\n
47. 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_ss_29\"<\/a><\/p>\n
48. Veritaban\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_ss_30\"<\/a><\/p>\n
49. 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_ss_31\"<\/a><\/p>\n
50. 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_ss_32\"<\/a><\/p>\n
51. 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_ss_33\"<\/a><\/p>\n
52. 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_ss_34\"<\/a><\/p>\n
53. 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_ss_35\"<\/a><\/p>\n
54. 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_ss_36\"<\/a><\/p>\n
55. 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_ss_37\"<\/a><\/p>\n
56. 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 mekanizmas\u0131 i\u00e7erisinde ayarl\u0131yor. Bu ayarlar\u0131m\u0131z\u0131 yapt\u0131ktan sonra \u201cSizing\u201d sekmesine ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_ss_38\"<\/a><\/p>\n
57. 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_ss_39\"<\/a><\/p>\n
58. 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_ss_40\"<\/a><\/p>\n
59. Ba\u011flant\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_ss_41\"<\/a><\/p>\n
60. Kurulum a\u015famas\u0131nda ayarlamak istedi\u011fimiz veritaban\u0131 parametrelerini a\u015fa\u011f\u0131daki ekrandan 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_ss_42\"<\/a><\/p>\n
61. 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_ss_43\"<\/a><\/p>\n
62. \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_ss_44\"<\/a><\/p>\n
63. 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_ss_45\"<\/a><\/p>\n
64. 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_ss_47\"<\/a><\/p>\n
65. 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_ss_48\"<\/a><\/p>\n
66. 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_ss_49\"<\/a><\/p>\n
67. 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 ve di\u011fer servislerimizin a\u00e7\u0131lmas\u0131 i\u00e7in gerekli d\u00fczenlemeyi yapal\u0131m.<\/span><\/p>\n
-- \"root\" kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f olan terminal ekran\u0131ndan<\/span>\r\n\r\n# vim \/etc\/sysconfig\/oracle<\/span>\r\n-- Dosyas\u0131n\u0131 a\u00e7\u0131p a\u015fa\u011f\u0131daki \"no\" olan sat\u0131rlar\u0131 \"yes\" olarak de\u011fi\u015ftiriyoruz.<\/span>\r\n\r\n# Start Oracle Database? Set to \"yes\" to enable database<\/span>\r\n# startup automatically at system boot. <\/span>\r\n# <\/span>\r\nSTART_ORACLE_DB=\"yes\"<\/span>\r\n\r\n# Enable clients on other computers to connect to the database<\/span>\r\n# <\/span>\r\nSTART_ORACLE_DB_LISTENER=\"yes\"<\/span>\r\n\r\n# Start Enterprise Manager to allow remote database management <\/span>\r\n#<\/span>\r\nSTART_ORACLE_DB_EMANAGER=\"yes\"<\/span>\r\n\r\n\r\n# vim \/etc\/oratab<\/span>\r\n-- Dosyas\u0131n\u0131 a\u00e7\u0131yoruz ve dosyam\u0131zdaki sat\u0131r\u0131n a\u015fa\u011f\u0131daki gibi oldu\u011funu<\/span>\r\nkontrol ediyoruz.<\/span>\r\n\r\norcl:\/u01\/app\/oracle\/product\/11.2.0.3\/db:Y<\/span>\r\n\r\n-- Bu i\u015flemlerle birlikte<\/span>\r\nOracle Listener Servisi<\/span>\r\nOracle Veritaban\u0131<\/span>\r\nOracle Enterprise Manager Konsolu<\/span>\r\n\r\n-- Sunucumuz a\u00e7\u0131ld\u0131\u011f\u0131nda otomatik ba\u015flayacakt\u0131r.<\/span><\/pre>\n
68. Sunucu \u00fczerinden veritaban\u0131m\u0131za oturum a\u00e7arak ge\u00e7mi\u015f oldu\u011fumuz pathsetin olup olmad\u0131\u011f\u0131na bakal\u0131m.<\/span><\/p>\n
SQL> select * from dba_registry_history;<\/span><\/pre>\n
\"DB_Install_ss_50\"<\/a><\/p>\n
69. 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
~> emctl start dbconsole<\/span>\r\n\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-ss.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-ss.localdomain_orcl\/sysman\/log<\/span>\r\n\r\nG\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi https:\/\/koraykey-ss.localdomain:1158\/em\/<\/span>\r\nadresinden Enterprise Manager konsolumuza eri\u015febiliriz.<\/span>\r\n\r\noracle@localhost:~> sqlplus \/ as sysdba<\/span>\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Apr 1 21:18:21 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_ss_51\"<\/a><\/p>\n
Bu makalemizde Suse Enterprise Linux 64 Bit \u00fczerine Oracle Database 11.2.0.3.0 with Patchset Update 11.2.0.3.5 dahil kurulum yapmay\u0131 g\u00f6rd\u00fck. Ayn\u0131 ad\u0131mlar openSUSE i\u015fletim sistemleri i\u00e7inde ge\u00e7erlidir.<\/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 SuSe Enterprise Linux 11 SP2 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 … 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,156,157,155,151,153,154,150,152],"class_list":["post-1971","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-opensuse-linux-isletim-sisteminde-oracle-veritabani-kurulumu","tag-opensuse-uzerine-oracle-veritabani-kurulumu","tag-suse-enterprise-linux-isletim-sisteminde-oracle-veritabani-kurulumu","tag-suse-enterprise-linux-oracle-kurulumu","tag-suse-linux-oracle-11g-kurulumu","tag-suse-linux-oracle-11gr2-kurulumu","tag-suse-linux-oracle-kurulumu","tag-suse-linux-uzerine-oracle-kurulumu"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1971","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=1971"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1971\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1971"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1971"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1971"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}