Friday, 30 October 2015


OBIEE 12 Commands and File Locations etc

OBIEE 12 Commands / Locations - Will keep Adding them

Uploading and Downloading an RPD for Offline Editing

Before Uploading and Download an RPD .

First of all get your service key ( You need to open the wlst Weblogic Scripting Tool)

weblogic offline


Once Logged in run the following

List Service Instances


Once you have the service Key (" my key was "ssi" ... must be default)

Run the following to upload and download RPD (Call RPD what you Like)

Location of BITOOLS : Most RPD Commands 


Download Command : 
sh downloadrpd -O myrpd.rpd -W Admin123 -SI ssi -U weblogic -P weblogic123

Upload Command :
sh uploadrpd -I myrpd_new.rpd -W Admin123 -SI ssi -U weblogic -P weblogic123

You will get completion messages after uploading and downloding such as Success !!

OBIEE 12 TNS Location for Oracle DB


Place your tnsnames.ora in the location above and run the ./  from bitools directory then ./ to bounce all services.

File Locations (SSI can vary dependent upon Serviceinstance)

NQS Config.INI




RPD - Datamodel


Log Files


High-level Directory Structure

  • Oracle BI Domain Home: /.../Oracle_Home/user_projects/domains/bi
  • Single Data Directory (SDD): /.../Oracle_Home/user_projects/domains/bi/bidata
  • Lifecycle Management / Process Control Scripts: /.../Oracle_Home/user_projects/domains/bi/bitools/bin

File Location  References:

Where are the start / stop / status  and lifecyle management scripts located?

  • ORACLE_HOME/user_projects/domains/bi/bitools/bin - / start.cmd | / start.cmd | 

  • sh (Will Start weblogic , managed servers , OBIEE and all Components)
  • (Will Stop weblogic , managed servers , OBIEE and all Components)
  • Individual Components same commands as above ie . -i obis1,obips1
  • / status.cmd  [use -h for syntax help]
  • ORACLE_HOME/bi/migration-tool/jlib/bi-migration-tool.jar (11g to 12c migration tool)
  • ORACLE_HOME/bi/lib/bi-bar.jar (CreateBIArchive java executable)

You may also continue to use Enterprise Manager Fusion Middleware Control and Weblogic Console.
  • Using Commands to Stop, Start, and View Status of Oracle Business Intelligence Processes
  • Using Fusion Middleware Control to Start and Stop System and Java Components
  • Using Fusion Middleware Control to Start and Stop Java Components
  • Using Oracle WebLogic Server Administration Console to Start and Stop Java Components
  • Viewing the Status of Oracle Business Intelligence Components in a Domain

Where are the common configuration and script files located?

Configuration files are no longer duplicated. Separate configuration files still exist for example, for Oracle BI Presentation Services and BI Server, but they are not duplicated in the case of a cluster.
  • Weblogic configuration
    • /.../ORACLE_HOME/user_projects/domains/bi/config/config.xml
    • /.../ORACLE_HOME/user_projects/domains/bi/bin/
  • JDBC Data Sources
    • /.../ORACLE_HOME/user_projects/domains/bi/config/jdbc/..
  • Weblogic Scripting Tool (WLST)
    • /.../ORACLE_HOME/oracle_common/common/bin/
  • RCU
    • /.../ORACLE_HOME/oracle_common/bin/rcu
  • Table and Schema DDL/SQL
    • /.../ORACLE_HOME/oracle_common/common/sql/biplatform

  • Sample Application XML data files
    • /.../Oracle_Home/bi/bifoundation/server/samples/SampleAppLite/sample/SampleAppFiles/Data
  • Core BI Domain
    • /.../Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/core/ bi-config.xml | bienv-components.xml | tnsnames.ora | odbc.ini
  • OBI Server (nqsserver)
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIS/NQSConfig.INI
  • Presentation Server (sawserver)
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIPS/instanceconfig.xml
    • /.../ORACLE_HOME/bi/bifoundation/web/schemas/*.xsd
    • /.../ORACLE_HOME/bi/bifoundation/web/display/authenticationschemas.xml
    • /.../ORACLE_HOME/user_projects/domains/bi/bidata/components/OBIPS/customMessages (for custom xml messaging)
  • ClusterController
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBICC/bi-cluster-config.xml
    • /.../Oracle_Home/user_projects/domains/bi/config/fmwconfig/biconfig/core/ClusterConfig.xml
  • Scheduler
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBISCH/schedulerconfig.xml
  • JavaHost
    • /.../ORACLE_HOME/bi/modules/  -- 17.2.1 Increasing Heap Size to Assist in Exports to Excel
    • /.../ORACLE_HOME/bi/modules/ (sourced, not executed -- see
    • /.../ORACLE_HOME/user_projects/domains/bi/config/fmwconfig/biconfig/OBIJH/config.xml

Where are the BI Executables?

  • OBI Server | Scheduler | ClusterController: /.../ORACLE_HOME/bi/bifoundation/server/bin/ nqsserver | nqscheduler | nqsclustercontroller 
  • PS: /.../ORACLE_HOME/bi/bifoundation/web/bin/ sawserver | catalogmanager | sawrepaj -deprecated
  • JavaHost: /.../ORACLE_HOME/bi/modules/
  • Catalog Manager CLI: /.../Oracle_Home/user_projects/domains/bi/bitools/bin/
  • RDA: /../oracle_common/rda

Where are the JEE apps?

  •  /.../Oracle_Home/bi/bifoundation/jee/ analytics.ear | xmlpserver.ear | bimad.ear | bisearch.ear | jbips.ear | bicustom.ear | ...

Where are the RPD and catalog located?

  • /.../ORACLE_HOME/user_projects/domains/bi/bidata/service_instances/ssi/metadata (ssi is the default service instance and only one supported in 12.2.1)

Where are the common diagnostic logs located?

  • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/logs/FineGrainedLogDir (on-line RPD udxml logs)
  • Weblogic
    • Administration Server: /.../ORACLE_HOME/user_projects/domains/bi/servers
    • Managed Server: /.../ORACLE_HOME/user_projects/domains/bi/servers
  • System Components
    • OBI Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/logs - obis1.out | obis1-diagnostic.log | obis1-query.log | oracle_BiServerXmlGen.log | oracle_nQSecUDMLGen.log
    • Presentation Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/logs - sawlog0.log | obips1.out | webcateupgrade0.log | upgrade-[date stamp].log
      • Catalog Manager: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/logs/catalogmanager - catalogmanager.0.0.log
    • Scheduler: /.../ORACLE_HOME/user_projects/domains/bi/servers/obisch1/logs - nqscheduler.log | obisch1.out
    • JavaHost: /.../ORACLE_HOME/user_projects/domains/bi/servers/obijh1/logs - jh.log | obijh1.out
    • ClusterController: /.../ORACLE_HOME/user_projects/domains/bi/servers/obiccs1/logs - nqcluster.log | obiccs1.out

Where are the common temporary | temp | tmp directories and cache located?

  • System Components
    • OBI Server:
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/tmp
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/tmp/obis_temp
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/cache
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obis1/MDXCache
      • Global Cache - no default, user defined
    • Presentation Server: /.../ORACLE_HOME/user_projects/domains/bi/servers/obips1/tmp
    • Scheduler: /.../ORACLE_HOME/user_projects/domains/bi/servers/obisch1/tmp
    • JavaHost:
      • /.../ORACLE_HOME/user_projects/domains/bi/servers/obijh1/tmp
      • /.../ORACLE_HOME/user_projects/domains/bi/system_components/OBIJH/obijh1/tmp
      • other as defined in JavaHost configuratoin file (e.g. ramdisk)

Over and Out 

Shahed M and Krishna M

Blog Archive

About Authors

Shahed Munir

Krishna Udathu

Shahed and Krishna are Oracle / Big Data Experts