My Blog

Welcome to OBIEE 12c: File Locations

by Paul Cannon on 10th December 2015 6 comments

Under the covers there are a lot of changes to OBIEE 12c, not least of which is the locations of the various files used by OBIEE. Most you don’t really need to know about, but there are quite a few which are really useful – to help with backup & restores, scanning log files when you encounter errors, some configuration files that may need manual editing.

This list is by no means exhaustive, but here are the locations of the most commonly used files (well, most commonly used by me anyway…)

In all cases below <obiee_home> refers to the location where OBIEE was installed, in my case /u01/app/obiee/

File Locations of most commonly used files in OBIEE 12c:

Common scripts bin directory.  This contains the start, stop & status scripts along with the data-model-cmd script for common tasks such as uploading/downloading repositories, updating application roles & users & setting repository variables plus many other utility scripts:

<obiee_home>/u01/app/obiee/user_projects/domains/bi/bitools/bin

Weblogic scripting tool – wlst.sh – used for perform backups of the BI content (to ‘bar’ files) and other weblogic tasks:

<obiee_home>/u01/app/obiee/oracle_common/common/bin

Service Instances. Where the metadata for each installed BI instance is stored. There is one sub-directory for each instance and if you just performed a basic install there will just be one directory, probably called ‘ssi’

<obiee_home>/user_projects/domains/bi/bidata/service_instances

Repository (RPD) files. These are kept beneath the Service Instances directory. Note you cannot directly edit these – or copy them down to your pc and edit them there. You must use the data-model-cmd to upload/download them:

<obiee_home>/user_projects/domains/bi/bidata/service_instances/ssi/metadata/datamodel/customizations

Web Catalog.  Where the dashboards, reports, prompts and all other user content is stored, along with some catalog config files. The structure of these directories is identify to OBIEE 11g, starting with root, then shared, users etc..

<obiee_home>/user_projects/domains/bi/bidata/service_instances/ssi/metadata/content/catalog

instanceconfig.xml. Normally you shouldn’t edit this file directly, you should use the mbean browser in enterprise manager, but there are occasions when you might need to.

<obiee_home>/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml

NQSConfig.INI. Again normally you shouldn’t edit this file directly, you should use the mbean browser in enterprise manager, but there are occasions when you might need to.

<obiee_home>/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS/NQSConfig.INI

obis.properties. This file can be used to define environment variables for OBI.

<obiee_home>/user_projects/domains/bi/config/fmwconfig/bienv/OBIS/obis.properties

config.xml. Security file containing, amount other items, the security realm details from weblogic – really handy if you have a LDAP issue and weblogic won’t start!

<obiee_home>/user_projects/domains/bi/config

fmwconfig. This is a folder contain many security files – system-jazn-data.xml, various SSO, wallet and other security config files.

<obiee_home>/user_projects/domains/bi/config/fmwconfig

xmlp-server-config.xml Configuration file for BI Publisher and the Mobile App Designer.

<obiee_home>//user_projects/domains/bi/bidata/components/bipublisher/repository/Admin/Configuration/xmlp-server-config.xml

odbc.ini, odbcinst.ini & tnsnames.ora.  All three of the data source connection files are located together:

<obiee_home >/user_projects/domains/bi/config/fmwconfig/bienv/core

odbc template files – useful for copying the basic config for new data sources into the actual odbc files used by OBIEE above:

<obiee_home >/bi/common/ODBC/Merant/7.1.4

Log files.  There are still separate log files for the five BI components and the Admin & BI managed services within weblogic, but there are now all located together in the same area.

AdminServer Managed Service logs:

<obiee_home>/user_projects/domains/bi/servers/AdminServer/logs

bi_server1 Managed Service logs:

<obiee_home>/user_projects/domains/bi/servers/bi_server1/logs

BI Server logs:

<obiee_home>/user_projects/domains/bi/servers/obis1/logs

Presentation server logs:          

<obiee_home>/user_projects/domains/bi/servers/obips1/logs

Java Host logs:

<obiee_home>/user_projects/domains/bi/servers/obijh1/logs

Cluster Component logs:

<obiee_home>/user_projects/domains/bi/servers/obiccs1/logs

Scheduler logs:

<obiee_home>/user_projects/domains/bi/servers/obisch1/logs

Enjoy!

READ MORE:

Paul CannonWelcome to OBIEE 12c: File Locations

6 comments

Join the conversation
  • Gary - 19th October 2016 reply

    Would you know where the log settings are for each of the logs you mentioned here? I want to control the log size and purging frequency.

    Paul Cannon - 26th October 2016 reply

    Gary,

    you can play with the log configuration in the enterprise manager. go to the business intelligence biiinstance page, then you want the diagnostics > log configuration tab.

    Paul.

  • sathya - 16th December 2016 reply

    Hi guys,
    I need to know how to take backup bar file and catalog file without using manual method
    please let me know and revert me as same
    Regards
    sathya

    Paul Cannon - 19th December 2016 reply

    Sathya,

    I blogged about this earlier in the year: http://www.redstk.com/welcome-to-obiee12c-scripting-bat-file-backups/

    Paul.

  • Shreyansh Shah - 30th August 2017 reply

    This blog series is really helpful and we installed OBIEE12c (12.2.1.2.0) successfully using this.

  • Monica - 9th November 2017 reply

    Please where is the location for sqlnet.ora file

Join the conversation