2 Oracle Business Intelligence Requirements

Before installing Oracle Business Intelligence, make sure that your computer meets the requirements described in the following sections:

Section 2.1, "Hardware requirements"
Section 2.2, "Operating system requirements"
Section 2.3, "Database requirements"
Section 2.4, "Browser requirements"
Section 2.5, "Other software requirements"

For detailed installation information about Reports Services, see Chapter 2, "Oracle Business Intelligence Requirements".

2.1 Hardware requirements

Oracle Business Intelligence has the following minimum hardware requirements:

Section 2.1.1, "Windows minimum hardware requirements"
Section 2.1.2, "Solaris minimum hardware requirements"

For the most current list of hardware requirements, check the OracleMetaLink site (http://metalink.oracle.com).

2.1.1 Windows minimum hardware requirements

Oracle Business Intelligence on Windows has the following hardware requirements for the machine hosting the middle tier:

Table 2-1 This table lists Windows minimum hardware requirements

Hardware item	Minimum Requirements
CPU	300 MHz Intel Pentium processor (500MHz recommended)
Memory	1 GB
Diskspace	1.6 GB
Space in TEMP directory	300 MB
Virtual Memory	1535 MB
Monitor	256 color display

For a user to run Discoverer Plus on a client machine:

there must be at least 30 MB of Users Personal Profile Space for the Oracle Jar Cache
to install a Java Virtual Machine:
- the user must have Administrative privileges on the client machine
- there must be a minimum of between 25 MB and 50 MB of available disk space

For the most current list of hardware requirements, check the OracleMetaLink site (http://metalink.oracle.com).

2.1.2 Solaris minimum hardware requirements

Oracle Business Intelligence on Solaris has the following hardware requirements for the machine hosting the middle tier:

Table 2-2 This table lists Solaris minimum hardware requirements

Hardware item	Minimum Requirements
Processor Type	The processor must have a SPARC v8 architecture (or later).
Processor Speed	300 MHz or greater (450 MHz recommended). Oracle recommends a multiple CPU computer.
Memory	1 GB
Diskspace	1.6 GB
Space in /tmp directory	250 MB
Swap space	640 MB
Virtual Memory	1535 MB
Monitor	256 color display

For the most current list of hardware requirements, check the OracleMetaLink site (http://metalink.oracle.com).

2.2 Operating system requirements

Oracle Business Intelligence has the following operating system requirements:

Section 2.2.1, "Windows operating system requirements"
Section 2.2.2, "Solaris operating system requirements"

For the most current list of operating system requirements, check the OracleMetaLink site (http://metalink.oracle.com).

You can install Oracle Business Intelligence:

On a computer that is not on a network. You must configure the computer to use either a static IP address or a loopback IP address. Configure the computer to resolve the hostname of the computer to either the static IP address or the loopback IP address.
On a computer on a Dynamic Host Configuration Protocol (DHCP) network. You must use a loopback configuration. Configure the computer to resolve the hostname of the computer to the loopback IP address.

Note: If you install on a machine that is not on a network or that is not on a DHCP network, you will only be able to use Discoverer from that machine. In other words, you will not be able to connect to Discoverer from any other machine.

2.2.1 Windows operating system requirements

Oracle Business Intelligence on Windows has the following operating system requirements for the machine hosting the middle tier:

Table 2-3 This table lists Windows middle tier operating system requirements

Operating System	Additional Requirements
Microsoft Windows 2000	Service Pack 4 or greater
Microsoft Windows 2003 (32 bit)	None

Oracle Business Intelligence on Windows has the following operating system requirements for client machines:

Table 2-4 This table lists Windows client operating system requirements

Operating System	Additional Requirements
Microsoft Windows 2000	Service Pack 4 or greater
Microsoft Windows XP Professional Edition	None
Microsoft Windows 2003 (32 bit)	None

For the most current list of operating system requirements, check the OracleMetaLink site (http://metalink.oracle.com).

2.2.2 Solaris operating system requirements

Oracle Business Intelligence on Solaris has the following operating system requirements for the machine hosting the middle tier:

Table 2-5 This table lists Solaris middle tier operating system requirements

Operating System	Patches Required
Solaris 8	108652-82 or higher: X11 6.4.1: Xsun patch 108921-21 or higher: CDE 1.4: dtwm patch 108940-62 or higher: Motif 1.2.7 and 2.1.1: Runtime library patch 108773-18 or higher: IIIM and X input and output method patch 111310-01 or higher: /usr/lib/libdhcpagent.so.1 patch 109147-28 or higher: Linker patch 111308-04 or higher: /usr/lib/libmtmalloc.so.1 patch 112438-03 or higher: /kernel/drv/random patch 108434-17 or higher: 32-bit shared library patch for C++ 108435-17 or higher: 64-bit shared library patch for C++ 111111-04 or higher: /usr/bin/nawk patch 112396-02 or higher: /usr/bin/fgrep patch 110386-03 or higher: RBAC feature patch 111023-03 or higher: /kernel/fs/mntfs and /kernel/fs/sparcv9/mntfs patch 111317-05 or higher: /sbin/init and /usr/sbin/init patch 113648-03 or higher: /usr/sbin/mount patch 115827-01 or higher: /sbin/sulogin and /sbin/netstrategy patch 116602-01 or higher: /sbin/uadmin and /sbin/hostconfig patch 108987-13 or higher: Patch for patchadd and patchrm 108528-29 or higher: Kernel update patch 108989-02 or higher: /usr/kernel/sys/acctctl and /usr/kernel/sys/exacctsys patch 108993-36 or higher: LDAP2 client, libc, libthread and libnsl libraries patch 109326-14 or higher: libresolv.so.2 and in.named patch 110615-11 or higher: sendmail patch
Solaris 9	113096-03 or higher: X11 6.6.1: OWconfig patch 112785-35 or higher: X11 6.6.1: Xsun patch

Operating System

Patches Required

Solaris 8

108652-82 or higher: X11 6.4.1: Xsun patch
108921-21 or higher: CDE 1.4: dtwm patch
108940-62 or higher: Motif 1.2.7 and 2.1.1: Runtime library patch
108773-18 or higher: IIIM and X input and output method patch
111310-01 or higher: /usr/lib/libdhcpagent.so.1 patch
109147-28 or higher: Linker patch
111308-04 or higher: /usr/lib/libmtmalloc.so.1 patch
112438-03 or higher: /kernel/drv/random patch
108434-17 or higher: 32-bit shared library patch for C++
108435-17 or higher: 64-bit shared library patch for C++
111111-04 or higher: /usr/bin/nawk patch
112396-02 or higher: /usr/bin/fgrep patch
110386-03 or higher: RBAC feature patch
111023-03 or higher: /kernel/fs/mntfs and /kernel/fs/sparcv9/mntfs patch
111317-05 or higher: /sbin/init and /usr/sbin/init patch
113648-03 or higher: /usr/sbin/mount patch
115827-01 or higher: /sbin/sulogin and /sbin/netstrategy patch
116602-01 or higher: /sbin/uadmin and /sbin/hostconfig patch
108987-13 or higher: Patch for patchadd and patchrm
108528-29 or higher: Kernel update patch
108989-02 or higher: /usr/kernel/sys/acctctl and /usr/kernel/sys/exacctsys patch
108993-36 or higher: LDAP2 client, libc, libthread and libnsl libraries patch
109326-14 or higher: libresolv.so.2 and in.named patch
110615-11 or higher: sendmail patch

Solaris 9

113096-03 or higher: X11 6.6.1: OWconfig patch
112785-35 or higher: X11 6.6.1: Xsun patch

Although the patches listed in the above table are current at the time of publication, Sun Microsystems, Inc. often updates the list of required patches. For the most current list of patches, go to the Sun web site (e.g. http://sunsolve.sun.com/pub-cgi/show.pl?target=patches/J2SE).

For the most current list of operating system requirements, check the OracleMetaLink site (http://metalink.oracle.com).

2.3 Database requirements

Oracle Business Intelligence 10.1.2.1 is supported with the following database versions:

Oracle9i Release 2 Database (9.2.0.6 and higher)
Oracle Database 10g Enterprise Edition Release 1 (10.1.0.4 and higher)
Oracle Database 10g Enterprise Edition Release 2 (10.2.0.1 and higher); certification is planned

The latest information on supported versions is available on the Certify application on http://metalink.oracle.com.

2.3.1 Downloading the most recent OLAP patch

When querying a multidimensional data source, only particular database releases and patches are supported. Use the following procedure to ensure that you have the latest OLAP patch.

To access the latest OLAP patches:

Log into OracleMetalink at http://metalink.oracle.com.
Click Patches.
Click Advanced Search.
In the Advanced Search screen, fill in the fields as follows:
- Product or Product Family: Click the Search icon, and from the Search In field, choose Database & Tools. Click View All. From the resulting list, click Oracle OLAP.
- Release: Select the appropriate release number from the drop-down list.
- Patch Type: Choose Any.
- Platform or Language: Select the platform for your site.
- Leave the remaining fields blank.
Click Go to display a list of patches. You can identify the OLAP patches because they include "OLAP" in the patch name.

2.3.2 About accepting the Default Setting for the OPTIMIZER_FEATURES_ENABLE Parameter

If you recently upgraded the Oracle database, then you might have set the OPTIMIZER_FEATURES_ENABLE initialization parameter to a value that enabled you to maintain the optimizer behavior of a previous release.

OracleBI Discoverer Plus OLAP takes advantage of the latest database features for optimal performance. OracleBI Discoverer Plus OLAP requires that the OPTIMIZER_FEATURES_ENABLE parameter be left at its default value for the respective database release (the default value is the database release number, such as 9.2.0.). Any other settings can lead to unexpected behavior.

Oracle does not recommend explicitly setting the OPTIMIZER_FEATURES_ENABLE parameter to an earlier release. Instead, resolve execution plan or query performance issues on a case-by-case basis.

2.4 Browser requirements

Oracle Business Intelligence has the following browser requirements for client machines:

Table 2-6 This table lists browser requirements

Item	Requirements
Microsoft Internet Explorer	5.5, 6.0 and higher
Netscape	7.1, 7.2
Mozilla	1.5 and higher
Safari	1.3 and higher

For the most current list of supported browsers, check the OracleMetaLink site (http://metalink.oracle.com).

2.5 Other software requirements

Oracle Business Intelligence has the following software requirements not described previously:

Table 2-7 This table lists other requirements

Item	Requirements
Discoverer Viewer	To run Discoverer Viewer on a client machine, JavaScript and cookies must be enabled in the browser.
Microsoft Excel	To export to Microsoft Excel using Discoverer Plus Relational, Excel 97 (or later) is required. Note that Excel 2000 (or later) is required when exporting worksheets to Microsoft Excel Web Query format. To export to Microsoft Excel using Discoverer Plus OLAP, Excel 2000 (or later) is required.
JRE	To run Discoverer Plus, one of the following JREs must be used: Sun Java Plug-in 1.4.2_06 (recommended) Oracle JInitiator 1.3.1.17

Item

Requirements

Discoverer Viewer

To run Discoverer Viewer on a client machine, JavaScript and cookies must be enabled in the browser.

Microsoft Excel

To export to Microsoft Excel using Discoverer Plus Relational, Excel 97 (or later) is required. Note that Excel 2000 (or later) is required when exporting worksheets to Microsoft Excel Web Query format.

To export to Microsoft Excel using Discoverer Plus OLAP, Excel 2000 (or later) is required.

JRE

To run Discoverer Plus, one of the following JREs must be used:

Sun Java Plug-in 1.4.2_06 (recommended)
Oracle JInitiator 1.3.1.17