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.

Configuring the Oracle database

To configure the Oracle database for BMC Server Automation, do the following:

  • Edit the init.ora file to set the following initialization parameters:
    • db_block_size must be set to 8192
    • Processes must be set to at least 200
       Ideally, the number of processes should be 30 to 40 greater than the total number of job-related and nonjob-related database connections configured for all Application Servers in your environment.
       If you are running BMC BladeLogic Decision Support for Server Automation, the number of processes should ideally be 20 to 30 higher than the total number of job-related and non-job-related database connections.
       For more information about configuring Application Servers, see Configuring-the-Application-Server.
       All other configuration parameters can be set at the discretion of the database administrator.
  • If the database is configured for the UTF8 or AL32UTF8 character set (NLS_CHARACTERSET parameter) in a LATIN-1 locale, and the CHAR schema is used as an underlying persistent schema, set the NLS_LENGTH_SEMANTICS parameter of the database to CHAR to prevent column field overflow. Set this parameter before you run the master schema script to set up the database schema.

  • Ensure that all synonyms are public.

     

 

Tip: For faster searching, add an asterisk to the end of your partial query. Example: cert*