This topic provides the steps to support multiple BMC ProactiveNet Child servers on a single Oracle database instance on Microsoft Windows. It includes the following use cases:
More than two Child Servers must be connected to a single Oracle database instance. The BMC ProactiveNet Server 9.5 must have the following load:
Load on each BMC ProactiveNet Server
|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|
The following parameters require to be tuned if you are hosting multiple child servers:
|Parameter Name||Recommended Size|
|memory_max_target||40% of total System RAM|
|/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:
The space available at /dev/shm (tmpfs) must be greater than the value that you set for
memory_target. For example:
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
If you are installing BMC ProactiveNet 9.5 with multiple Child Servers option, perform the following steps:
If you are upgrading to BMC ProactiveNet 9.5 with multiple Child Servers option, you must export or import Oracle Real Application Clusters, 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.
Ensure that you back up each BMC ProactiveNet Server level schema to restore at a user level.
For information on the guidelines and tuning recommendations for supporting multiple BMC ProactiveNet Servers on a single Oracle database instance, see Guidelines and tuning recommendations for supporting multiple BMC ProactiveNet Servers on a single Oracle database instance.