Skip Headers
Oracle® Business Intelligence Installation Guide
10g Release 2 (10.1.2) for AIX 5L Based Systems (64-Bit)
B25208-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

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

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

Table 2-1 System Requirements

Item Requirement

Network

You can install Oracle Application Server on a computer that is connected to a network, or on a "standalone" computer (not connected to the network).

If you are installing Oracle Application Server on a standalone computer, you can connect the computer to a network after installation. You have to perform some configuration tasks when you connect it to the network.

Refer to Oracle Application Server Administrator's Guide for details.

Checked by Installer: No

Hostname

Ensure that your hostnames are not longer than 255 characters.

Processor type

All AIX Common Hardware Reference Platform processors (64-bit)

If the processor is a 64-bit processor, the following command returns the value 64:

# /usr/bin/getconf HARDWARE_BITMODE

To make sure the processor is a Common Hardware Reference Platform processor, run the following command as the root user and make sure it returns the value chrp:

# bootinfo -p

Disk space

OracleAS Infrastructure: 4.12 GB

Oracle Application Server middle tier:

  • J2EE and Web Cache: 1.7 GB

  • Portal and Wireless: 3.1 GB

  • Business Intelligence and Forms: 3.99 GB

OracleAS Developer Kits: 2.2 GB

The installer may display inaccurate disk space requirement figures. Refer to the figures listed above for disk space requirements.

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

prompt> bdf dir

Replace dir with the Oracle home directory or with the parent directory if the Oracle home directory does not exist yet. For example, if you plan to install Oracle Application Server in /opt/oracle/infra, you can replace dir with /opt/oracle or /opt/oracle/infra.

Checked by Installer: No

Operating System

AIX 5L Based Systems

IP

The IP address of the computer must be static. Oracle Application Server does not support AIX systems using DHCP.

Memory

The memory requirements provided for the various installation types represents enough physical memory to install and run Oracle Application Server. However, for most production sites, you should configure at least 1 GB of physical memory. For sites with substantial traffic, increasing the amount of memory further may improve your performance. For Java applications, you should either increase the maximum heap allocated to the OC4J processes, or configure additional OC4J processes to utilize this memory. Refer to Oracle Application Server Performance Guide for details.

In determining the optimal amount of memory for your installation, the best practice is to load test your site. Resource requirements can vary substantially for different applications and different usage patterns. In addition, some operating system utilities for monitoring memory can overstate memory usage (partially due to the representation of shared memory). The preferred method for determining memory requirements is to monitor the improvement in performance resulting from the addition of physical memory in your load test. Refer to your platform vendor documentation for information on how to configure memory and processor resources for testing purposes.

OracleAS Infrastructure 10g:

  • OracleAS Metadata Repository and Identity Management: 1 GB

  • Identity Management only: 512 MB

  • OracleAS Metadata Repository only: 750 MB

Oracle Application Server middle tier:

  • J2EE and Web Cache: 512 MB

  • Portal and Wireless: 1 GB

  • Business Intelligence and Forms: 1 GB

OracleAS Developer Kits 10g: 256 MB, but 512 MB recommended

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

# /usr/sbin/lsattr -E -l sys0 -a realmem

Space in /tmp directory

400 MB

To determine the amount of free disk space in the /tmp directory, enter the following 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.

Swap Space

1.5 GB of available swap space

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

# /usr/sbin/lsps -a

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.1.1 Memory Requirements for Running Multiple Instances on the Same Computer

If you plan to run OracleAS Infrastructure and a middle tier on the same computer, ensure the computer meets the memory requirements listed in Table 2-2.

Note that these values have been tested against a small number of users. If you have many users, you might have to increase the amount of memory.

Table 2-2 Memory Requirements for Running Multiple Instances on the Same Computer

Description Memory

OracleAS Infrastructure plus J2EE and Web Cache

1 GB

OracleAS Infrastructure plus Portal and Wireless

1.5 GB

OracleAS Infrastructure plus Business Intelligence and Forms

1.5 GB


2.1.2 Installing from the Console or X Windows

If you are performing the installation from the console or X Windows, then add the following line to the /etc/pamd.d/xdm file:

session required pam_limits.so

2.1.3 Tips for Reducing Memory Usage

If you need to reduce memory consumption:

  • Configure only the components that you need.

  • Choose the smallest middle-tier type that contains the components that you need.

  • After installation, start up only the components that you need. Refer to Oracle Application Server Administrator's Guide for details.

  • Run Application Server Control only when you need to administer an instance. In most cases, you do not need Application Server Control running all the time.

    If you are running multiple Oracle Application Server instances on one computer, each Application Server Control can consume a lot of memory. Running Application Server Control only when you need it can free up memory for other components.

  • Configure Application Server Control so that it can manage multiple instances. Refer to Oracle Application Server Administrator's Guide for details.

2.2 Software Requirements

Depending on the version of AIX you are using, refer to the following sections for the corresponding software requirements:

2.2.1 Software Requirements for AIX 5L Version 5.2

Table 2-3 lists the software requirements for AIX 5L version 5.2.

Table 2-3 Software Requirements for AIX 5L Version 5.2

Item Requirements

Maintenance Level

04 or higher

Filesets

bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
X11.motif.lib

Patches (All Filesets)

IY65001 mklvcopy on a striped lv is failing to update lvcb

IY64978 deadlock with concurrent renaming and unlinking

IY64737 knot lock not released properly

IY64691 chvg -b can cause corruption and crash

IY63366 dlsym returns NULL even for valid symbol

IY63133 Performance degredation with many CPUS and volume group

IY69518 chvg -L / extendvg anomaly

IY75901 extendvg can cause corruption after IY69518

IY59082 systems hang with JFS2 and heavy load


Before installing AIX-based systems running AIX 5L version 5.2, complete the following step:

  1. Check that AIX 5L version 5.2, Maintenance Level 04 or higher is installed by entering the oslevel -r command, as shown in the following example:

    # oslevel -r
    5200-04
    
    

    In this example, the version of AIX is 5.2, Maintenance Level 04.

    If the operating system version is lower than AIX 5.2.0.0 Maintenance Level 04 (5200-04),then upgrade your operating system to this level. AIX 5L version 5.2 maintenance packages are available from the following Web site:

    https://techsupport.services.ibm.com/server/aix.fdc
    
    
  2. To determine whether the required filesets are installed and committed, enter a command similar to the following:

    # lslpp -l bos.adt.base bos.adt.lib bos.adt.libm \ 
    bos.perf.perfstat bos.perf.libperfstat X11.motif.lib
    
    

    For the list of filesets required for AIX 5L version 5.2, refer to Table 2-3

    If a fileset is not installed and committed, then install it. Refer to your operating system or software documentation for information on installing filesets.

  3. Check that the patches mentioned in Table 2-3 are installed. To determine whether an authorized program analysis report (APAR) is installed, enter a command similar to the following:

    # /usr/sbin/instfix -i -k "IY22854 IY26778 ..."
    
    

    If an APAR is not installed, then download it from the following Web site and install it:

    https://techsupport.services.ibm.com/server/aix.fdc
    

2.2.2 Software Requirements for AIX 5L Version 5.3

Table 2-4 lists the software requirements for AIX 5L version 5.3.

Table 2-4 Software Requriements for AIX 5L version 5.3

Item Requirements

Maintenance Level

02 or higher

Filesets

bos.adt.base
bos.adt.lib
bos.adt.libm
bos.perf.libperfstat
bos.perf.perfstat
bos.perf.proctools
X11.motif.lib

Patches

IY70159 : KRTL relocation problem

IY66513 : Parsing of LDR_CNTRL value fails

IY68989 : write to mmapped space hangs


Following are the steps to check if the parameters mentioned in Table 2-4 are installed on the system or not:

  1. Check that AIX 5.3, Maintenance Level 02 or higher is installed by entering the oslevel -r command, as shown in the following example:

    # oslevel -r
    5300-02
    
    

    In this example, the version of AIX is 5.3, Maintenance Level 02.

    If the operating system version is lower than AIX 5.3.0.0 Maintenance Level 2 (5300-02), then upgrade the operating system to this level. AIX 5L version 5.3 maintenance packages are available from the following Web site:

    https://techsupport.services.ibm.com/server/aix.fdc
    
    
  2. To determine whether the required filesets are installed and committed, enter following command:

    # lslpp -l bos.adt.base bos.adt.lib bos.adt.libm \ 
    bos.perf.perfstat bos.perf.libperfstat X11.motif.lib
    
    

    For the list of filesets required for AIX 5L version 5.3, refer to Table 2-4

    If a fileset is not installed and committed, then install it. Refer to your operating system or software documentation for information on installing filesets.

  3. Check that the patches mentioned in Table 2-4 are installed. To determine whether an authorized program analysis report (APAR) is installed, enter a command similar to the following:

    # /usr/sbin/instfix -i -k "IY66513 IY70159 IY66513 IY60930 IY59386"
    
    

    If an APAR or one of its fileset is not installed, then download it from the following Web site and install it:

    https://techsupport.services.ibm.com/server/aix.fdc
    

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 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 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.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.