Supporting multiple Infrastructure Management Servers on a single Oracle database instance on Microsoft Windows
This topic provides the steps to support multiple Infrastructure Management Servers on a single Oracle database instance on Microsoft Windows. It includes the following use cases:
- 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
Instance Attributes Events 1.7 Million 250 K 350 K per day
The following are the requirements to configure the Oracle database instance on a Windows or a Linux operating system:
Component Minimum requirement Maximum requirement RAM
The following parameters require to be tuned if you are hosting multiple Infrastructure Management Servers:
Parameter Name Recommended Size memory_target 37.5 % memory_max_target 40% of total System RAM Processes 15001 Open_cursors 6000 Db_writer_processes 4 Job_queue_processes 30 Session_max_open_files 30 /dev/shm Should be > 20 GB /root Space should be > 40 GB Table Spaces Space 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:
- Navigate to %temp%\pw\pronto\conf\ directory.
- Open the oracle_parameters.conf file.
- Remove the values mentioned in the Parameter tuning table, of the INIT parameter from file.
- Save the file and restart the installation
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_targetparameter to about 6 GB. If you want to set
memory_targetto 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>
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
processesparameter value to 2000. You can do this by running the ALTER SYSTEM SET command.
For more information, see Manually setting up an Oracle database.