Loading...

Defining Oracle Parameters for an Auxiliary PFILE

If you use an auxiliary instance, you can define parameters to add to the instance's PFILE. This helps avoid problems with the auxiliary database not starting because it is using default PFILE parameters.

Procedure

  • To the Oracle client, add the sORACLE_AUX_PARAMETER additional setting as shown in the following table. If you are using Oracle 10.2.0.5, add the parameter UNDO_MANAGEMENT = AUTO, along with any other parameters you want to define.

    For instructions on how to add additional settings from the CommCell Console, see Adding or Modifying Additional Settings from the CommCell Console.

    Property

    Value

    Name

    sORACLE_AUX_PARAMETER

    Category

    OracleAgent

    Type

    String

    Value

    The Oracle parameters to add to the auxiliary instance Oracle PFILE.

    Separate each parameter with a semi-colon (;).

    Example:

    Add the parameters DB_4K_CACHE_SIZE=4M and DB_16K_CACHE_SIZE=2G

    sORACLE_AUX_PARAMETER DB_16K_CACHE_SIZE=2G;DB_4K_CACHE_SIZE=4M

Last modified: 1/29/2021 9:39:23 PM