Based on some work we’ve been doing with our clients recently, we thought it would be helpful to write up Linux-based references to some (not all) common file paths that have changed between OBI11g and OBI12c and the basic new commands (Start/Stop/Status, RPD, Service Instance Backup) of Oracle BI 12c. Feel free to save this as a reference document for future Oracle BI 12c activities.
Some of the Basic Oracle BI 12c File Locations and Commands:
**Note these are based on a single application server environment not at scaled out environment.
/ORACLE_HOME /user_projects/domains/bi/bitools/bin ./stop.sh ./start.sh
With the above 2 commands, you can specifically start/ stop different services by utilizing the –i (lower case i) placing it directly after the cmd and then specifying the services you wish to start/stop
./stop.sh –i obis1,obisch1,obijh1,obiccs1,obips1 ./start.sh –i AdminServer,bi_server1,obis1,obips1 ./status.sh
./datamodel.sh downloadrpd -O /Directory/To/Save/OBI12c.rpd -SI ssi -U weblogic -P password
./datadmodel.sh uploadrpd -I /Directory/Of/Saved/OBI12c.rpd -SI ssi -U weblogic -P password
Common Log Files:
/ORACLE_HOME/user_projects/domains/bi/servers /AdminServer/logs/AdminServer.log /AdminServer/logs/AdminServer-diagnostic.log /AdminServer/logs/AdminServer.out /bi_server1/logs/bi_server1.log /bi_server1/logs/bi_server1-diagnostic.log /bi_server1/logs/bi_server1.out /OBIS1/logs/obis1-query.log /OBIS1/logs/obis1-diagnostic.log /OBIS1/logs/obis1.out /OBIPS1/logs/sawlog#.log /OBIPS1/logs/obips1.out
Common Configuration Files:
/biconfig/OBIPS/instanceconfig.xml /biconfig/OBIS/NQSConfig.ini /bienv/core/tnsnames.ora /bienv/core/odbc.ini /bienv/core/bi-environment.xml
WebLogic Scripting tool:
Export/Import Service Instance: (aka Service Instance Backup/Restore or Service Instance Migration)
Restore Backup of Instance:
Was this helpful? What other reference-able material would you like to have? Let us know in the comments.
EPM applications help measure the business performance. This post will help you choose the best EPM solutions for your organization’s needs and objectives.
It’s 2015 and you can now establish totally respectable MS SQL DBA credibility just by mentioning you have been in the game since SQL Server version 9. You may even get the same gasps of shock from some colleagues that used to be reserved for the version 6 veterans.