Supporting multiple Infrastructure Management Servers on a single Oracle database instance on Microsoft Windows

Guidelines and recommendations for supporting multiple TrueSight Infrastructure Management Servers on a single Oracle database instance

  • Hardware resources of the computer in which multiple Infrastructure Management Servers share the same Oracle instance must be increased to accommodate the extra load. For example, if you have 8 GB RAM for one Infrastructure Management Server, increase it to 16 GB if you want to host two Infrastructure Management Servers. Also increase the disk capacity based on Performance benchmarks and tuning for Infrastructure Management.
  • More than two TrueSight Infrastructure Management Servers must not be connected to a single Oracle database instance. The Infrastructure Management Server must have the following load:

    Load on each TrueSight Infrastructure Management Server

    InstanceAttributes Events 
    1.7 Million250 K350 K per day
  • The following are the requirements to configure the Oracle database instance on a Windows or a Linux operating system:

    Recommended Configuration

    ComponentMinimum requirementMaximum requirement
    RAM

    64 GB

    74GB

    CPU

    12 CPUs

    16CPUs

    Disk space

    750 GB

    1 TB

  • The following parameters require to be tuned if you are hosting multiple Infrastructure Management Servers:

     Parameter tuning

    Parameter NameRecommended Size
    memory_target37.5 %
    memory_max_target40% of total System RAM
    Processes15001
    Open_cursors6000
    Db_writer_processes4
    Job_queue_processes30
    Session_max_open_files30
    /dev/shmShould be > 20 GB
    /rootSpace should be > 40 GB
    Table SpacesSpace should be > 30 GB
  • If you want to add more than one child servers, you must update the INIT parameters. To update the INIT parameters, perform the following steps:

    1. Navigate to %temp%\pw\pronto\conf\ directory.
    2. Open the oracle_parameters.conf file. 
    3. Remove the values mentioned in the Parameter tuning table, of the INIT parameter from file.
    4.  Save the file and restart the installation
  • On UNIX platforms, the Oracle memory_target and memory_max_target parameters are dependent on the space available in the /dev/shm file system. You can check the space using the df -kh /dev/shm command and based on the space available, set the values of the memory_target and memory_max_targetparameters. The space available at /dev/shm (tmpfs) must be greater than the value that you set for memory_target.  For example:

    <- 
    Cmd# 
    df -kh 
    tmpfs 		7.9G 1.3G 
    6.6G 17% /dev/shm 
    ->

    In this case, you can set the memory_target parameter to about 6 GB. If you want to set memory_target to a higher value, proportionally increase the space in the tmpfs directory.

  • To export or import from/to Oracle Real Application Clusters (RAC), you can use one of the SIDs or services to connect to the database as follows:
    expdp <sys of instance-b>/<password>@< SID of instance-b>|<service name of the instance> PARFILE=<path of the pnet_exp_all_tables.par file>

    impdp sys/<password>@< SID of instance-a>|<service name of the instance> PARFILE=<path of the pnet_imp_all_tables.par file>

    Note

    The service name of the RAC is common to both the instances.

  • When you are migrating the BMC TrueSight Infrastructure Management Server’s database from one instance to another, ensure that you stop the BMC TrueSight Infrastructure Management Server and then export the contents of the database. If the BMC TrueSight Infrastructure Management Server is running during the database export, information may be lost.
  • Ensure that you back up each BMC TrueSight Infrastructure Management Server level schema to restore at a user level.

    For information on the guidelines and tuning recommendations for supporting multiple BMC TrueSight Infrastructure Management Servers on a single Oracle database instance, see Guidelines and tuning recommendations for supporting multiple BMC TrueSight Infrastructure Management Servers on a single Oracle database instance.

  • If you plan to use the same SID for multiple TrueSight Infrastructure Management servers, you need to ensure that you set the processes parameter value to 2000. You can do this by running the ALTER SYSTEM SET command.

    For more information, see Manually setting up an Oracle database.

Was this page helpful? Yes No Submitting... Thank you

Comments