Skip Headers
Oracle® Business Intelligence Installation Guide
10g Release 2 (10.1.2) for Linux Itanium
B25825-01
  Go To Table Of Contents
Contents
Go To Index
Index

Previous
Previous
 
Next
Next
 

2 Oracle Business Intelligence Requirements

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

For detailed installation information about Reports Services, refer to Chapter 3, "Detailed Reports Services Requirements".

2.1 Hardware Requirements

Oracle Business Intelligence has the following minimum hardware requirements.

For the most current list of hardware requirements, check the OracleMetaLink site at

https://metalink.oracle.com

Table 2-1 lists the system requirements for the computer that hosts the middle tier.

Table 2-1 System Requirements

Item Requirement

Network

Oracle Application Server can be only installed on a computer that is connected to a network.

Checked by Installer: No

Hostname

Ensure that your hostnames are not longer than 255 characters.

Processor speed

900 MHz or faster

You can check the processor speed by using the following command:

# grep "clock" /proc/cpuinfo

Processor type

Itanium 2

You can check the processor type by using the following command:

# grep family /proc/cpuinfo

Checked by Installer: No

Disk space

2.5 GB

To determine the amount of free disk space, use the following command:

prompt> df -k dir

Checked by Installer: No

Operating System

Red Hat Enterprise Linux AS/ES 3.0 (Update 6 or later), Red Hat Enterprise Linux 4.0 (Update 1 or later) and SUSE Linux Enterprise Server 9.0 with SP3 or later.

IP

IP address must be static. The installation is not supported on computers that obtain the IP addresses using DHCP.

Checked by Installer: No

Memory

1 GB

To determine the amount of memory, enter the following command:

prompt> # grep MemTotal /proc/meminfo

Checked by Installer: Yes.

Available Memory

In addition to the total memory requirement (refer to previous row), you also need to check that your computer has enough available memory during installation.

# free

The output is as follows:

total   used      free      shared    buffers    cached
Mem:   3734420    3655240   79180     142584    217192    2153260
-/+ buffers/cache:  1284788    2449632
Swap:   4193608     872528    3321080

The available memory shows up under the free column on the first line.

Checked by Installer: No

Space in /tmp directory

250 MB

To determine the amount of free disk space in the /tmp directory, use the df command:

prompt> df -k /tmp

If the /tmp directory does not have enough free space, you can specify a different directory by setting the TMP environment variable. See Section 3.9.5, "TMP and TMPDIR" for details.

Swap space

1.5 GB of available swap space

To determine the amount of available swap space, enter the following command:

# grep SwapTotal /proc/meminfo

If necessary, see your operating system documentation for information on how to configure additional swap space.

Monitor

256 color display

To determine your monitor's display capabilities, run the following command:

prompt> /usr/X11R6/bin/xdpyinfo

Look for the "depths" line. You need a depth of at least 8 (bits per pixel).


2.2 Software Requirements

You can install Oracle Business Intelligence on a computer, that is configured to use static IP address.

This section provides information about the operating system requirements and certification on Linux Itanium


See Also:

  • Oracle Application Server Installation Guide for a complete list of operating system requirements

  • OracleMetaLink site (http://metalink.oracle.com) for the most current list of operating system requirements


2.2.1 Software Requirements for Linux Itanium

Depending on your distribution of Linux Itanium, refer to the following sections for information on checking the software requirements:

Oracle does not support customized kernels or modules not supported by the Linux vendor.

2.2.1.1 Software Requirements for Red Hat Enterprise Linux AS/ES 3.0 Systems

Table 2-2 lists the software requirements for Red Hat Enterprise Linux AS/ES 3.0 systems and the procedure that follows the table describes how to ensure your system meets these requirements and any additional requirements for installing Oracle Business Intelligence.


Note:

Red Hat Enterprise Linux AS/ES 3.0, 4.0, and SUSE Linux Enterprise Server 9 are certified and supported. For the most current list of supported Linux Operating Systems, check OracleMetaLink (http://metalink.oracle.com).

Table 2-2 System Requirements for Red Hat Enterprise Linux AS/ES 3.0

Item Requirement

Operating System

Red Hat Enterprise Linux AS/ES 3.0, update 6 or later.

For more information on Red Hat, see:

http://www.redhat.com

The minimum supported kernel versions are:

  • kernel-2.4.21-37.EL or later.

Red Hat Update

Update 6 or later.

Software packages

(check that these versions or higher versions are installed)

make-3.79.1-17.1
gcc-3.2.3-53
gcc-c++-3.2.3-53
glibc-2.3.2-95.37
glibc-common-2.3.2-95.37
glibc-devel-2.3.2-95.37
compat-db-4.0.14-5.1
compat-gcc-7.3-2.96.128
compat-gcc-c++-7.3-2.96.128
compat-libstdc++-devel-7.3-2.96.128
libstdc++-3.2.3-53
libstdc++-devel-3.2.3-53
openmotif21-2.1.30-9.RHEL3.6
sysstat-5.0.5-5.rhel3
setarch-1.3-1
libaio-0.3.96-5
libaio-devel-0.3.96-5
binutils-2.14.90.0.4-39
pdksh-5.2.14-21


To ensure that the system meets all the requirements, follow these steps:

  1. Log in as the root user.

  2. To determine which distribution and version of Linux is installed, enter the following command:

    # cat /etc/issue
    Red Hat Enterprise Linux AS release 3 (Taroon Update 6) 
    
    

    Note:

    Red Hat Enterprise Linux AS/ES 3.0, 4.0, and SUSE Linux Enterprise Server 9 are certified and supported. For the most current list of supported Linux Operating Systems, check OracleMetaLink (http://metalink.oracle.com).

  3. To check that Update 6 is installed:

    # cat /etc/redhat-release
    Red Hat Enterprise Linux AS release 3 (Taroon Update 6)
    
    
  4. To determine whether any other package is installed, enter a command similar to the following:

    # rpm -q package_name
    
    

    If a package is missing, download it and install it using the following command:

    # rpm -i package_name
    
    

    When installing a package, make sure you are using the correct architecture and optimization rpm file. To check the architecture of an rpm file, run the following command:

    # rpm -q package_name --queryformat "%{arch}\n"
    
    

    In the following example, the glibc rpm file is suitable for an Intel architecture

    # rpm -q glibc --queryformat "%{arch}\n" 
    ia64
    
    

2.2.1.2 Software Requirements for Red Hat Enterprise Linux AS/ES 4.0 Systems

Table 2-3 lists the software requirements for Red Hat Enterprise Linux AS/ES 4.0. The procedure that follows the table describes how to ensure that your system meets these requirements and any additional requirements for installing Oracle Application Server.


Note:

Red Hat Enterprise Linux AS/ES 3.0, 4.0 and SUSE Linux Enterprise Server 9 are certified and supported. For the most current list of supported Linux Operating Systems, check OracleMetaLink (http://metalink.oracle.com).

Table 2-3 Software Requirements for Red Hat Enterprise Linux AS/ES 4.0 Systems

Item Requirements

Operating System

Red Hat Enterprise Linux AS/ES 4.0, update 1 or later.

For more information on Red Hat, see:

http://www.redhat.com

The minimum supported kernel versions are:

  • 2.6.9-11.EL or later

Red Hat Update

Update 1 or later.

Software packages (check that these versions or higher versions are installed)

glibc-2.3.4-2.9 
glibc-common-2.3.4-2.9 
glibc-devel-2.3.4-2.9 
gcc-3.4.3-22.1
gcc-c++-3.4.3-22.1
libstdc++-3.4.3-22.1
libstdc++-devel-3.4.3-22.1
compat-libstdc++-296-2.96-132.7.2
compat-db-4.1.25-9
binutils-2.15.92.0.2-13
make-3.80-5
pdksh-5.2.14-30
sysstat-5.0.5-1
openmotif21-2.1.30-11.RHEL4.4
libaio-devel-0.3.103-3
libaio-0.3.103-3


To ensure that the system meets all the requirements, follow these steps:

  1. Log in as the root user.

  2. To determine which distribution and version of Linux is installed, enter the following command:

    # cat /etc/issue
    Red Hat Enterprise Linux AS release 4 (Nahant Update 1)
    
    
  3. To check that Update 1 or later is installed:

    # cat /etc/redhat-release
    Red Hat Enterprise Linux AS release 4 (Nahant Update 1)
    
    
  4. To determine whether any other package is installed, enter a command similar to the following:

    # rpm -q package_name
    
    

    If a package is missing, download it and install it using the following command:

    # rpm -i package_name
    
    

    When installing a package, make sure you are using the correct architecture and optimization rpm file. To check the architecture of an rpm file, run the following command:

    # rpm -q package_name --queryformat "%{arch}\n"
    
    

    In the following example, the glibc rpm file is suitable for an Intel architecture

    # rpm -q glibc --queryformat "%{arch}\n" 
    ia64
    
    

2.2.1.3 Software Requirements for SUSE Linux Enterprise Server 9 Systems

Table 2-4 lists the software requirements for SUSE Linux Enterprise Server 9 systems and the procedure that follows the table describes how to ensure your system meets these requirements and any additional requirements for installing Oracle Business Intelligence.


Note:

Oracle Application Server 10g Release 2 (10.1.2) is certified with the following Operating System specific software. For the most current list of supported Operating System specific software, for example JDK version, Operating System version, check OracleMetaLink (http://metalink.oracle.com).

Table 2-4 System Requirements for SUSE Linux Enyterpeise Sever 9

Item Requirement

Operating System

SUSE Linux Enterprise Server 9 with service pack 2 or later.

For more information on SUSE Linux Enterprise Server, see:

http://www.suse.com

For SUSE Linux Enterprise Server 9, the minimum supported kernel versions are:

  • 2.6.5-7.244 or later

Software packages

(check that these versions or higher versions are installed)

glibc-2.3.3-98.61
gcc-3.3.3-43.41 
gcc-c++-3.3.3-43.41 
libstdc++-3.3.3-43.41 
libstdc++-devel-3.3.3-43.41
openmotif-libs-2.2.2-519.4 
pdksh-5.2.14-780.7 
make-3.80-184.1 
sysstat-5.0.1-35.7 
binutils-2.15.90.0.1.1-32.10 
glibc-devel-2.3.3-98.61
libaio-0.3.102-1.5
libaio-devel-0.3.102-1.5
compat-2004.7.1-1.2
db1-1.85-85.1


To ensure that the system meets all the requirements, follow these steps:

  1. Log in as the root user.

  2. To determine which distribution and version of Linux is installed, enter the following command:

    # cat /etc/issue
    Welcome to SUSE LINUX Enterprise Server 9 (ia64) - Kernel \r (\l)
    

    Note:

    Red Hat Enterprise Linux AS/ES 3.0, 4.0 and SUSE Linux Enterprise Server 9 are certified and supported. For the most current list of supported Linux Operating Systems, check OracleMetaLink (http://metalink.oracle.com).

  3. To check if the SUSE Linux Enterprise Server 9 with service pack 2 or later is installed, entering the following command:

    # cat /etc/SuSE-release
    SUSE Linux Enterprise Server 9 (ia64)
    VERSION=9
    PATCHLEVEL=2
    
    
  4. To determine the kernel version, enter the following command:

    # uname -r
    2.6.5-7.244
    
    
  5. To determine whether any other package is installed, enter a command similar to the following:

    # rpm -q package_name
    
    

    If a package is missing, download it and install it using the following command:

    # rpm -i package_name
    
    

    When installing a package, make sure you are using the correct architecture and optimization rpm file. To check the architecture of an rpm file, run the following command:

    # rpm -q package_name --queryformat "%{arch}\n"
    
    

    In the following example, the glibc rpm file is suitable for an Intel architecture

    # rpm -q glibc --queryformat "%{arch}\n" 
    ia64
    
    
  6. Create the following symbolic link for the Perl executable if it does not already exist:

    # ln -sf /usr/bin/perl /usr/local/bin/perl
    
    
  7. Create the following symbolic link for the fuser executable if it does not already exist:

    # ln -sf /bin/fuser /sbin/fuser
    
    
  8. If the orarun package was installed on a SUSE Linux Enterprise Server system, complete the following steps as the oracle user to reset the environment:

    1. Enter the following commands:

      prompt> cd /etc/profile.d 
      prompt> mv oracle.csh oracle.csh.bak
      prompt> mv oracle.sh oracle.sh.bak
      prompt> mv alljava.sh alljava.sh.bak
      prompt> mv alljava.csh alljava.csh.bak
      
      
    2. Use any text editor to comment out the following line from the $HOME/.profile file:

      . ./.oracle
      
      
    3. Log out of the oracle user account.

    4. Log into the oracle user account for the changes to take effect.

  9. If any Java packages are installed on the system, unset the Java environment variables, for example JAVA_HOME.


    Note:

    Oracle recommends that you do not install any of the Java packages supplied with the SUSE Linux Enterprise Server distribution.

  10. Check the /etc/services file to make sure that the following port ranges are available on the system:

    • ports 3060-3129 required for Oracle Internet Directory

    • ports 3130-3199 required for Oracle Internet Directory (SSL)

    • ports 1812-1829 required for Oracle Enterprise Manager (console)

    • ports 1830-1849 required for Oracle Enterprise Manager (agent)

    • ports 1850-1869 required for Oracle Enterprise Manager (RMI)

    If necessary, remove entries from the /etc/services file and restart the system. To remove the entries, you can use the perl script included in the utils/3167528/ directory of CD-ROM Disk 1 and in the application_server/utils/3167528/ directory on the DVD-ROM. Run the script as the root user. This script is also available as patch 3167528. This patch is available from:

    http://metalink.oracle.com
    
    

    If these ports are not available, the associated configuration assistants will fail during the installation.

  11. If you use Network Information Service (NIS):

    1. Make sure that the following line exists in the /etc/yp.conf file:

      hostname.domainname broadcast 
      
      
    2. Make sure that the following line exists in the /etc/nsswitch.conf file:

      hosts: files nis dns 
      
      
  12. Make sure that the localhost entry in the /etc/hosts file is an IPv4 entry. If the IP entry for localhost is IPv6 format, installation cannot succeed. The following example shows an IPv6 entry:

    # special IPv6 addresses
    ::1             localhost ipv6-localhost ipv6-loopback
    ::1             ipv6-localhost ipv6-loopback
    
    

    To correct this example /etc/hosts file, comment the localhost entry as follows:

    # special IPv6 addresses
    # ::1             localhost ipv6-localhost ipv6-loopback
    ::1             ipv6-localhost ipv6-loopback
    
    

    To comment the entries, you can use the perl script included in the utils/4015045/ directory of CD-ROM Disk 1 and in the application_server/utils/4015045/ directory on the DVD-ROM. Run the script as the root user. This script is also available as patch 4015045. This patch is available from:

    http://metalink.oracle.com
    
    

2.3 Database Requirements

Oracle Business Intelligence 10g Release 2 (10.1.2) is supported with the following database versions:

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 access the latest OLAP patches:

  1. Log into OracleMetalink at http://metalink.oracle.com.

  2. Click Patches.

  3. Click Advanced Search.

  4. 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 computers:

Table 2-5 Browser Requirements

Item Requirements

Microsoft Internet Explorer

5.5, 6.0 with service pack 2 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-6 Additional Software 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.22


Check the /etc/services file to make sure that the following port ranges are available on the system:

If necessary, remove entries from the /etc/services file and reboot the system. To remove the entries, you can use the perl script included with the patch 3167528. This patch is available from:

http://metalink.oracle.com

If these ports are not available, the associated configuration assistants will fail during the installation.