NOTE: It is recommended to set up all Oracle BI Application tiers in the same local area network.
Installation of any of these tiers over WAN may cause timeouts during ETL mappings execution on the ETL tier
Installation of any of these tiers over WAN may cause timeouts during ETL mappings execution on the ETL tier
Tiers
| Machine Summary | ||||
| Tier | machine name | User Name | IP Address | |
| 1 | OBIA DW Tier | OBIADW | oracle | |
| 2 | OBIA ETL Tier | OBIAETL | oracle | |
| 3 | OBIA Presentation Tier | OBIEE | oracle | |
| 4 | OBIA Client Tier | WIN | xxx | |
| Business Analytics Warehouse
|
|
| Machine Specification | |
| M5000 SPARC VII - Core Factor - 0.75
16 GB RAM 2 cores Sun Solaris 10 (64-bit) Disk 400 GB |
|
| Software | |
| 1. Oracle Database 11g EE 11.2.0.1 ( with patch 9739315 applied and 9255542 is bug not a patch) |
| ETL Server | |
| Machine Specification | |
| SPARC T3 - Core Factor 0.25
4 GB RAM 8 cores Sun Solaris 10 (64-bit) Disk 100 GB |
|
| Software | |
| 1. DB Client 11.2.0.1.0 for Solaris
2. DAC Server 10.1.3.4.1 Patch 12381656 applied 3. Informatica Server - Powercenter 9.0.1 Hotfix 2 4. Java Platform Standard Edition (Java SE) Development Kit (JDK) 6 (1.6.0_05) |
| ETL Client | |
| Machine Specification | |
| 3 GB RAM 2 quad cores
Windows XP Professional SP3 (32 bit) Disk 1 TB |
|
| Software | |
| 1. Oracle Business Intelligence Developer Client Tool (MS Win 32 bit) 11.1.1.5.0
2. Oracle Database Client 11g EE 11.2.0.1 3. Informatica Client - PowerCenter 9.0.1 Hotfix 2 4. Informatica Services - PowerCenter 9.0.1 Hotfix 2 5. DAC Client 10.1.3.4.1 Patch 12381656 applied |
| Presentation Server | |
| Machine Specification | |
| SPARC T3 - Core Factor 0.25
8 GB RAM 8 cores Sun Solaris 10 (64-bit) (Update 8+) Disk 50 GB |
|
| Software | |
| 1. Oracle Business Intelligence Enterprise Edition 11.1.1.5.0
NOTE: certified with Oracle DB: - Oracle 10.2.0.4+ - Oracle 11.1.0.7+ - Oracle 11.2.0.1+ 2. BI Apps 7.9.6.3 repository and Catalog deployed |
