Installation Guide › Server Installation › Report Server

Report Server

Standalone Report Server

If you do not need high availability for the Report Server, use the following procedure for a standalone installation.

Prerequisites

If you are planning to use RHEL 6 for the Business Objects installation, these prerequisites exist:

• Minimum patch requirements for RHEL 6: compat-libstdc++-33-3.2.3-69.el6.i686 (compatibility standard C++ library from GCC 3.3.4); glibc-2.12-1 (RedHat advisory RHBA-2007:0619-3); libXext.i386; libncurses.so.5, libXext-devel-1.1-3.el6.i686, libXext-devel-1.1-3.el6.x86_64

  Note: Install both X86_64 & i636 patches for the above. We recommend using yum install package_name.

  The hostname cannot have special characters such as '-' (a hyphen). It can be only alpha-numeric.

• Oracle Client 32Bit (or you can use Instant Client. To download OracleLinuxClient.zip)
• Open your Oracle server Enterprise Management Console or SQL console and create Tablespaces for CMS ("BO_CMS_TS") and Auditing ("BO_AUDIT_TS"). Also create 2 users, one for CMS ("BO_CMS_USER") and other for Auditing ("BO_AUDIT_USER") and give them dba privileges on respective Tablespaces.
• locale en_US.utf8 (to be default locale for BO installation)
• export LANG=en_US.utf8

Follow these steps:

1. Create a UNIX group (for example: bobje) to be used as a CA Business Intelligence User:

   # groupadd -g 400 bobje
   

2. Create a folder to be used as home folder for CA Business Intelligence User:

   # mkdir /home/bobje
   

3. Create a UNIX user (for example: bobje) to be used by the CA Business Intelligence installer for administrators:

   # useradd -d /home/bobje -g bobje bobje
   

4. Set the password for the user created in step 3.

   # passwd bobje
   

5. Change the ownership of the home directory as follows:

   # chown -R bobje:bobje /home/bobje
   

6. Download and copy the CABI3.3 to /home/bobje (or home folder created in step #2)
7. Extract the installer GZ file as follows:

   gunzip cabi-version_number-linux.tar.gz
   

8. Extract the TAR file as follows:

   tar -xvf cabi-version_number-linux.tar
   

9. Give necessary permissions on CABI install folder and Installer media

   copy OracleLinuxClient.zip to /tmp
   

10. Extract zip file and all other zip files in it
11. Rename the folder "instantclient_11_2" to "oracle" and move "oracle" folder to /opt/.
12. Go to /opt/oracle and create softlinks as below

    ln -s libclntsh.so.11.1 libclntsh.so
    ln -s libocci.so.11.1 libocci.so
    

13. Create a file "tnsnames.ora" with following content. Remember to replace parameters (specified between < and >) according to your setup

     <your Oracle SID> =
       (DESCRIPTION =
      (ADDRESS = (PROTOCOL = TCP)(HOST = <Oracle Hostname>)(PORT = 1521))
      (CONNECT_DATA =
     (SERVER = DEDICATED)
     (SERVICE_NAME = <your Oracle Service/SID name>)
    

14. Edit .bash_profile of both "root" (/root/.bash_profile) and "bobje" (/home/bobje/.bash_profile) (or CA Business object user created in step #3) and add the following.

    Note: If /home/bobje/.bash_profile does not exist for bobje user, create one and change owner to bobje using command "chown bobje:bobje /home/bobje/.bash_profile"

    export ORACLE_HOME=/opt/oracle
    export PATH=$PATH:$ORACLE_HOME
    export TNS_ADMIN=/opt/oracle
    export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/opt/oracle
    

15. Go to the user home folder (/home/bobje).
16. Run the Cabi installer.

    cabiinstall.sh
    

    Note: CABI installation is console installation. Provide the necessary details in the screen, keeping note of the passwords, ports and usernames provided during the installation

    See the following section for a few important parameters to be given during installation.

Non-Root Credentials

The BusinessObjects Enterprise installation program needs to run as a non-root user. The installer is running as the 'root' user, enter credentials for a valid non-root user.

• User Name: bobje
• Group Name: bobje
• For Installation Type, Select New (Install a new Enterprise system) for Oracle, orr Custom for PostgreSQL)
• Select 1 - Use an existing database (Oracle/DB2/Sybase/MySQL,SQLAnywhere)" for CMS Repository
• Select 2 - Oracle for Database Type
• Provide CMS user details for the CMS Database
• Provide Audit user details for the Audit Database
• Select Yes to initialize the database
• Select 1 - Install Tomcat, deploy web applications"

  Note: In case of any database error during install, check the latest "/opt/CA/SharedComponents/CommonReporting3/setup/logs/dbcheck" for details. All installation logs exist here: "/opt/CA/SharedComponents/CommonReporting3/setup/logs/"

Install verification

After installation, you should be able to access the CMS console (http://<hostname>:8080/CmcApp)