Thursday May 30, 2013

Is Exachk available for Exalytics?

Is Exachck available for Exalytics?


Exachk is supported on Oracle Exalytics 'X' Series Machines (X2-4, X3-4, etc.), Release (image version and above.  This utility is currently not available for Exalytics T5-8 systems.

Reference: Oracle Exalytics Exachk Health-Check Tool (for Exalytics PatchSet 3 and Higher) (Doc ID 1566134.1) 

Thursday May 16, 2013

Is Essbase Server certified for Exalytics machine?

According to Exalytics certification matrix (oracle-exalytics-1x-1875875.xls), the Exalytics hardware is certified only for Essbase Server Is Essbase Server version certified with Exalytics?


If you are deploying the Essbase from EPM deployment mechanism (HIT), then it is already certified. The certification matrix will be updated accordingly soon.

Monday May 13, 2013

Exalytics: Loading Data From Oracle To TimesTen

There are three primary use cases for Exalytics/OBIEE/TimesTen:

1.    Normal BI use case

2.    DataMart use case

3.   Operational Data Store (ODS) use case

In terms of how TimesTen is used (1) is the most common case (maybe 70-80% of customers) and (2) and (3) are very similar to each other.

For (1), only aggregates are stored in TimesTen. These aggregates are recommended by the BI software based on the various reports and dashboards that have been configured there, the queries that BI generates as a result of them and the way the data is organised in the backend database. BI generates scripts to compute these aggregates and to load them into TimesTen. This is all completely controlled and managed by the BI software. We should not be getting involved in any recommendations relating to data loading for this aspect (since it is all under the control of BI and is closely coupled with who BI is setup and used). Any 'advice' for customers in this area is the job of BI SCs, BI consulting and maybe BI support. 

For (2) and (3) a subset of the backend database DataMart / ODS is typically loaded into TimesTen. This usually consists of one or more very large 'fact' tables plus a larger number of significantly smaller (but still often large in absolute terms) 'dimension' tables. The decision as to which tables need to be moved into TimesTen and what subset of the data is needed is still really driven by BI considerations and has to be carefully evaluated on a case by case basis. We should not get involved in that aspect; that is firmly the province of BI SCs / consultants to assist the customer with. Once the customer already nows the exact set of tables etc. that they want to move into TimesTen then we can potentially provide some advice, though again it should be in conjunction with the BI folk to ensure we are all aligned on the best option(s) for a given use case.

For initial data loading (initial population):

If the backend DB is non-Oracle then potential options are:

1.    Manual; create compatible TT schemas and create tables in TT, unload data from backend DB in a format that ttBulkCp can read, load data into TimesTen using ttBulkCp.

2.    Use OBIEE. This has some limited data loading capabilities.

3.    Use Oracle Data Integrator (if the backend DB is supported). This requires a license so it is not a free option.

4.    Use Oracle Datawarehouse Administration Console (DAC). This also requires a licence so is not a free option.

If the backend database is Oracle 10gR2 or later then there is an additional option:

5.    Use ttImportFromOracle to perform type mapping, data compression etc. and generate TT compatible DDL files to create the tables in Oracle. Use the (new) parallel data load feature of ttImportFromOracle (as from TT to load data to TT tables quickly and with high throughput.

For Oracle DB backends in general (5) would be the recommendation (since it is free and flexible) but customers may of course choose any of these options.

For incremental refresh loads:

Typically, once the initial population has been done then from time to time (might be hourly but more often daily or less frequently) there is a need to add new data to the TT datamart / ODS. Usually this is simply adding new data but sometimes it may also require updating existing data. Due to the limited capacity of memory there will also need to be a mechanism to periodically purge 'old' data.

This is a more complex area and as of today we do not have any really good solutions (but they are begin worked on). Post we hope to have some better options (but that is internal information not for external consumption at present). The two main challenges here are:

1.    All queries that originate from BI use table level locking for performance reasons. Thus they are incompatible leith any concurrent DML against the tables being queried.

2.    What does it mean anyway, in business terms, to run report and queries against data  that is changing (given that TimesTen does not support the same query consistency models as e.g. Oracle DB). 

So today options for incremental refresh require either:

a)    Some BI application downtime to allow the TT tables to be refreshed. This maybe can be selective if there are different sets of tables that can be refreshed together.

b)   Some form of double buffering whereby two copies of all relevant tables are maintained in TT. App runs against copy 1 while copy 2 is refreshed then app switches to copy 2. Later copy 1 can be refreshed and app switched back to copy 1 afterwards. Bi can support this but the memory requirements in TimesTen often make it impractical.

The 'tools' that can be used for this are pretty much the same as for initial loading…

For non-Oracle backend DBs:

1.    Manual; Unload data from backend DB in a format that ttBulkCp can read, load data into TimesTen using ttBulkCp. If anything other than INSERT is needed then may need top use staging tables and PL/SQL processing in TimesTen etc.

2.    Use Oracle Data Integrator (if the backend DB is supported). This requires a license so it is not a free option.

3.    Use Oracle Datawarehouse Administration Console (DAC).

DAC is free and supported for customers with license of any of the BI Applications.

If the backend database is Oracle 10gR2 or later then there is an additional option:

4.    Use the ttLoadFromOracle building to load data directly into the TT tables, or into staging tables for further processing using e.g. PL/SQL. The LoadData.sql script generated by ttImportFromOracle could be used as a basis to construct suitable scripts.

Friday May 10, 2013

Exalytics Backup and Recovery

Oracle Exalytics is an engineered system that comprises a number of hardware and software component.

The core software components include:

  1. OBIEE
  2. Timesten
  3. Weblogic Server
  4. Essabse

Optional components:

  1. Endeca
  2. Hyperion Planning
  3. Golden Gate
  4. Oracle Data Integrator
  5. DAC

This blog provides information to perform backup and recovery on the Exalytics Machine.

The backup procedure for OBIEE and Timesten is described in Exalytics Installation and Administration Guide

The references for backup procedures for other components can be found below:

Weblogic Server

Oracle Fusion Middleware Administrator's Guide 11g Release 1 (11.1.1)->
15.5.1 Backup and Recovery Recommendations for Oracle WebLogic Server


Note  589433.1 -Backup Methods for Essbase Databases
Note 583342.1 -Restore an Essbase Application From Backup


Note 1536707.1 -General Backup And Restore Procedures For An Endeca Information Discovery Deployment

Hyperion Planning:

Note 1195635.1 -How to Backup And Recover a Hyperion Planning Application

Golden Gate

Note 1465044.1 -Oracle GoldenGate ( OGG ) Recovery Techniques Main Note

Oracle Data Integrator (ODI)

Oracle Fusion Middleware Administrator's Guide 11g Release 1 (11.1.1)->
15.5.9 Backup and Recovery Recommendations for Oracle Data Integrator


Note 1332271.1 -How to restore Informatica admin console and informatica services as the infrep database crashed and moved to a different database host    

Note 735969.1 -Linux Directories/Filesystems to Backup to Recover from Catastrophic System Failure

Tuesday May 07, 2013

Exalytics Documentation Library

Link to access Exalytics documentation is :



Sunday May 05, 2013

Fusion Middleware Certification Matrix

Here is the link to download all the Fusion Middleware Certification (including Exalytics)



OBIEE Patch released bundle patch is now available for download from My Oracle Support for all platforms.

Bundled Patch Details:

  • Patch (1 of 7) Oracle Business Intelligence Installer (BIINST):
    Patch 16504136
  • Patch (2 of 7) Oracle Real Time Decisions (RTD):
    Patch 16504143
  • Patch (3 of 7) Oracle Business Intelligence Publisher (BIP):
    Patch 16504148
  • Patch (4 of 7) Oracle Business Intelligence ADF Components (BIADFCOMPS):
    Patch 16504154
  • Patch (5 of 7) Enterprise Performance Management Components Installed from BI Installer (BIFNDNEPM):
    Patch 16504156
  • Patch (6 of 7) Oracle Business Intelligence: (OBIEE):
    Patch 16427939
  • Patch (7 of 7) Oracle Business Intelligence Platform Client Installers and MapViewer:
    Patch 16504161

Please refer to the readme file on the Installer download for important installation instructions.




This Blog is for sharing the latest information regarding Exalytics and OBIEE


« May 2013 »