Integration Guide › Implementing Enterprise Reporting › How to Set Up Reporting Service Server Components › Prepare Solaris and Linux for CA Business Intelligence Installation

Prepare Solaris and Linux for CA Business Intelligence Installation

Before you can install CA Business Intelligence on Solaris or Linux, you must prepare the computer for the installation. When you prepare the computer, you create a non-root user for the CA Business Intelligence installation ,verify that the Oracle RDBMS is exposed to the installation of CA Business Intelligence and set the environment variables.

Follow these steps:

1. Log in as a root user.
2. Create a non-root user. The CA Business Intelligence installation requires a non-root user.

   For example, enter the following commands to create a user named bouser that belongs to the group other:

   groupadd other
   useradd -d /home/bouser -g other -m -s /bin/bash -c bouser bouser
   passwd bouser
   

   When prompted, enter and confirm a password for the user you defined.

3. (Linux) Verify that the LANG environment variable is configured as follows:

   LANG=en US.utf8
   

4. Log in as the non-root user you created.
5. Enter the following commands to verify that the ORACLE_HOME and TNS_ADMIN environment variables are set correctly:

   echo $ORACLE_HOME
   echo $TNS_ADMIN
   

   A non-empty output verifies that these environment variables are valid. For example:

   /opt/oracle/app/oracle/product/10.2.0/client_1
   /opt/oracle/app/oracle/product/10.2.0/client_1/admin/network
   

   If you receive an empty output for the commands, verify that the variables are set for the non-root user you created. For example, edit /home/bouser/.profile as follows:

   ORACLE_HOME=/opt/oracle/app/oracle/product/10.2.0/client_1
   export ORACLE_HOME
   TNS_ADMIN=$ORACLE_HOME/network/admin
   export TNS_ADMIN
   

6. Verify that LD_LIBRARY_PATH for your non-root user contains the following paths:

   $ORACLE_HOME/lib:$ORACLE_HOME/lib32
   

   For example, type the following command and search the output for these paths:

   echo $LD_LIBRARY_PATH
   

   If these paths are missing, append them to LD_LIBRARY_PATH. For example, edit /home/bouser/.profile as follows:

   LD_LIBRARY_PATH=$LD_LIBRARY_PATH:$ORACLE_HOME/lib:$ORACLE_HOME/lib32
   export LD_LIBRARY_PATH
   

7. Verify that the folders in LD_LIBRARY_PATH and TNS_ADMIN are accessible, as follows:

   ls -l $ORACLE_HOME
   ls -l $TNS_ADMIN/tnsnames.ora
   

   The commands should not return a permission denied error. If they do, you must grant proper permissions. For example, the root/oracle user should run the following command:

   chmod -R +xr $ORACLE_HOME
   

8. Verify that Oracle connectivity is valid, using the TNS Ping utility as follows:

   $ORACLE_HOME/bin/tnsping service_name
   

   The output from TNS Ping should look be similar to the following example:

   TNS Ping Utility for Solaris: Version 10.2.0.1.0 - Production on 07-MAY-2008 09:17:02
   Copyright (c) 1997, 2005, Oracle.  All rights reserved.
   Used parameter files:
   /opt/oracle/app/oracle/oracle/product/10.2.0/client_1/network/admin/sqlnet.ora
   Used TNSNAMES adapter to resolve the alias
   Attempting to contact (DESCRIPTION = (ADDRESS_LIST = (ADDRESS = (PROTOCOL = TCP)(HOST = 172.16.234.75)(PORT = 1521))) (CONNECT_DATA = (SERVICE_NAME = service_name)))
   OK (30 msec)
   

   You can now install CA Business Intelligence on Solaris or Linux.