1 Installation Prerequisites

Oracle WebCenter Analytics Host Computer

• 1.6 GHz^, with 2MB L2 cache

• 1 GB memory

• 2 GB disk space

Database Server Host Computer

• Dual 2.0 GHz^, with 2 MB L2 cache

• 2 GB memory^

• Mirrored SCSI drives (either 15K or 10K RPM)

• Disk space to accommodate growth of the Oracle WebCenter Analytics database. Growth is directly correlated to the number of events occurring. Events include such things as page views, portlet views, user logins, and discussion posts. Estimate 100 MB of growth per 1 million events. For example, if your portal receives roughly 1 million events per day, you should anticipate growth of 36.5 GB per year.

Operating System:

• Microsoft Windows Server 2003 SP2 (x86)

Databases:

• Microsoft SQL Server 2005 or 2005 SP2 with SQL Server 2000 Compatibility Level (32- and 64-bit in default or failover cluster configuration)

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Operating System:

• RedHat Enterprise Linux ES 4.0 update 3 on all processors except Itanium

• RedHat Enterprise Linux ES 5.x on all processors except Itanium

Databases:

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Operating System:

• Oracle Enterprise Linux 4.x on all processors except Itanium

• Oracle Enterprise Linux 5.x on all processors except Itanium

Databases:

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Operating System:

• SuSE Enterprise Linux SLES 9 on all processors except Itanium

• SuSE Enterprise Linux SLES 10 on all processors except Itanium

Databases:

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Operating System:

• Solaris 8 on 64-bit SPARC

• Solaris 9 on 64-bit SPARC, requires the following patch: 111711-15 (32-bit Shared library patch for C++ ) or 111712-15 (64-bit Shared library patch for C++)

• Solaris 10 on 64-bit SPARC

Databases:

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Operating System:

• IBM AIX 5.3 on 64-bit POWER, requires the following patches: AIX 5.3 Service pack 5300-05–06 and July 2007 IBM C++ Runtime Environment Component for AIX

Databases:

• Oracle Database 10g (10.1.0.5 and above) or Oracle Database 10gR2 (10.2.0.2 and above) in default or Oracle Real Application Clusters (RAC) configuration

• Oracle 11g (11.1.0.6 and above) in default or Oracle Real Application Clusters (RAC) configuration

  When running Oracle 11g versions prior to 11.1.0.7.0 the Oracle system parameter _optimizer_group_by_placement must be set to false. This can either be set in the init.ora file of the respective database instances or by by issuing an ALTER SYSTEM command as follows:

  SQLPLUS /nolog
  CONNECT / AS SYSDBA
  ALTER SYSTEM SET "_optimizer_group_by_placement"=false
  

  Note:

  If you are upgrading Oracle Database from 10.1.x to 10.2.x, you should perform this upgrade before upgrading Oracle WebCenter Interaction.

Mozilla Firefox 2.0 and 3.0

Microsoft Internet Explorer 6.0, 6.0 SP1, 6.0 SP2 (on XP), 7.0 (on Vista), or 7.0 SP2 (on XP SP2)

Apple Safari 3.0 (on Microsoft Windows)

Oracle WebCenter Analytics leverages Hibernate 3.0.5 for persistence. You must install Hibernate 3.0.5 before you install Oracle WebCenter Analytics. Hibernate 3.0.5 can be downloaded from http://sourceforge.net/project/showfiles.php?group_id=40712&package_id=127784.

Oracle WebCenter Analytics leverages Cewolf 0.10.3 for its charting engine. You must install Cewolf 0.10.3 before you install Oracle WebCenter Analytics. Cewolf can be downloaded from https://olex.openlogic.com/package_versions/download/5428?package_version_id=218&path=openlogic%2Fcewolf%2F0.10.3%2Fcewolf-0.10.3-all-bin.zip.