Page tree

Unsupported content

 

This version of the documentation is no longer supported. However, the documentation is available for your convenience. You will not be able to leave comments.

Skip to end of metadata
Go to start of metadata

BMC ProactiveNet Server supports Sybase or Oracle databases.

A Sybase ASA Database comes embedded with BMC ProactiveNet Server. Most of the settings are optimized out-of-the-box. You can tune the Sybase Database according to your deployment type.

An Oracle Database requires the database installation on a separate computer. You can tune several BMC ProactiveNet properties and Oracle Database parameters to optimize performance. The following tables provides the most common properties and changes that you should consider before installing BMC ProactiveNet Server.

Tuning recommendations for Oracle Database

Parameter description

Value command

Procedure

Set the number of processes and sessions.

alter system set processes = 1000 scope=spfile;
alter system set sessions = 1000 scope=spfile;

  1. Set the number of processes and sessions to 1000.
  2. Run the commands on the database and then restart the database.
  3. Connect to the database as system or sys in sysdba mode.

Set the sga_max_size.

alter system set sga_max_size=0 scope=spfile

Reset sga_max_size to 0.

Set memory allocation.

alter system set memory_max_target=8192M scope=spfile
alter system set memory_target=8192M scope=spfile

Set memory allocation to half of the system memory.
For example, if the system has 16 GB RAM, then set to memory_max_target=8192M.

To resize available REDO log files before BMC ProactiveNet installation

Parameter description

Value command

Procedure

Set REDO01.

alter database add logfile group Inactive group number ('Path\Redo Filename Without Group NumberInactive group number.LOG') size 500m reuse;

To avoid Cannot allocate new log error.
For status of redo log file select group# status from v$log;

Set REDO02.

alter database add logfile group Inactive group number ('Path\Redo Filename Without Group NumberInactive group number.LOG') size 500m reuse;

To avoid Cannot allocate new log error.
For status of redo log file select group# status from v$log;

Set REDO03.

alter database add logfile group Inactive group number ('Path\Redo Filename Without Group NumberInactive group number.LOG') size 500m reuse;

To avoid Cannot allocate new log error.
For status of redo log file select group# status from v$log;

Check status of redo log files.

select group# status from v$log;
alter system switch logfile;
alter system switch logfile;

Set status of one redo log file to CURRENT, and the other two to ACTIVE.

Set audit_trail and scope.

alter system set audit_trail=none scope=spfile

Alter the audit_trail and scope values.

Set CONNECT_TIMEOUT_LISTENER.

CONNECT_TIMEOUT_LISTENER = 0

Add CONNECT_TIMEOUT_LISTENER = 0 in the listener.ora file.

Related topics

Supported databases

  • No labels