How do I reconfigure TrueSight Capacity Optimization (TSCO) to change environment parameters like the Database host or password, Remedy Single Sign On (RSSO) or TrueSight Presentation Server (TSPS) URL? - INCLUDES VIDEO

Version 25
    Share This:

    This document contains official content from the BMC Software Knowledge Base. It is automatically updated when the knowledge article is modified.


    TrueSight Capacity Optimization


    Capacity Optimization


    BMC TrueSight Capacity Optimization 11.x, 10.x


    Which steps are needed to reconfigure the TrueSight Capacity Optimization (TSCO) instance information or change the database user passwords?
    Which are the steps if I migrated the TSCO database instance/host or I need to point TSCO to a new Remedy Single Sign On (RSSO) or TrueSight Presentation Server (TSPS) server?



    The following video shows how to reconfigure TSCO to change environment parameters like Database host or password, RSSO or TSPS URL:

    IMPORTANT NOTE: When changing the "Database Schema Owner" database account's password it is necessary to reconfigure all of the servers that are part of the TrueSight Capacity Optimization (TSCO) instance (All Application Servers and ETL Engine Servers).


    Updating the database passwords within the TSCO configuration files if they have already been changed by the DBA


    In TSCO 10.5 or newer, the following link to the product documentation describes how to to update the database password within the TSCO configuration if it has already been changed by your DBA:

      Validate database connection using Database Credentials Tool  
    The command should be run on the TSCO Application Servers first and then on the TSCO ETL Engines.  The utility can only update the TSCO database user password if it has already been changed on the database side.  To update the TSCO database user passwords on the database side and change them within the TSCO configuration it is necessary to run the in Reconfigure mode.  
      User-added image      User-added image

    Changing other configuration parameters (like DB host, TSPS, RSSO, ...)


    If the TSCO database has been moved to a new server or migrated to a new instance, as first step, you should manually change the tnsnames.ora file or validate that the appropriate entry is there, or ask to DBA to do this.

    Typically only the DBA will have access to modify this file (although any Oracle Client user should have access to view it).


    Then you have to run the TSCO installer similar to performing an install or an upgrade (please refer to official documentation of your TSCO version).

    The only officially supported method to change the TSCO database instance information (database hostname, instance/service name, alias or TNS name) is by running the in Reconfigure mode as described below.


    Select "Reconfigure BMC Capacity Optimization" when you will be in step "Existing installation detected"


    Select the option "Yes, I need to update Database users password" if you need to update the Database user password.

    User-added image




    When you will be in the step "Oracle Database Information" change the parameters you need.


    NOTE: If the database host has been changed to a new server you need to make sure the $ORACLE_HOME/network/admin/tnsnames.ora file is properly updated and contains the new Database host. Then you can add that information to the Wizard installer as well, this will allow you to successfully update the new Database server if needed.


    At the end of the configuration, all TSCO services will be restarted.


    There are no additional operations to do after the installer finishes its execution.


    Changing the password on the BCO ETL Engine or Presentation AS machines


    After changing the password for the BCO_OWN user it is necessary to run the Reconfigure on each of the ETL Engine or Presentation AS (Non-primary AS)
    servers in the environment.  The Reconfigure will not require the updated password to be entered -- it will instead download it from the TSCO Primary AS server.


    Additional Information


    Q: Database accounts are becoming locked when changing the TSCO database user passwords.  How does one determine which machine is locking out the account?

    The DBAs can usually tell from the Oracle database logs which server is making the login attempts that cause the accounts to become locked.  That may be something that needs to be configured on the database side to track but is seems to be a somewhat common configuration to have it enabled. 

    This page regarding Oracle database side auditing of login failures provides useful information:

    For example, running the SQL from that page will generate a list of failed login attempt with information on the hostname that attempted to login and failed: 
      select ntimestamp#, userid, userhost, spare1, comment$text from sys.aud$ where returncode=1017 order by ntimestamp# DESC;

    The database side logging may be enabled by default or it could require a database configuration change.  Contact your DBAs for additional information.  

    Q: The is attempting to access the Oracle database with the wrong password initially.  Could that be locking the account?

    The tool makes a single login attempt on startup against each of the TSCO database accounts using the currently configured password.  In the Oracle database query referenced above one will see the failed login attempt on the database accounts (BCO_OWN, BCO_REP, and in TSCO 10.7.01 and earlier BCO_DASH) when running the since the ool neesd to attempt a login to test the password). 

    Q: What is the best way to update the TSCO ETL Engines with updated database passwords?

    On the ETL Engines, the best way to reconfigure them with the new password is using the ' Reconfigure' workflow via the silent install.  Alternately, one could run the '' on each of the EE servers and enter the new password, but that process generally requires more effor than running the reconfigure silent install workflow.  

    Steps to do the reconfigure silent install on the EE servers

      (1) Find the TSCO Installation Image on the machine.  
    (2) Copy the [TSCO Installation Image]/BCO/Disk1/silentInstallTemplates//BCO_ADDITIONAL_SERVER_EE.txt to the /tmp directory (or some other directory of your choosing)  
    (3) Edit the BCO_ADDITIONAL_SERVER_EE.txt and update the contents.  
    You'll want to change the following options:  
      (a) If you have changed your TSCO Installation Directory from the default to a custom path, update the -P installLocation' property with the correct path.  
    So, change this:  
        -P installLocation=/opt/bmc/BCO 
      (b) In the "LAN Connection" section, set the URL_HOST and URL_PORT values to the fully qualified hostname of your Application Server and the port.  
    So, change this:  
      -J URL_HOST=
    -J URL_PORT=8000
    To something like:  
    -J URL_PORT=8443
    The installer will automatically figure out whether the connection should be http or https (you don't need to specify that in the configuration file).  
      (c) Update the ORACLE_HOME and ORACLE_SID parameters with the correct $ORACLE_HOME and $ORACLE_SID values   
    So, change this:  
      -J _ORACLE_HOME_=/opt/oracle/product/11.2.0/client_1
    With the correct Oracle Home Directory and Oracle Instance name which can you extract from the existing $CPITBASE/ file on the machine.  
      (d) Uncomment the 'IS_RECONFIGURATION_FLOW' parameter and set it to 'true'.  
    So, change this:  
    To this:  
      (e) Run the silent install as the TSCO Installation Owner user:  
        ./ -i silent -DOPTIONS_FILE=/tmp/BCO_ADDITIONAL_SERVER_EE.txt 
    That will run the ETL Engine silent reconfigure workflow which will trigger the installer to contact the TSCO Application Server, download the current configuration properties (including the updated password), and update the ETL Engine configuration with the new information.  
    You can check the end of the /tmp/bco_install_log.txt for the following message to see that the silent reconfigure has been successful:  
      TrueSight Capacity Optimization V.V.VV install succeeded.
    Where V.V.VV is the TSCO version.  
    You can then repeat that process with the exact same BCO_ADDITIONAL_SERVER_EE.txt file on each ETL Engine Server in the environment (since typically one would expect the specified parameters to be the same across all EEs in the environment).  
    Alternately, you could run the on each ETL Engine Server in the environment but that requires you to specify the updated password on each server and also the execution of the script will make an initial login attempt using the old, wrong password (which could, in limited circumstances) trigger the BCO_OWN database account to be locked). 

    Related Products:  
    1. BMC TrueSight Capacity Optimization
    3. BMC Capacity Management
       Legacy ID:KA380046


    Article Number:


    Article Type:


      Looking for additional information?    Search BMC Support  or  Browse Knowledge Articles