P6 Reporting Database Tested Configurations
Release Version: 3.0.0.0
Date: December 2011


This document lists the configurations that have been tested for the P6 Reporting Database 3.0.0.0 release.

Databases

The following table lists the combinations of databases and database server platforms that have been tested with the P6 Reporting Database (version 3.0.0.0) application.

PMDB Database

Collation Page/Locale

Database Server Platform

Microsoft SQL Server 2005 sp4

Microsoft SQL Server 2008 R2 sp1

  • Chinese/PRC
  • English
  • French
  • German
  • Japanese
  • Spanish
  • Russian
  • Brazilian Portuguese
  • Italian
  • Windows 2003 Server R2 sp2
  • Windows 2008 R2 sp1

Oracle 10.2.0.5

Oracle 11.2.0.2

Oracle 11.2.0.3

  • UTF8
  • Western European (WE8MSWIN1252)
  • AL32UTF8
  • Oracle Enterprise Linux 5.3, 6.0 and 6.1
  • Solaris 10 SPARC (64 bit)(English only)
  • IBM AIX 6.1.7.0 (64 bit)(English only)
  • HP Itanium
  • Windows 2008 Server R2 sp1
  • Windows 2003 Server R2 sp2

 

Data Warehouse (ODS, and STAR) are Oracle Only.

ODS, and STAR Databases

Collation Page/Locale

Database Server Platform

Oracle 10.2.0.5*

Oracle 11.2.0.2*

Oracle 11.2.0.3*

  • UTF8
  • Western European (WE8MSWIN1252)
  • Oracle Enterprise Linux 5.3, 6.0 and 6.1
  • Solaris 10 SPARC (64 bit)(English only)
  • IBM AIX 6.1.7.0 (64 bit)(English only)
  • HP Itanium  
  • Windows 2008 Server R2 sp1
  • Windows 2003 Server R2 sp2

*Please see P6 Reporting Database Planning and Sizing Guide for more details on recommendations regarding use of Oracle Enterprise Edition and Oracle Standard Edition Databases.

OBIEE Version

OBIEE 11.1.1.5 and 11.1.1.6 are supported for Reporting Database 3.0 and Analytics 2.0.  OBIEE 10g is not supported.

Languages

Tested with the following core languages:

Languages

  • English
  • French
  • German
  • Japanese
  • Simplified Chinese
  • Traditional Chinese
  • Spanish
  • Russian
  • Brazilian Portuguese
  • Italian

JREs 

Tested with the following JREs:

Operating System

JRE

Oracle Enterprise Linux 5.0 and 6.0

Solaris 10 SPARC (64 bit)(English only)

Windows 2008 Server R2 sp1

Windows 2003 Server R2 sp2

 

  • Sun Java Runtime Engine 1.6.0_27
  • Sun Java Runtime Engine 1.6.0_27

 

IBM AIX 6.1(64 bit)(English only)

  • IBM JRE 1.6.0 SR 7

HP-UX Itanium

  • HP Java 2 JDK version 6.0 update 6 (1.6.0_06)   
  • JRE 1.6.0.07

 

Copyright © 2008, 2011 Oracle and/or its affiliates. All rights reserved.