System Requirements & Supported Platforms For Oracle Business .

Transcription

System Requirementsand Supported Platformsfor Oracle BusinessIntelligence ApplicationsVersion 7.9.6, Rev. JJanuary 2011

Part Number: E14221-11Copyright 2009, 2011, Oracle and/or its affiliates. All rights reserved.This software and related documentation are provided under a license agreement containing restrictionson use and disclosure and are protected by intellectual property laws. Except as expressly permitted inyour license agreement or allowed by law, you may not use, copy, reproduce, translate, broadcast,modify, license, transmit, distribute, exhibit, perform, publish, or display any part, in any form, or by anymeans. Reverse engineering, disassembly, or decompilation of this software, unless required by law forinteroperability, is prohibited.The information contained herein is subject to change without notice and is not warranted to be errorfree. If you find any errors, please report them to us in writing.If this software or related documentation is delivered to the U.S. Government or anyone licensing it onbehalf of the U.S. Government, the following notice is applicable:U.S. GOVERNMENT RIGHTS Programs, software, databases, and related documentation and technicaldata delivered to U.S. Government customers are "commercial computer software" or "commercialtechnical data" pursuant to the applicable Federal Acquisition Regulation and agency-specificsupplemental regulations. As such, the use, duplication, disclosure, modification, and adaptation shallbe subject to the restrictions and license terms set forth in the applicable Government contract, and, tothe extent applicable by the terms of the Government contract, the additional rights set forth in FAR52.227-19, Commercial Computer Software License (December 2007). Oracle USA, Inc., 500 OracleParkway, Redwood City, CA 94065.This software is developed for general use in a variety of information management applications. It is notdeveloped or intended for use in any inherently dangerous applications, including applications which maycreate a risk of personal injury. If you use this software in dangerous applications, then you shall beresponsible to take all appropriate fail-safe, backup, redundancy, and other measures to ensure the safeuse of this software. Oracle Corporation and its affiliates disclaim any liability for any damages causedby use of this software in dangerous applications.Oracle is a registered trademark of Oracle Corporation and/or its affiliates. Other names may betrademarks of their respective owners.This software and documentation may provide access to or information on content, products, andservices from third parties. Oracle Corporation and its affiliates are not responsible for and expresslydisclaim all warranties of any kind with respect to third-party content, products, and services. OracleCorporation and its affiliates will not be responsible for any loss, costs, or damages incurred due to youraccess to or use of third-party content, products, or services.

ContentsSystem Requirements and Supported Platforms for Oracle Business Intelligence Applications 1Chapter 1:IntroductionWhat’s New in Systems Requirements and Supported Platforms for Oracle BusinessIntelligence Applications, Version 7.9.6, Rev. J 5What’s New in Systems Requirements and Supported Platforms for Oracle BusinessIntelligence Applications, Version 7.9.6, Rev. I 6Oracle Business Intelligence Applications DocumentationChapter 2:6Platform Requirements for Oracle BusinessIntelligence ApplicationsOracle Business Intelligence Infrastructure Requirements7Oracle Business Intelligence Data Warehouse Administration Console (DAC)Requirements 8Informatica PowerCenter RequirementsHardware Requirements88Client and Server Environment Requirements9Supported Client and Server Operating Systems 9Support for Virtualization and Virtual Machines 11Supported Databases13Supported Databases for Oracle Business Analytics Warehouse 14Supported Databases for Oracle Business Intelligence Data Warehouse AdministrationConsole Repository 17Supported Databases for Informatica PowerCenter Repositories 17Supported Source Systems17Available Languages for Oracle Business Intelligence Applications SoftwareChapter 3:22Supported Software and Ancillary ProgramsAncillary Programs for Oracle Business Intelligence ApplicationsInformatica OEM PowerCenter Version 8.62526System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J3

Contents nChapter 4:Upgrade ConsiderationsChapter 5:Planned CertificationPlanned Certification for Oracle Business Intelligence Infrastructure 31Planned Certification for Databases for Oracle Business Analytics Warehouse431System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

1IntroductionThis book contains the definitive list of system requirements and supported platforms for Release7.9.6.0, 7.9.6.1 and 7.9.6.2 of Oracle Business Intelligence Applications.Topics in this chapter include the following:nWhat’s New in Systems Requirements and Supported Platforms for Oracle Business IntelligenceApplications, Version 7.9.6, Rev. JnWhat’s New in Systems Requirements and Supported Platforms for Oracle Business IntelligenceApplications, Version 7.9.6, Rev. InOracle Business Intelligence Applications DocumentationnOracle Business Intelligence Applications DocumentationWhat’s New in Systems Requirements and SupportedPlatforms for Oracle Business Intelligence Applications,Version 7.9.6, Rev. JTable 1.Changes in Systems Requirements and Supported Platforms for Oracle BusinessIntelligence Applications, Version 7.9.6, Rev. JTopicDescriptionSupported Source SystemsUpdated Table 9 on page 18 to include Oracle eBusinessSuite R12.1.3 as a supported source system for OracleBusiness Intelligence Applications version 7.9.6.2.System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J5

Introduction n Oracle Business Intelligence Applications DocumentationWhat’s New in Systems Requirements and SupportedPlatforms for Oracle Business Intelligence Applications,Version 7.9.6, Rev. ITable 2.Changes in Systems Requirements and Supported Platforms for Oracle BusinessIntelligence Applications, Version 7.9.6, Rev. ITopicDescriptionOracle Business IntelligenceInfrastructure RequirementsUpdated section “Oracle Business Intelligence InfrastructureRequirements” on page 7 to clarify support and certificationstatements for Oracle Business Intelligence EnterpriseEdition version 11.1.1.3.0 and Oracle Business IntelligenceApplications.Also corrected a typographical error in the version numberfor Oracle Business Intelligence Enterprise Edition version10.1.3.4.1.Planned Certification for OracleBusiness Intelligence EnterpriseEdition version 11.1.1.4.0Updated Planned Certification on page 31 to includecertification plans for Oracle Business IntelligenceEnterprise Edition version 11.1.1.4.0 with Oracle BusinessIntelligence Applications.Oracle Business IntelligenceApplications DocumentationDocumentation for Oracle Business Intelligence Applications is available on Oracle TechnologyNetwork (OTN).To access Oracle Business Intelligence Applications Documentation on OracleTechnology NetworkGo to the Oracle Business Intelligence Applications Documentation Library -foundation/documentation/bi-apps098545.htmlThe latest revision of this document is included in the Documentation Library for this release ofOracle Business Intelligence Applications.6System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

2Platform Requirements forOracle Business IntelligenceApplicationsThis chapter describes all of the supported environments under which Oracle Business IntelligenceApplications operate correctly. It includes information about hardware and software requirements,as well as globalization requirements, and the following topics:nOracle Business Intelligence Infrastructure RequirementsnOracle Business Intelligence Data Warehouse Administration Console (DAC) RequirementsnInformatica PowerCenter RequirementsnHardware RequirementsnClient and Server Environment RequirementsnSupport for Virtualization and Virtual MachinesnSupported DatabasesnSupported Source SystemsnAvailable Languages for Oracle Business Intelligence Applications SoftwareOracle Business IntelligenceInfrastructure RequirementsOracle Business Intelligence Applications versions 7.9.6.0, 7.9.6.1 and 7.9.6.2 are supported onOracle Business Intelligence Enterprise Edition version 10.1.3.4.1.Oracle Business Intelligence Applications 7.9.6.0, 7.9.6.1 and 7.9.6.2 are also supported on OracleBusiness Intelligence Enterprise Edition 11g version 11.1.1.3.0, but this combination has not yetbeen certified. Customers considering the use of Oracle Business Intelligence Enterprise 11.1.1.3.0with Oracle Business Intelligence Applications should review Document 1196943.1 on My OracleSupport (http://support.oracle.com).The Oracle Business Intelligence Applications Installer requires a complete installation of OracleBusiness Intelligence Enterprise Edition 10.1.3.4.1 infrastructure on the machine where you will runthe installer. For more information, see Oracle Business Intelligence Applications Installation Guide.NOTE: Oracle Business Intelligence Applications is also supported on Oracle Business IntelligenceStandard Edition One. You must upgrade the Oracle Business Intelligence components of Oracle BIStandard Edition One to version 10.1.3.4.1 by running the Oracle Business Intelligence EnterpriseEdition Installer. Note further that Oracle Database SE1, included with Oracle BI Standard EditionOne, does not support the features that are required for Oracle Business Intelligence Applications,and so does not meet the pre-requisite without a separate supported database to be used as theOracle Business Analytics Warehouse. For information on the supported databases for the OracleBusiness Analytics Warehouse, see “Supported Databases for Oracle Business Analytics Warehouse” onpage 14System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J7

Platform Requirements for Oracle Business Intelligence Applications n OracleBusiness Intelligence Data Warehouse Administration Console (DAC) RequirementsOracle Business Intelligence DataWarehouse Administration Console(DAC) RequirementsOracle Business Intelligence Applications 7.9.6.0 and 7.9.6.1 support Oracle Business IntelligenceData Warehouse Administration Console (DAC) platform version 10.1.3.4.1. with minimum Patch9179169.Oracle Business Intelligence Applications 7.9.6.2 supports Oracle Business Intelligence DataWarehouse Administration Console (DAC) platform version 10.1.3.4.1. with Patch 10052370.The DAC patches are available for download on the Patches and Updates tab on My Oracle Supportat http://support.oracle.com.For information on the system requirements and supported platforms for the Oracle BusinessIntelligence DAC Client and Server, see Systems Requirements and Supported Platforms Guide forOracle Business Intelligence Data Warehouse Administration Console. This guide is included in theDocumentation Library for Oracle Business Intelligence Data Warehouse Administration Console onOracle Technology Network.Informatica PowerCenter RequirementsOracle Business Intelligence Applications version 7.9.6.0 supports Informatica PowerCenter 8.6.0HotFix 4, Informatica PowerCenter 8.6.1 HotFix 10 and Informatica PowerCenter 8.6.1 HotFix 11.Oracle Business Intelligence Applications version 7.9.6.1 supports Informatica PowerCenter 8.6.1HotFix 6, Informatica PowerCenter 8.6.1 HotFix 10 and Informatica PowerCenter 8.6.1 HotFix 11.Oracle Business Intelligence Applications version 7.9.6.2 supports Informatica PowerCenter 8.6.1HotFix 11.NOTE: Customers using Informatica PowerCenter 8.6.1 HotFix 10 should be aware of the issueidentified in Support Note 1135110.1 available on My Oracle Support (http://support.oracle.com).Oracle recommends upgrading to Informatica PowerCenter 8.6.1 HotFix 11.NOTE: Emergency Bug Fix (EBF) 211261 and 214715 are required with Informatica PowerCenter8.6.1 HotFix6 if the Oracle Business Analytics Warehouse is on either Teradata or MicroSoft SQLServer.Hardware RequirementsThis section describes the hardware and network requirements for Oracle Business IntelligenceApplications versions 7.9.6.0, 7.9.6.1 and 7.9.6.2. Oracle has certified acceptable performance inthese environments; however, performance is improved by using faster processors and additionalmemory, particularly in environments where users run multiple applications simultaneously.8System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

Platform Requirements for Oracle Business Intelligence Applications n Client andServer Environment RequirementsTable 3 describes the minimum requirements for Oracle Business Intelligence Applications.Table 3.Minimum Requirements for Oracle Business Intelligence ApplicationsDescriptionRequirementOracle Business Analytics WarehouseCPU:2 GHz or better, 8 CPU cores minimumRAM:8 GBETL Client (Oracle Business Intelligence DataWarehouse Administration Console Client andInformatica PowerCenter Client Tools)CPU:1 GHz or betterRAM:1 GBETL Server (Oracle Business Intelligence DataWarehouse Administration Console Server andInformatica PowerCenter Services)CPU:2 GHz or better, 4 CPU cores minimumRAM:8 GBStorage Space:100 GB free spaceClient and Server EnvironmentRequirementsThis section contains information about the supported client and server operating systems for OracleBusiness Intelligence Applications versions 7.9.6.0, 7.9.6.1 and 7.9.6.2.Supported Client and Server Operating SystemsInformatica PowerCenter supports the client and server operating systems listed in Table 4.Since Oracle Business Intelligence Applications requires that Oracle Business Intelligence DataWarehouse Administration Console (DAC) be co-located with Informatica PowerCenter, the operatingsystems listed in Table 4 are also the supported operating systems for Oracle Business IntelligenceData Warehouse Administration Console Client and Server components.System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J9

Platform Requirements for Oracle Business Intelligence Applications n Client andServer Environment RequirementsTable 4.Supported Client and Server Operating Systems for Informatica PowerCenter and OracleBusiness Intelligence Data Administration ConsoleComponent TypeOperating SystemInformatica PowerCenter ServicesHP-UX 11.11 (32-bit and 64-bit), 11.23 (32-bit and 64-bit).Processor: PA-RISC(Oracle Business Intelligence DataWarehouse Administration ConsoleServer version 10.1.3.4.1)HP-UX 11.23 (64-bit), 11.31 (64-bit). Processor: Itanium1IBM AIX 5L versions 5.2 (32-bit and 64-bit), 5.3 (32-bit and64-bit). Processor: Power2IBM AIX 6.1 (64-bit)3. Processor: Power2Microsoft Windows 2000 Server (32-bit), 2003 Server (32bit). Processor: x86Microsoft Windows 2003 Server (64-bit). Processor: x64(Opteron and EM64T), ItaniumMicrosoft Windows 2008 Server R1 (32-bit)3. Processor:x864Microsoft Windows 2008 Server R1 (64-bit)3. Processor:x64(Opteron and EM64T)4, Itanium5Novell SUSE Linux Enterprise Server 9 with minimum kernel2.6 (32-bit)6. Processor: x86Novell SUSE Linux Enterprise Server 9 with minimum kernel2.6 (64-bit)6. Processor: x64 (Opteron and EM64T)Oracle Enterprise Linux 4 Update 4 or higher with minimumkernel 2.6 (32-bit). Processor: x86Oracle Enterprise Linux 4 Update 4 or higher with minimumkernel 2.6 (64-bit). Processor: x64 (Opteron and EM64T),ItaniumOracle Enterprise Linux 5.x (32-bit)3. Processor: x86Oracle Enterprise Linux 5.x (64-bit)3. Processor: x64(Opteron and EM64T), ItaniumRed Hat Enterprise Linux 4 with minimum kernel 2.6 (32bit). Processor: x86Red Hat Enterprise Linux 4 with minimum kernel 2.6 (64bit). Processor: x64 (Opteron and EM64T), Itanium10System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

Platform Requirements for Oracle Business Intelligence Applications n Client andServer Environment RequirementsTable 4.Supported Client and Server Operating Systems for Informatica PowerCenter and OracleBusiness Intelligence Data Administration ConsoleComponent TypeOperating SystemInformatica PowerCenter ServicesRed Hat Enterprise Linux 5.2 or higher (32-bit)3. Processor:x86(Oracle Business Intelligence DataWarehouse Administration ConsoleServer version 10.1.3.4.1)Red Hat Enterprise Linux 5.2 or higher (64-bit)3. Processor:x64 (Opteron and EM64T), ItaniumSun Solaris versions 8, 9, 10 (32-bit and 64-bit). Processor:SPARCSun Solaris 10 (64-bit). Processor: x64 (Opteron andEM64T)Informatica PowerCenter Client ToolsMicrosoft Windows 2000 SP4 (32-bit)(Oracle Business Intelligence DataWarehouse Administration ConsoleClient version 10.1.3.4.1)Microsoft Windows 2003 Server (32-bit)Microsoft Windows 2008 Server R13 (32-bit)Microsoft Windows XP Professional (32-bit)Microsoft Vista Business/Enterprise SP1 or higher (32-bit)Microsoft Windows 771.HP-UX 11.23 Itanium 64-bit systems require Patch PHSS 33349 or higher.2.POWER7 is not supported.3.Not supported for Informatica PowerCenter 8.6.0 HotFix 4.4.Informatica PowerCenter Services on either Windows 2008 x86 or Windows 2008 x64 is not supported for Source database, OracleBusiness Analytics Warehouse (Target), and Informatica metadata and Domain Repositories on Oracle 11g or IBM DB2 8.2.Informatica PowerCenter Services on Windows 2008 x86 and x64 are not supported for the Oracle Business Analytics Warehouseon Teradata v13.5.Windows 2008 Itanium is supported for Informatica PowerCenter Services only for Source database, Oracle Business AnalyticsWarehouse (Target), and Informatica metadata and Domain Repositories on MS SQL Server 2000, 2005, 2008.6.Requires glibc libraries (libstdc .so.6) prior to Informatica 8.6 installation. Available 5892a565af183b0f83eeaeb62ad.html7.Supported with Informatica PowerCenter 8.6.1 HotFix 11.Support for Virtualization and Virtual MachinesOracle Business Intelligence Applications may be used with VMware virtualized environmentsconsistent with the policy for other Oracle products as stated in Support Note 475484.1 available onMy Oracle Support (http://support.oracle.com). For information on Oracle VM, see Support Notes464756.1 and 464754.1 also available on My Oracle Support.Oracle Business Intelligence Applications leverages Informatica software to perform the dataintegration between source systems and the Oracle Business Analytics Warehouse. This software isdeveloped by Informatica. Informatica’s support policy for virtualized environments is stated below:System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J11

Platform Requirements for Oracle Business Intelligence Applications n Client andServer Environment RequirementsSupport ImpactInformatica supports Informatica products on supported operating systems, irrespective of whetherthey are deployed under a virtual environment.Given that virtualization software supports a limited set of certified operating systems and hardwareplatforms, the customer is responsible for configuring the virtual machine and applications for usein this environment. In deploying Informatica in this environment, the customer, along with thevirtualization software vendor, will be responsible for any issues that arise at the hardware oroperating system layer as a result of their use of the virtualization software.Informatica will not require customers to recreate and troubleshoot every issue in a non-virtualenvironment; however, Informatica does reserve the right to request our customers to recreatecertain issues outside the virtual environment in a native certified operating system environment.Informatica will typically make this request only when there is reason to believe that the virtualenvironment is a contributing factor to the issue.Other ConsiderationsIf support for third party software used by Informatica is restricted, or limited in a virtualenvironment, this also applies to the use of this software in Informatica environments. Informaticadepends on the support from various partner and OEM software products and is required to pass theirlimitations and restrictions on to the customer. It is the customer’s responsibility to work with thevirtualization vendor to ensure compliance and compatibility of third party applications.Since a virtual environment is not native, there may be a possible performance impact when runningInformatica products in a virtual environment. For best performance, Informatica recommendsrunning in non-virtual environments.NOTE: The above information is reproduced from the Statement of Support Related to Usage ofInformatica Products in a Virtual Environment document published by Informatica.Customers who have purchased Informatica PowerCenter and PowerConnect Adapters from OracleCorporation do not have direct support from Informatica. Customers should use My Oracle Support(http://support.oracle.com).12System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

Platform Requirements for Oracle Business Intelligence Applications n SupportedDatabasesSupported DatabasesTable 5 lists the supported databases for the Oracle Business Analytics Warehouse, the OracleBusiness Intelligence Data Warehouse Administration Console (DAC) Repository and the InformaticaPowerCenter Metadata Repository and Informatica Domain Repository for Oracle BusinessIntelligence Applications versions 7.9.6.0, 7.9.6.1 and 7.9.6.2.Table 5.Supported DatabasesOracleDatabaseMS SQLServerIBM DB2TeradataOracle Business AnalyticsWarehouseXX1X1X1Oracle Business IntelligenceData Warehouse AdministrationConsole RepositoryXXXInformatica PowerCenterMetadata Repository andDomain RepositoryXXXComponent1.Not supported in Oracle Business Intelligence Applications versions 7.9.6.0.For information on the database versions supported for the components listed above, see thefollowing topics:nSupported Databases for Oracle Business Analytics WarehousenSupported Databases for Oracle Business Intelligence Data Warehouse Administration ConsoleRepositorynSupported Databases for Informatica PowerCenter RepositoriesSystem Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J13

Platform Requirements for Oracle Business Intelligence Applications n SupportedDatabasesSupported Databases for Oracle Business AnalyticsWarehouseThe databases listed in Table 6 have been certified for the Oracle Business Analytics Warehouse.Table 6.Supported Databases for Oracle Business Analytics WarehouseConnectivitySoftware1Code Page2Sort OrderSQL ServerODBC Driver/Microsoft DataAccessComponents(MDAC) 2.7 orhigherUCS-2, TraditionalBinary orDictionary withCase Sensitive2000SQL ServerODBC Driver/Microsoft DataAccessComponents(MDAC) 2.7 orhigherUCS-2, TraditionalBinary orDictionary withCase SensitiveMicrosoft SQL Server200532005 PatchLevel9.00.1399.06SQL ServerODBC Driverversion3.70.08.20Microsoft DataAccessComponents(MDAC) 2.8UCS-2, TraditionalBinary orDictionary withCase SensitiveMicrosoft SQL Server200832008 SP110.0.2520.0SQL ServerODBC Driverversion2007.100.1600.22UCS-2, TraditionalBinary orDictionary withCase SensitiveIBM DB2 EnterpriseServer Edition39.7 Fix Pack 29.7 DataServer Client(with Fix Pack2 applied)UCS-2Identity/SystemIBM DB2 EnterpriseServer Edition39.59.5 DataServer Client4UCS-2Vendor and ProductVersionMicrosoft SQL Server200032000 ServicePack 2 orabove, 32-bitMicrosoft SQL Server2000 Enterprise ystemSystem Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J

Platform Requirements for Oracle Business Intelligence Applications n SupportedDatabasesTable 6.Supported Databases for Oracle Business Analytics WarehouseConnectivitySoftware1Code Page2Sort OrderDB2 ADCL9.1.0 clientUCS-2Identity/System8.25DB2 Connectwith FixPak 10or higherUCS-2, TraditionalIdentity/SystemV2R6.26,7TTU8.2UTF-8, ASCIICase SensitiveUTF-8, ASCIICase SensitiveUTF-8, ASCIICase SensitiveVendor and ProductVersionIBM DB2 EnterpriseServer Edition39.1IBM DB2 for UDB EE3Teradata3TraditionalODBC Driverfor Teradata3.6.0.0(03.06.00.00)or higher8Teradata312.07TTU12ODBC Driverfor Teradata 12or higher8Teradata313.07TTU13ODBC Driverfor Teradata 13or higher8Oracle Database 10gEnterprise Edition10gR2:10.2.0.4. orhigherOracle 10gclientUTF-8, TraditionalBinary orDictionaryOracle Database 11gEnterprise Edition511gR1:Oracle 11gclientUTF-8, TraditionalBinary orDictionaryOracle Database 11gEnterprise Edition511gR29:Oracle 11gclientUTF-8, TraditionalBinary orDictionaryOracle 11gclientUTF-8, TraditionalBinary orDictionaryOracle DatabaseMachine11.1.0.711.2.0.110 orhigher11.2.0.110 orhigherOracle Exadata V281.The connectivity software listed in this column refers to the connectivity software used by Informatica to connect to the OracleBusiness Analytics Warehouse. For connectivity software used by the Oracle Business Intelligence Data Warehouse AdministrationConsole (DAC), see Supported Platforms and System Requirements Guide for Oracle Business Intelligence Data WarehouseAdministration Console. For connectivity software used by the Oracle Business Intelligence Server to connect to the OracleBusiness Analytics Warehouse, see the Supported Platforms and System Requirements Guide for Oracle Business IntelligenceSuite Enterprise Edition.System Requirements and Supported Platforms for Oracle BusinessIntelligence Applications Version 7.9.6, Rev. J15

Platform Requirements for Oracle Business Intelligence Applications n SupportedDatabases2.The code page of the Oracle Business Analytics Warehouse must be a superset of the code page of the source database. A codepage is considered to be a superset of another code page when the code page contains all the characters encoded in the othercode page and additional characters not encoded in the other code page. See Oracle Business Intelligence ApplicationsInstallation Guide.3.Supported with Oracle Business Intelligence Applications 7.9.6.1 and 7.9.6.2.4.Versions of this document prior to Revision H incorrectly listed DB2 ADCL 9.5 client as the Connectivity Software.5.Also see Footnotes 4 and 5 to Table 4 on page 10.6.Not supported for Oracle Business Intelligence Applications 7.9.6.2.7.The following operating system are supported for Database Clients for the Oracle Business Analytics Warehouse on TeradataV2R6.2, v12.0 and v13.0: IBM AIX 5.2, 5.3 (32-bit and 64-bit), HP-UX 11.11 (PA-RISC 32-bit), HP-UX 11.23 (PA-RISC 32-bit,Itanium), Red Hat Linux 4, 5 (x86 32-bit, x64 Opteron and x64 EM64T), Oracle Enterprise Linux 4, 5 (x86 32-bit, x6 Opteron andx64 EM64T), SUSE Linux 9 (x86 32-bit, x64 Opteron and x64 EM64T),Solaris 8,9,10 (SPARC, 32-bit and 64-bit), Solaris 10 (x64),Windows 2000, 2003 (x86 32-bit), Windows 2003 x64 (supported through Teradata ODBC). Windows 2008 (x86 32-bit) issupported an operating system for Database Clients for the Business Analytics Warehouse on Teradata v12.0. Windows 2008 (x8632-bit) is supported as an operating system for Database Clients for the Business Analytics Warehouse on Teradata v12.0 using32-bit SQL loaders.8.The exact version of the Teradata ODBC driver that is required depends on the operating system and processor (32 bit or 64 bit).Refer to the Drivers and Connectivity Software download page on the Teradata website for information on the exact ODBC driverversion that is supported for a given operating system.9.Supported with Informatica PowerCenter 8.6.1 HotFix 10 and Informatica PowerCenter 8.6.1 HotFix 11.10. Oracle Database 11.2.0.1 requires Patches 9739315 and 9255542 to be applied.NOTE: SQL Server databases with case-sensitive server collation is supported. Also, SQL Serverdatabases should be created with the ANSI NULL option selected.NOTE: Teradata is only supported for the target Oracle Business Analytics Warehouse and not as asource database.NOTE: By its very nature, Oracle Business Intelligence Applications software is very much linked tospecific versions of database software. For this reason, only explicitly tested versions of databaseclient and server software are listed above in Table 6. In instances where alternative service pack orpatch levels have been tested and certified, these will also be indicated.If a customer running on a higher patch level of a supported database finds a problem in the use of theirOracle Business Intelligence Applications software, then Oracle Support will investigate it. If a defect isfound in the Oracle Business Intelligence Applications software, the normal support process will befollowed to determine if and when the defect will be rectified. It may be possible for Oracle to produce apatch for the Oracle Business Intelligence Applications software to work around this defect, but thiscannot be guaranteed and indeed may not even be technically possible. If a defect is identified withinthe database software, then in such a case the defect will not be considered as a defect of the OracleBusiness Intelligence Applications software.Customers’ regression and acceptance tests that will be run after the database upgrades areperformed should fully test the range of features and functionality that are expected to be seen inthe production environment, to ensure that they are confident there are no significant problemsintroduced by the upgrade of the database software.Support for Oracle Real Applications Clusters (RAC)The Oracle Busi

HotFix 6, Informatica PowerCenter 8.6.1 HotFix 10 and Informatica PowerCenter 8.6.1 HotFix 11. . Applications versions 7.9.6.0, 7.9.6.1 and 7.9.6.2. Oracle has certified acceptable performance in these environments; however, performance is improved by using faster processors and additional