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
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