1 Installation Prerequisites

Complete the following basic steps to prepare your network and host computers for deployment:

Read the product release notes for information on compatibility issues, known problems, and workarounds that might affect how you proceed with your deployment.
Print the configuration worksheets provided in the Oracle WebCenter Analytics Configuration Worksheets document in the Oracle WebCenter Analytics 10g Release 3 (10.3.0.0) documentation set.
Determine the values you have assigned for this deployment, and record these values in the Oracle WebCenter Analytics Configuration Worksheets document.
Provision host computers for your deployment and install prerequisite software. For details, see Hardware and Software Requirements.

Hardware and Software Requirements

The following sections list the hardware and software requirements for Oracle WebCenter Analytics.

Caution:

IPv6 is not supported. You should verify that IPv6 is not enabled prior to installing Oracle WebCenter Analytics.

Hardware Requirements
Software Requirements for Microsoft Windows Environments
Software Requirements for RedHat Linux Environments
Software Requirements for Oracle Enterprise Linux Environments
Software Requirements for Novell SuSE Linux Environments
Software Requirements for Sun Solaris Environments
Software Requirements for IBM AIX Environments
Supported Web Browsers
Supported Oracle-BEA Products

For the most current platform support information, see the Oracle WebCenter Analytics spreadsheet under System Requirements and Supported Platforms for Oracle WebCenter Interaction & Ensemble 10gR3 on the Oracle Fusion Middleware Certification page at http://www.oracle.com/technology/software/products/ias/files/fusion_certification.html.

For more information on recommended configurations based on the size of your implementation, see the section about provisioning computers in the Oracle Fusion Middleware Deployment Planning Guide for Oracle WebCenter Interaction.

Caution:

IPv6 is not supported. You should verify that IPv6 is not enabled prior to upgrading this product.

Hardware Requirements

This section lists the hardware requirements for an Oracle WebCenter Analytics deployment.

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.

Software Requirements for Microsoft Windows Environments

This section lists the software requirements for Microsoft Windows environments.

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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Software Requirements for RedHat Linux Environments

This section lists the software requirements for RedHat Linux environments.

Operating System:
- RedHat Enterprise Linux ES 4.0 update 3 on x86
- RedHat Enterprise Linux ES 5.2 on 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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Software Requirements for Oracle Enterprise Linux Environments

This section lists the software requirements for Oracle Enterprise Linux environments.

Operating System:
- Oracle Enterprise Linux 5.2
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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Software Requirements for Novell SuSE Linux Environments

This section lists the software requirements for Novell SuSE Linux environments.

Operating System:
- SuSE Enterprise Linux SLES 9 on x86
- SuSE Enterprise Linux SLES 10 on 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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Software Requirements for Sun Solaris Environments

This section lists the software requirements for Sun Solaris environments.

Operating System:
- Solaris 9 on SPARC
- Solaris 10 on SPARC
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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Software Requirements for IBM AIX Environments

This section lists the software requirements for IBM AIX environments.

Operating System:
- IBM AIX 5.3 Technology Level 5300-05 on POWER3, POWER4, POWER5
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 9.0.2.7 and above in default or Oracle Real Application Clusters (RAC) configuration
- Oracle Database 10g (10.1.0.3 and above) or Oracle Database 10gR2 (10.2.0.x 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.

Supported Web Browsers

This section lists web browser support.

Mozilla Firefox 2.0 and above, and 3.0
Microsoft Internet Explorer 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)

Supported Oracle-BEA Products

This section describes the Oracle-BEA products that Oracle WebCenter Analytics can work with.

Oracle WebCenter Collaboration 10.3
Oracle-BEA AquaLogic Interaction Publisher 6.4 and above, and 6.5
Oracle-BEA AquaLogic Interaction Studio 2.2 MP1

Note:
Oracle WebCenter Analytics does not include Studio-specific reports. This requirement is for basic compatibility only.

Default Ports Used by Oracle WebCenter Analytics

The following table summarizes the default ports that are used by Oracle WebCenter Analytics:

Table 1-1 Default ports used by Oracle WebCenter Analytics

Communication	Description
Portal to Oracle WebCenter Analytics port 31314	Used for data collection.
Portal to Oracle WebCenter Analytics port 11944	Used to display reports.
Oracle WebCenter Analytics to Image Service port 80	Used to embed objects stored in the Image Service into Oracle WebCenter Analytics reports.
Oracle WebCenter Analytics to Portal DB and Oracle WebCenter Collaboration DB. Port used depends on database implementation, for example 1433 (SQLServer) or 1521 (Oracle)	Used to synchronize data from portal or Oracle WebCenter Collaboration.
Oracle WebCenter Analytics to API Services machine port 11905	Used to synchronize data from the portal.