{"id":2466,"date":"2013-04-08T18:34:17","date_gmt":"2013-04-08T15:34:17","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=2466"},"modified":"2013-06-26T11:42:13","modified_gmt":"2013-06-26T08:42:13","slug":"oracle-sun-solaris-11-text-isletim-sisteminde-komut-satirindan-standalone-single-instance-oracle-veritabani-kurulumu","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=2466","title":{"rendered":"Oracle (Sun) Solaris 11 (Text) \u0130\u015fletim Sisteminde Komut Sat\u0131r\u0131ndan Standalone (Single Instance) Oracle 11g R2 Veritaban\u0131 Kurulumu"},"content":{"rendered":"

\"OracleDbEnt\"<\/a>Bu makelemizde Oracle (Sun) Solaris 11 (Text Install) Grafik Aray\u00fcz (GUI) olmayan i\u015fletim sistemi \u00fczerine Oracle 11g R2 veritaban\u0131n\u0131 komut sat\u0131r\u0131ndan (Silent Install) olarak yapmay\u0131 inceleyece\u011fiz.<\/span><\/p>\n

1. \u00d6ncelikle i\u015fletim sistemimizi “Oracle (Sun) Solaris 11 \u0130\u015fletim Sistemi Kurulumu (Text Install)”<\/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

# vi \/etc\/hosts<\/span>\r\n\r\n<IP-address>  <fully-qualified-machine-name>  <machine-name><\/span>\r\n\r\n\u00d6rnek;\r\n<\/span>\r\n192.168.2.130   koraykey-sl.localdomain koraykey-sl<\/span><\/pre>\n
3. Sunucumuzda kernel parametrelerini ayarlamak i\u00e7in \u201c\/etc\/system\u201d dosyas\u0131n\u0131n sonuna a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span><\/p>\n
# vi \/etc\/system<\/span>\r\n-- <\/span>Dosyas\u0131n\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span>\r\n\r\nset shmsys:shminfo_shmmax=4294967295<\/span>\r\nset shmsys:shminfo_shmmni=100<\/span>\r\nset shmsys:shminfo_shmseg=10<\/span>\r\nset semsys:seminfo_semmni=100<\/span>\r\nset semsys:seminfo_semmns=1024<\/span>\r\nset shmsys:shminfo_shmmin=1<\/span>\r\nset max_nprocs=30000<\/span>\r\nset maxuprc=16384<\/span><\/pre>\n
4. Sunucumuzda a\u015fa\u011f\u0131daki projadd sistemine oracle\u2019\u0131 ekliyoruz.<\/span><\/p>\n
# projadd -U oracle user.oracle<\/span>\r\n# projmod -s -K \"project.max-sem-ids=(priv,100,deny)\" user.oracle<\/span>\r\n# projmod -s -K \"process.max-sem-nsems=(priv,256,deny)\" user.oracle<\/span>\r\n# projmod -s -K \"project.max-shm-memory=(priv,4294967295,deny)\" user.oracle<\/span>\r\n# projmod -s -K \"project.max-shm-ids=(priv,100,deny)\" user.oracle<\/span>\r\n# projmod -s -K \"process.max-file-descriptor=(priv,65536,deny)\" user.oracle<\/span><\/pre>\n
5. Sunucumuzda port aral\u0131\u011f\u0131n\u0131 belirlemek i\u00e7in \u201c\/etc\/inittab\u201d dosyas\u0131na a\u015fa\u011f\u0131daki yap\u0131land\u0131rma de\u011ferlerini ekliyoruz.<\/span><\/p>\n
# vi \/etc\/inittab<\/span>\r\n--Dosyas\u0131n\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri ekliyoruz.<\/span>\r\n\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_smallest_anon_port 9000 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/tcp tcp_largest_anon_port 65500 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_smallest_anon_port 9000 > \/dev\/console<\/span>\r\ntm::sysinit:\/usr\/sbin\/ndd -set \/dev\/udp udp_largest_anon_port 65500 > \/dev\/console<\/span><\/pre>\n
6. Sunucumuzda bulunan “\/etc\/ssh\/sshd_config” dosyas\u0131nda “LoginGraceTime” de\u011ferini d\u00fczenliyoruz.<\/span><\/p>\n
# vi \/etc\/ssh\/sshd_config<\/span>\r\n-- Dosyas\u0131n\u0131 a\u00e7\u0131yoruz \"LoginGraceTime\" de\u011fi\u015fkenine <\/span>\"0\" de\u011ferini at\u0131yoruz.<\/span>\r\n\r\nLoginGraceTime 0\r\n\r\n-- De\u011feri de\u011fi\u015ftirdikten sonra ge\u00e7erli olabilmesi i\u00e7in servisimizi\r\nyeniden ba\u015flat\u0131yoruz.\r\n\r\n# svcadm restart ssh<\/span><\/pre>\n
7.\u00a0 Sunucumuzda kullan\u0131c\u0131lar\u0131 ve gruplar\u0131 yarat\u0131yoruz.<\/span><\/p>\n
# groupadd dba<\/span>\r\n# groupadd oinstall<\/span>\r\n# useradd -g oinstall -G dba -m -d \/export\/home\/oracle -s \/bin\/bash oracle<\/span>\r\n# passwd oracle<\/span><\/pre>\n
8. Sunucumuzda a\u015fa\u011f\u0131daki paketlerin durumunu sorguluyoruz ve olmayanlar\u0131 sistemimize kuruyoruz.<\/span><\/p>\n
# pkginfo -i SUNWarc SUNWbtool SUNWhea SUNWlibm SUNWlibms SUNWpool SUNWpoolr<\/span>\r\nSUNWsprot SUNWtoo SUNWuiu8 SUNWfont-xorg-core SUNWfont-xorg-iso8859-1 SUNWmfrun<\/span>\r\nSUNWxorg-client-programs SUNWxorg-clientlibs SUNWxwfsw SUNWxwplt<\/span>\r\n\r\n-- Komutunu \u00e7al\u0131\u015ft\u0131rd\u0131\u011f\u0131m\u0131zda olmayan paketlerimizde a\u015fa\u011f\u0131daki gibi bir \u00e7\u0131kt\u0131\r\nal\u0131yoruz. <\/span>(Komutu sistemimizde yan yana olacak \u015fekilde \u00e7al\u0131\u015ft\u0131rmal\u0131y\u0131z.)<\/span>\r\n\r\nERROR: information for \"SUNWxwplt\" was not found<\/span>\r\nERROR: information for \"SUNWmfrun\" was not found<\/span>\r\nERROR: information for \"SUNWarct\" was not found<\/span>\r\nERROR: information for \"SUNWhea\" was not found<\/span>\r\nERROR: information for \"SUNWlibm\" was not found<\/span>\r\n\r\n-- Sunucumuz internete \u00e7\u0131k\u0131yorusa Solaris deposunu ekleyerek oracle i\u00e7in gerekli<\/span>\r\npaketleri y\u00fckl\u00fcyoruz. E\u011fer internete \u00e7\u0131km\u0131yorsa paketlerin oldu\u011fu dvd s\u00fcr\u00fcc\u00fcs\u00fcnden <\/span>\r\nkurmam\u0131z gerekir.<\/span>\r\n\r\n# pkg set-publisher -Pe -O http:\/\/pkg.oracle.com\/solaris\/release solaris<\/span>\r\n\r\n-- Depoyu ekledikten sonra  Oracle i\u00e7in gerekli olan paketleri kontrol ediyoruz.<\/span>\r\n\r\n# pkg install compatibility\/packages\/SUNWxwplt SUNWmfrun SUNWarc SUNWhea SUNWlibm<\/span>\r\n\r\n-- DVD S\u00fcr\u00fcc\u00fcs\u00fcnden kuracaksak<\/span>\r\n\r\n# pkgadd -d \/cdrom\/paketlerinyolu SUNWxwplt SUNWmfrun SUNWarc SUNWhea SUNWlibm<\/span>\r\n\r\n-- Kurarken bizden onay isteyecek \"y\" tu\u015funa basarak ge\u00e7iyoruz.<\/span>\r\n\r\nDo you want to continue with the installation of <packagename> [y,n,?] y<\/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# mkdir -p \/export\/home\/oracle\/u01<\/span>\r\n# ln -s \/export\/home\/oracle\/u01 \/u01<\/span>\r\n# chown -R oracle:oinstall \/u01<\/span>\r\n# chmod -R 775 \/u01\/<\/span>\r\n# chown -R oracle:oinstall \/export\/home\/oracle\/<\/span>\r\n\r\n-- Oracle 11.2.0.2.0 versiyonundan sonra ayr\u0131 bir dizine kurulum<\/span>\r\nyap\u0131larak upgrade etme imkan\u0131 getirdi. Yani mevcut oracle dizinleri<\/span>\r\nharicinde bir dizine kurulum yap\u0131larak mevcut dizinleri bozmadan<\/span>\r\ny\u00fckseltme imkan\u0131m\u0131z oluyor bu y\u00fczden dizinler olu\u015fturulurken<\/span>\r\n\"\/u01\/app\/oracle\/product\/11.2.0.3\/db\" gibi versiyon isimlerinide koydum<\/span>\r\nyeni bir versiyon \u00e7\u0131kt\u0131\u011f\u0131nda y\u00fckseltme i\u015flemi yap\u0131l\u0131rken<\/span>\r\n\"\/u01\/app\/oracle\/product\/11.2.0.4\/db\" gibi dizin yaratarak mevcut<\/span>\r\ndizinlere dokunmadan upgrade i\u015flemini yapabiliriz.<\/span><\/pre>\n
10. Oracle Veritaban\u0131 i\u00e7in de\u011fi\u015fkenlerimizi .bash_profile dosyalar\u0131m\u0131za yaz\u0131yoruz.<\/span><\/p>\n
# vi \/home\/oracle\/.bash_profile<\/span>\r\n-- Dosyas\u0131n\u0131 a\u00e7\u0131p a\u015fa\u011f\u0131daki de\u011fi\u015fkenlerimizi giriyoruz.<\/span>\r\n\r\n# Oracle Settings<\/span>\r\nTMP=\/tmp; export TMP<\/span>\r\nTMPDIR=$TMP; export TMPDIR<\/span>\r\nORACLE_HOSTNAME=koraykey-sl.localdomain; export ORACLE_HOSTNAME<\/span>\r\nORACLE_UNQNAME=orcl; export ORACLE_UNQNAME<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle; export ORACLE_BASE<\/span>\r\nORACLE_HOME=$ORACLE_BASE\/product\/11.2.0.3\/db; export ORACLE_HOME<\/span>\r\nORACLE_SID=orcl; export ORACLE_SID<\/span>\r\nORACLE_HOME_LISTNER=$ORACLE_HOME export ORACLE_HOME_LISTNER<\/span>\r\nPATH=$ORACLE_HOME\/bin:$PATH:$ORACLE_HOME\/OPatch:$BASE_PATH; export PATH<\/span><\/pre>\n
11. Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile oracle kullan\u0131c\u0131s\u0131 ile ba\u011fl\u0131yken kurulum dosyalar\u0131m\u0131z\u0131 olu\u015fturdu\u011fumuz \u201c\/u01\/orainstall\/\u201d dizini alt\u0131na at\u0131yoruz. Oracle kullan\u0131c\u0131s\u0131 ile kopyalama i\u015flemimiz bitti\u011finde kurulum dosyalar\u0131m\u0131z\u0131 kontrol ediyoruz ve gerekli haklar\u0131 veriyoruz.<\/span><\/p>\n
Oracle kullan\u0131c\u0131s\u0131yla sisteme ba\u011fl\u0131yken<\/span>\r\n\r\n$ cd \/u01\/orainstall\/<\/span>\r\n$ ls<\/span>\r\np10404530_112030_Solaris86-64_1of6.zip<\/span>\r\np10404530_112030_Solaris86-64_2of6.zip<\/span>\r\n\r\n-- Dosyalar \u00fczerinde gerekli haklar\u0131 veriyoruz.<\/span>\r\n\r\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
$ unzip p10404530_112030_Solaris86-64_1of6.zip<\/span>\r\n$ unzip p10404530_112030_Solaris86-64_2of6.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
$ rm p10404530_112030_Solaris86-64_1of6.zip<\/span>\r\n$ rm p10404530_112030_Solaris86-64_2of6.zip<\/span>\r\n\r\n-- A\u015fa\u011f\u0131daki komut ile \"database\" kurulum dizinimizi <\/span>g\u00f6rebiliriz.<\/span>\r\n$ ls<\/span>\r\ndatabase<\/span><\/pre>\n
14. Kurulum i\u015flemine ba\u015flamadan \u00f6nce sunucumuzu yeniden ba\u015flatarak de\u011fi\u015fikliklerin ge\u00e7erli oldu\u011fundan emin olmak faydal\u0131 olacakt\u0131r. Bunun i\u00e7in a\u015fa\u011f\u0131daki komutu \u00e7al\u0131\u015ft\u0131rmam\u0131z yeterli olacakt\u0131r.<\/span><\/p>\n
$ init 6<\/span><\/pre>\n
15. Bu i\u015flemlerin tamam\u0131 bitti\u011finde kuruluma ge\u00e7ebiliriz. \u00d6ncelikle Silent Kurulum s\u0131ras\u0131nda kullanaca\u011f\u0131m\u0131z response (otomatik yan\u0131t) dosyas\u0131n\u0131 “\/u01\/orainstall\/database\/response\/db_install.rsp”\u00a0 dizininden d\u00fczenlemek i\u00e7in “\/u01\/orainstall\/” dizinine kopyal\u0131yoruz.<\/span><\/p>\n
$ cp \/u01\/orainstall\/database\/response\/db_install.rsp \/u01\/orainstall\/<\/span><\/pre>\n
16. Otomatik kurulum dosyam\u0131z\u0131 kendi sistemimize g\u00f6re d\u00fczenliyoruz.<\/span><\/p>\n
$ vi \/u01\/orainstall\/db_install.rsp<\/span>\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri<\/span>\r\nkendi sistemimize g\u00f6re d\u00fczenliyoruz.<\/span>\r\n\r\n-- Veritaban\u0131m\u0131z\u0131 patch ge\u00e7tikten sonra olu\u015fturmak i\u00e7in<\/span>\r\n\u201cSoftware Only\" kuraca\u011f\u0131m\u0131z\u0131 belirtiyoruz.<\/span>\r\n\r\noracle.install.option=INSTALL_DB_SWONLY<\/span>\r\n\r\n-- Veritaban\u0131 kuraca\u011f\u0131m\u0131z sunucu ismini giriyoruz.<\/span>\r\nORACLE_HOSTNAME=koraykey-sl.localdomain<\/span>\r\n\r\n-- Kurulumda kullan\u0131lacak \u0130\u015fletim Sistemi grubunu<\/span>\r\ngiriyoruz. (Inventory Sahibi)<\/span>\r\nUNIX_GROUP_NAME=oinstall<\/span>\r\n\r\n-- Oracle Inventory dizinini belirtiyoruz.<\/span>\r\nINVENTORY_LOCATION=\/u01\/app\/oracle\/oraInventory<\/span>\r\n\r\n-- Veritaban\u0131 dilimizi se\u00e7iyoruz.<\/span>\r\nSELECTED_LANGUAGES=en<\/span>\r\n\r\n-- Oracle Home dizinimizi belirtiyoruz.<\/span>\r\nORACLE_HOME=\/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\n\r\n-- Oracle ana dizinini belirtiyoruz.<\/span>\r\nORACLE_BASE=\/u01\/app\/oracle<\/span>\r\n\r\n--Lisans se\u00e7ene\u011fimize g\u00f6re Oracle Kurulum se\u00e7ene\u011fimizi belirtiyoruz.<\/span>\r\n--EE : Enterprise Edition<\/span>\r\n--SE : Standard Edition<\/span>\r\noracle.install.db.InstallEdition=EE<\/span>\r\n\r\n-- DBA yetkisi verilecek grup ismini belirtiyoruz.<\/span>\r\noracle.install.db.DBA_GROUP=dba<\/span>\r\n\r\n-- Oper yetkisi verilecek grup ismini belirtiyoruz.<\/span>\r\noracle.install.db.OPER_GROUP=dba<\/span>\r\n\r\n-- Oracle My Support (MOS) arac\u0131l\u0131\u011f\u0131 ile g\u00fcncellemelerin yap\u0131lmas\u0131 se\u00e7ene\u011fini<\/span>\r\ne\u011fer istemiyorsak \"true\" olarak belirtiyoruz.<\/span>\r\nDECLINE_SECURITY_UPDATES=true<\/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 haz\u0131rlam\u0131\u015f oldu\u011fumuz Response\r\n(Otomatik Yan\u0131t) dosyas\u0131 ile kurulumu ba\u015flat\u0131yoruz.<\/span>\r\n\r\n$ cd \/u01\/orainstall\/database<\/span>\r\n\r\n$ .\/runInstaller -silent -noconfig -responseFile \/u01\/orainstall\/db_install.rsp<\/span><\/pre>\n
18. Kurulumun sonuna grafik aray\u00fczl\u00fc kurulumda oldu\u011fu gibi bizden scriplerin \u201croot\u201d kullan\u0131c\u0131s\u0131 ile \u00e7al\u0131\u015ft\u0131r\u0131lmas\u0131n\u0131 isteyecektir. \u201croot\u201d kullan\u0131c\u0131s\u0131 ile a\u00e7\u0131lm\u0131\u015f bir terminal ekran\u0131nda a\u015fa\u011f\u0131daki gibi komutlar\u0131 \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
# 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\nCreating \/usr\/local\/bin directory...<\/span>\r\n   Copying dbhome to \/usr\/local\/bin ...<\/span>\r\n   Copying oraenv to \/usr\/local\/bin ...<\/span>\r\n   Copying coraenv to \/usr\/local\/bin ...<\/span>\r\n\r\nCreating \/var\/opt\/oracle\/oratab file...<\/span>\r\nEntries will be added to the \/var\/opt\/oracle\/oratab file as needed by<\/span>\r\nDatabase Configuration Assistant when a database is created<\/span>\r\nFinished running generic part of root script.<\/span>\r\nNow product-specific root actions will be performed.<\/span>\r\nFinished product-specific root actions.<\/span><\/pre>\n
19. 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\nOnun \u00f6ncesinde patch dosyas\u0131na gerekli haklar\u0131 veriyoruz.<\/span>\r\n\r\n# cd \/u01\/orainstall\/patch<\/span>\r\n# chmod 775 *<\/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_Solaris86-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-- 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\nOracle Interim Patch Installer version 11.2.0.3.3<\/span>\r\nCopyright (c) 2012, Oracle Corporation.  All rights reserved.<\/span>\r\n\r\nOracle Home       : \/u01\/app\/oracle\/product\/11.2.0.3\/db<\/span>\r\nCentral Inventory : \/u01\/app\/oraInventory<\/span>\r\n   from           : \/u01\/app\/oracle\/product\/11.2.0.3\/db\/oraInst.loc<\/span>\r\n\r\nOPatch version    : 11.2.0.3.3<\/span>\r\nOUI version       : 11.2.0.3.0<\/span>\r\nLog file location : \/u01\/app\/oracle\/product\/11.2.0.3\/db\/cfgtoollogs\/opatch\/opatch.log<\/span>\r\n\r\nVerifying environment and performing prerequisite checks...<\/span>\r\nOPatch continues with these patches: 13343438  13696216  13923374  14275605  14727310<\/span>\r\n\r\nDo you want to proceed? [y|n]<\/span>\r\n\r\nComposite patch 14727310 successfully applied.<\/span>\r\n\r\nOPatch succeeded.<\/span>\r\n\r\n-- Mesaj\u0131n\u0131 ald\u0131ktan sonra art\u0131k veritaban\u0131 yaratma i\u015flemine ge\u00e7ebiliriz.<\/span><\/pre>\n
20. 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\u00e7inde Silent Kurulum s\u0131ras\u0131nda kullanaca\u011f\u0131m\u0131z response (otomatik yan\u0131t) dosyas\u0131n\u0131 “\/u01\/orainstall\/database\/response\/netca.rsp”\u00a0 dizininden d\u00fczenlemek i\u00e7in “\/u01\/orainstall\/” dizinine kopyal\u0131yoruz.<\/span><\/p>\n
$ cp \/u01\/orainstall\/database\/response\/netca.rsp \/u01\/orainstall\/<\/span>\r\n\r\n-- Ben kurulum s\u0131ras\u0131nda varsay\u0131lan ayarlarla \"Listener\" olu\u015fturaca\u011f\u0131m\r\ni\u00e7in dosyada herhangi bir de\u011fi\u015fiklik yapmadan direk \"Listener\" olu\u015fturma\r\nad\u0131m\u0131na ge\u00e7iyorum.<\/span>\r\n\r\n-- E\u011fer \u00f6zel bir d\u00fczenleme yap\u0131lacaksa bir \u00f6nceki ad\u0131mda veritaban\u0131 i\u00e7in\r\nolu\u015fturdu\u011fumuz otomatik yan\u0131t dosyas\u0131ndaki gibi parametreleri d\u00fczenlememiz\r\ngerekmektedir.<\/span><\/pre>\n
21. Listener servisimizi olu\u015fturmak i\u00e7in otomatik yan\u0131t dosyam\u0131zla gerekli komutu \u00e7al\u0131\u015ft\u0131r\u0131yoruz.<\/span><\/p>\n
$ netca -silent -responsefile \/u01\/orainstall\/database\/response\/netca.rsp<\/span><\/pre>\n
22. Listener servisi olu\u015fturma i\u015flemimizi bitirdikten sonra veritaban\u0131 yaratma i\u015flemine ge\u00e7ebiliriz. Veritaban\u0131 olu\u015fturmak i\u00e7in response (otomatik yan\u0131t) dosyas\u0131n\u0131 “\/u01\/orainstall\/database\/response\/dbca.rsp”\u00a0 dizininden d\u00fczenlemek i\u00e7in “\/u01\/orainstall\/” dizinine kopyal\u0131yoruz.<\/span><\/p>\n
$ cp \/u01\/orainstall\/database\/response\/dbca.rsp \/u01\/orainstall\/<\/span>\r\n\r\n-- Kopyalama i\u015fleminden sonra kuruluma ge\u00e7ebiliriz.<\/span>\r\n\r\n$ vi \/u01\/orainstall\/dbca.rsp<\/span>\r\n-- Dosyam\u0131z\u0131 a\u00e7\u0131yoruz ve a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri<\/span>\r\nkendi sistemimize g\u00f6re d\u00fczenleyebiliriz. Ben istedi\u011fimiz de\u011ferleri<\/span>\r\nkomut ile g\u00f6nderece\u011fimden herhangi bir de\u011fi\u015fiklik yapm\u0131yorum.<\/span>\r\n\r\n-- Ancak database olu\u015fturulduktan sonra \"Enterprise Manager\" konsolunun\r\nba\u015flamas\u0131nda s\u0131k\u0131nt\u0131 <\/span>olu\u015ftu\u011fu i\u00e7in \u00f6nce timezone de\u011ferini \"localtime\"dan\r\n\"Europe\/Istanbul\" olarak de\u011fi\u015ftirece\u011fiz. <\/span>Bu i\u015flem i\u00e7in a\u015fa\u011f\u0131daki komutlar\u0131\r\n\"root\" kullan\u0131c\u0131s\u0131 ile \u00e7al\u0131\u015ft\u0131ral\u0131m.<\/span>\r\n\r\n# svccfg -s timezone:default setprop timezone\/TZ= astring: Europe\/Istanbul \r\nsvcadm refresh timezone:default\r\n\r\n-- Burada komut tek sat\u0131rda olmas\u0131 gerekiyor. S\u0131\u011fmad\u0131\u011f\u0131 i\u00e7in alt alta yazd\u0131m.<\/span>\r\n\r\n-- De\u011fi\u015fikli\u011fi test ediyoruz.<\/span>\r\n\r\n# echo $TZ Europe\/Istanbul<\/span>\r\n\r\n-- De\u011fi\u015fikli\u011fi test ettikten sonra a\u015fa\u011f\u0131daki komut ile veritaban\u0131m\u0131z\u0131\r\nolu\u015fturuyoruz.<\/span>\r\n\r\n$ dbca -silent -createDatabase -gdbName orcl <\/span>\r\n-templateName \/u01\/app\/oracle\/product\/11.2.0.3\/db\/assistants\/dbca\/templates\/General_Purpose.dbc <\/span>\r\n-characterSet WE8ISO8859P9 -nationalCharacterSet ALU32UTF16 -datafileDestination \/u01\/app\/oracle <\/span>\r\n-systempassword \"parolamiz\" -syspassword \"parolamiz\" -emConfiguration LOCAL \r\n-dbsnmpPASSWORD \"parolamiz\" <\/span>\r\n-sysmanPASSWORD \"parolamiz\"<\/span>\r\n\r\n-- Burada komut tek sat\u0131rda olmas\u0131 gerekiyor. S\u0131\u011fmad\u0131\u011f\u0131 i\u00e7in alt alta yazd\u0131m.<\/span>\r\n\r\n-- Notepad ayard\u0131m\u0131yla b\u00fct\u00fcn komutu yanyana kopyalay\u0131p \u00e7al\u0131\u015ft\u0131rabilirsiniz.<\/span><\/pre>\n
23. Veritaban\u0131 kurulum ve olu\u015fturma i\u015flemlerimiz tamamland\u0131 art\u0131k bir veritaban\u0131m\u0131z var \u015fimdi kurulum sonras\u0131 bir ka\u00e7 ayar\u0131 yapal\u0131m. \u00d6ncelikle sistemimiz a\u00e7\u0131ld\u0131\u011f\u0131nda veritaban\u0131m\u0131z\u0131nda a\u00e7\u0131lmas\u0131 i\u00e7in gerekli d\u00fczenlemeyi yapal\u0131m.<\/span><\/p>\n
# vi \/var\/opt\/oracle\/oratab<\/span>\r\n\r\n-- Dosyas\u0131ndaki a\u015fa\u011f\u0131daki sat\u0131rlar\u0131n sonundaki \"N\" se\u00e7ene\u011fini<\/span>\r\n\"Y\" se\u00e7ene\u011fi ile de\u011fi\u015ftiriyoruz.<\/span>\r\n\r\norcl:\/u01\/app\/oracle\/product\/11.2.0.3\/db:Y<\/span>\r\n\r\n-- \u0130\u015flemimiz bitti\u011finde art\u0131k sistem a\u00e7\u0131l\u0131\u015f\u0131nda veritaban\u0131m\u0131z<\/span>\r\notomatik olarak a\u00e7\u0131lacakt\u0131r.<\/span><\/pre>\n
24. 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\nOracle Enterprise Manager 11g Database Control Release 11.2.0.3.0 <\/span>\r\nCopyright (c) 1996, 2011 Oracle Corporation.  All rights reserved.<\/span>\r\nhttps:\/\/koraykey-sl.localdomain:1158\/em\/console\/aboutApplication<\/span>\r\nStarting Oracle Enterprise Manager 11g Database Control ......... started. <\/span>\r\n------------------------------------------------------------------<\/span>\r\nLogs are generated in directory<\/span>\r\n\/u01\/app\/oracle\/product\/11.2.0.3\/db\/koraykey-sl.localdomain_orcl\/sysman\/log <\/span>\r\n\r\n-- G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi https:\/\/koraykey-sl.localdomain:1158\/em\/<\/span>\r\nadresinden Enterprise Manager konsolumuza eri\u015febiliriz.<\/span>\r\n\r\n$ sqlplus \/ as sysdba <\/span>\r\n\r\nSQL*Plus: Release 11.2.0.3.0 Production on Mon Mar 25 00:27:37 2013<\/span>\r\n\r\nCopyright (c) 1982, 2011, Oracle.  All rights reserved.<\/span>\r\n\r\nConnected to:<\/span>\r\nOracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production<\/span>\r\nWith the Partitioning, OLAP, Data Mining and Real Application Testing options<\/span>\r\n\r\nSQL> select status from v$instance;<\/span>\r\n\r\nSTATUS<\/span>\r\n------------<\/span>\r\nOPEN<\/span>\r\n\r\n-- Art\u0131k veritaban\u0131m\u0131za oturum a\u00e7abilir istedi\u011fimiz i\u015flemleri yapabiliriz.<\/span><\/pre>\n
\"DB_Install_sl_51\"<\/a><\/p>\n
Bu makalemizde Oracle (Sun) Solaris 11 (Text) \u0130\u015fletim Sisteminde Komut Sat\u0131r\u0131ndan Standalone (Single Instance) Oracle Veritaban\u0131 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 makelemizde Oracle (Sun) Solaris 11 (Text Install) Grafik Aray\u00fcz (GUI) olmayan i\u015fletim sistemi \u00fczerine Oracle 11g R2 veritaban\u0131n\u0131 komut sat\u0131r\u0131ndan (Silent Install) olarak yapmay\u0131 inceleyece\u011fiz. 1. \u00d6ncelikle i\u015fletim sistemimizi “Oracle (Sun) Solaris 11 \u0130\u015fletim Sistemi Kurulumu (Text Install)” makalemizde … 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,203,20,19,202,205,204],"class_list":["post-2466","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-komut-satirindan-database-kurma","tag-koray-gunduz","tag-koraykey","tag-oracle-sun-solaris-11-text-isletim-sisteminde-komut-satirindan-database-kurma","tag-solaris-11-text-on-oracle-11g-r2","tag-solaris-11-text-oracle-11g-r2"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2466","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=2466"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2466\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2466"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2466"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2466"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}