OBIEE 12C
New Features and Changes for Oracle BI EE 12c (12.2.1) (12.2.1) •
• •
"Invoking WLST From a Single Location" (UNIX) ORACLE_HOME /oracle_common/common/bin/wlst.sh /oracle_common/common/bin/wlst.sh (Windows) ORACLE_HOME \oracle_common\common\bin\wlst.cmd
•
•
"Oracle Home Location Redefned and o !iddleare Home"
•
"O#! i$ o Longer %$ed in F&$ion !iddleare"
•
"Oracle We' Cac(e ot #art o) F&$ion !iddleare"
•
"!oving From Te$t Te$t To To #rod&ction i$ Carried O&t in a *i+erent Wa,"
•
"e Command$ For #roce$$ Control"
•
"!anaging !etadata In B&$ine$$ Intelligence -rc(ive File$"
•
"Single Enter.ri$e In$tall"
•
"C(ange$ to Scaling O&t"
•
"Sim.lifed Confg&ration"
•
"!anaging S,$tem Com.onent In$tance$ %$ing Command$"
•
"Collecting *iagno$tic B&ndle$"
S,$tem -dmini$trator/$ 0&ide (tt.doc$3oracle3commiddleare1221'ieeBIES0toc3(tm !igration 0&ide (tt.doc$3oracle3commiddleare1221coreBI!I03.d) S,$tem -dmini$trator/$ 0&ide (tt.$doc$3oracle3commiddleare1221'ieeBIES03.d)
File locations and meanings he file locations in OBIEE12c are very d ifferent fro !revious versions. I"ll u!date this !age when I find soething I consider interesting.
First few naing conventions# I installed OBIEE and $e%logic under d#&'$O'E12. ORACLE_HOME would %e the installation irectory. (In y case d#&'$O'E12&). BI_DOMAIN* soeties called DOMAIN_HOME is O+,C-EO'E/user!ro0ects/doains/%i (in y case it is #&'$O'E12&user!ro0ects&doains&%i).
SDD (ingelton ata irectory) is O',INO'E/%idata (for one host installation). (In y case it is #&'$O'E12&user!ro0ects&doains&%i&%idata).
he catalog is located %y default at /serviceinstances/ssi/etadata/content/catalog (In y case it is #&'$O'E12&user!ro0ects&doains&%i&%idata&serviceinstances&ssi&etadata&content&catalog). he +e!ository is (sort of) in /serviceinstances&ssi&etadata&dataodel&custoi3ations (In y case it is #&'$O'E12&user!ro0ects&doains&%i&%idata&serviceinstances&ssi&etadata&dataodel&custoi3atio ns). he entire handling of +e!ository and Catalog is different in 12c and is handled via B,+ files. 'ore a%out it later.
•
•
Configuration files are located under BIO',IN/config/fwconfig/%iconfig (In y case #&'$O'E12&user!ro0ects&doains&%i&config&fwconfig&%iconfig) Each in it"s folder. For e4a!le# instaceconfig.4l is in BIO',IN/config/fwconfig/%iconfig/OBI5 N6Config.ini
in BIO',IN/config/fwconfig/%iconfig/OBI
LOGS: ,re in BIO',IN/servers* each in his folder. For e4a!le sawlog.log is under BIO',IN/servers/o%i!s1/logs. ,ll the logs are located in the sae !lace* including ,dinserver logs. Not only the logs are here. 7ou will found t!* cache and other folders as well.
Most executale scri!ts are located in BIO',IN/%itools/%in (#&'$O'E12&user!ro0ects&doains&%i&%itools&%in* in y case).
he start and sto! scri!ts are here and also the scri!t that collects diagnostic for Oracle u!!ort (diagnosticdu!.cd for $indows and diagnosticdu!.sh for -inu4). $e%-ogic cri!ting tool (wlst.cd / wlst.sh) is located in Oracleoe/oraclecoon/coon/%in (#&'$O'E12&oraclecoon&coon&%in in y case.)
24 (tt.deliver'i3'log$.ot3co3at 12c is using a local N in Online 'ode and Offline 'ode and not using the N,'IN on a windows achine. owever you can view the data in the ta%les within the +5( $eird huh) as it using the networ8 tnsnaes.ora
,nyway goto the OBIEE ,dinistration tool installation location and !aste a tnsnaes.ora file. te!s# goto the OBIEE ,dinistration tool installation location 9OBIEE Installation irectory:&Oracleoe&networ8 Create a irectory called adin hen within that !aste a valid tnsnaes.ora file. +estart the BI ,dinistration tool and everything wor8s as it should ie creating ta%les fro B.
;) htt!#//docs.oracle.co/iddleware/1221/core/BI'I<.!df
13 O.en t(e re.o$itor, in o5ine mode3 a3 C(ange to t(e )olloing director, on t(e 12c $,$tem *O!-I6HO!E'itool$'in Re.lace t(e *O!-I6HO!E it( t(e act&al *omain (ome on ,o&r 12c $,$tem3 '3 R&n t(e )olloing command $( data7model7cmd3$( donloadr.d 8& &name 8. .d 8o donloaded3r.d 8 r.d6.a$$ord 7SI $$i
W(ere9 7o i$ t(e o&t.&t R#* 7 r.d6.a$$ord i$ t(e R#* .a$$ord9 $a, -dmin12: c3 O.en t(e donloaded re.o$itor, o5ine in t(e BI -dmini$tration Tool9 (ic( ,o& in$talled it( t(e client in$taller3 23 Com.lete t(e )olloing $te.$ a3 From t(e !anage men& in t(e BI -dmini$tration Tool9 $elect ;aria'le$3 '3 In t(e ;aria'le !anager dialog9 )rom t(e -ction men&9 $elect Se$$ion9 t(en Initiali
&ired )or -&t(entication c(eck'o?3 e3 Click -..l, and $ave t(e re.o$itor,3 :3 O.en t(e re.o$itor, in online mode &$ing t(e &.loadr.d command3 *O!-I6HO!E'itool$'indata7model7cmd3$( &.loadr.d 8& &name 8. .d 8i donloaded3r.d 8 r.d6.a$$ord
No t e s :
I s pec i fi esnameoft her epo si t or y . W s pec i fi est her epos i t or y ’ spas swor d.
s pec i fi esav a l i du ser ’ snamet obeus edf o rOr a cl eBIEEaut hen t i c at i on. U s pe ci fi est h ep as s wo r dc or r e s po nd i n gt ot h eu se r ’ sna met h aty o us pe c i fi edf o rU. P s pe ci fi est henameoft hese r v i c ei ns t anc e. SI "o Sto! All Ser#ices Cd C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&%itools&%in C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&%itools&%in= sto!.cd >all "o $anuall% starting i$!ortant ser#ices First set doain environent then start we%logic E4ecute setoainEnv.cd Cd C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&setoainEnv.cd E4ecute start$e%-ogic.cd Cd C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i& start$e%-ogic.cd
$e%-ogic Console Fusion 'iddleware Control BI 5u%lisher isual ,naly3er BI ,nalytics
htt!#//?yourhost=#@A/console htt!#//?yourhost=#@A/e htt!#//?yourhost=#@A2/4l!server htt!#//?yourhost=#@A2/va tt!#//?yourhost=#@A2/analytics
OBIEE ne& !at' to executales an( scri!ts Start)Sto!)Status scri!ts
9O+,C-EO'E:/user!ro0ects/doains/%i/%itools/%in > sto!.sh D start.cd D start.cd Dstatus.cd
9O+,C-EO'E:/%i/li%/%i>%ar.0ar (CreateBI,rchive 0ava e4ecuta%le) 9O+,C-EO'E:/%i/%ifoundation/server/%in/ 9O+,C-EO'E:/%i/igration>tool/0li%/%i>igration>tool.0ar OBI11g to OBIEE12c igration tool.
OBI Ser#er* Sc'e(uler * ClusterController executales
Catalog $anager 9O+,C-EO'E:/user!ro0ects/doains/%i/%itools/%in/runcat.sh
+a#a'ost 9O+,C-EO'E:/%i/odules/oracle.%i.ca.o%i0h/startOBI.cd
+a#a a!!lications ,x$l!ser#er-ear* anal%tics-ear etc./ 9O+,C-EO'E:/%i/%ifoundation/0ee/
BI !resentation ser#ice executale
9O+,C-EO'E:/%i/%ifoundation/we%/%in/ sawserver
Re!ositor% file an( &e catalog 9O+,C-EO'E:/user!ro0ects/doains/%i/%idata/serviceinstances/ssi/etadata
Log files •
9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%is1/logs/
0elogic •
,dinistration erver# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers
'anaged erver# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers
•
S%ste$ Co$!onents OBI erver# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%is1/logs 5resentation erver#
•
9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%i!s1/logs Catalog 'anager#
•
/O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%i!s1/logs/cataloganager
o
cheduler# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%isch1/logs
o
avaost# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%i0h1/logs
o
ClusterController# 9O+,C-EO'E:/user!ro0ects/doains/%i/servers/o%iccs1/logs
OBIEE12c Log file locations OBIEE 12c 5resentation services log file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&systeco!onents&OBI5&o%i!s1&logs OBIEE 12c erver services log file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&systeco!onents&OBI&o%is1&logs ,dinerver>diagnostic.log C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&servers&,dinerver&logs&,dinerver> diagnostic.log %iserver1.log C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&servers&%iserver1&logs&%iserver1.log OBIEE12c Configuration file location: +oot BI Configuration directories e4ists at C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig OBIEE 12c BI erver configuration file location C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&OBI&N6Co nfig.ini OBIEE 12c 5resentation services configuration file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&OBI5&instanc econfig.4l OBIEE 12c ava services configuration file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&OBI&config. 4l OBIEE 12c cheduler ervices configuration file location#
C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&OBIC&sche dulerconfig.4l OBIEE 12c Cluster ervices configuration file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&OBICC& %i> cluster>config.4l OBIEE 12c 'etadata configuration file location# C#&F'$122&'iddleware&Oracleoe&user!ro0ects&doains&%i&config&fwconfig&%iconfig&etadata&conf ig.4l