Preparing to install the Application Server and ETL Engine

Before installing the Application Server and ETL Engine, ensure that your environment meets the installation requirements, and complete the tasks described in this section.

• Preparing to install the Application Server without a sysdba password
• Preparing to install the Application Server as a non-root user
• Preparing for TLS-enabled communication between internal database and product components

Preparing to install the Application Server without a sysdba password

The sysdba password is needed to automatically create users and tablespaces during installation. If you do not have a sysdba password, you can set up the database users and tablespaces manually before you install the product using scripts provided with the installer.

If the Database Administrator cannot provide the sysdba password, do the following to create users and tablespaces manually: 

1. Log in to the host computer on which you want to install the Application Server and ETL Engine, and create a temporary directory.

2. Extract the downloaded files to the temporary directory. 

3. Navigate to the <temp_download>/BCO/Disk1/scripts folder.

4. Based on the database you are using, copy the following database creation script from the scripts folder to the database server. 

   • (Oracle) create_users_tablespaces.sql

   • (PostgreSQL) create_postgres_users_tablespaces.sql

5. Log in to the database server and navigate to the folder in which you have copied the script.

6. Edit the script and modify the required values such as database users, roles, and tablespace names.
   Ensure to use the same values when you choose the Use existing database users and tablespaces option while installing.

7. Run the script.

For information about supported database versions and requirements, see  Database requirements .

Preparing to install the Application Server as a non-root user

BMC recommends that you install the TrueSight Capacity Optimization product as a root user. If you cannot perform the installation as a root user, do the following: 

If you have access to the root user, proceed to Installing the Application Server and ETL Egine. The required user, group, and system properties will be automatically set by the installer.

If you are using a  supported Oracle Database Server , you must have a supported Oracle Client  installed on the host system or virtual machine.

1. Create the system user, and its home folder.

   As a best practice, name the user group cpit, user name cpit, and the home directory /opt/bmc/BCO.

   mkdir /opt/bmc/BCO
   groupadd -g 87654321 cpit
   useradd -g cpit -d /opt/bmc/BCO -s /bin/bash -c "BMC TrueSight Capacity Optimization" -K UMASK=007 cpit
   chown cpit:cpit /opt/bmc/BCO
   chmod 770 /opt/bmc/BCO

   Note

   • UMASK for cpit has been explicitly set to allow users in the same group to modify files, and allow every user in the system to read files and folders created by the cpit user.
   • Ensure that the primary group names do not include space or parenthesis.
2. Change the default password, 'cpit', for the cpit user.

3. Define the open file limit for the cpit user. Defining this limit allows simultaneous execution of other operations on the same host. For example, importing data using ETL tasks.

   echo "cpit soft nofile 10240" >> /etc/security/limits.conf
   echo "cpit hard nofile 65536" >> /etc/security/limits.conf
   sysctl -p

4. Create a temporary folder for the installation files. BMC recommends you to use /opt/cpitinstall.

5. Define the cpit user as the owner of the temporary folder: chown -R cpit:cpit /opt/cpitinstall

6. (Optional) If, on the application server, you plan to run an ETL process that accesses Windows shares, you need to enable permission for the application server to mount Windows shares. For more information, see  Enabling Windows shares mounting .
7. (Optional) Ensure that the Capacity Optimization system user who runs the Application Server and ETL Engine has permissions to use the system crontab file:
   • If the host has a cron.deny policy, ensure that the Capacity Optimization user is not included in it.
   • If the host has a cron.allow policy, add the Capacity Optimization user to it.

Preparing for TLS-enabled communication between the internal database and the product components

The internal database (Oracle or PostgreSQL) communicates with the Application Server and ETL Engine. By default, this communication is non-secure. 

To upgrade the communication channel security to use TLS 1.2 with server certificate validation, do the following:

Where to go from here

Perform the other preinstallation tasks listed in Preparing to install TrueSight Capacity Optimization.