Questions on configuring the Oracle database for use with TrueSight Infrastructure Management 11.3.01

Version 3
    Share This:

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


    PRODUCT:

    TrueSight Infrastructure Management


    COMPONENT:

    TSIM Database


    APPLIES TO:

    TSIM 11.3.01



    DETAILS:

    The installation instructions here :
    https://docs.bmc.com/docs/TSOperations/113/installing-the-infrastructure-management-server-in-the-standalone-mode-using-the-wizard-814553305.html

    If you want to install it with Oracle, you can configure the Oracle database during installation, so the Preparing to Install tasks are detailed below:
    https://docs.bmc.com/docs/TSOperations/113/preparing-to-install-infrastructure-management-814553250.html

    To have the DBA configure the Oracle database before installation. If we have the installer configure the database, will it cover all of the oracle configuration details?

    1) Which configurations would the Oracle DBA still have to do if the installer configures the Oracle database?

    The DBA needs to install the Oracle DB in network as per the doc since the configuration details are handled


    2) Does the DBA need to run set_system_parameter_oracle_pnet.sql and run_oracle_db_scripts.sql before installation if we select to have the installer configure the database?

    If you are on the TSIM install screen and you select USE EXISTING  USER then you need to run set_system_parameter_oracle_pnet.sql and run_oracle_db_scripts.sql  before installing TSIM.

    If you are on the TSIM  install screen and you select CREATE NEW USER  then you need  to run only the set_system_parameter_oracle_pnet.sql  before Installing TSIM


    3) During the installation, we will enter the information for basically three accounts correct? A User with SYSDBA privileges, the proact user, and the Oracle report user?

    If on the TSIM  install screen and you select CREATE NEW USER you need to use SYSDBA otherwise, you would need to use the  PROACT and REPORT user name and password

        a) if so, do any of those need to be created in advance, if we have the SYSDBA user/password, it will create the other two accounts, but we just need to input the password for those accounts in the installer?
        
    BMC: If on the TSIM install screen and you select USE EXISTING  USER then you need to run set_system_parameter_oracle_pnet.sql and run_oracle_db_scripts.sql  before installing TSIM.[No need to provide SYSDBA]

    If on the TSIM  install screen and you select CREATE NEW USER  then you need run only set_system_parameter_oracle_pnet.sql  before Installing TSIM and need to provide SYSDBA



     


    Article Number:

    000155781


    Article Type:

    Product/Service Description



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