{"id":1094,"date":"2013-03-22T04:15:33","date_gmt":"2013-03-22T02:15:33","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=1094"},"modified":"2013-09-02T19:01:27","modified_gmt":"2013-09-02T16:01:27","slug":"centos-linux-isletim-sisteminde-standalone-single-instance-oracle-veritabani-kurulumu","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=1094","title":{"rendered":"CentOS Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu"},"content":{"rendered":"

\"OracleDbEnt\"<\/a>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 CentOS Linux 6.4 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 “Oracle Tahiti”<\/a>\u00a0sitesinden 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 Oracle Database CentOS Linux i\u015fletim sistemlerinde sertifikaland\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. Ancak kurulumu veya \u00e7al\u0131\u015fmas\u0131nda herhangi bir sorun yoktur. CentOS Linux da\u011f\u0131t\u0131mlar\u0131 aras\u0131nda yap\u0131 olarak \u201dRed Hat Enterprise Linux\u201d ve \u201cOracle Enterprise Linux\u201d i\u015fletim sistemlerine en yak\u0131n Linux \u0130\u015fletim Sistemidir. Linux da\u011f\u0131t\u0131mlar\u0131nda Lisans bedeli olan \u201cRed Hat\u201d ve \u201cOracle\u201d Linux yerine \u00fccretsiz Linux da\u011f\u0131t\u0131m\u0131 kurulacaksa \u201cCentOS\u201d akla gelebilecek ilk i\u015fletim sistemidir.<\/span><\/p>\n

1. \u0130\u015fletim sistemimizi \u201cCentOS Linux 6.x 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

# vim \/etc\/hosts<\/span>\r\n\r\n<IP-address>  <fully-qualified-machine-name>  <machine-name><\/span>\r\n\r\n-- \u00d6rnek;<\/span>\r\n\r\n192.168.2.120   koraykey-ct.localdomain koraykey-ct<\/span><\/pre>\n
3. Bununla beraber kurulumda e\u011fer NTP servisi kullanacaksak onuda ayarlamam\u0131zda fayda olacakt\u0131r. Kurulum a\u015famas\u0131nda onunla ilgili ayarlar yap\u0131lmad\u0131\u011f\u0131nda hata verebiliyor<\/span>.<\/p>\n
# vim \/etc\/sysconfig\/ntpd<\/span>\r\n\r\n-- Dosyas\u0131nda bulunan parametre a\u015fa\u011f\u0131daki gibi d\u00fczenlenmelidir.<\/span>\r\n\r\nOPTIONS=\"-x -u ntp:ntp -p \/var\/run\/ntpd.pid\"<\/span>\r\n\r\n-- Ard\u0131ndan da servis yeniden ba\u015flat\u0131lmal\u0131d\u0131r. <\/span>\r\nBu ayar cluster ortamlar\u0131nda zaman senkronizasyonu bozuldu\u011funda<\/span>\r\nzaman\u0131 geri ya da ileri almak yerine bekletecektir.<\/span>\r\nBu \u015fekilde senkronizasyonun bozulmas\u0131n\u0131 engelleyecektir.<\/span>\r\n\r\n# service ntpd restart<\/span><\/pre>\n
4. Kernel Parametre dosyas\u0131nda gerekli d\u00fczenlemeyi yap\u0131yoruz. A\u015fa\u011f\u0131daki sat\u0131rlar\u0131 direk kopyalayacaksak ayn\u0131 olan parametrelerden mevcut olanlar\u0131n \u00f6n\u00fcne # i\u015fareti koymal\u0131y\u0131z. Aksi takdirde ayn\u0131 parametrenin iki farkl\u0131 de\u011feri olur ve sorun \u00e7\u0131kar.<\/span><\/p>\n
# vim \/etc\/sysctl.conf<\/span>\r\n\r\n# Oracle Database Parameters<\/span>\r\nfs.suid_dumpable = 1<\/span>\r\nfs.aio-max-nr = 1048576<\/span>\r\nfs.file-max = 6815744<\/span>\r\nkernel.shmall = 2097152<\/span>\r\nkernel.shmmax = 2073131008\r\n<\/span>kernel.shmmni = 4096<\/span>\r\n# semaphores: semmsl, semmns, semopm, semmni<\/span>\r\nkernel.sem = 250 32000 100 128<\/span>\r\nnet.ipv4.ip_local_port_range = 9000 65500<\/span>\r\nnet.core.rmem_default=4194304<\/span>\r\nnet.core.rmem_max=4194304<\/span>\r\nnet.core.wmem_default=262144<\/span>\r\nnet.core.wmem_max=1048586<\/span>\r\n\r\n-- Bu parametreleri girdikten sonra de\u011fi\u015fikliklerin uygulanabilmesi i\u00e7in<\/span>\r\n\r\n# \/sbin\/sysctl -p<\/span>\r\n\r\nkomutunu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/pre>\n
5. Limitlerin belirlendi\u011fi dosyada gerekli d\u00fczenlemeyi yap\u0131yoruz.<\/span><\/p>\n
# vim \/etc\/security\/limits.conf<\/span>\r\n\r\n-- Dosyas\u0131na a\u015fa\u011f\u0131daki parametreleri giriyoruz.<\/span>\r\n\r\n# Oracle Database Limit Parameters<\/span>\r\noracle              soft    nproc   2047<\/span>\r\noracle              hard    nproc   16384<\/span>\r\noracle              soft    nofile  4096<\/span>\r\noracle              hard    nofile  65536<\/span>\r\noracle              soft    stack   10240<\/span><\/pre>\n
6. Veritaban\u0131 kurulumu i\u00e7in gereken paket gruplar\u0131 ve paketleri kuruyoruz. Sistemimizde mevcut olan paketler varsa kurma iste\u011fimizde “Nothing to do” uyar\u0131s\u0131 alaca\u011f\u0131z. Bu uyar\u0131y\u0131 al\u0131yorsak paket zaten sistemimizde kurulu demektedir.<\/span> Bir \u00e7ok paketin mevcut oldu\u011funu s\u00f6yleyecek ve olmayan bir ka\u00e7 paketi sisteme kuracakt\u0131r.<\/span><\/p>\n
-- Sunucumuz \u0130nternete \u00e7\u0131k\u0131yorsa paketleri direk \"yum install\" <\/span>komutu ile\r\nkurabiliriz.<\/span>\r\n\r\nyum -y install binutils-2*x86_64*<\/span>\r\nyum -y install glibc-2*x86_64* nss-softokn-freebl-3*x86_64*<\/span>\r\nyum -y install glibc-2*i686* nss-softokn-freebl-3*i686*<\/span>\r\nyum -y install compat-libstdc++-33*x86_64*<\/span>\r\nyum -y install glibc-common-2*x86_64*<\/span>\r\nyum -y install glibc-devel-2*x86_64*<\/span>\r\nyum -y install glibc-devel-2*i686*<\/span>\r\nyum -y install glibc-headers-2*x86_64*<\/span>\r\nyum -y install elfutils-libelf-0*x86_64*<\/span>\r\nyum -y install elfutils-libelf-devel-0*x86_64*<\/span>\r\nyum -y install gcc-4*x86_64*<\/span>\r\nyum -y install gcc-c++-4*x86_64*<\/span>\r\nyum -y install ksh-*x86_64*<\/span>\r\nyum -y install libaio-0*x86_64*<\/span>\r\nyum -y install libaio-devel-0*x86_64*<\/span>\r\nyum -y install libaio-0*i686*<\/span>\r\nyum -y install libaio-devel-0*i686*<\/span>\r\nyum -y install libgcc-4*x86_64*<\/span>\r\nyum -y install libgcc-4*i686*<\/span>\r\nyum -y install libstdc++-4*x86_64*<\/span>\r\nyum -y install libstdc++-4*i686*<\/span>\r\nyum -y install libstdc++-devel-4*x86_64*<\/span>\r\nyum -y install make-3.81*x86_64*<\/span>\r\nyum -y install numactl-devel-2*x86_64*<\/span>\r\nyum -y install sysstat-9*x86_64*<\/span>\r\nyum -y install compat-libstdc++-33*i686*<\/span>\r\nyum -y install compat-libcap*\r\n\r\n<\/span>-- Sunucumuz internete \u00e7\u0131km\u0131yorsa paketlerin kurulmas\u0131 i\u00e7in <\/span>sunucumuzdaki\r\nKurulum DVD'sini takarak paketleri kuruyoruz.<\/span>\r\n\r\n# CentOS Linux DVD<\/span>\r\n\r\n# cd dvd_paketlerinin_yolu\r\n<\/span>\r\nrpm -Uvh binutils-2*x86_64*<\/span>\r\nrpm -Uvh glibc-2*x86_64* nss-softokn-freebl-3*x86_64*<\/span>\r\nrpm -Uvh glibc-2*i686* nss-softokn-freebl-3*i686*<\/span>\r\nrpm -Uvh compat-libstdc++-33*x86_64*<\/span>\r\nrpm -Uvh glibc-common-2*x86_64*<\/span>\r\nrpm -Uvh glibc-devel-2*x86_64*<\/span>\r\nrpm -Uvh glibc-devel-2*i686*<\/span>\r\nrpm -Uvh glibc-headers-2*x86_64*<\/span>\r\nrpm -Uvh elfutils-libelf-0*x86_64*<\/span>\r\nrpm -Uvh elfutils-libelf-devel-0*x86_64*<\/span>\r\nrpm -Uvh gcc-4*x86_64*<\/span>\r\nrpm -Uvh gcc-c++-4*x86_64*<\/span>\r\nrpm -Uvh ksh-*x86_64*<\/span>\r\nrpm -Uvh libaio-0*x86_64*<\/span>\r\nrpm -Uvh libaio-devel-0*x86_64*<\/span>\r\nrpm -Uvh libaio-0*i686*<\/span>\r\nrpm -Uvh libaio-devel-0*i686*<\/span>\r\nrpm -Uvh libgcc-4*x86_64*<\/span>\r\nrpm -Uvh libgcc-4*i686*<\/span>\r\nrpm -Uvh libstdc++-4*x86_64*<\/span>\r\nrpm -Uvh libstdc++-4*i686*<\/span>\r\nrpm -Uvh libstdc++-devel-4*x86_64*<\/span>\r\nrpm -Uvh make-3.81*x86_64*<\/span>\r\nrpm -Uvh numactl-devel-2*x86_64*<\/span>\r\nrpm -Uvh sysstat-9*x86_64*<\/span>\r\nrpm -Uvh compat-libstdc++-33*i686*<\/span>\r\nrpm -Uvh compat-libcap*<\/span><\/pre>\n
7. Oracle i\u00e7in kullan\u0131c\u0131lar\u0131 ve kullan\u0131c\u0131 gruplar\u0131n\u0131 yarat\u0131yoruz.<\/span><\/p>\n
# groupadd -g 501 oinstall<\/span>\r\n# groupadd -g 502 dba<\/span>\r\n# groupadd -g 503 oper<\/span>\r\n\r\n# useradd -u 502 -g oinstall -G dba,oper oracle<\/span>\r\n# passwd oracle<\/span>\r\n\r\nChanging password for user oracle.<\/span>\r\nNew password: <\/span>\r\nRetype new password: <\/span>\r\npasswd: all authentication tokens updated successfully.<\/span><\/pre>\n
8. E\u011fer kurulum bitiminde \u201cSecure Linux\u201d ve \u201cFirewall\u201d \u00f6zelli\u011fini kapatmam\u0131\u015fsak bunlar\u0131 kapat\u0131yoruz.<\/span><\/p>\n
# vim \/etc\/selinux\/config<\/span>\r\n\r\n-- dosyas\u0131nda bulunan<\/span>\r\n\r\nSELINUX=disabled<\/span>\r\n\r\n-- Parametresini yukar\u0131daki gibi kapal\u0131 duruma getiriyoruz.<\/span>\r\n\r\n-- Firewall Servisini kapatmak i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span>\r\n\r\n# service iptables stop<\/span>\r\n# chkconfig iptables off<\/span><\/pre>\n
9. 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\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
10. Oracle kurulumlar\u0131n\u0131 yapabilmek, kurulum ve patch\u00a0dosyalar\u0131m\u0131z\u0131\u00a0koyabilmek 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\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
11. Oracle Veritaban\u0131 i\u00e7in de\u011fi\u015fkenlerimizi \u201c.bash_profile\u201d dosyam\u0131za yaz\u0131yoruz.<\/span><\/p>\n
-- Oracle kullan\u0131c\u0131s\u0131na ge\u00e7i\u015f yap\u0131yoruz.<\/span>\r\n# su - oracle<\/span>\r\n\r\n$ vim \/home\/oracle\/.bash_profile<\/span>\r\n\r\n-- Dosyas\u0131na a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri giriyoruz.<\/span>\r\n\r\n# Oracle bash_profile Environment Settings<\/span>\r\n\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\n\r\nORACLE_HOSTNAME=koraykey-ct.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nDB_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export DB_HOME<\/span>\r\nORACLE_HOME=$DB_HOME; export ORACLE_HOME<\/span>\r\nORACLE_SID=orcl; export ORACLE_SID\r\nORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER\r\n<\/span>ORACLE_TERM=xterm; export ORACLE_TERM<\/span>\r\nBASE_PATH=\/usr\/sbin:$PATH; export BASE_PATH<\/span>\r\nPATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span>\r\nLD_LIBRARY_PATH=$ORACLE_HOME\/lib:\/lib:\/usr\/lib; export LD_LIBRARY_PATH<\/span>\r\nCLASSPATH=$ORACLE_HOME\/JRE:$ORACLE_HOME\/jlib:$ORACLE_HOME\/rdbms\/jlib; export CLASSPATH<\/span>\r\n\r\nif [ $USER = \"oracle\" ]; then<\/span>\r\n  if [ $SHELL = \"\/bin\/ksh\" ]; then<\/span>\r\n    ulimit -p 16384<\/span>\r\n    ulimit -n 65536<\/span>\r\n  else<\/span>\r\n    ulimit -u 16384 -n 65536<\/span>\r\n  fi<\/span>\r\nfi<\/span><\/pre>\n
12. 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
13. 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>p10404530_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\r\n$ cd \/u01\/orainstall\/<\/span>\r\n$ chmod 775 *<\/span><\/pre>\n
14. 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
$ unzip p10404530_112030_Linux-x86-64_1of7.zip<\/span>\r\n$ unzip p10404530_112030_Linux-x86-64_2of7.zip<\/span><\/pre>\n
15. 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
$ rm p10404530_112030_Linux-x86-64_1of7.zip<\/span>\r\n$ 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$ ls<\/span>\r\ndatabase<\/span><\/pre>\n
16. Kurulum sunucu \u00fczerinde de\u011filde uzaktan kendi bilgisayarm\u0131zda yap\u0131lacaksa ekran\u0131 export edebiliriz. Bunun i\u00e7in \u201cXmanager\u201d<\/a> vb. em\u00fclat\u00f6r yaz\u0131l\u0131mlar\u0131 kullan\u0131labilir. Bu yaz\u0131l\u0131m\u0131 bilgisayar\u0131m\u0131za kurdu\u011fumuzda \u201cXmanager \u2013 Passive\u201d program\u0131n\u0131 \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z. G\u00f6rev \u00e7ubu\u011funda yaz\u0131l\u0131m \u00e7al\u0131\u015facak ve export etti\u011fimiz ekran\u0131 kendi bilgisayar\u0131m\u0131zdan y\u00f6netebilece\u011fiz. Bununla beraber \u201cVNC Server\u201d arac\u0131l\u0131\u011f\u0131 ile de sunucuya ba\u011flanabilir ve kurulumu direk sunucu \u00fczerinden yapabiliriz. Bunun i\u00e7in \u201cLinux \u0130\u015fletim Sistemlerinde VNC Server Yap\u0131land\u0131rmas\u0131\u201d<\/a> makalemizden yararlanabilirsiniz. \u00d6nerilen 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\n-- Test 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
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\n$ cd \/u01\/orainstall\/database<\/span>\r\n\r\n-- Kurulum dizininde bulunan<\/span>\r\n\r\n$ .\/runInstaller<\/span>\r\n\r\n-- Uygulamas\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_ct_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_ct_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_ct_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_ct_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_ct_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_ct_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_ct_7\"<\/a><\/p>\n
\"DB_Install_ct_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_ct_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_ct_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_ct_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_ct_12\"<\/a><\/p>\n
29. Kurulum \u00f6n gereksinimlerini denetlendikten sonra \u201cPackage: pdksh-5.2.1.4\u2033 paketinin olmad\u0131\u011f\u0131 konusunda bizi uyar\u0131yor.<\/span><\/p>\n
\"DB_Install_ct_13\"<\/a><\/p>\n
30. Bu uyar\u0131y\u0131 ge\u00e7ebiliriz. \u00c7\u00fcnk\u00fc sistemimizde bu paketin daha yeni s\u00fcr\u00fcm\u00fc olan \u201cksh\u201d paketi y\u00fckl\u00fcd\u00fcr. Zaten paketi bulup y\u00fcklemeye \u00e7al\u0131\u015f\u0131nca i\u015fletim istemimizde daha yeni s\u00fcr\u00fcm\u00fc olan \u201cksh\u201d paketiyle \u00e7ak\u0131\u015ft\u0131\u011f\u0131 konusunda bizi uyar\u0131yor.<\/span><\/p>\n
# rpm -i pdksh-5.2.14-30.x86_64.rpm <\/span>\r\nwarning: pdksh-5.2.14-30.x86_64.rpm: Header V3 DSA\/SHA1 Signature,<\/span>\r\nerror: Failed dependencies:<\/span>\r\n        pdksh conflicts with (installed) ksh-20120801-6.fc18.x86_64<\/span><\/pre>\n
31. Bu a\u015famada sa\u011f \u00fcst k\u00f6\u015fede bulunan \u201cIgnore All\u201d se\u00e7ene\u011fini i\u015faretliyerek \u201cNext\u201d d\u00fc\u011fmesini t\u0131kl\u0131yoruz. Bizi bu eksikli\u011fi yoksayd\u0131\u011f\u0131m\u0131z konusunda uyaran ekranda \u201cYes\u201d d\u00fc\u011fmesini t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"DB_Install_ct_14\"<\/a><\/p>\n
32. Kurulum \u00f6zet ekran\u0131 \u00e7\u0131kt\u0131ktan sonra \u201cInstall\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"DB_Install_ct_15\"<\/a><\/p>\n
33. 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_ct_16\"<\/a><\/p>\n
34. 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’leri \u00e7al\u0131\u015ft\u0131rd\u0131ktan sonra \u201cOK\u201d d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz<\/strong>.<\/span><\/p>\n
\"DB_Install_ct_17\"<\/a><\/p>\n
# cd \/u01\/app\/oraInventory\/<\/span>\r\n# .\/orainstRoot.sh<\/span>\r\n\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\n\r\n# cd \/u01\/app\/oracle\/product\/11.2.0.3\/db\/<\/span>\r\n# .\/root.sh<\/span>\r\n\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
35.\u00a0Kurulumumuz ba\u015far\u0131l\u0131 bir \u015fekilde tamamland\u0131 \u201cClose\u201d d\u00fc\u011fmesine t\u0131klayarak kurulumu sonland\u0131r\u0131yoruz.<\/span><\/p>\n
\"DB_Install_ct_18\"<\/a><\/p>\n
36. 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.<\/span>\r\n\r\n$ cd 14727310\/<\/span>\r\n\r\n-- Patch 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\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><\/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\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
37. 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><\/pre>\n
38. 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_ct_19\"<\/a><\/p>\n
39. 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_ct_20\"<\/a><\/p>\n
40. 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_ct_21\"<\/a><\/p>\n
41. 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_ct_22\"<\/a><\/p>\n
42. 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_ct_23\"<\/a><\/p>\n
43. 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_ct_24\"<\/a><\/p>\n
44. 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_ct_25\"<\/a><\/p>\n
45. Yeniden d\u00f6nd\u00fc\u011f\u00fcm\u00fcz \u201cHo\u015f geldin\u201d ekran\u0131nda \u201cFinish\u201d d\u00fc\u011fmesini t\u0131klayarak yap\u0131land\u0131rmam\u0131z\u0131 tamaml\u0131yoruz.<\/span><\/p>\n
\"DB_Install_ct_26\"<\/a><\/p>\n
46. 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
47. Ho\u015fgeldiniz ekran\u0131n\u0131 \u201cNext\u201d d\u00fc\u011fmesine t\u0131klayarak ge\u00e7iyoruz.<\/span><\/p>\n
\"DB_Install_ct_27\"<\/a><\/p>\n
48. 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_ct_28\"<\/a><\/p>\n
49. 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_ct_29\"<\/a><\/p>\n
50. 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_ct_30\"<\/a><\/p>\n
51. 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_ct_31\"<\/a><\/p>\n
52. 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_ct_32\"<\/a><\/p>\n
53. 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_ct_33\"<\/a><\/p>\n
54. 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_ct_34\"<\/a><\/p>\n
55. 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_ct_35\"<\/a><\/p>\n
56. 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_ct_36\"<\/a><\/p>\n
57. 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_ct_37\"<\/a><\/p>\n
58. 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_ct_38\"<\/a><\/p>\n
59. 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_ct_39\"<\/a><\/p>\n
60. 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_ct_40\"<\/a><\/p>\n
61. 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_ct_41\"<\/a><\/p>\n
62. 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_ct_42\"<\/a><\/p>\n
63. 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_ct_43\"<\/a><\/p>\n
64. 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_ct_44\"<\/a><\/p>\n
65. 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_ct_45\"<\/a><\/p>\n
66. \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_ct_46\"<\/a><\/p>\n
67. 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_ct_47\"<\/a><\/p>\n
\"DB_Install_ct_48\"<\/a><\/p>\n
\u00a068. 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_ct_49\"<\/a><\/p>\n
69. 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_ct_50\"<\/a><\/p>\n
70. 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_ct_51\"<\/a><\/span><\/p>\n
71.\u00a0Veritaban\u0131<\/span><\/span> 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><\/span><\/p>\n
# vim \/etc\/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
72. 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_ct_52\"<\/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
73. 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. Otomatik veritaban\u0131 ve Enterprise Manager ba\u015flatma ve kapatma i\u015flemleri i\u00e7in \u201cLinux \u0130\u015fletim Sistemlerinde Otomatik Veritaban\u0131 Ba\u015flatma ve Durdurma\u201d<\/a> makalemizi inceleyebilirsiniz.<\/span><\/p>\n
$ 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-ct.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-ct.localdomain_orcl\/sysman\/log<\/span>\r\n\r\n-- G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi http:\/\/koraykey-ct.localdomain:1158\/em\/<\/span>\r\nadresinden Enterprise Manager konsolumuza eri\u015febiliriz.<\/span>\r\n\r\n$ sqlplus \/ as sysdba<\/span>\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Fri Mar 22 04:05:01 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_ct_53\"<\/a><\/p>\n
Bu makalemizde CentOS 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.<\/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 CentOS Linux 6.4 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 … 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":[93,94,95,96,21,290,20,19],"class_list":["post-1094","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-centos-6-oracle","tag-centos-linux-isletim-sisteminde-oracle-kurulumu","tag-centos-oracle","tag-centos-uzerine-oracle-kurulumu","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1094","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=1094"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/1094\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1094"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1094"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1094"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}