{"id":2283,"date":"2013-04-06T06:52:18","date_gmt":"2013-04-06T03:52:18","guid":{"rendered":"http:\/\/www.koraykey.com\/?p=2283"},"modified":"2014-04-17T16:27:17","modified_gmt":"2014-04-17T13:27:17","slug":"oracle-business-intelligence-oracle-bi-kurulum-yapilandirma-ve-yonetimi","status":"publish","type":"post","link":"https:\/\/www.koraykey.com\/?p=2283","title":{"rendered":"Oracle Business Intelligence (Oracle BI) Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimi"},"content":{"rendered":"

\"OracleBI\"<\/a>Bu makalemizde Oracle firmas\u0131n\u0131n \u0130\u015f Zekas\u0131 (Business Intelligence) \u00e7\u00f6z\u00fcm\u00fc olan “Oracle Business Intelligence” \u00fcr\u00fcn\u00fcn\u00fcn Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimini inceleyece\u011fiz.<\/span><\/p>\n

Oracle BI (Oracle Business Intelligence) Nedir ?<\/span><\/strong><\/p>\n

Oracle firmas\u0131n\u0131n kurumsal firmalar i\u00e7in i\u015f zekas\u0131 \u00e7\u00f6z\u00fcm\u00fc olan “The Oracle Business Intelligence Suite Enterprise Edition (EE)”, t\u00fcm i\u015f zekas\u0131 problemlerine \u00e7\u00f6z\u00fcm sunabilecek ve yeni geli\u015fmekte olan yeni i\u015f zekas\u0131 uygulama ihtiya\u00e7lar\u0131n\u0131n t\u00fcm\u00fcne cevap verebilecek niteliktedir. Oracle’\u0131n Siebel firmas\u0131n\u0131 sat\u0131n almas\u0131ndan sonra Siebel Analytics \u00fcr\u00fcn\u00fc, BI Suite Enterprise Edition’da raporlama arac\u0131 olarak se\u00e7ilmi\u015ftir. Oracle, Siebel Analytics ile kullan\u0131c\u0131lara \u015firket i\u00e7erisindeki t\u00fcm verilere eri\u015fme, bunlar\u0131 yorumlama, tespitler yapma, de\u011ferlendirme ve d\u00fczeltme olana\u011f\u0131 sa\u011flayan ara\u00e7lar\u0131 ve teknolojiyi sunmaktad\u0131r. Oracle BI EE’nin raporlama \u00e7\u00f6z\u00fcm\u00fc olan Siebel Analytics, Siebel Analytics Server ve Siebel Analytics WEB denilen iki ana bile\u015fenden olu\u015fmaktad\u0131r. Siebel Analytics Server, Oracle BI EE’nin par\u00e7as\u0131 oldukran sonra Oracle BI Server ad\u0131n\u0131 alm\u0131\u015ft\u0131r. Oracle BI EE, ODBC ba\u011flant\u0131s\u0131 sa\u011flayabilen her veri kayna\u011f\u0131na eri\u015febilmekte, bunlar\u0131 kullanarak analitik modelleme yapmay\u0131 sa\u011flamakta ve birden fazla kanala veri da\u011f\u0131t\u0131m\u0131 yapabilmektedir.<\/span><\/p>\n

1. \u00d6ncelikle i\u015fletim sistemimizi daha \u00f6nceki \u201cOracle Enterprise Linux 6.x Kurulumu\u201d<\/a> makalemizde anlat\u0131ld\u0131\u011f\u0131 gibi kuruyoruz.<\/span><\/p>\n

2. \u0130\u015fletim sistemi kurulumundan sonra \u201cOracle Business Intelligence (Oracle BI)\u201d arac\u0131n\u0131n repository (depo) olu\u015fturabilmesi i\u00e7in kurulum gereksinimi olan Oracle Veritaban\u0131 kurulumunu ger\u00e7ekle\u015ftiriyoruz.<\/span><\/p>\n

\u201cOracle Grid Infrastructure ile Single Instance (Standalone) Veritaban\u0131 Kurulumu\u201d<\/span><\/a>
\n\u201cOracle Enterprise Linux \u0130\u015fletim Sisteminde Standalone (Single Instance) Oracle Veritaban\u0131 Kurulumu\u201d<\/span><\/a>
\n“Oracle Enterprise Linux \u0130\u015fletim Sisteminde Oracle Real Application Cluster (Rac) Veritaban\u0131 Kurulumu”<\/span><\/a><\/p>\n

Veritaban\u0131 kurulumumuzu tercihimize g\u00f6re a\u015fa\u011f\u0131daki makalelerimizden se\u00e7erek ger\u00e7ekle\u015ftiriyoruz.<\/span><\/p>\n

3. Kurulum i\u00e7in ihtiyac\u0131m\u0131z olan dosyalar\u0131 “Oracle Business Intelligence Downloads”<\/a> sitesinden indiriyoruz.<\/span><\/p>\n

bi_linux_x86_111170_64_disk1_1of2.zip<\/span>\r\nbi_linux_x86_111170_64_disk1_2of2.zip<\/span>\r\nbi_linux_x86_111170_64_disk2_1of2.zip<\/span>\r\nbi_linux_x86_111170_64_disk2_2of2.zip<\/span>\r\nbi_linux_x86_111170_64_disk3.zip<\/span>\r\nofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip<\/span><\/pre>\n
4. Kuruluma ge\u00e7ebilmemiz i\u00e7in ftp yada ba\u015fka bir y\u00f6ntem ile kurulum dosyalar\u0131m\u0131z\u0131 olu\u015fturdu\u011fumuz \u201c\/u01\/orainstall\/obi\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
5. Oracle Business Intelligence kurulumunu yapaca\u011f\u0131m\u0131z ve kurulum dosyalar\u0131m\u0131z\u0131 koyaca\u011f\u0131m\u0131z dizinleri yarat\u0131yoruz.<\/span><\/p>\n
-- Oracle Kullan\u0131c\u0131s\u0131 ile a\u015fa\u011f\u0131daki dizinleri yarat\u0131yoruz.\r\n\r\n$ mkdir -p \/u01\/orainstall\/obi<\/span>\r\n$ mkdir -p \/u01\/app\/oracle\/obiee<\/span>\r\n$ cd \/u01\/orainstall\/obi\/<\/span>\r\n$ chmod 775 *<\/span>\r\n\r\n-- Kurulum i\u00e7in gerekli dosyalar\u0131m\u0131z\u0131 koydu\u011fumuz dizin alt\u0131nda a\u00e7\u0131yoruz.<\/span>\r\n\r\n$ cd \/u01\/orainstall\/obi<\/span>\r\n$ unzip bi_linux_x86_111170_64_disk1_1of2.zip<\/span>\r\n$ unzip bi_linux_x86_111170_64_disk1_2of2.zip<\/span>\r\n$ unzip bi_linux_x86_111170_64_disk2_1of2.zip<\/span>\r\n$ unzip bi_linux_x86_111170_64_disk2_2of2.zip<\/span>\r\n$ unzip bi_linux_x86_111170_64_disk3.zip<\/span>\r\n$ unzip ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip<\/span>\r\n\r\n-- Alan kaplamamas\u0131 i\u00e7in s\u0131k\u0131\u015ft\u0131r\u0131lm\u0131\u015f dosyalar\u0131m\u0131z\u0131 siliyoruz.<\/span>\r\n$ rm bi_linux_x86_111170_64_disk*<\/span>\r\n$ rm ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip<\/span><\/pre>\n
6. 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. 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=:0.0; export DISPLAY<\/span>\r\n\r\n\u00d6rnek;<\/span>\r\n\r\n$ DISPLAY=192.168.2.83:0.0; export DISPLAY<\/span>\r\n\r\nTest i\u00e7in;<\/span>\r\n\r\n$ xclock<\/span>\r\n\r\n-- Yazd\u0131\u011f\u0131m\u0131zda ekran\u0131m\u0131zda bir saat yaz\u0131l\u0131m\u0131n\u0131n \u00e7al\u0131\u015ft\u0131\u011f\u0131n\u0131 g\u00f6rmeliyiz.<\/span>\r\nE\u011fer a\u00e7\u0131lm\u0131yorsa ayarlarda bir sorun var demektir. Firewall vb.<\/span>\r\nayarlar\u0131m\u0131z\u0131 kontrol etmeliyiz.<\/span><\/pre>\n
7. Bu i\u015flemlerin tamam\u0131 bitti\u011finde kuruluma ge\u00e7ebiliriz. \u00d6ncelikle “Repository” (depo) kurulumunu yap\u0131yoruz. Daha sonra “Oracle Business Intelligence” kurulumu yap\u0131yoruz. Repository i\u00e7in “ofm_rcu_linux_11.1.1.7.0_64_disk1_1of1.zip” dosyas\u0131n\u0131 indirip yukar\u0131daki ad\u0131mlarda a\u00e7m\u0131\u015ft\u0131k. \u015eimdi bu dizine girip repository kurulumunu yapal\u0131m. Repository kurulumu olmadan “Oracle Business Intelligence” kurulumuna ge\u00e7memeliyiz.
\n<\/span><\/p>\n
$ cd \/u01\/orainstall\/obi\/rcuHome\/bin<\/span>\r\n\r\n$ .\/rcu<\/span><\/pre>\n
8. Ho\u015fgeldiniz ekran\u0131nda “Next” d\u00fc\u011fmesine t\u0131klayarak ilerliyoruz.<\/span><\/p>\n
\"OracleBiInstall_1\"<\/a><\/p>\n
9. Repository (Depo) yap\u0131land\u0131rma ekran\u0131nda yeni depo yarataca\u011f\u0131m\u0131z i\u00e7in “Create” se\u00e7ene\u011fi i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_2\"<\/a><\/p>\n
10. Repository y\u00fcklemesinin hangi veritban\u0131na nas\u0131l ba\u011flanaca\u011f\u0131yla ilgili bilgileri giriyoruz. burada dikkat edece\u011fimiz Oracle RAC veritaban\u0131na ba\u011flant\u0131 kuracaksak \u00fcyelerden birinin ad\u0131n\u0131 yaz\u0131yoruz. E\u011fer Oracle SCAN IP kullan\u0131yorsak veritaban\u0131m\u0131z\u0131n SCAN ismini giriyoruz. Gerekli bilgileri girdikten sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_3\"<\/a><\/p>\n
11. Repository yaratma arac\u0131 gerekli i\u015flemleri yap\u0131yor bu arada veritaban\u0131 kurulumunda karakter seti olarak “W8ISO8859-P9” se\u00e7ti\u011fimiz i\u00e7in bizi uyar\u0131yor. Gelen uyar\u0131y\u0131 “Ignore” d\u00fc\u011fmesine t\u0131klayarak ge\u00e7iyoruz.<\/span><\/p>\n
\"OracleBiInstall_4\"<\/a><\/p>\n
12. Eklentilerin se\u00e7ilece\u011fi ekranda “Oracle Business Intelligence” se\u00e7ene\u011fini i\u015faretledi\u011fimizde gerekli paketlerde otomatik se\u00e7iliyor. Ayr\u0131ca olu\u015fturaca\u011f\u0131 \u015fema ve kullanc\u0131larda \u00f6n ek olarak “DEV” ismini getiriyor bu se\u00e7ene\u011fi de\u011fi\u015ftirmek istiyorsak gerekli \u00f6neki sadece alfa numerik de\u011ferler girerek belirliyoruz ve kuruluma devam edebilmek i\u00e7in “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_5\"<\/a><\/p>\n
13. Sistemimiz se\u00e7imlerimize g\u00f6re gerekli i\u015flemi yap\u0131yor. Bitti\u011finde “OK” d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"OracleBiInstall_6\"<\/a><\/p>\n
14. Sunucumuzda metadata servisi ve OracleBI Platformu i\u00e7in kullan\u0131c\u0131 parolalar\u0131n\u0131 belirliyoruz. Burada istersek her iki kullan\u0131c\u0131 i\u00e7inde ayn\u0131 parolay\u0131 verebiliriz veya ay\u0131rabiliriz. Bu parolalar veritaban\u0131m\u0131zdaki “DEV_MDS” ve “DEV_BIPLATFORM” kullan\u0131c\u0131lar\u0131n\u0131n parolalar\u0131 olacakt\u0131r.<\/span><\/p>\n
\"OracleBiInstall_7\"<\/a><\/p>\n
15. Yarat\u0131lacak kullan\u0131c\u0131lar\u0131n hangi “tablespace”leri kullanaca\u011f\u0131n\u0131 belirten ekranda herhangi bir de\u011fi\u015fiklik yapmayacaksak “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_8\"<\/a><\/p>\n
16. Yarataca\u011f\u0131 “tablespace”lerin veritaban\u0131m\u0131zda olmamas\u0131 gerekti\u011fiyle ilgili bizi uyar\u0131yor. E\u011fer veritaban\u0131m\u0131zda bunlar mevcut de\u011filse “OK” d\u00fc\u011fmesine t\u0131kl\u0131yoruz. Ayn\u0131 isimle “tablespace” mevcutsa “drop” edece\u011fiz veya ba\u015fka bir isimle yarataca\u011f\u0131z.<\/span><\/p>\n
\"OracleBiInstall_9\"<\/a><\/p>\n
17. Gerekli “tablespace” yarat\u0131l\u0131rken bekliyoruz. Yaratma i\u015flemi bitti\u011finde “OK” d\u00fc\u011fmesine t\u0131klayarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"OracleBiInstall_10\"<\/a><\/p>\n
18. \u00d6zet bilgi ekran\u0131nda yapt\u0131\u011f\u0131m\u0131z tercihlerle ilgili bilgileri g\u00f6rebiliyoruz. Herhangi bir yanl\u0131\u015fl\u0131k yoksa veya de\u011fi\u015fiklik yapmayacaksak “Create” d\u00fc\u011fmesine t\u0131klayarak Oracle BI i\u00e7in “Repository” olu\u015fturulmas\u0131na ba\u015fl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_11\"<\/a><\/p>\n
19. Sunucumuzda “Repository” olu\u015fturulurken durumunu a\u015fa\u011f\u0131daki ekrandan takip edebiliriz.<\/span><\/p>\n
\"OracleBiInstall_12\"<\/a><\/p>\n
20. Sunucumuzda “Repository” yaratma i\u015flemi bitti\u011finde “Close” d\u00fc\u011fmesine t\u0131klayarak kurulum ekran\u0131ndan \u00e7\u0131k\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_13\"<\/a><\/p>\n
21. “Oracle Business Intelligence” i\u00e7in “Repository” (Depo) olu\u015fturma i\u015flemimizi tamamlad\u0131ktan sonra “Oracle Business Intelligence” kurulum dosyalar\u0131m\u0131z\u0131n oldu\u011fu dizine ge\u00e7erek kurulum i\u015flemini ba\u015flat\u0131yoruz.<\/span><\/p>\n
-- \u201cOracle Business Intelligence\u201d yaz\u0131l\u0131m\u0131n\u0131n kurulumuna ba\u015fl\u0131yoruz.<\/span>\r\n\r\n$ cd \/u01\/orainstall\/obi\/bishiphome\/Disk1\/<\/span>\r\n\r\n$ .\/runInstaller<\/span><\/pre>\n
22. Ho\u015fgeldiniz ekran\u0131nda “Next” d\u00fc\u011fmesine t\u0131klayarak ilerliyoruz.<\/span><\/p>\n
\"OracleBiInstall_14\"<\/a><\/p>\n
23. Yaz\u0131l\u0131m g\u00fcncellemesiyle ilgili ekranda “Skip Software Updates” se\u00e7ene\u011fi i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_15\"<\/a><\/p>\n
24. Kurulumuzu “Simple” se\u00e7ene\u011fi ile yapaca\u011f\u0131z e\u011fer sunucumuzda domain vb. se\u00e7eneklerin tamam\u0131n\u0131 elle yap\u0131land\u0131racaksak “Enterprise Install” se\u00e7ene\u011fini se\u00e7ebiliriz. Gerekli se\u00e7ene\u011fimiz i\u015faretliyken “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_16\"<\/a><\/p>\n
25. \u00d6ngereksinimlerimizin durumunu sorgularken bekliyoruz. E\u011fer kurulumu yapmam\u0131za engel bir uyar\u0131 vermemi\u015fse “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz. Sunucumuzda herhangi bir eksiklik olmad\u0131\u011f\u0131nda hepsini “OK” olarak i\u015faretleyecektir.<\/span><\/p>\n
\"OracleBiInstall_17\"<\/a><\/p>\n
26. Yaz\u0131l\u0131m\u0131 kuraca\u011f\u0131m\u0131z dizini kurulum a\u015famalar\u0131m\u0131z\u0131n ba\u015f\u0131nda yaratm\u0131\u015ft\u0131k. Bu bilgiyi “\/u01\/app\/oracle\/obiee” yaratt\u0131\u011f\u0131m\u0131z dizin yoluna g\u00f6re giriyoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_18\"<\/a><\/p>\n
27. Kurulum i\u00e7in “weblogic” kullan\u0131c\u0131 parolas\u0131n\u0131 belirliyoruz. Bu parola daha sonra sistemi y\u00f6netebilmek i\u00e7in gereklidir. Bu y\u00fczden do\u011fru bir \u015fekilde girilmeli ve unutulmamal\u0131d\u0131r. Parolam\u0131z\u0131 belirledikten sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_19\"<\/a><\/p>\n
28. Oracle BI i\u00e7in ihtiyac\u0131m\u0131z olan bile\u015fenleri se\u00e7iyoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_20\"<\/a><\/p>\n
29. Oracle BI i\u00e7in “repository” yarat\u0131rken kulland\u0131\u011f\u0131m\u0131z bilgileri burada giriyoruz. Bizden veritaban\u0131na ba\u011flanmak i\u00e7in ba\u011flant\u0131 ayar\u0131n\u0131 ve \u015femaya ba\u011flanabilmek i\u00e7in kullan\u0131c\u0131 ad\u0131 ve parolam\u0131z\u0131 soruyor. Gerekli bilgileri girdikten sonra “Next” d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz. E\u011fer “repository” kurulumu yapmadan direk kuruluma ge\u00e7mi\u015fsek bu a\u015famada kal\u0131r\u0131z.<\/span><\/p>\n
\"OracleBiInstall_21\"<\/a><\/p>\n
30. Oracle BI i\u00e7in “metadata”n\u0131n tutulaca\u011f\u0131 veritaban\u0131 bilgilerini istiyor. Bu ad\u0131mda istenilen bilgileride “repository” yarat\u0131rken olu\u015fturmu\u015ftuk. Gerekli bilgileri girdikten sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_22\"<\/a><\/p>\n
31. G\u00fcvenlik g\u00fcncellemelerinin yap\u0131labilmesi i\u00e7in bizden “Oracle My Support” hesab\u0131m\u0131z\u0131 istiyor. Bu bilgileri girmeden devam edebiliriz. “I wish receive security updates via My Oracle Support” i\u015faretini kald\u0131r\u0131yoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_23\"<\/a><\/p>\n
32. Bizi g\u00fcncellemelerin yap\u0131lmayaca\u011f\u0131yla ilgili uyar\u0131yor. “YES” d\u00fc\u011fmesine t\u0131kl\u0131yarak kuruluma devam ediyoruz.<\/span><\/p>\n
\"OracleBiInstall_24\"<\/a><\/p>\n
33. \u00d6zet bilgi ekran\u0131nda yapt\u0131\u011f\u0131m\u0131z tercihlerle ilgili ayarlar\u0131 kontrol ettikten sonra “Install” d\u00fc\u011fmesine t\u0131kl\u0131yoruz ve kurulum i\u015flemimizi ba\u015flat\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_25\"<\/a><\/p>\n
34. Kurulum a\u015famalar\u0131n\u0131 a\u015fa\u011f\u0131daki ekrandan takip edebiliriz.<\/span><\/p>\n
\"OracleBiInstall_26\"<\/a><\/p>\n
35. Kurulum i\u015flemi otomatik olarak ayarlar\u0131n yap\u0131land\u0131r\u0131ld\u0131\u011f\u0131 ekrana ge\u00e7ecektir. Yap\u0131land\u0131rma ve kurulum sunucumuzun kaynaklar\u0131na ba\u011fl\u0131 olarak yakla\u015f\u0131k 1 saate yak\u0131n s\u00fcrecektir.<\/span><\/p>\n
\"OracleBiInstall_27\"<\/a><\/p>\n
36. Yap\u0131land\u0131rma i\u015flemi bitti\u011finde “Next” d\u00fc\u011fmesine t\u0131klayarak devam ediyoruz.<\/span><\/p>\n
\"OracleBiInstall_28\"<\/a><\/p>\n
37. Kurulum i\u015flemimiz tamamland\u0131. Kurulum \u00f6zet bilgi ekran\u0131nda sunucumuza eri\u015febilmek i\u00e7in gerekli adresleri not etmeliyiz. Kurulum i\u015flemini “Finish” d\u00fc\u011fmesine t\u0131klayarak bitiriyoruz.<\/span><\/p>\n
\"OracleBiInstall_29\"<\/a><\/p>\n
38. Kurulum bitti\u011finde otomatik olarak giri\u015f ekran\u0131m\u0131z a\u00e7\u0131lacakt\u0131r.<\/span><\/p>\n
\"OracleBiInstall_30\"<\/a><\/p>\n
39. Dil se\u00e7eneklerinden yaz\u0131l\u0131m\u0131 kullanmak istedi\u011fimiz dili se\u00e7ebiliriz.<\/span><\/p>\n
\"OracleBiInstall_31\"<\/a><\/p>\n
40. Kurulum a\u015famas\u0131nda “weblogic” kullan\u0131c\u0131s\u0131na verdi\u011fimiz parola ile sisteme oturum a\u00e7abiliriz.<\/span><\/p>\n
\"OracleBiInstall_32\"<\/a><\/p>\n
41. Oturum a\u00e7t\u0131\u011f\u0131m\u0131zda bizi “OBIEE Sample App” uygulamas\u0131yla ilgili uyar\u0131 ekran\u0131 kar\u015f\u0131m\u0131za \u00e7\u0131k\u0131yor.<\/span><\/p>\n
\"OracleBiInstall_33\"<\/a><\/p>\n
42. Sa\u011f \u00fcst k\u00f6\u015fede bulunan “New>Report” se\u00e7ene\u011fini takip ederek elimizde veri varsa rapor olu\u015fturabiliriz. \u00d6rnek olarak kurulumda gelmi\u015f “Simple” veriyi kullanarak rapor olu\u015ftural\u0131m. “Use Subject Area” se\u00e7ene\u011fini i\u015faretleyerek “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_34\"<\/a><\/p>\n
43. Sayfa yap\u0131m\u0131z ve kullan\u0131lacak rapor grafiklerini se\u00e7tikten sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_35\"<\/a><\/p>\n
44. Raporumuza dahil edilecek verisetlerini sa\u011f taraftaki a\u011fa\u00e7 men\u00fcs\u00fcnden s\u00fcr\u00fckle b\u0131rak y\u00f6ntemi ile raporumuza ekliyoruz.<\/span><\/p>\n
\"OracleBiInstall_36\"<\/a><\/p>\n
45. Ayn\u0131 i\u015flemi kar\u015f\u0131la\u015ft\u0131rma yapaca\u011f\u0131m\u0131z ikinci grafi\u011fimiz i\u00e7inde yap\u0131yoruz ve “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_37\"<\/a><\/p>\n
46. Tablo yaratma ekran\u0131nda \u00f6zet bilgileri g\u00f6rd\u00fckten sonra “Next” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_38\"<\/a><\/p>\n
47. Raporumuzda herhangi bir ayarlama yapmayacaksak “Finish” d\u00fc\u011fmesine t\u0131klayarak rapor olu\u015fturma i\u015flemimizi tamaml\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_39\"<\/a><\/p>\n
48. Olu\u015fturdu\u011fumuz raporu hangi dizinde tutmak istiyorsak oraya isimlendirerek kaydediyoruz.<\/span><\/p>\n
\"OracleBiInstall_40\"<\/a><\/p>\n
49.\u00a0Basit \u00f6rneklerle haz\u0131rlad\u0131\u011f\u0131m\u0131z raporumuz haz\u0131r. Ekranda g\u00f6rebiliriz.<\/span><\/p>\n
\"OracleBiInstall_41\"<\/a><\/p>\n
50. Konsol ekran\u0131nda “Home” tu\u015funa basarak a\u00e7\u0131l\u0131\u015f ekran\u0131m\u0131za d\u00f6nebiliriz.<\/span><\/p>\n
\"OracleBiInstall_42\"<\/a><\/p>\n
51. Sistemden \u00e7\u0131kmak i\u00e7in sa\u011f \u00fcst k\u00f6\u015fedeki “Sign Out” d\u00fc\u011fmesine t\u0131kl\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_43\"<\/a><\/p>\n
52. Oracle BI i\u00e7in mobil cihazlarda \u00e7al\u0131\u015fmak \u00fczere ara\u00e7lar geli\u015ftirilmi\u015ftir. \u00d6rnek olarak bir Ipad tablet bilgisayar\u0131nda olu\u015fturulmu\u015f raporlar\u0131m\u0131z\u0131 g\u00f6rebilir veya raporlar olu\u015fturabiliriz.<\/span><\/p>\n
\"OracleBiInstall_44\"<\/a><\/p>\n
53. Sunucu ekle veya mevcut ayarlar \u00fczerine t\u0131kl\u0131yoruz ve a\u00e7\u0131lan ekranda gerekli bilgilerimizi yap\u0131land\u0131r\u0131yoruz.<\/span><\/p>\n
\"OracleBiInstall_45\"<\/a><\/p>\n
54. Oturum a\u00e7 d\u00fc\u011fmesine t\u0131klayarak sistemimize giriyoruz.<\/span><\/p>\n
\"OracleBiInstall_46\"<\/a><\/p>\n
55. Giri\u015f yapm\u0131\u015f oldu\u011fumuz kullan\u0131c\u0131m\u0131z ile olu\u015fturulmu\u015f raporlar veya di\u011fer kullan\u0131c\u0131lar\u0131n payla\u015ft\u0131\u011f\u0131 raporlar\u0131 g\u00f6rebiliyoruz.<\/span><\/p>\n
\"OracleBiInstall_47\"<\/a><\/p>\n
56. G\u00f6rd\u00fc\u011f\u00fcm\u00fcz gibi az \u00f6nce bilgisayar\u0131m\u0131zdan olu\u015fturulmu\u015f “Satislar” raporu ekran\u0131m\u0131za geldi. \u00dczerinde t\u0131klad\u0131\u011f\u0131m\u0131zda raporumuzu a\u00e7abiliriz.<\/span><\/p>\n
\"OracleBiInstall_48\"<\/a><\/p>\n
57. Oracle BI y\u00f6netim konsoluna girebilmek i\u00e7in bilgisayar\u0131m\u0131z\u0131n taray\u0131c\u0131s\u0131na a\u015fa\u011f\u0131daki gibi \u00f6rnek adresi yazd\u0131\u011f\u0131m\u0131zda eri\u015febiliriz.<\/span><\/p>\n
http:\/\/koraykey-oel.localdomain:7001\/analytics<\/span><\/pre>\n
58. Sunucumuz a\u00e7\u0131ld\u0131\u011f\u0131nda Oracle Business Intelligence (Oracle BI) otomatik ba\u015flamas\u0131n\u0131 istiyorsak bununla ilgili servis yaratabiliriz. Servisimizin do\u011fru \u00e7al\u0131\u015fabilmesi i\u00e7in ba\u011fland\u0131\u011f\u0131 veritaban\u0131n\u0131n a\u00e7\u0131k durumda olmas\u0131 gerekmektedir. Bununla ilgili “Linux \u0130\u015fletim Sistemlerinde Otomatik Veritaban\u0131 Ba\u015flatma ve Durdurma”<\/a> makalemizi inceleyebilirsiniz. Veritaban\u0131m\u0131z a\u00e7\u0131kken Oracle Business Intelligence (Oracle BI) sunucumuzun sistemimiz a\u00e7\u0131l\u0131rken otomatik ba\u015flamas\u0131 i\u00e7in servis yazabiliriz.<\/span><\/p>\n
-- \u0130\u015fletim Sistemi ba\u015flang\u0131c\u0131nda \u00e7al\u0131\u015facak servis dosyam\u0131z\u0131 haz\u0131rl\u0131yoruz.<\/span>\r\n\r\n# vim \/etc\/init.d\/obiee<\/span>\r\n-- Dosyas\u0131n\u0131 olu\u015fturup i\u00e7erisine a\u015fa\u011f\u0131daki de\u011fi\u015fkenleri kendi sistemimize<\/span>\r\ng\u00f6re d\u00fczenleyerek yaz\u0131yoruz.<\/span>\r\n\r\n#!\/bin\/bash<\/span>\r\n# <\/span>\r\n# File:    \/etc\/init.d\/obiee<\/span>\r\n# Purpose: Start and stop Oracle Business Intelligence 11g components.<\/span>\r\n#<\/span>\r\n# chkconfig: 2345 99 10<\/span>\r\n# description: Manage OBIEE service.<\/span>\r\n#<\/span>\r\n\r\n# These values must be adapted to your environment.<\/span>\r\n\r\nORACLE_OWNR=oracle<\/span>\r\nORACLE_FMW=\/u01\/app\/oracle\/obiee<\/span>\r\n\r\nBIEE_USER=weblogic<\/span>\r\nBIEE_PASSWD=parolamiz<\/span>\r\nBIEE_DOMAIN=bifoundation_domain<\/span>\r\nBIEE_INSTANCE=instance1<\/span>\r\nBIEE_SERVER=koraykey-oel<\/span>\r\nBIEE_MANAGER_URL=koraykey-oel.localdomain:7001<\/span>\r\n\r\n# These should require no change.<\/span>\r\n\r\nWL_PATH=$ORACLE_FMW\/wlserver_10.3\/server\/bin<\/span>\r\nBIEE_PATH=$ORACLE_FMW\/user_projects\/domains\/$BIEE_DOMAIN\/bin<\/span>\r\nORACLE_INSTANCE=$ORACLE_FMW\/instances\/$BIEE_INSTANCE<\/span>\r\n\r\nexport ORACLE_INSTANCE<\/span>\r\n\r\nSTART_LOG=\/var\/log\/obiee-start.log<\/span>\r\nSTOP_LOG=\/var\/log\/obiee-stop.log<\/span>\r\nSUBSYS=obiee<\/span>\r\n\r\nstart() {<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Starting Admin Server on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$BIEE_PATH\/startWebLogic.sh\" &<\/span>\r\n    wait_for \"Server started in RUNNING mode\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Starting Node Manager on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$WL_PATH\/startNodeManager.sh\" &<\/span>\r\n    wait_for \"socket listener started on port\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Starting Managed Server $BIEE_SERVER on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$BIEE_PATH\/startManagedWebLogic.sh $BIEE_SERVER http:\/\/$BIEE_MANAGER_URL\" &<\/span>\r\n    wait_for \"Server started in RUNNING mode\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Starting BI components on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$ORACLE_INSTANCE\/bin\/opmnctl startall\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"OBIEE start sequence completed on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n}<\/span>\r\n\r\nstop() {<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Stopping BI components on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$ORACLE_INSTANCE\/bin\/opmnctl stopall\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Stopping Managed Server $BIEE_SERVER on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$BIEE_PATH\/stopManagedWebLogic.sh $BIEE_SERVER t3:\/\/$BIEE_MANAGER_URL $BIEE_USER $BIEE_PASSWD\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Stopping Node Manager on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    pkill -TERM -u $ORACLE_OWNR -f \"weblogic\\\\.NodeManager\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"Stopping Admin Server on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n    su $ORACLE_OWNR -c \"$BIEE_PATH\/stopWebLogic.sh\"<\/span>\r\n\r\n    echo \"********************************************************************************\"<\/span>\r\n    echo \"OBIEE stop sequence completed on $(date)\"<\/span>\r\n    echo \"********************************************************************************\"<\/span>\r\n}<\/span>\r\n\r\nwait_for() {<\/span>\r\n    res=0<\/span>\r\n    while [[ ! $res -gt 0 ]]<\/span>\r\n    do<\/span>\r\n        res=$(tail -5 \"$START_LOG\" | fgrep -c \"$1\")<\/span>\r\n        sleep 5<\/span>\r\n    done<\/span>\r\n}<\/span>\r\n\r\ncase \"$1\" in<\/span>\r\n    start)<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        echo \"Starting Oracle Business Intelligence on $(date)\"<\/span>\r\n        echo \"Logs are sent to $START_LOG\"<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        start &> $START_LOG &<\/span>\r\n        touch \/var\/lock\/subsys\/$SUBSYS<\/span>\r\n    ;;<\/span>\r\n    stop)<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        echo \"Stopping Oracle Business Intelligence on $(date)\"<\/span>\r\n        echo \"Logs are sent to $STOP_LOG\"<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        stop &> $STOP_LOG<\/span>\r\n        rm -f \/var\/lock\/subsys\/$SUBSYS<\/span>\r\n    ;;<\/span>\r\n    status)<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        echo \"Oracle BIEE components status....\"<\/span>\r\n        echo \"********************************************************************************\"<\/span>\r\n        su $ORACLE_OWNR -c \"$ORACLE_INSTANCE\/bin\/opmnctl status\"<\/span>\r\n    ;;<\/span>\r\n    restart)<\/span>\r\n        $0 stop<\/span>\r\n        $0 start<\/span>\r\n    ;;<\/span>\r\n    *)<\/span>\r\n        echo \"Usage: $(basename $0) start|stop|restart|status\"<\/span>\r\n        exit 1<\/span>\r\nesac<\/span>\r\n\r\nexit 0<\/span>\r\n\r\n-- <\/span>\u0130\u015fletim sistemimize yazm\u0131\u015f oldu\u011fumuz scripti servis olarak ekliyoruz.<\/span>\r\n\r\n# chkconfig --add obiee<\/span>\r\n\r\n-- Servisimizin sunucumuz a\u00e7\u0131l\u0131rken ba\u015flamas\u0131n\u0131 istiyorsak \"on\" parametresi<\/span>\r\nile a\u00e7\u0131y\u0131yoruz.<\/span>\r\n\r\n# chkconfig obiee on<\/span>\r\n\r\n-- Servisimizin \u00e7al\u0131\u015fmas\u0131 i\u00e7in gerekli haklar\u0131 at\u0131yoruz.<\/span>\r\n\r\n# chmod 750 \/etc\/init.d\/obiee<\/span>\r\n\r\n-- Servisimizi ba\u015flatmak, durdurmak ve durumunu sorgulamak i\u00e7in a\u015fa\u011f\u0131daki<\/span>\r\nkomutlar\u0131 kullanabiliriz.<\/span>\r\n\r\n# service obiee start<\/span>\r\n# service obiee stop<\/span>\r\n# service obiee status<\/span><\/pre>\n
Bu makalemizde Oracle Enterprise Linux 64 Bit \u00fczerine \u201cOracle Business Intelligence (Oracle BI) Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimini\u201d g\u00f6rd\u00fck. Kurulum i\u00e7in Oracle Enterprise Linux 6.4 \u0130\u015fletim Sistemi, Oracle 11g R2 (11.2.0.3.0 with 11.2.0.3.5 patchset) veritaban\u0131 ve Oracle Business Intelligence 11.1.1.7.0 yaz\u0131l\u0131mlar\u0131n\u0131 kulland\u0131k. Buradaki ad\u0131mlar di\u011fer Linux da\u011f\u0131t\u0131mlar\u0131ylada uyumludur.<\/span><\/p>\n
Bir sonraki makalemizde g\u00f6r\u00fc\u015fmek dile\u011fiyle\u2026<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"
Bu makalemizde Oracle firmas\u0131n\u0131n \u0130\u015f Zekas\u0131 (Business Intelligence) \u00e7\u00f6z\u00fcm\u00fc olan “Oracle Business Intelligence” \u00fcr\u00fcn\u00fcn\u00fcn Kurulum, Yap\u0131land\u0131rma ve Y\u00f6netimini inceleyece\u011fiz. Oracle BI (Oracle Business Intelligence) Nedir ? Oracle firmas\u0131n\u0131n kurumsal firmalar i\u00e7in i\u015f zekas\u0131 \u00e7\u00f6z\u00fcm\u00fc olan “The Oracle Business Intelligence Suite … 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,561,560,558,557,559,563,562,188,189,195,192,184,185,196,191,190,186,187,542,544,543],"class_list":["post-2283","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-h-koray-gunduz","tag-halil-koray-gunduz","tag-koray-gunduz","tag-koraykey","tag-linux-obiee-11g-kurulumu","tag-linux-obiee-kurulumu","tag-linux-oracle-bi","tag-linux-oracle-bi-kurulumu","tag-linux-oracle-bi-start-stop-script","tag-obiee-11g-kurulumu","tag-obiee-kurulumu","tag-oracle-bi-11g","tag-oracle-bi-11g-kurulumu","tag-oracle-bi-baslatma","tag-oracle-bi-ipad","tag-oracle-bi-kurulumu","tag-oracle-bi-nedir","tag-oracle-bi-otomatik-baslatma","tag-oracle-bi-rapor-alma","tag-oracle-bi-rapor-hazirlama","tag-oracle-business-intelligence-kurulumu","tag-oracle-business-intelligence-nedir","tag-oracle-is-zekasi","tag-oracle-is-zekasi-kurulumu","tag-oracle-is-zekasi-nedir"],"_links":{"self":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2283","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=2283"}],"version-history":[{"count":0,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=\/wp\/v2\/posts\/2283\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2283"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2283"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.koraykey.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2283"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}