Installation Guides › WebLogic Version › Report Server Installation › How to Install the Report Server › Reports Pre-Installation Checklist

Reports Pre-Installation Checklist

You may want to print the following checklist to help ensure you meet the minimum system and database requirements before installing the report server:

• Be sure that the Windows or UNIX system to which you are installing the report server meets the minimum system requirements.
• Be sure that you are using a supported version of MS SQL Server or Oracle database for the Report Database.
• Create a database instance to be used as the Report Database.
  • If you are using MS SQL Server, create a data source name (DSN) that the report server uses to communicate with the Report Database.
  • If you are using Oracle, create a transparent network substrate (TNS) that the report server uses to communicate with the Report Database.
• If you create a new database instance for the Snapshot Database, run the following scripts on the new database:
  • MS SQL: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\imrexport\db\sqlserver\ims_mssql_report.sql
  • Oracle: C:\Program Files\CA\Identity Manager\IAM Suite\Identity Manager\tools\imrexport\db\oracle\ims_oracle_report.sql

    To execute these scripts, the database user needs dba, connect, and resource roles and system privileges to create tables, indexes, sessions and views with global query rewrite privilege.

• Create the Business Objects database and a user account to access it. The tables will be created by business objects. Do not use your product database for the Business Objects schema.
• Make sure you close all Oracle client applications, such as SQL plus and SQL developer before you start the installation.
• On UNIX, set the following parameters as global in the local .profile files:
  • ORACLE_BASE: the top-level directory where Oracle is installed.
  • ORACLE_HOME: the path to the Oracle root directory under ORACLE_BASE
  • LD_LIBRARY_PATH: $ORACLE_HOME/lib32:$ORACLE_HOME/lib

    If Oracle is a 64-bit installation, use lib32. Use SQL Plus to connect to the oracle database instance to check if it is a 64-bit installation.

  • ORACLE_SID: the SID name used in the tnsnames.ora file.
  • JAVA_HOME: the path to the Java root directory. Business Objects installs a JDK in the following location:

    report_server_home/j2sdk1.4.2_08
    

    Note: JDK 1.5 is required for reports even though Business Objects installs the JDK 1.4.2 08

  • PATH: $LD_LIBRARY_PATH:$JAVA_HOME:$JAVA_HOME/bin:$ORACLE_HOME/bin:$PATH
  • LC_ALL: en_US.UTF-8

    Note: Make sure the CASHCOMP environment variable is empty.

• On UNIX systems:
  • 3 GB of free space is required under /tmp.
  • You need access to a non-root user account to install the report server.

    This user should have a home directory in the local file system. For example. the following command creates a user with a local home directory:

    useradd -u 505 -g 0 -d /export/home/cabi -m cabi
    

    Also, add the non-root user to the oinstall group and any group for which the root user is a member.

  • Enter the database server name in the /etc/hosts file if the database server is not on the same system as the Business Objects server.
  • If you encounter problems, check the SDK.log under these locations:

    /opt/CA/SharedComponents/CommonReporting/ca-install.log

    /opt/CA/SharedComponents/CommonReporting/ CA_Business_Intelligence_InstallLog.log